Adrian Moisey <[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. [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
