Обсуждение: files in database directory
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?
-- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
On 08/02/2016 06:44 AM, Grigory Smolkin wrote: > 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? 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. ... " > > -- > Grigory Smolkin > Postgres Professional: http://www.postgrespro.com > The Russian Postgres Company > -- Adrian Klaver adrian.klaver@aklaver.com
On 08/02/2016 04:51 PM, Adrian Klaver wrote:
On 08/02/2016 06:44 AM, Grigory Smolkin wrote:Thank you, I overlooked that part.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?
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. ...
"
-- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company