@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.
- Re: Fwd: temp_file_limit? Thomas Munro
- Re: Fwd: temp_file_limit? Thomas Munro
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Ranier Vilela
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Ranier Vilela
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Justin Pryzby
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Ranier Vilela
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Thomas Munro
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Justin Pryzby
- Re: Fwd: temp_file_limit? Justin Pryzby
- Re: Fwd: temp_file_limit? Frits Jalvingh
- Re: Fwd: temp_file_limit? Justin Pryzby
- Re: Fwd: temp_file_limit? Frits Jalvingh