Re: Cleaning bloated pg_attribute

From: Richard Huxton <dev(at)archonet(dot)com>
To: Michal Taborsky <michal(dot)taborsky(at)mall(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Cleaning bloated pg_attribute
Date: 2005-06-10 10:07:17
Message-ID: 42A96655.3090202@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Martin Fandel 2005-06-10 10:14:36 Re: Importing from pg_dump slow, low Disk IO
Previous Message Michal Taborsky 2005-06-10 09:05:45 Cleaning bloated pg_attribute