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
>