Re: Cleaning bloated pg_attribute - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Cleaning bloated pg_attribute
Date
Msg-id 42A96655.3090202@archonet.com
Whole thread Raw
In response to Cleaning bloated pg_attribute  (Michal Taborsky <michal.taborsky@mall.cz>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Michal Taborsky
Date:
Subject: Cleaning bloated pg_attribute
Next
From: "Martin Fandel"
Date:
Subject: Re: Importing from pg_dump slow, low Disk IO