On Tue, 26 Aug 2003, Andrew Sullivan wrote:
> I'm afraid that's the problem, though. The code cannot recover freed
> btree pages which can't be recycled for others to use. There is no
> choice but to reindex certain indexes.
While we're at it, anybody got a clue on how to reindex system tables?
Our unit testing framework (yes, we unit test all of our database code)
has to do a lot of schema loads and drops, and the indexes for the
system tables (particularly pg_attribute) tend to grow dramatically,
slowing performance. (The total size of the pg_catalog starts out around
a few megabytes, and doesn't take too long to grow to several hundred
megabytes.)
So far, the only way I've found to fix this is to do a complete dump
and reload of the database, but that's a pain since we have tables with
mutual constraints that can't be reloaded without modifying the dump
file.
cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.NetBSD.org
Don't you know, in this new Dark Age, we're all light. --XTC