Skip site navigation (1) Skip section navigation (2)

Re: db size

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: db size
Date: 2008-04-15 11:12:22
Message-ID: 20080415071222.36b2e8eb.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-performance
Adrian Moisey <adrian(at)careerjunction(dot)co(dot)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(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

  • Re: db size at 2008-04-15 07:33:06 from Adrian Moisey

Responses

  • Re: db size at 2008-04-17 06:28:42 from Adrian Moisey

pgsql-performance by date

Next:From: Florian WeimerDate: 2008-04-15 13:27:20
Subject: Re: Performance increase with elevator=deadline
Previous:From: Gaetano MendolaDate: 2008-04-15 09:11:31
Subject: Re: shared_buffers performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group