> 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
