Thread: temp files size and count
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
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
Hi Mladen,
Thank your for your advice. I changed the temp_buffers parameter, and I am monitoring what happens.
Best,
Laim
Mladen Gogala <gogala.mladen@gmail.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.RegardsOn 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