Server Overload

From: "Arthur M(dot) Kang" <arthur(at)levelogic(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Server Overload
Date: 2000-08-22 18:00:46
Message-ID: 4.3.2.7.2.20000822105605.00aad890@mail.levelogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
I shut down one of the frontend servers to clear some connections to the DB
and then start it back up and everything seems to be back to normal.

Has anyone experienced anything similar? Does anyone have any suggestions
on what I could try to do to rectify this problem?

Any comments and/or suggestions are much appreciated!

Thanks.

Arthur

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mikeo 2000-08-22 18:52:26 Re: hidden data fields
Previous Message Tom Lane 2000-08-22 17:52:25 Re: [Solved] SQL Server to PostgreSQL