vacuum slowness - Mailing list pgsql-hackers

From Bruce Momjian
Subject vacuum slowness
Date
Msg-id 199903171825.NAA11920@candle.pha.pa.us
Whole thread Raw
Responses Re: [HACKERS] vacuum slowness
List 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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Clark Evans
Date:
Subject: [Fwd: Re: [HACKERS] Sequences....]
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Subqueries and indexes