Re: Data Directory size increasing abnormally

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: utsav <utsav(dot)turray(at)newgen(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data Directory size increasing abnormally
Date: 2009-11-18 02:07:47
Message-ID: dcc563d10911171807p2434614bre9d7a5f46610d076@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Note that with pgsql, the older the version you're running, the
greater your pgsql-fu must be to keep it happy.

With autovacuum and more efficient vacuuming all around in later
versions, your simple first step is to upgrade to 8.4.1 or 8.3.8 as
soon as possible. Until then, dump / reload that table and / or
vacuum full and reindex it and / or cluster that table (did we have
cluster in 7.3? Been too long, can't remember).

In simple terms, please stop torturing yourself with an old and pretty
much unsupported pg version.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Naoko Reeves 2009-11-18 03:12:31 Where do you store key for encryption
Previous Message John R Pierce 2009-11-18 00:55:05 Re: Data Directory size increasing abnormally