temp files size and count

From: liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: temp files size and count
Date: 2022-08-25 03:43:52
Message-ID: CAGHjuabD1Shvd=OM2vg9RrJM=gg_qvCwYH2ejJJsohvf1=fhBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mladen Gogala 2022-08-25 04:20:41 Re: temp files size and count
Previous Message Mladen Gogala 2022-08-25 02:55:04 Re: Performance issue after creating partitions