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

Re: db size

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: db size
Date: 2008-04-15 07:33:06
Message-ID: 48045A32.3010607@careerjunction.co.za (view raw or flat)
Thread:
Lists: pgsql-performance
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

-- 
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

In response to

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2008-04-15 09:05:12
Subject: Re: shared_buffers performance
Previous:From: Adam GundyDate: 2008-04-14 22:16:41
Subject: Re: varchar index joins not working?

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