Postgres Pro
Downloads
Home   >   mailing lists

Re: temp files size and count - Mailing list pgsql-admin

From Mladen Gogala
Subject Re: temp files size and count
Date
Msg-id CALcG2DLZhT11hn9eo4GqZ5C61dGR0AzoKNcTBnFVc-rZ-YEx2g@mail.gmail.com
Whole thread Raw
In response to temp files size and count  (liam saffioti <liam.saffiotti@gmail.com>)
Responses Re: temp files size and count  (liam saffioti <liam.saffiotti@gmail.com>)
List pgsql-admin
Tree view
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.saffiotti@gmail.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

pgsql-admin by date:

Previous
From: liam saffioti
Date:
Subject: temp files size and count
Next
From: liam saffioti
Date:
Subject: Re: temp files size and count