search

TablePlus / TablePlus-Linux

TablePlus Linux issue tracker
https://tableplus.com
293 stars 30 forks source link

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

Open emhagman opened 3 years ago

emhagman commented 3 years ago

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 commented 1 year ago

This is still happening in build 200 on ubuntu 22.10.

marcosbrasil commented 1 year ago

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 commented 5 months ago

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