Re: files in database directory

[Grigory Smolkin <g.smolkin@xxxxxxxxxxxxxx>]

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