| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | "Sheena, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Re: Query running slow for only one specific id. (Postgres 9.3) version |
| Date: | 2015-06-05 19:28:23 |
| Message-ID: | 5571F857.8000107@pinpointresearch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On 06/05/2015 11:38 AM, Sheena, Prabhjot wrote:
>
> When I run vacuum analyze it fixes the problem but after 1 or 2 days
> the problem comes back
>
>
Is autovacuum running and using what settings?
(select name, setting from pg_settings where name ~ 'autovacuum' Konsole
output or name ~ 'statistics';)
Cheers,
Steve
P.S. The convention on the PostgreSQL mailing lists it to bottom-post,
not top-post replies.
Konsole outpor name ~ 'statistics';)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2015-06-05 19:34:05 | Re: Re: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version |
| Previous Message | Ravi Krishna | 2015-06-05 19:20:40 | Re: alter column type |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2015-06-05 19:34:05 | Re: Re: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version |
| Previous Message | Igor Neyman | 2015-06-05 18:46:15 | Re: Query running slow for only one specific id. (Postgres 9.3) version |