From: Bruce Momjian <maillist@candle.pha.pa.us>
insert a few row in a table (>50000) and do
delete from mytable;
vacuum verbose analyze;

Why is this that slow?
Analyze checks every column in every row.
even if you only type "vacuum verbose" it takes _very_ long.

I deleted _all_ records with "delete from mytable;" before.
A drop and a new create is faster. But what is when you delete (maybe
100000) rows but keep 100 in the table?

I use 6.4.2 on NetBSD/i486 (that box makes gets 12MBytes/sec via the
filesystem out of the drives)
---
_ _
_(_)(_)_ 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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 16 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedJan 6, '99 at 8:06p
activeJul 7, '99 at 12:33a
posts16
users4
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase