Vacuum

From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: "p-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Vacuum
Date: 2001-07-16 19:26:48
Message-ID: 00b001c10e2d$420007e0$5dd26383@corp.compucom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi fellow Postgressers

I have a relatively small database. The data itself is about 1.5GB. After I did some index value changes over the weekend, I decided that it's time to do a vacuum - the db had grown to 10 GB in size - which was just unrealistic.
at 7:13 this otherwise fine morning, I started the vacuum and was hoping for a run time of maybe 2 hours - max. Well, it is 2:20 PM now and it's still ticking. It has created so far 1411 files in $PGDATA/pg_xlog (which, since last night resides on a different drive from the database). Each of the file is 16 MB in size and if this continues for another 3 hours (or so) I'm running out of disk space.

If I would have done a
dump all data
drop db
create new db
restore schema (create tables/indexes/sequences)
load all data

I would have been done in about 2 hours.

Can somebody explain to me what this vacuum is doing with all these files? I suppose, this transaction logging stuff needs some serious looking into/re-writing.
Is there a way to switch this stuff off all together?

Best regards,
Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2001-07-16 19:50:44 Re: psql and lo_import
Previous Message berger, ralf 2001-07-16 19:18:41 AW: psql and lo_import