Date: Mon, 28 Jul 2008 09:47:02 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: Faludi =?iso-8859-1?Q?G=E1bor?= <gfaludi@fits.hu>,
	pgsql-performance@postgresql.org
Subject: Re: how does pg handle concurrent queries and same
	queries
Message-ID: <20080728134702.GA14617@alvh.no-ip.org>
References: <000301c8f07d$4bee0f10$e3ca2d30$@hu>
	<488D8754.2010208@postnewspapers.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <488D8754.2010208@postnewspapers.com.au>
User-Agent: Mutt/1.5.18 (2008-05-17)

Craig Ringer wrote:
> Faludi Gábor wrote:
> 
> > .         Why does the second and the later queries take the whole on second
> > if the dataset is the same . Shouldn't PG realise that the query is the same
> > so i give the user the same resultset ?
> 
> That would require a result cache. I don't know if Pg even has a query
> result cache - I don't think so, but I'm not sure.

It doesn't.

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