Re: temp files size and count
| От | liam saffioti |
|---|---|
| Тема | Re: temp files size and count |
| Дата | |
| Msg-id | CAGHjuaYVX65UchPw-aRuZoz-8H3_QL77sQ59U++HLh+uPgBbCw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: temp files size and count (Mladen Gogala <gogala.mladen@gmail.com>) |
| Список | pgsql-admin |
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.RegardsOn 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 по дате отправления: