Re: temp files size and count

Hi Mladen,

Thank your for your advice. I changed the temp_buffers parameter, and I am
monitoring what happens.
Best,
Laim

Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>, 25 Ağu 2022 Per, 07:20 tarihinde
şunu yazdı:

> Hi Liam,
> Temp files are created when temp buffers do not suffice. I would try
> increasing temp_buffers to 64mb and see what happens.
> Regards
>
> On Wed, Aug 24, 2022, 11:44 PM liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>
> wrote:
>
>> Hi Team,
>>
>> I am using PG 14.5 for 12 days. My production database generates 33TB in
>> 12 days. This value is horrible, isn't it? Also, there are 453836 temp
>> files.
>>
>> The application is running a CREATE TEMP TABLE statement very heavily.
>>
>> My temp_buffers is 8MB and work_mem is 128MB. Should I increase these
>> parameters or others?There are about 2000 idle connections.
>>
>> Thanks in advance for your help.
>> Liam
>>
>