[GENERAL] files in database directory

[Grigory Smolkin]

Hello, everyone!

I found some files in postgresql database directory:

t13_14363083
t13_14363081
t13_14363098

Some of them are quite old. Can someone explain their purpose?

[Adrian Klaver]

Post by Grigory Smolkin
Hello, everyone!
t13_14363083
t13_14363081
t13_14363098
Some of them are quite old. Can someone explain their purpose?

https://www.postgresql.org/docs/9.5/static/storage-file-layout.html
"
... But for temporary relations, the file name is of the form tBBB_FFF,
where BBB is the backend ID of the backend which created the file, and
FFF is the filenode number. ...
"

Post by Grigory Smolkin
--
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

[Grigory Smolkin]

Post by Adrian Klaver

Post by Grigory Smolkin
Hello, everyone!
t13_14363083
t13_14363081
t13_14363098
Some of them are quite old. Can someone explain their purpose?

https://www.postgresql.org/docs/9.5/static/storage-file-layout.html
"
... But for temporary relations, the file name is of the form
tBBB_FFF, where BBB is the backend ID of the backend which created the
file, and FFF is the filenode number. ...
"

Thank you, I overlooked that part.