From: Alvaro Herrera <alvherre@commandprompt.com>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: Faludi Gábor <gfaludi@fits.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: how does pg handle concurrent queries and same queries
Date: Mon, 28 Jul 2008 09:47:02 -0400
Message-ID: <20080728134702.GA14617@alvh.no-ip.org> (raw)
In-Reply-To: <488D8754.2010208@postnewspapers.com.au>
References: <000301c8f07d$4bee0f10$e3ca2d30$@hu>
<488D8754.2010208@postnewspapers.com.au>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, craig@postnewspapers.com.au, gfaludi@fits.hu
Subject: Re: how does pg handle concurrent queries and same queries
In-Reply-To: <20080728134702.GA14617@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox