Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-ports by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group