many many open files on pgsql_tmp with size 0

From: francis cherat <renaultf11(at)hotmail(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: many many open files on pgsql_tmp with size 0
Date: 2017-09-28 11:29:16
Message-ID: HE1PR0802MB2298DB7854C9E955719B688ADC790@HE1PR0802MB2298.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

HI

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.

This behavior impact the max inodes limite on the FS.

Is this expected behavior ?

Regards

Francis

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ashesh Vashi 2017-09-28 12:14:28 Re: many many open files on pgsql_tmp with size 0
Previous Message Dave Page 2017-09-27 07:52:59 Re: pgAdmin 4 v2.0 Release Candidate 2