forums

Use these forums to ask questions and discuss Tableau.

Query cancellation stalling

Posted July 16th, 2008 by elloyd
in Data Sources and Performance

I use Tableau with PostgreSQL 8.3, and often have canceled queries that never complete. This essentially locks up the application to the point it becomes unusable. I recall reading that canceled queries will happen in the background with information remaining in the status bar. Is there a reason this wouldn't happen the same way with an RDBMS?

Add new comment

Comments

On July 17th, 2008 Ross Bunker said:

Can you describe the situation a bit more? You hit cancel in the dialog, and then what happens? The dialog stays up and continues counting? or does it go away, but another one comes up? Do the dialogs go away, but then the application freezes up anyway?

thanks,
:)ross

reply
On July 18th, 2008 elloyd said:

The cancel dialog remains in place, and it hangs, I guess. If I have a complicated query in SQL, when using a client application like pgAdmin for example, I can cancel it properly and the program continues almost immediately. Tableau, on the other hand, often gets stuck like a memory leak is happening and chews the CPU by 40-50%. I'll try to recreate a situation with it.

reply
On August 12th, 2008 Ross Bunker said:

Any luck recreating the problem?

reply
Syndicate content Subscribe to the comments on "Query cancellation stalling"