vacuum takes too long

From: David Wetzel <dave(at)turbocat(dot)de>
To: ports(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org
Subject: vacuum takes too long
Date: 1999-01-06 19:09:20
Message-ID: 199901061909.UAA02282@cat.turbocat.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-ports

Hi,

insert a few row in a table (>50000) and do
delete from mytable;
vacuum verbose analyze;

Why is this that slow?

[I am not on hackers(at)postgreSQL(dot)org]
---
_ _
_(_)(_)_ David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
_/ \_ Fax +49 33056 82835 NeXTmail dave(at)turbocat(dot)de
(______) http://www.turbocat.de/
DEVELOPMENT * CONSULTING * ADMINISTRATION
WATCH OUT FOR TURBOFAX for OPENSTEP!

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-01-06 21:02:33 Re: [PORTS] vacuum takes too long
Previous Message Jan Wieck 1999-01-06 17:09:48 Re: [HACKERS] Numeric type

Browse pgsql-ports by date

  From Date Subject
Next Message Bruce Momjian 1999-01-06 21:02:33 Re: [PORTS] vacuum takes too long
Previous Message Billy G. Allie 1999-01-06 08:18:12 Re: Stale porting list?