Re: Growing Database Size

On Sat, Jun 14, 2003 at 16:35:16 +1000,
  Jason Godden <jasongodden@optushome.com.au> wrote:
> Hi All,
>
> I've got a bit of a dilemma with growing database sizes.  Before upgrading to
> 7.3.2 my 7.3.0 database had an average size of 1.4-2.0gb.  I have a large
> number of LO records in my db and presumed the size growth was because of
> them.  However I do have the appropriate trigger functions on my LO records
> to ensure that lo_manage runs to unlink the old reference etc.
>
> Since moving to 7.3.2, even though I VACUUM regularly, my DB size has
> increased to 3.2GB on disk!!  The raw data only consumes about 700-900mb so I
> feel that an additional 2.2gb for index and statistics info is a bit much!
> Any clues from the experienced among the group?
>
> PS - strange thing is that even with that huge change on disk PG's performance

You probably want to use a reindex. If you have an index on a column
that only increases or decreases over time, the index won't be able
to use reuse pages that are no longer in use. This is fixed in 7.4.