• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: PostgreSQL performance through Plugin/JDBC
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Prev by Date: Re: Any JavaScript Experts?
  • Next by Date: Cocoa EO Apps
  • Previous by thread: Re: attn: Practical WO Authors/XML Ch.11 Question
  • Next by thread: Cocoa EO Apps
  • Index(es):
    • Date
    • Thread