Re: Fwd: temp_file_limit?

From: Frits Jalvingh <jal(at)etc(dot)to>
To:
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Fwd: temp_file_limit?
Date: 2022-12-19 17:27:57
Message-ID: CAKhTGFWSzMgqBijTmNhFXeSzFBg387r=cK0EoD-=CBrbksZb4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have listed the files during that run, I will try to add those as an
attachment to the mail, no idea if the list accepts that. There were 2024
files in that directory around the end...

Executing that lsof command only produces some warnings, no files:

root(at)chatelet:/d2/var/lib/postgresql/15/main/base# lsof -nn |grep pgsql_tmp
|grep -E 'DEL|deleted|inode|no such'
lsof: WARNING: can't stat() fuse.gvfsd-fuse file system /run/user/1000/gvfs
Output information may be incomplete.
lsof: WARNING: can't stat() fuse.jetbrains-toolbox file system
/tmp/.mount_jetbraOAyv5H
Output information may be incomplete.
lsof: WARNING: can't stat() fuse.portal file system /run/user/1000/doc
Output information may be incomplete.

Attachment Content-Type Size
pgtmpfiles.txt text/plain 135.2 KB

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2022-12-19 17:46:44 Re: Fwd: temp_file_limit?
Previous Message Justin Pryzby 2022-12-19 17:15:43 Re: Fwd: temp_file_limit?