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:48:05
Message-ID: 20081121194805.GI5210@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Andrus wrote:

> Will value of 30 allow other clients to work when VACUUM FULL is running ?

1. vacuum_cost_delay does not affect vacuum full
2. vacuum full is always blocking, regardless of settings

So I gather you're not doing any vacuuming, eh?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-11-21 20:07:02 Re: Hash join on int takes 8..114 seconds
Previous Message Andrus 2008-11-21 19:45:11 Re: Hash join on int takes 8..114 seconds