| From: | Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: files in database directory |
| Date: | 2016-08-02 14:26:30 |
| Message-ID: | 1a310fa6-f06f-0312-c994-99993f184a0a@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ladislav Lenart | 2016-08-02 15:16:37 | Re: consolidating data with window functions |
| Previous Message | Adrian Klaver | 2016-08-02 13:51:33 | Re: files in database directory |