Re: files in database directory

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru>, pgsql-general(at)postgresql(dot)org
Subject: Re: files in database directory
Date: 2016-08-02 13:51:33
Message-ID: 847685bf-25d8-6260-3e23-78566b0458b2@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grigory Smolkin 2016-08-02 14:26:30 Re: files in database directory
Previous Message Grigory Smolkin 2016-08-02 13:44:32 files in database directory