Re: Server Overload - Mailing list pgsql-general

From Steve Wolfe
Subject Re: Server Overload
Date
Msg-id 001801c00c6a$bdbfbc60$50824e40@iboats.com
Whole thread Raw
In response to Server Overload  ("Arthur M. Kang" <arthur@levelogic.com>)
Responses Re: Server Overload
List pgsql-general
> 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Server Overload
Next
From: Vince Vielhaber
Date:
Subject: Re: [Solved] SQL Server to PostgreSQL