Deleted Records & file format
От
Jonathan Bond-Caron
Тема
Deleted Records & file format
Дата
Msg-id
002001caa4e3$762be4c0$6283ae40$@com
Список
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?
В списке pgsql-general по дате отправления
От: Pedro Zorzenon Neto
Дата: