> I've seen brief posts regarding server loads, distrubution for heavy
loads,
> etc, but don't recall if there were any solutions...
>
> Anyways...We are running a Postgres DB against multiple frontend
> webservers. For most of the time, everything runs fine. Then, all of a
> sudden, everything will start to go all funky. Crashing...Errors...Etc...
>
> When I log onto the DB server and try to do anything, I get "Too many open
> files in system." ulimit is set to unlimited and there is PLENTY of FREE
> memory.
What OS are you running? Despite ulimit being "unlimited", your kernel
may have a limit on either the number of open files, or the number of file
handles.
steve