Re: VACUUM process running for a long time

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