Re: temp files size and count

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: temp files size and count
Дата
Msg-id CALcG2DLZhT11hn9eo4GqZ5C61dGR0AzoKNcTBnFVc-rZ-YEx2g@mail.gmail.com
обсуждение исходный текст
Ответ на temp files size and count  (liam saffioti <liam.saffiotti@gmail.com>)
Ответы Re: temp files size and count
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: liam saffioti
Дата:
Сообщение: temp files size and count
Следующее
От: liam saffioti
Дата:
Сообщение: Re: temp files size and count