| 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: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version |
| Date: | 2015-06-05 19:34:05 |
| Message-ID: | 5571F9AD.2060402@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On 06/05/2015 12:28 PM, Steve Crawford wrote:
> 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';)
And just to confirm, are there any table-specific overrides to the
system-wide settings?
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2015-06-05 19:42:52 | Re: alter column type |
| Previous Message | Steve Crawford | 2015-06-05 19:28:23 | Re: Re: Query running slow for only one specific id. (Postgres 9.3) version |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matheus de Oliveira | 2015-06-05 22:34:30 | Re: [PERFORM] Query running slow for only one specific id. (Postgres 9.3) version |
| Previous Message | Steve Crawford | 2015-06-05 19:28:23 | Re: Re: Query running slow for only one specific id. (Postgres 9.3) version |