Unexplained growth of tables

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

 



This is subsequent to the previous issue which I am expperiencing.
In my monitoring application, I have a few tables which contain few rows
but are constantly pounded with updates.

These tables are growing at very high rates.  For example, a table with
less than 4K rows, which when reloaded was about 8 Mb, is now 1.4GB!  As
these tables grow, the performance of the application - which only looks
at these previously relativele small tables - is exremely slow.  The
huge tables are only used to calculate some statistical values on a
nightly basis.

I took another table which just started growing and ran analyze on it.
This is the result:


INFO:  analyzing "public.tblkstests"
INFO:  "tblkstests": scanned 3000 of 81837 pages, containing 109 live
rows and 10512 dead rows; 109 rows in sample, 2973 estimated total rows

Total query runtime: 52702 ms.

The actual number of physical rows in this table is 3404.  Row width is
361.  Table size = 639 MB.
What can be causing this growth?  Not vacuuming often enough? I hav
pg_autovacuum running every 60 seconds.  These tables have 10-15
insert/update statements per second.

Any assistance or guidance will be deeply appreciated.  I am pulling
hairs on this one.
> 
>
> 


[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