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!

Search Discussions

  • Bruce Momjian at Jan 6, 1999 at 9:21 pm

    Hi,

    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.

    --
    Bruce Momjian | http://www.op.net/~candle
    maillist@candle.pha.pa.us | (610) 853-3000
    + If your life is a hard drive, | 830 Blythe Avenue
    + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
  • David Wetzel at Jan 7, 1999 at 12:25 am

    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedJan 6, '99 at 8:06p
activeJan 7, '99 at 12:25a
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

David Wetzel: 2 posts Bruce Momjian: 1 post

People

Translate

site design / logo © 2021 Grokbase