Mark Wong escribió:
> Hrm, tracking just the launcher process certainly doesn't help. Are
> the spawned processed short lived? I take a snapshot of
> /proc/<pid>/io data every 60 seconds.
The worker processes can be short-lived, but if they are, obviously they
are not vacuuming the large tables. If you want to track all autovacuum
actions, change autovacuum_log_min_messages to 0.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support