From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | Matthew Arnison <matthewa(at)physics(dot)usyd(dot)edu(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org, Rabble-Rouser <rabble(at)protest(dot)net>, Manse Jacobi <jacobi(at)freespeech(dot)org> |
Subject: | Re: database file size bloat |
Date: | 2000-04-14 15:17:38 |
Message-ID: | 38F73692.E28C9AD7@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 2000-04-14 15:34:10 | Re: Postgresqlism & Vacuum? |
Previous Message | A James Lewis | 2000-04-14 15:11:50 | Parallel databases? |