Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 2C6D19FA102
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 29 Dec 2006 10:26:23 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 60142-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 29 Dec 2006 10:26:16 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158])
	by postgresql.org (Postfix) with ESMTP id D593F9F9F08
	for <pgsql-performance@postgresql.org>;
	Fri, 29 Dec 2006 10:26:17 -0400 (AST)
Received: by fafnir.androme.com (Postfix, from userid 1003)
	id C1F20BA2D78; Fri, 29 Dec 2006 15:26:15 +0100 (CET)
Message-ID: <45952587.5060603@andromeiberica.com>
Date: Fri, 29 Dec 2006 15:26:15 +0100
From: Arnau <arnaulist@andromeiberica.com>
Reply-To: arnaulist@andromeiberica.com
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: High update activity, PostgreSQL vs BigDBMS
References: <45935A49.6080602@burntmail.com>
	<E1H0HFH-0004cw-6E@elasmtp-dupuy.atl.sa.earthlink.net>
In-Reply-To: <E1H0HFH-0004cw-6E@elasmtp-dupuy.atl.sa.earthlink.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200612/524
X-Sequence-Number: 22580

Hi all,

> A= go through each query and see what work_mem needs to be for that 
> query to be as RAM resident as possible.  If you have enough RAM, set 
> work_mem for that query that large.  Remember that work_mem is =per 
> query=, so queries running in parallel eat the sum of each of their 
> work_mem's.

How can I know what work_mem needs a query needs?

Regards
-- 
Arnau