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

2 process postgres -D for one instance

Hi, some time whe have 2 process postgres for 1 instance like this exppgs 17769 1 0 01:06 ?00:01:04 /usr/pgsql-9.3/bin/postgres -D /bases/postgresql/scl/data -i -p 5450 -h bd-sillage.info. exppgs 39922 17769 0 15:39 ?00:00:00 /usr/pgsql-9.3/bin/postgres -D /bases