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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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