Re: Unaccounted for disk use - Mailing list pgsql-novice

From Tom Lane
Subject Re: Unaccounted for disk use
Date
Msg-id 8101.1053538402@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unaccounted for disk use  (Chris Cameron <chris@upnix.com>)
List pgsql-novice
Chris Cameron <chris@upnix.com> writes:
> [root@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

pgsql-novice by date:

Previous
From: Chris Cameron
Date:
Subject: Re: Unaccounted for disk use
Next
From: Josh Berkus
Date:
Subject: Re: Installing PlPerl