Jan Krcmar wrote:
hi i've got the database (about 300G) and it's still growing. i am inserting new data (about 2G/day) into the database (there is only one table there) and i'm also deleting about 2G/day (data older than month). the documentation says, one should run VACUUM if there are many changes in the database, but the vacuumdb never finishes sooner than the new data should be imported. is there any technique that can solve this problem?
your table is currently in a messy state, as its apparently not been vacuumed (what version of postgres is this, anything since 8.1 should have autovacuum running by default). in theory your table has about 60GB of data in it, the fact that its 300GB indicates there's a lot of 'dead' tuples. You might consider partitioning this table by date, either by day or by week, and instead of deleting old rows, drop entire old partitions
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
