Re: [BUGS] Too many open files

Thanks, so far that looks like it is helping. Only time will tell :) I take it, that the pg_nofile is the max number of file to open per postgres session? Darin Tom Lane wrote: > Darin Fisher <[EMAIL PROTECTED]> writes: > > I am running PosgreSQL 7.1 on Redhat 6.2 Kernel 2.4

[BUGS] Too many open files

I am running PosgreSQL 7.1 on Redhat 6.2 Kernel 2.4.6. Under a pretty heavy load: 1000 Transactions per second 32 Open connections Everything restarts because of too many open files. I have increase my max number of open files to 16384 but this just delays the inevitable. I have