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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-jdbc by date

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