> Is both server/client running on FreeBSD or Windows, or are you switching > only part of the stack? When I run it it's all FreeBSD. When the other developer working on it runs it it's all Windows. > It shouldn't get stuck. It might be slower on some platforms, but it > shouldn't really get stuck, so it might be a bug. That's what I was starting to thing. > On linux I'd recommend perf/strace/... to investigate the issue, but I'm > not familiar with similar tool on Windows. On Windows I'm not sure what he could run either. > Is the query eating a lot of CPU, or is it just sitting there idle, doing > nothing? Or is there some other process doing a lot of CPU (e.g. Java)? IIRC it's eating CPU. I'll double check though. > Can you try running the query through 'psql' directly, to rule out JDBC > issues etc.? Try to collect explain plans for the query (maybe there's > something wrong with it). That's a good idea. I'll see what he can come up with. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
