Re: Terrible performance after deleting/recreating indexes

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