Alvaro,

> One issue I do have to deal with right now is how many autovacuum
> processes do we want to be running. �The current approach is to have one
> autovacuum process. �Two possible options would be to have one per
> database, and one per tablespace. �What do people think?

I'd vote for one, period, for the cluster, if you can manage that.   Let's 
stick to simple for now.   Most users have their database on a single disk or 
array, so multiple concurrent vacuums will compete for I/O regardless of 
different databases.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to