Re: PostgreSQL performance through Plugin/JDBC
Re: PostgreSQL performance through Plugin/JDBC
- Subject: Re: PostgreSQL performance through Plugin/JDBC
- From: Arturo Pérez <email@hidden>
- Date: Fri, 2 Sep 2005 21:53:58 -0400
Hi Guido,
I found the below on the pgSQL jdbc mailing list. There's a thread
there titled: Performance problem using V3 protcol in jdbc
"Barry Lind" <email@hidden> writes:
> ... On a hunch I switched the jdbc driver to using the V2 protocol
> and the load on the machine dropped down to what it was when using
> Oracle and everything was fine.
First knee-jerk reaction is that it's an optimization problem stemming
from V3 protocol feeding parameterized queries to the backend where V2
did not, and the planner being unable to cope :-(
Can you identify the specific queries causing the problem?
regards, tom lane
-arturo
On Sep 2, 2005, at 7:21 AM, Arturo Pérez wrote:
On Sep 2, 2005, at 2:47 AM, Guido Neitzer wrote:
On 01.09.2005, at 21:53 Uhr, Arturo Perez wrote:
Please let me know how this works out. I do plan on upgrading but
just haven't found a good time to do it. What with Xcode 2+
breaking some things, Tiger breaking others the last thing I need is
for pgSQL 8.x to polish off the rest.
Currently I can't recommend upgrading to a recent PostgreSQL due to
the fact, that you can only use it with a 7.4 JDBC driver if you want
your indexes used with "standard" webobjects functions.
If you only use rawRowForSQL, you may decide to upgrade, if not, I
would wait until this is solved.
I have tested now:
- PostgreSQL 8.0.1, 8.0.3, 8.1beta
- all recent v3 JDBC-Drivers
It works for me with the 7.4 Driver but I don't know whether there
are side effects. Also I didn't receive valuable answers to my
question on the mailing lists so far.
You're asking on the JDBC lists?
In my opinion, the query planner (concept) must be totally broken, if
it is a difference whether you provide the value for a select
"inline" or separately. Sorry, no.
As long as this isn't solved I'll stick with Frontbase where I know
the bugs I have to avoid ... :-/ Or perhaps I should try MySQL ...
You really don't want to go the MySQL route.
cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden