| From: | Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> |
|---|---|
| To: | liam saffioti <liam(dot)saffiotti(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: temp files size and count |
| Date: | 2022-08-25 04:20:41 |
| Message-ID: | CALcG2DLZhT11hn9eo4GqZ5C61dGR0AzoKNcTBnFVc-rZ-YEx2g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | liam saffioti | 2022-08-25 05:22:31 | Re: temp files size and count |
| Previous Message | liam saffioti | 2022-08-25 03:43:52 | temp files size and count |