David Noel <david.i.noel@xxxxxxxxx> writes: > Both queries are run from a Java project using the latest JDBC driver. > The PostgreSQL Server versions it's being run on are 9.2 and 9.3. The > query executes and returns just fine when run on a FreeBSD-based > platform, but executes forever when run under Windows. Um .. which one is 9.2, and which one is 9.3? Do you get the same plan according to EXPLAIN on both systems? (Even if you do, let's see the EXPLAIN output. And maybe EXPLAIN ANALYZE, on the system where it completes.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
