From: Lamar Owen <lowen@pari.edu>
To: jer@highboard.com
To: pgsql-admin@postgresql.org
Subject: Re: PosgreSQL hogging resources?
Date: Fri, 20 Feb 2004 13:48:29 -0500
Message-ID: <200402201348.29462.lowen@pari.edu> (raw)
In-Reply-To: <FKEOIJEHOIKIOEHCGNCLAEOJEDAA.jer@highboard.com>
References: <FKEOIJEHOIKIOEHCGNCLAEOJEDAA.jer@highboard.com>
On Friday 20 February 2004 01:39 pm, Jeremy Smith wrote:
> I have newly installed PostgreSQL onto my server, the server's main
> function is to serve up a fantasy football site that has a tremendous
> number of queries per page. Right now with very low traffic I am seeing a
> server load of 2.0+.
Not too bad.
> That got me a little concerned, so I looked at "top"
> and noticed that postgres is taking anywhere from 60 - 100 percent of my
> CPU at any given time.
That would be good.
> There are also 116 sleeping processes out of 123.
> This all seems very bad, do you guys have any idea what might be causing it
> or how it can be addressed?
>How do I go about cleaning out the sleeping
> processes?
You don't. Sleeping processes is a normal thing with a multitasking OS.
How fast does the page load? That would be the big question. Run apache
bench (ab) against the page and see how many pages per second yu can get. A
load of 2.0, an average CPU of 60-100%, and 7 running processes is not bad at
all. It just means your server is working.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: lowen@pari.edu, jer@highboard.com
Subject: Re: PosgreSQL hogging resources?
In-Reply-To: <200402201348.29462.lowen@pari.edu>
References: <FKEOIJEHOIKIOEHCGNCLAEOJEDAA.jer@highboard.com> <200402201348.29462.lowen@pari.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox