temporary files - Mailing list pgsql-general

From dangal
Subject temporary files
Date
Msg-id 1570481561995-0.post@n3.nabble.com
Whole thread Raw
Responses Re: temporary files
List pgsql-general
Hello everyone, I have a question to see if you can help me, I have set
work_mem in 100 MB but I have the following in the pgbadger

Queries generating the most temporary files (N)

Count Total size   Min size      Max size    Avg size
   58   3.24 GiB     57.15 MiB  57.15 MiB 57.15 MiB

How could it be that if you require 57 MB, 100 MB will not reach ?
thanks a lot



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



pgsql-general by date:

Previous
From: Erik Aronesty
Date:
Subject: Re: pgcrypto question
Next
From: Artur Zając
Date:
Subject: Table locking during backup