by alexpetralia » Mon May 16, 2016 4:32 pm
I have queries that hang on DBeaver yet run very fast on pgadmin. I have restarted DBeaver and the problem remains. I've turned off all metadata queries in the Preferences. I also am on Ubuntu. It almost feels like there's a DBeaver "wrapper" for the query that pgadmin doesn't have, and it's making the query slow. In this particular case, a "WHERE <col> NOT IN ( subquery )" made the query infinitely slow on DBeaver but ran fine on pgadmin. On the other hand, using a LEFT JOIN instead made the query run equally fast on both platforms. Does anyone know why this may be?