many many open files on pgsql_tmp with size 0

From: francis cherat <renaultf11(at)hotmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: many many open files on pgsql_tmp with size 0
Date: 2017-09-28 07:43:57
Message-ID: HE1PR0802MB22986300C3389F737F4250FDDC790@HE1PR0802MB2298.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 pgsql-general by date

  From Date Subject
Next Message Denisa Cirstescu 2017-09-28 08:08:44 Re: Catching errors inside a LOOP is causing performance issues
Previous Message John Britto 2017-09-28 07:32:34 Re: WAL Archive command.