Re: [HACKERS] reducing bloat in pg_statistic

2005-12-16 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > I'm looking at a postgresql 7.3 database that has gotten rather bloated > in pg_statistic: > I am trying to figure out a way to shrink this down to something more > reasonable, with the caveat of not restarting the database server. You haven't got too man

[HACKERS] reducing bloat in pg_statistic

2005-12-16 Thread Robert Treat
I'm looking at a postgresql 7.3 database that has gotten rather bloated in pg_statistic: VACUUM verbose pg_statistic; INFO: --Relation pg_catalog.pg_statistic-- INFO: Index pg_statistic_relid_att_index: Pages 4420; Tuples 1590: Deleted 3789. CPU 0.33s/0.03u sec elapsed 0.96 sec. INFO: R