Re: [PERFORM] Cleaning bloated pg_attribute

2005-06-10 Thread Richard Huxton
Michal Taborsky wrote: I managed, by extensive usage of temporary tables, to totally bloat pg_attribute. It currently has about 4 pages with just 3000 tuples. The only thing I could think of is VACUUM FULL, but from my former experience I guess it'll take maybe over an hour, effectively r

[PERFORM] Cleaning bloated pg_attribute

2005-06-10 Thread Michal Taborsky
I managed, by extensive usage of temporary tables, to totally bloat pg_attribute. It currently has about 4 pages with just 3000 tuples. The question is, how to restore it to it's former beauty? With ordinary table I'd just CLUSTER it, but alas! I cannot do that with system catalog. I always