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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: Richard Huxton <dev(at)archonet(dot)com>, PFC <lists(at)peufeu(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Hash join on int takes 8..114 seconds
Date: 2008-11-21 19:16:46
Message-ID: 20081121191646.GH5210@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Andrus wrote:

> I discovered vacuum_cost_delay=2000 option. Will this remove blocking
> issue and allow vacuum full to work ?

No.

Are you really using vacuum_cost_delay=2000? If so, therein lies your
problem. That's a silly value to use for that variable. Useful values
are in the 20-40 range probably, or maybe 10-100 being extremely
generous.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2008-11-21 19:45:11 Re: Hash join on int takes 8..114 seconds
Previous Message Alan Hodgson 2008-11-21 19:13:46 Re: Hash join on int takes 8..114 seconds