Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za> wrote:
> >>> Now, is the bloat in the tables (which tables ?) or in the
> >>> indexes (which indexes ?), or in the toast tables perhaps, or in the
> >>> system catalogs or all of the above ? Or perhaps there is a
> >>> long-forgotten process that got zombified while holding a huge temp
> >>> table ? (not very likely, but who knows).
> >>> Use pg_relation_size() and its friends to get an idea of the size
> >>> of stuff.
> Can anybody give me some advice on the above? I'm not sure where to
> start looking or how to start looking
Running VACUUM VERBOSE will give you a detailed view of space usage of
each individual table.
Collaborative Fusion Inc.
In response to
pgsql-performance by date
|Next:||From: Florian Weimer||Date: 2008-04-15 13:27:20|
|Subject: Re: Performance increase with elevator=deadline|
|Previous:||From: Gaetano Mendola||Date: 2008-04-15 09:11:31|
|Subject: Re: shared_buffers performance|