Re: files in database directory - Mailing list pgsql-general

From Grigory Smolkin
Subject Re: files in database directory
Date
Msg-id 1a310fa6-f06f-0312-c994-99993f184a0a@postgrespro.ru
Whole thread Raw
In response to Re: files in database directory  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

On 08/02/2016 04:51 PM, Adrian Klaver wrote:
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.  ...
"
Thank you, I overlooked that part.

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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: files in database directory
Next
From: Ladislav Lenart
Date:
Subject: Re: consolidating data with window functions