| From: | Chris Gamache <cgg007(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Postmaster hogs CPU |
| Date: | 2004-05-05 20:03:55 |
| Message-ID: | 20040505200355.43021.qmail@web13807.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
When I run an query (that I have identified as expensive, and non-critical), I
would like to be able to take its priority down a few notches to allow the
standard every-day tasks of the DB to run unhindered. As it stands, postmasters
elbow each other out for processor time, and it seems like one expensive query
can bring other DB functions to a crawl.
Hardware : Dual P4 Xeon 2.8GHz; 1 GB RAM; ULTRA320 RAID 10 with an ext3
filesystem
PostgreSQL 7.4.2
What can be done to allow for smarter preemption? Could I do anything at the OS
level to throttle that particular postmaster's process? I'm running (IMO) a
balanced config, but there's always room for improvement. Its that oddball
query that comes around once every so often that causes the problem.
CG
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-05-05 21:25:16 | Re: Postmaster hogs CPU |
| Previous Message | Peter Eisentraut | 2004-05-05 17:10:26 | Re: Limiting user access to a view only |