Re: database file size bloat - Mailing list pgsql-general

From Ed Loehr
Subject Re: database file size bloat
Date
Msg-id 38F73692.E28C9AD7@austin.rr.com
Whole thread Raw
In response to Re: database file size bloat  (Matthew Arnison <matthewa@physics.usyd.edu.au>)
List pgsql-general
Matthew Arnison wrote:
>
> the bloat is a big problem. i just checked it again, and the db has
> balloooned to 20 megs again, with i think 2650 unused pages. this is after
> vacuuming it last night. i guess we need to setup the vacuum script to run
> every hour. i am worried about this locking out users during the
> vacuuming, although i guess if it happens more often, it should take less
> time.

I should add that my vacuum runs don't take very long (< 10 seconds).  I
would have to consider other alternatives if it took much longer...

> meanwhile, as for upgrading, i think i'll try 6.5.3 first.
>
> version 7 is still in beta. is it atleast as stable as 6.5.3? is it
> atleast as fast as 6.5.3?

Beta3 is more stable and much faster, IMO.  Haven't tried beta5.

pgsql-general by date:

Previous
From: A James Lewis
Date:
Subject: Parallel databases?
Next
From: Ed Loehr
Date:
Subject: Re: Postgresqlism & Vacuum?