temporary files

From: dangal <danielito(dot)gallo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: temporary files
Date: 2019-10-07 20:52:41
Message-ID: 1570481561995-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Artur Zając 2019-10-07 21:00:08 Table locking during backup
Previous Message Erik Aronesty 2019-10-07 20:39:07 Re: pgcrypto question