Postgres Pro
Downloads
Home   >   mailing lists

VACUUM process running for a long time - Mailing list pgsql-general

From Jan Krcmar
Subject VACUUM process running for a long time
Date
Msg-id p2v27cffc1004140701wf74c0a01y894f621dee1bd3c5@mail.gmail.com
Whole thread Raw
Responses Re: VACUUM process running for a long time  (John R Pierce <pierce@hogranch.com>)
Re: VACUUM process running for a long time  (Adrian von Bidder <avbidder@fortytwo.ch>)
Re: VACUUM process running for a long time  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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?

thanks
fous

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [BUGS] Can you please let me know?
Next
From: Merlin Moncure
Date:
Subject: Re: How to insert Ecoded values into postrgresql