Re: vacuum slowness

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: Re: vacuum slowness
Date: 1999-03-18 01:53:41
Message-ID: 36F05CA5.8C5D35CE@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-03-18 02:25:01 Re: OID vs SERIAL? (Was: Re: [HACKERS] Sequences....)
Previous Message Tom Lane 1999-03-18 01:52:36 Re: [HACKERS] vacuum slowness