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