Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Re: vacuum slowness - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Re: vacuum slowness
Date
Msg-id 36F089E2.562F0ED3@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Re: vacuum slowness  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses RE: [HACKERS] Re: vacuum slowness
List pgsql-hackers
Tree view 
Bruce Momjian wrote:
> 
> >
> > Indices?
> 
> Yes.  That seems to be the problem.  45k lines, COPY is fast, DELETE is
> fast if there are no indexes.  With an index, it takes a long time.
> Bummer.  Ideas?

I hope to implement space re-using and address vacuum slowness
in 6.6

Vadim

pgsql-hackers by date:

Previous
From: Wayne Piekarski
Date:
Subject: Re: [HACKERS] vacuum slowness
Next
From: Bruce Momjian
Date:
Subject: Re: OID vs SERIAL? (Was: Re: [HACKERS] Sequences....)