Postgres Pro
Downloads
Home   >   mailing lists

Re: abnormal data grow - Mailing list pgsql-general

From Tom Lane
Subject Re: abnormal data grow
Date
Msg-id 1027.1095779114@sss.pgh.pa.us
Whole thread Raw
In response to abnormal data grow  (Reynard Hilman <reynardmh@lightsky.com>)
List pgsql-general
Tree view 
Reynard Hilman <reynardmh@lightsky.com> writes:
> But in the filesystem data directory the total size is 12Gb. I noticed
> there are 10 files with 1Gb size each:
> 1.1G    25677563
> 1.1G    25677563.1
> ...

> I'm just wondering is there a way to know what that 25677563 file is?

select relname from pg_class where relfilenode = 25677563;

            regards, tom lane

pgsql-general by date:

Previous
From: Reynard Hilman
Date:
Subject: abnormal data grow
Next
From: Doug McNaught
Date:
Subject: Re: abnormal data grow