| From: | Lamar Owen <lowen(at)pari(dot)edu> |
|---|---|
| To: | <jer(at)highboard(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PosgreSQL hogging resources? |
| Date: | 2004-02-20 18:48:29 |
| Message-ID: | 200402201348.29462.lowen@pari.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-02-20 18:51:01 | Re: PosgreSQL hogging resources? |
| Previous Message | scott.marlowe | 2004-02-20 18:43:23 | Re: PosgreSQL hogging resources? |