Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 69BFC6501BA
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 21 Nov 2008 15:45:48 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 61606-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 21 Nov 2008 15:45:45 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp-out.neti.ee (smtp-out.neti.ee [194.126.126.44])
	by mail.postgresql.org (Postfix) with ESMTP id 1AD5664FE69
	for <pgsql-performance@postgresql.org>;
	Fri, 21 Nov 2008 15:45:45 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by MXR-4.estpak.ee (Postfix) with ESMTP id D963523EFCB;
	Fri, 21 Nov 2008 21:45:41 +0200 (EET)
X-Virus-Scanned: Debian amavisd-new at Relay4.estpak.ee
Received: from smtp-out.neti.ee ([127.0.0.1])
	by localhost (MXR-4.estpak.ee [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id e1JN9inTJTS7; Fri, 21 Nov 2008 21:45:40 +0200 (EET)
Received: from Relayhost3.neti.ee (relayhost3.estpak.ee [88.196.174.169])
	by MXR-4.estpak.ee (Postfix) with ESMTP id 5E08923EBA7;
	Fri, 21 Nov 2008 21:45:40 +0200 (EET)
X-SMTP-Auth-NETI-Businesmail: no
Received: from andrusnotebook (unknown [195.50.198.194])
	by Relayhost3.neti.ee (Postfix) with SMTP id 259E8D4C68;
	Fri, 21 Nov 2008 21:45:37 +0200 (EET)
Message-ID: <A44943E272DF48CC9BC306C513387020@andrusnotebook>
From: "Andrus" <kobruleht2@hot.ee>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Cc: "Richard Huxton" <dev@archonet.com>, "PFC" <lists@peufeu.com>,
	<pgsql-performance@postgresql.org>
References: <gg1sv3$27fr$1@news.hub.org> <49253FE1.3070706@archonet.com>
	<0205611B528C4C2CBA99AFC64E57D6E8@andrusnotebook>
	<op.ukw669uvcigqcu@soyouz>
	<75A918DFCF25470FAF96B3FE3D25A38B@andrusnotebook>
	<4926E2B2.9050202@archonet.com>
	<8A78204AA6D44C04B053E6412B244E13@andrusnotebook>
	<op.ukzdioivcigqcu@soyouz>
	<8D7F64CF7F614E13AC554D6CF86F39B2@andrusnotebook>
	<20081121191646.GH5210@alvh.no-ip.org>
In-Reply-To: <20081121191646.GH5210@alvh.no-ip.org>
Subject: Re: Hash join on int takes 8..114 seconds
Date: Fri, 21 Nov 2008 21:45:11 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=STOX_REPLY_TYPE=0.001
X-Spam-Level: 
X-Archive-Number: 200811/191
X-Sequence-Number: 31922

Alvaro,

> 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.

Thank you.
My 8.1.4 postgresql.conf does not contain such option. So vacuum_cost_delay 
is off probably.
Since doc does not recommend any value, I planned to use 2000

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

Uncommented relevant values in postgresql.conf file are:

shared_buffers = 15000
work_mem = 512
maintenance_work_mem = 131072
fsync = on
effective_cache_size= 70000
log_min_duration_statement= 30000

Andrus.