Received: from mail.memeticsystems.com (flywheel.memeticsystems.com [64.85.80.85]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBK2wam41458 for ; Wed, 19 Dec 2001 21:58:36 -0500 (EST) (envelope-from peter@memeticsystems.com) Received: (qmail 21234 invoked from network); 20 Dec 2001 02:58:39 -0000 Received: from unknown (HELO PETER) (63.249.24.21) by flywheel.memeticsystems.com with SMTP; 20 Dec 2001 02:58:39 -0000 From: "Peter T. Brown" To: , Subject: controlling process priority Date: Wed, 19 Dec 2001 18:58:37 -0800 Message-ID: <007301c18902$39df9b20$7d00000a@PETER> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200112/134 X-Sequence-Number: 2642 Hi-- I've got a complicated SQL select/insert which inserts up to 1 million records when run and can take up to 20 minutes to complete. Is there a way to control the priority of this select such that when Postgres is busy with other (higher priority) tasks it gets delayed?? My problem is that when dealing with lots of traffic, if one of these complex queries gets run, all the query traffic is slowed considerably thus hurting the performance of my application. Thanks, Peter T. Brown