From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Hash join on int takes 8..114 seconds
Date: Fri, 21 Nov 2008 11:13:46 -0800
Message-ID: <200811211113.46410@hal.medialogik.com> (raw)
In-Reply-To: <EDAB641B4D004D1BB5126A75CFBDD79F@andrusnotebook>
References: <gg1sv3$27fr$1@news.hub.org>
<63239.89.102.139.23.1227284110.squirrel@sq.gransy.com>
<EDAB641B4D004D1BB5126A75CFBDD79F@andrusnotebook>
On Friday 21 November 2008, "Andrus" <kobruleht2@hot.ee> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: Hash join on int takes 8..114 seconds
In-Reply-To: <200811211113.46410@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox