Re: [GENERAL] Large database

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