Vick Khera <vivek@xxxxxxxxx> writes: > On Tue, Aug 25, 2009 at 1:09 PM, Alvaro > Herrera<alvherre@xxxxxxxxxxxxxxxxx> wrote: >> PG is not supposed to crash when it runs out of file descriptors. In >> fact there's a whole abstraction layer to ensure this does not happen. > From my syslog: > Aug 21 15:11:13 d01 postgres[12037]: [156-1] PANIC: could not open > file "pg_xlog/00000001000013E300000014" (log file 5091, segment 20): > Too many open files in system This is probably coming from walwriter, which might not have very much of a cushion of "extra" open files to close. 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