On 13-Jan-07, at 7:24 PM, Tom Lane wrote:

Jignesh Shah <[EMAIL PROTECTED]> writes:
The appserver is basically using bunch of prepared statements that the
server should be executing directly without doing the parsing again.

Better have another look at that theory, because you're clearly spending a lot of time in parsing (operator resolution to be specific). I think
your client code is failing to re-use prepared statements the way you
think it is.

This is exactly what is happening. The driver needs to cache statements for this to work.


                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not

Reply via email to