> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026