Re: slow vacuuming...

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