Re: vacuum slowness - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: vacuum slowness
Date
Msg-id 36F05CA5.8C5D35CE@krs.ru
Whole thread Raw
In response to vacuum slowness  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Re: vacuum slowness
List pgsql-hackers
Bruce Momjian wrote:
> 
> 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?

Indices?

Vadim


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] vacuum slowness
Next
From: Tom Lane
Date:
Subject: Re: OID vs SERIAL? (Was: Re: [HACKERS] Sequences....)