by wmoran@[EMAIL PROTECTED]
(Bill Moran)
Apr 15, 2008 at 07:12 AM
Adrian Moisey <adrian@[EMAIL PROTECTED]
> wrote:
>
> Hi
>
> >>> 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.
--
Bill Moran
Collaborative Fusion Inc.
wmoran@[EMAIL PROTECTED]
412-422-3463x4023
--
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
