Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1A475650444 for ; Fri, 21 Nov 2008 15:13:55 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55363-01-4 for ; Fri, 21 Nov 2008 15:13:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from skynet.simkin.ca (skynet.simkin.ca [72.51.27.117]) by mail.postgresql.org (Postfix) with ESMTP id 57BED650448 for ; Fri, 21 Nov 2008 15:13:49 -0400 (AST) Received: from charon.medialogik.com (unknown [10.10.2.229]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by skynet.simkin.ca (Postfix) with ESMTP id 7D12B4A40 for ; Fri, 21 Nov 2008 11:13:47 -0800 (PST) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-performance@postgresql.org Subject: Re: Hash join on int takes 8..114 seconds Date: Fri, 21 Nov 2008 11:13:46 -0800 User-Agent: KMail/1.9.10 References: <63239.89.102.139.23.1227284110.squirrel@sq.gransy.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200811211113.46410@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/189 X-Sequence-Number: 31920 On Friday 21 November 2008, "Andrus" wrote: > Those commands cause server probably to stop responding to other client > like vacuum full pg_shdepend > did. > > Should vacuum_cost_delay = 2000 allow other users to work when running > those commands ? Any vacuum full or cluster will lock out other clients. A high vacuum_cost_delay will just make the vacuum run slower. -- Corporations will ingest natural resources and defecate garbage until all resources are depleted, debt can no longer be repaid and our money becomes worthless - Jay Hanson