Postgres Pro
Downloads
Home   >   mailing lists

temp files size and count - Mailing list pgsql-admin

From liam saffioti
Subject temp files size and count
Date
Msg-id CAGHjuabD1Shvd=OM2vg9RrJM=gg_qvCwYH2ejJJsohvf1=fhBw@mail.gmail.com
Whole thread Raw
Responses Re: temp files size and count  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-admin
Tree view
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: Mladen Gogala
Date:
Subject: Re: Performance issue after creating partitions
Next
From: Mladen Gogala
Date:
Subject: Re: temp files size and count