Re: db size

Adrian Moisey <adrian@careerjunction.co.za> 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@collaborativefusion.com
Phone: 412-422-3463x4023