Postgres Pro
Downloads
Home   >   mailing lists

Re: how does pg handle concurrent queries and same queries - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: how does pg handle concurrent queries and same queries
Date
Msg-id 20080728134702.GA14617@alvh.no-ip.org
Whole thread Raw
In response to Re: how does pg handle concurrent queries and same queries  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: how does pg handle concurrent queries and same queries
Next
From: "Mark Wong"
Date:
Subject: Re: A guide/tutorial to performance monitoring and tuning