Re: many many open files on pgsql_tmp with size 0

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: francis cherat <renaultf11(at)hotmail(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: many many open files on pgsql_tmp with size 0
Date: 2017-09-28 12:14:28
Message-ID: CAG7mmowG53J34ZT6LUCED5juo_nyWC5m0zoCE7djoWNVe7KBrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

You may want to send the mail to pgsql-general(at)postgresql(dot)org(dot)
This is a pgAdmin specific mailing list.

-- Thanks, Ashesh

On Sep 28, 2017 16:59, "francis cherat" <renaultf11(at)hotmail(dot)com> wrote:

> 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
>
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Mark Watson 2017-09-29 14:21:42 Encrypted role password
Previous Message francis cherat 2017-09-28 11:29:16 many many open files on pgsql_tmp with size 0