Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 5FFB364FCD9
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 28 Nov 2008 15:57:59 -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 79918-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 28 Nov 2008 15:57:56 -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 A4EB164FC78
	for <pgsql-performance@postgresql.org>;
	Fri, 28 Nov 2008 15:57:56 -0400 (AST)
X-Virus-Scanned: Debian amavisd-new at estpak.ee
Received: from Relayhost3.neti.ee (relayhost3.estpak.ee [88.196.174.169])
	by MXR-8.estpak.ee (Postfix) with ESMTP id BF8D6885B9;
	Fri, 28 Nov 2008 21:57:51 +0200 (EET)
X-SMTP-Auth-NETI-Businesmail: no
Received: from andrusnotebook (unknown [195.50.198.194])
	by Relayhost3.neti.ee (Postfix) with SMTP id 1D061D4D44;
	Fri, 28 Nov 2008 21:57:47 +0200 (EET)
Message-ID: <8553B7AAE7294B4BAB18B759978ECD24@andrusnotebook>
From: "Andrus" <kobruleht2@hot.ee>
To: "Scott Carey" <scott@richrelevance.com>,
	"Scott Marlowe" <scott.marlowe@gmail.com>
Cc: <pgsql-performance@postgresql.org>
References: <ggp1au$1iq2$1@news.hub.org>
	<BDFBB77C9E07BE4A984DAAE981D19F961ACA17D9C9@EXVMBX018-1.exch018.msoutlookonline.net>
	<3E5CE5640FFD4172956D223988D8D578@andrusnotebook>,
	<dcc563d10811281024l4cc3a063r4f17ba8337b1ee36@mail.gmail.com>
	<BDFBB77C9E07BE4A984DAAE981D19F961ACA17D9CE@EXVMBX018-1.exch018.msoutlookonline.net>
In-Reply-To: 
 <BDFBB77C9E07BE4A984DAAE981D19F961ACA17D9CE@EXVMBX018-1.exch018.msoutlookonline.net>
Subject: Re: Increasing GROUP BY CHAR columns speed
Date: Fri, 28 Nov 2008 21:57:43 +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/296
X-Sequence-Number: 32027

Application should work with any server starting at 8.1 with any RAM size 
(probably starting at 1 GB).

How to find safe value which does not cause error in SET work_mem command ?

If I use 2 GB maybe this can cause excaption when running in server with 1 
GB RAM where this setting may be not allowed.

Andrus.