2009/8/12 Jonatan Evald Buus <jonatan.buus@xxxxxxxxxxxxxxxxxxx>: > Greetings, > We're seeing numerous "LOG: out of file descriptors: Too many open files in > system; release and retry" entries as well as quite a few "LOG: could not > open temporary statistics file "global/pgstat.tmp": Too many open files in > system" > Much more alarming however, we're seeing errors such as: > FATAL: could not open file "global/pg_database": Too many open files in > system > ERROR: could not open relation 1663/2219053/2601: Too many open files in > system > > kern.maxfiles is currently set to 12328 and "sysctl -a | grep > kern.openfiles" showed over 10.000 open files prior to a reboot. > After the reboot kern.openfiles quickly increased from less than 200 to over Did you request about kern.maxfiles? -- Emanuel Calvo Franco Database consultant at: www.siu.edu.ar www.emanuelcalvofranco.com.ar -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin