Re: Fwd: temp_file_limit?

From: Frits Jalvingh <jal(at)etc(dot)to>
To: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Fwd: temp_file_limit?
Date: 2022-12-19 19:59:31
Message-ID: CAKhTGFUivvdxwSsTAbCDw1fAXGh6ZWTn692AAK5VyeY=CmRnUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

@ranier
These files ONLY exist during the query. They get deleted as soon as the
query terminates, by Postgres itself. Once the query terminates pgsql_tmp
is completely empty. Considering what Thomas said (and the actual
occurrence of the files he mentioned) this does seem to be the more likely
cause to me.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Munro 2022-12-19 20:07:48 Re: Fwd: temp_file_limit?
Previous Message Justin Pryzby 2022-12-19 19:50:03 Re: Fwd: temp_file_limit?