On 13-Jan-07, at 7:24 PM, Tom Lane wrote:
Jignesh Shah <J.K.Shah@xxxxxxx> 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 majordomo@xxxxxxxxxxxxxx so that
your
message can get through to the mailing list cleanly