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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq