Re: Growing Database Size Solved - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Growing Database Size Solved
Date
Msg-id 20030614134745.GF27374@wolff.to
Whole thread Raw
In response to Growing Database Size Solved  (Jason Godden <jasongodden@optushome.com.au>)
Responses Re: Growing Database Size Solved  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sat, Jun 14, 2003 at 18:57:42 +1000,
  Jason Godden <jasongodden@optushome.com.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.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Growing Database Size
Next
From: Tino Wildenhain
Date:
Subject: Re: Insert NULL for ''