From: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Unexplained growth of tables |
Date: | 2006-07-23 10:56:03 |
Message-ID: | BF337097BDD9D849A2F4B818DDB2798702949D@stash.stackdump.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-07-23 11:19:28 | Re: Unexplained growth of tables |
Previous Message | Shen, Mingzuo | 2006-07-22 20:17:00 | Read db files directly |