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