PG 8.3.7 on HP 11.31. Very strong Server with lots of memory. A query runs that inserts 40K records takes 1 second when run from psql. It takes 20 minutes!! And 100% CPU !! when called from a standalone JDBC program. No other users are running !!!
The problematic query: 2013-01-02 15:00:38.008 ISTLOG: duration: 1207547.589 ms execute <unnamed>: insert into CMR_IOALOG_2 select * from CMR_IOALOG_PRE where ORDERNO in (select ORDERNO from CMR_AJF_PRE) or ORDERNO=0 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
