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.
Dave
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
match
