Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 764309FB44C for ; Sun, 11 Feb 2007 14:13:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 73464-04-5 for ; Sun, 11 Feb 2007 14:13:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.183]) by postgresql.org (Postfix) with ESMTP id 0904E9FB430 for ; Sun, 11 Feb 2007 14:13:14 -0400 (AST) Received: from [194.25.154.138] (helo=webserv.wug.de) by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis), id 0MKxQS-1HGJCJ0ejC-00046Q; Sun, 11 Feb 2007 19:13:11 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1HGJCG-0007ST-00 for pgsql-general@postgresql.org; Sun, 11 Feb 2007 19:13:08 +0100 Date: Sun, 11 Feb 2007 19:13:08 +0100 From: "A. Kretschmer" To: pgsql-general@postgresql.org Subject: Re: [ADMIN] Priorities for users or queries? Message-ID: <20070211181307.GA28557@a-kretschmer.de> References: <45CE69B5.40204@araisoft.com> <376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com> <20070211084716.GB6652@KanotixBox> <1890.1171215477@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1890.1171215477@sss.pgh.pa.us> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! X-Message-Flag: "Windows" is not the answer. "Windows" is the question and the answer is "no"! User-Agent: Mutt/1.5.9i X-Provags-ID: kundenserver.de abuse@kundenserver.de login:51ea9561fc3f6d9539a2acd743e4748c X-Provags-ID2: V01U2FsdGVkX19ddU0c462sAFDb8SchIo302WMUjXYGo9qsAd0AdcH4p3waYg8cAr4vNLro5dyBrTOwohru/EpNGbDftQk7pITQJvyc43lYkf/ifTpR/NqDmNaB4n2Rn5A1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/516 X-Sequence-Number: 109006 am Sun, dem 11.02.2007, um 12:37:57 -0500 mailte Tom Lane folgendes: > Andreas Kretschmer writes: > > You can retrieve the PID and the username of running querys in > > pg_stat_activity. Perhaps, with this knowledge and an untrusted language > > you can run system-commands such renice to change the priority of > > running postmaster-processes. > > See "priority inversion" in the archives. Thanks for the hint, i have seen 'Magnus Hagander's mail ;-) Btw.: thanks you and others for your excellent work to improve PostgreSQL. I'm only a customer, but i want to help others. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net