lightdb=# create unlogged table unlogged_test (id int); CREATE TABLE lightdb=# select pg_relation_filepath('unlogged_test'); pg_relation_filepath ---------------------- base/13583/77186 (1 row) lightdb=# exit [lightdb@VM-16-10-centos scripts]$ cd $PGDATA/base/13583/ [lightdb@VM-16-10-centos 13583]$ ls -l | grep 77186 -rw------- 1 lightdb lightdb 0 Mar 5 16:30 77186 -rw------- 1 lightdb lightdb 0 Mar 5 16:30 77186_init