UI freezes when running raw SQL query that takes a long time

[emhagman]

Hi! This is by far the best GUI for psql on Linux and I appreciate all your work :)

1. psql 10.15

2. TablePlus Build 80

3. Manjaro (Archlinux) 2021

4. Select a large table or do any query that lasts awhile and hit "Run Current" in the "SQL Query" window

I assume the query is being run in the same thread as the UI as when I run a raw query the UI freezes until the SQL query finishes. For example, running VACUUM ANALYZE large_table, the UI freezes until that finishes. Other GUI show a timer of query execution for example.

[thejspr]

This is still happening in build 200 on ubuntu 22.10.

[marcosbrasil]

Same thing here I think. When executing long queries, if I switch to another application , after a couple of minutes, the query seems to enter a hold state. When I switch back to tableplus, it resumes its self and the result fetch continues. I'm fetching results sets about 1.5M rows.

[brennoflavio]

It still happens, seems that a query blocks the main thread at least on Linux