Horton

vacuum takes too long

David Wetzel <dave@turbocat.de>

View thread
From: David Wetzel <dave@turbocat.de>
To: ports@postgreSQL.org, hackers@postgreSQL.org
Date: 1999-01-06T19:09:20Z
Lists: pgsql-hackers 
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@postgreSQL.org]
---
   _  _
 _(_)(_)_  David Wetzel, Turbocat's Development,
(_) __ (_) Buchhorster Strasse, D-16567 Muehlenbeck/Berlin, FRG,
  _/  \_   Fax +49 33056 82835 NeXTmail dave@turbocat.de
 (______)  http://www.turbocat.de/
           DEVELOPMENT * CONSULTING * ADMINISTRATION
           WATCH OUT FOR TURBOFAX for OPENSTEP!