>
>
>
> Try:
> SELECT oid,* from pg_database ;
>
> I suspect the relfilnode you are looking at is another database in the
> cluster.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>
Maybe I am possibly doing that. I did a du -h --max-depth=1 in the base/
within the data directory. This showed a single folder that contained ~34
GB. On performing a ls in this, it showed 2 oids/filenodes that had more
than 1 GB (multiple files with .<number> at the end). The large table I
mentioned in the original post was in this folder, so I assumed that the
rest of the files in the same directory belonged to the same DB.
Have I made an incorrect assumption ?