8.3 Autovacuum Questions

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

 



I just have a couple of quick questions about 8.3 and Autovacuum.

1.  When autovacuum chooses to vacuum a table, the entire table is vacuumed, and not just a specified percentage of the table.  Correct?

2.  There is no way, without turning autovacuum off, of excluding vacuum/analyze during a specific period of time (say during a known peak usage period).

3.  If I have a PostgreSQL cluster with 10 databases, does autovacuum_max_workers=3 mean I have a possibility of 3 total workers or 30 workers (i.e. autovacuum_max_workers * number of db's)?

Thanks,

Chris

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux