Michal Taborsky wrote:
> I managed, by extensive usage of temporary tables, to totally bloat
> pg_attribute. It currently has about 40000 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 rendering
> the server unusable, because of the exclusive lock.
You can vacuum full a single table - shouldn't take an hour for just the
one table. Unless your disk I/O is *constantly* running flat-out.
--
Richard Huxton
Archonet Ltd