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'
or name ~ 'statistics'
;)
Cheers,
Steve
P.S. The convention on the PostgreSQL mailing lists it to bottom-post, not top-post replies.
And just to confirm, are there any table-specific overrides to the system-wide settings?
Cheers,
Steve