X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F15DAD1F1CA for ; Wed, 5 May 2004 17:04:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 28245-03 for ; Wed, 5 May 2004 17:03:58 -0300 (ADT) Received: from web13807.mail.yahoo.com (web13807.mail.yahoo.com [216.136.175.17]) by svr1.postgresql.org (Postfix) with SMTP id F220ED1BBB9 for ; Wed, 5 May 2004 17:03:55 -0300 (ADT) Message-ID: <20040505200355.43021.qmail@web13807.mail.yahoo.com> Received: from [216.173.173.66] by web13807.mail.yahoo.com via HTTP; Wed, 05 May 2004 13:03:55 PDT Date: Wed, 5 May 2004 13:03:55 -0700 (PDT) From: Chris Gamache Reply-To: cgg007@yahoo.com Subject: Postmaster hogs CPU To: pgsql-admin@postgresql.org In-Reply-To: <1083773198.21180.464.camel@camel> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200405/50 X-Sequence-Number: 13366 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