Re: many many open files on pgsql_tmp with size 0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: francis cherat <renaultf11(at)hotmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: many many open files on pgsql_tmp with size 0
Date: 2017-09-28 17:18:27
Message-ID: 596.1506619107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

francis cherat <renaultf11(at)hotmail(dot)com> writes:
> when i execute a huge sql query on my database (version 9.3), i see many many open files (360000) on pgsql_tmp with size 0.
> This files are deleted where the query is done.

Hmm. Can we see the query that causes this, and maybe EXPLAIN ANALYZE
output for it? Also, 9.3.what exactly?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John McKown 2017-09-28 17:22:49 Re: Function to return per-column counts?
Previous Message Tomas Vondra 2017-09-28 17:15:43 Re: Function to return per-column counts?