Postgres Pro
Downloads
Home   >   mailing lists

Re: temp files size and count - Mailing list pgsql-admin

From liam saffioti
Subject Re: temp files size and count
Date
Msg-id CAGHjuaYVX65UchPw-aRuZoz-8H3_QL77sQ59U++HLh+uPgBbCw@mail.gmail.com
Whole thread Raw
In response to Re: temp files size and count  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-admin
Tree view
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.
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

pgsql-admin by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: temp files size and count
Next
From: liam saffioti
Date:
Subject: postgresql statement problem