> > > i filed a bug report at one time noting that:
> > > "ALTER TABLE tbname RENAME TO tbname_new;"
> > > was not renaming all of the extents.
> > >
> > > do you know if this has been fixed?
> >
> > Yes, in 6.5.*.
>
> cool.
>
> if i'm annoying you, tell me to go away.
>
> do you know why vacuum can consume an enormous amount of core when cleaning
> a large table?
>
> i've actually had to add a gig of swap to our server so that vacuum can
> actually finish on some of our tables.
>
> sometimes the vacuum won't even do that, and i need to:
>
> pg_dump -t tb -s db > tb.dmp
> psql -c "copy tb to stdout using delimiters ':';" db | gzip > tb.dat.gz
> psql -c "drop table tb;" db
> psql -e db < tb.dmp
> zcat tb.dat.gz | psql -c "copy tb from stdin using delimiters ':';" db
>
> very painful (taking several hours).
Can someone comment on the high memory usage of vacuum?
-- 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