From: | "Hossein S(dot) Zadeh" <hossein(at)hossein(dot)bf(dot)rmit(dot)edu(dot)au> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | David Powicki <dpowicki(at)oit(dot)umass(dot)edu>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: slow vacuuming... |
Date: | 2000-11-14 01:07:16 |
Message-ID: | Pine.LNX.4.21.0011141201570.17361-100000@hossein.bf.rmit.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, 13 Nov 2000, Stephan Szabo wrote:
> On Mon, 13 Nov 2000, David Powicki wrote:
>
> > Each day the DB grows to ~70MB in size and takes upwards of 25 minutes to
> > vacuum. A 70MB DB doesn't sound too big and 25 minutes is a painfully long time
> > to wait.
I have had the same problem; I think it only occurs if you have any BLOB
field. In my case, vacuum on a ~100MB table took around 40 minutes (on a
dual PII 450, 256MB RAM, all 10,000RPM SCSI HDDs).
Here's what I did; I created a script that rather than just running vacuum
did the followings:
create a temp table identical to the large table
insert into temp (select * from old);
drop old
vacuum
create the old table
insert into old (select * from temp);
drop temp
vacuum
You can ditch the last vacuum if you wish (I was just being pedantic :-)
This whole thing took less than a minute on the same machine!!!
cheers,
Hossein
From | Date | Subject | |
---|---|---|---|
Next Message | Rynell Wesson | 2000-11-14 12:23:28 | create view error??? |
Previous Message | Stephan Szabo | 2000-11-13 16:31:23 | Re: slow vacuuming... |