Re: [HACKERS] Re: vacuum slowness

> 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?

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?


--  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