Thread: Deleted Records & file format

Deleted Records & file format

From
"Jonathan Bond-Caron"
Date:

Is there any documentation of the binary format of the ‘base’ tables?

 

I found that I can find where a table’s data stored with:

 

SELECT oid FROM pg_database WHERE datname = current_database();

SELECT relfilenode, reltoastrelid FROM pg_class WHERE relname = 'table';

 

/usr/local/pgsql/data/base/$oid/$relfilenode

 

From what I understand, deleted records should still be there unless vacuum removes them.

Is that right?