Re: Unaccounted for disk use

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Cameron <chris(at)upnix(dot)com>
Cc: Pgsql-Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Unaccounted for disk use
Date: 2003-05-21 17:33:22
Message-ID: 8101.1053538402@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Chris Cameron <chris(at)upnix(dot)com> writes:
> [root(at)ilearner 16976]# du -hs * | grep M
> 26M 1456419
> 6.1M 1456422
> 35M 639251
> 30M 639253
^^^^^^

The file names correspond to values in the relfilenode column of
pg_class. Now look in pg_class to discover exactly which tables or
indexes these large files are.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Michel POURE 2003-05-21 17:48:56 Re: ENCODING (Unicode)
Previous Message Reshat Sabiq 2003-05-21 17:19:05 Re: ENCODING (Unicode)