Reynard Hilman <reynardmh(at)lightsky(dot)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