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

From Adrian Klaver
Subject Re: files in database directory
Date
Msg-id 847685bf-25d8-6260-3e23-78566b0458b2@aklaver.com
Whole thread Raw
In response to files in database directory  (Grigory Smolkin <g.smolkin@postgrespro.ru>)
Responses Re: files in database directory  (Grigory Smolkin <g.smolkin@postgrespro.ru>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Grigory Smolkin
Date:
Subject: files in database directory
Next
From: Grigory Smolkin
Date:
Subject: Re: files in database directory