Re: vacuumdb --freeze

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> vacuum analyze doesn't unfreeze pg_class.  It could create unfrozen
> >> tuples in pg_statistic, perhaps, but we could easily fix that by
> >> truncating pg_statistic afterwards (its not like there will be useful
> >> data there...)
> 
> > I have added --analyze to the vacuumdb command and documented its
> > purpose.
> 
> Surely that's backwards?  What's the point of doing analyze work you'll
> have to throw away?

Hmmm, that is true;  removed.

> >> The end goal is going to be to have all this work happen in a standalone
> >> backend,
> 
> > Any idea how to do that?
> 
> I didn't say it was easy.

Well, seeing as we want something for 8.4, I figured you had a plan.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +