francis cherat <renaultf11@xxxxxxxxxxx> writes: > 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. Hmm. Can we see the query that causes this, and maybe EXPLAIN ANALYZE output for it? Also, 9.3.what exactly? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
