Re: Unexplained growth of tables

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

 



Benjamin Krajmalnik wrote:
> What can be causing this growth?  Not vacuuming often enough?

The is exactly the reason.

> I hav 
> pg_autovacuum running every 60 seconds.  These tables have 10-15
> insert/update statements per second.

You should probably run VACUUM FULL to get the table back to a normal 
size and then closely monitor what pg_autovacuum actually does.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


[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