pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Tom Lane <tgl@sss.pgh.pa.us>
To: Devendra Singh Rawat <Devendra_Rawat@infosys.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Disk Space issue
Date: Tue, 10 Jun 2008 21:28:37 -0400
Message-ID: <27795.1213147717@sss.pgh.pa.us> (raw )
In-Reply-To: <4242E42288B6E842A52B88D4B3A3E620E0610625@AUSMELMBX01.ad.infosys.com >
References: <484E61A0.5030706@kerkhove.net >
<484E88AB.6020505@kerkhove.net >
<4242E42288B6E842A52B88D4B3A3E620E0610550@AUSMELMBX01.ad.infosys.com >
<1213142115.17340.213.camel@jd-laptop >
<4242E42288B6E842A52B88D4B3A3E620E0610579@AUSMELMBX01.ad.infosys.com >
<1213142730.17340.218.camel@jd-laptop >
<4242E42288B6E842A52B88D4B3A3E620E0610625@AUSMELMBX01.ad.infosys.com >
Devendra Singh Rawat <Devendra_Rawat@infosys.com> writes:
> We ran the SQL to get the table which are consuming maximum space.
> The results are as shown:-
> SELECT relname, relpages FROM pg_class ORDER BY relpages DESC;
> relname | relpages
> --------------------------------------------------+----------
> <table-1> | 52869
> <table-2> | 31267
> <table-3> | 15418
> <table-4> | 9693
> <table-5> | 6426
> But these only cover around few GB of data.
pg_class.relpages is only up-to-date as of the last VACUUM.
There's already good reason to suspect that you're not vacuuming
enough; maybe some big tables are not getting vacuumed at all.
I'd suggest having a look into the data directory to see for yourself
which are the big files. The documentation might help you:
http://www.postgresql.org/docs/8.3/static/storage.html
(IIRC, all of this except the material on tablespaces will apply
to 7.4.)
regards, tom lane
view thread (13+ messages) latest in thread
Message-ID: <27795.1213147717@sss.pgh.pa.us>
Permalink: ../27795.1213147717@sss.pgh.pa.us/
Also on: postgresql.org/message-id/27795.1213147717@sss.pgh.pa.us
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Devendra_Rawat@infosys.com, jd@commandprompt.com
Subject: Re: Disk Space issue
In-Reply-To: <27795.1213147717@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox