Skip site navigation (1) Skip section navigation (2)

Re: Hash join on int takes 8..114 seconds

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hash join on int takes 8..114 seconds
Date: 2008-11-21 19:13:46
Message-ID: 200811211113.46410@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Friday 21 November 2008, "Andrus" <kobruleht2(at)hot(dot)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

In response to

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2008-11-21 19:16:46
Subject: Re: Hash join on int takes 8..114 seconds
Previous:From: AndrusDate: 2008-11-21 19:10:21
Subject: Re: Hash join on int takes 8..114 seconds

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group