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. +