vacuum slowness

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: vadim(at)krs(dot)ru (Vadim B(dot) Mikheev)
Cc: hackers(at)postgreSQL(dot)org (PostgreSQL-development)
Subject: vacuum slowness
Date: 1999-03-17 18:25:30
Message-ID: 199903171825.NAA11920@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I just deleted all 50,000 rows from a table that has one int4 and one text
field.

Why does vacuum take so long? If all the rows are superceeded, so no
rows actually have to be moved, should it take so long for vacuum to
run?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-03-17 18:32:28 Re: [HACKERS] Subqueries and indexes
Previous Message Bruce Momjian 1999-03-17 18:14:03 Re: [HACKERS] Sequences....