X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8AA84476361 for ; Fri, 2 May 2003 10:05:40 -0400 (EDT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id AC18147635E for ; Fri, 2 May 2003 10:05:39 -0400 (EDT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19BbAW-0004ky-00 for ; Fri, 02 May 2003 10:05:44 -0400 Received: by dba2 (Postfix, from userid 1019) id 0D759CF78; Fri, 2 May 2003 10:05:44 -0400 (EDT) Date: Fri, 2 May 2003 10:05:44 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Query Priority Message-ID: <20030502140543.GA13419@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.3i X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/5 X-Sequence-Number: 1784 On Fri, May 02, 2003 at 01:55:01PM +0100, Peter Childs wrote: > Is there some way to give some postgres backends higher priority. > Hence on a very busy server "important" queries get done faster than less > priority that unimportant queries. No. > I don't think this would be too difficult to do as certainly on > Linux the process could just be reniced and the os left to figure it out. > of course any query that is holding up another query with locks needs to > get done quickly. It's the latter condition that causes the problem for the nice-ing (among other things -- there's plenty of discussion about this in the archives. Tom Lane gave a quite long explanation one time, but I can't find it right now.) > I find my self with a database thats slowed to a craw because of a > slow batch program it not letting the gui clients the speed they require > to be usable. Sounds like what you really need is a replica database which you can use for batch reports, &c. You could do this with a small-ish box, because you'd only have one client. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110