VACUUM process running for a long time

From: Jan Krcmar <honza801(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM process running for a long time
Date: 2010-04-14 14:01:39
Message-ID: p2v27cffc1004140701wf74c0a01y894f621dee1bd3c5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-04-14 14:04:39 Re: How to insert Ecoded values into postrgresql
Previous Message Pavel Stehule 2010-04-14 13:51:52 Re: [BUGS] Can you please let me know?