Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] many many open files on pgsql_tmp with size 0 - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] many many open files on pgsql_tmp with size 0
Date
Msg-id 596.1506619107@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] many many open files on pgsql_tmp with size 0  (francis cherat <renaultf11@hotmail.com>)
List pgsql-general
Tree view 
francis cherat <renaultf11@hotmail.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
size0. 
> 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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [GENERAL] Function to return per-column counts?
Next
From: John McKown
Date:
Subject: Re: [GENERAL] Function to return per-column counts?