Skip site navigation (1) Skip section navigation (2)

Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work

From: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Thomas Burdairon <tburdairon(at)entelience(dot)com>, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Date: 2008-05-29 03:13:12
Message-ID: 483E1F48.8040708@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
Are there any head fixes proposed for it?

I am seeing some scaling problems with EAStress which uses JDBC with 
8.3.0 and this one could be the reason why I am seeing some problems.. I 
will be happy to try it out and report on it.. The setup is ready right 
now if someone can point me to a patch that I can try it out and 
hopefully see if the patch fixes my problem.

-Jignesh


Dave Cramer wrote:
> It's pretty easy to test.
>
> prepare the query
> and
> run explain analyze on the prepared statement.
>
> Dave
> On 10-Apr-08, at 5:47 AM, Thomas Burdairon wrote:
>
>> Is there any patch available for this one?
>>
>> I'm encountering troubles with some JDBC queries and I'd like to test 
>> it before asking some help on the JDBC list.
>>
>> Thanks.
>> Tom
>>
>> -- 
>> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>
>

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-05-29 03:19:45
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Previous:From: MikeDate: 2008-05-29 01:47:22
Subject: Re: intercepting WAL writes

pgsql-jdbc by date

Next:From: Tom LaneDate: 2008-05-29 03:19:45
Subject: Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work
Previous:From: Kris JurkaDate: 2008-05-28 20:28:51
Subject: Re: ResultSet & setFetchSize fails to stop heap failures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group