Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: how does pg handle concurrent queries and same queries
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
- Cc: Faludi Gábor <gfaludi(at)fits(dot)hu>, pgsql-performance(at)postgresql(dot)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> <text/plain>
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
- References:
- how does pg handle concurrent queries and same queries
- From: Faludi Gábor
- Re: how does pg handle concurrent queries and same queries
- From: Craig Ringer
- how does pg handle concurrent queries and same queries
- Prev by Date: Re: how does pg handle concurrent queries and same queries
- Next by Date: Re: A guide/tutorial to performance monitoring and tuning
- Previous by thread: Re: how does pg handle concurrent queries and same queries
- Next by thread: Re: how does pg handle concurrent queries and same queries
- Indexes: