Le 2012-08-10 à 07:53, Laszlo Fogas a écrit :
> We are running Postgres 8.3 on our production servers on Amazon EC2.
> 
> 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.

The usual solution is to run autovacuum *more* frequently, not less. It's not 
perfectly clear, but you say "after enabling autovacuum every 6 months". If 
that's the case, then it's much too long. autovacuum should be running hourly, 
if not more often.

http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#autovacuum_max_fsm_pages.2C_max_fsm_relations
 talks about running more frequently.

Hope that helps!
François Beausoleil
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to