It might be worth setting "log_statement=true" in postgresql.conf and checking that you are executing *exactly* the same statement in both JDBC and psql.
regards
Mark
P.s : lets see the output from EXPLAIN ANALYZE :-)
Bill Chandler wrote:
Thanks for the advice.
On further review it appears I am only getting this performance degradation when I run the command via
a JDBC app. If I do the exact same query from
psql, the performance is fine. I've tried both the
JDBC2 and JDBC3 jars. Same results.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster