Re: Growing Database Size Solved

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jason Godden <jasongodden(at)optushome(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Growing Database Size Solved
Date: 2003-06-14 13:47:45
Message-ID: 20030614134745.GF27374@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jun 14, 2003 at 18:57:42 +1000,
Jason Godden <jasongodden(at)optushome(dot)com(dot)au> wrote:
> My mistake - even though I was running VACUUM everyday I wasn't running VACUUM
> FULL - a VACUUM FULL fixed the problem. Strange - I thought that regular
> VACUUM was pretty good these days?

You need to make sure that FSM is set high enough or that you vacuum
frequently enough that it will be big enough now that you have removed
most of dead tuples.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2003-06-14 14:57:40 Re: Insert NULL for ''
Previous Message Bruno Wolff III 2003-06-14 13:45:33 Re: Growing Database Size