That is interesting - both psql and JDBC merely submit statements for
the backend to process, so generally you would expect no difference in
execution plan or performance.
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.
>
>
>
>
>
>
>