Search Postgresql Archives

Re: slowness what only full vacuum can solve

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Laszlo Fogas <laszlo@xxxxxxxxxxxxxxxx> wrote:
 
> We have a reoccurring problem of slowness initially in every 2
> months, after enabling autovacuum every 6 months what only full
> vacuum can solve. It's kind of a problem as it requires 2hrs
> downtime and we want to avoid that. What we are doing now is
> moving to Postgres 9.1 as a desperate measure, but we would like
> to understand better the root cause of the problem.
 
Your autovacuum is not configured to be aggressive enough.  The
upgrade should help, as autovacuum has been improved in recent
releases, but you may need to increase autovacuum_max_workers,
decrease autovacuum_naptime, etc.  There are a lot of knobs, and I
often find I need to make autovacuum a bit more aggressive than the
defaults to keep things in good shape.
 
-Kevin

-
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux