Re: Can anyone explain this: duplicate dbs.

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: SpaceBallOne <space_ball_one(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Can anyone explain this: duplicate dbs.
Date: 2005-05-25 02:21:46
Message-ID: 4293E13A.5050901@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Can anyone explain why this may be occurring and how I might be able to
> keep the original database running at the same speed as "tempdb"?

You're not vacuuming anywhere near often enough. Read up the database
maintenance section of the manual. Then, set up contrib/pg_autovacuum
to vacuum your database regularly, or make a cron job to run "vacuumdb
-a -z -q" once an hour, say.

You can fix for the case when you haven't been vacuuming enough by a
once off VACUUM FULL ANALYZE command, but this will lock tables
exclusively as it does its work.

Chris

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-05-25 02:22:53 Re: Can anyone explain this: duplicate dbs.
Previous Message SpaceBallOne 2005-05-25 02:07:49 Can anyone explain this: duplicate dbs.