Re: many many open files on pgsql_tmp with size 0

You may want to send the mail to pgsql-gene...@postgresql.org. This is a pgAdmin specific mailing list. -- Thanks, Ashesh On Sep 28, 2017 16:59, "francis cherat" wrote: > HI > > > when i execute a huge sql query on my database (version 9.3), i see many > many open files (36) on pgsql_tmp wi

many many open files on pgsql_tmp with size 0

HI when i execute a huge sql query on my database (version 9.3), i see many many open files (36) 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