How to include “set enable_nestloop to off” into Virtual Table?
13 February, 2014
Dear Yellowfin Support Team!
Due to a performance issue with queries based on one particular view, we have analyzed the Query Plan (using PostgreSQL 9.3) and came to the result that the query is much faster when "set enable_nestloop to off".
Inserting the command directly into the SQL on Database level works fine. But inserting the command into a virtual table in Yellowfin does not work:
Thus, is there a way to insert "set enable_nestloop to off" into a Virtual Table? Or is there a other way to do it in Yellowfin?
We don't want to disable nestloop for the whole database.
Thank you so much!
Due to a performance issue with queries based on one particular view, we have analyzed the Query Plan (using PostgreSQL 9.3) and came to the result that the query is much faster when "set enable_nestloop to off".
Inserting the command directly into the SQL on Database level works fine. But inserting the command into a virtual table in Yellowfin does not work:
Thus, is there a way to insert "set enable_nestloop to off" into a Virtual Table? Or is there a other way to do it in Yellowfin?
We don't want to disable nestloop for the whole database.
Thank you so much!
Hi Sebastian,
I would recommend creating this as a database view. A database view is essentially the same as the virtual table, except the database manages all of the heavy lifting.
Let us know how you go.
Cheers!
I would recommend creating this as a database view. A database view is essentially the same as the virtual table, except the database manages all of the heavy lifting.
Let us know how you go.
Cheers!
Thank you!
Hi Cameron,
my DB Admins have tried a while now to create a view with "set enable_nestloop to off" within PostgreSQL but according to them PostgreSQL seems not to support this. Do you see any other way to do this or to include this function into Yellowfin?
We have found a couple of reports which increase drastically in performance when disabling nestloop.
Thank you for your support!
Kind regards,
Sebastian
my DB Admins have tried a while now to create a view with "set enable_nestloop to off" within PostgreSQL but according to them PostgreSQL seems not to support this. Do you see any other way to do this or to include this function into Yellowfin?
We have found a couple of reports which increase drastically in performance when disabling nestloop.
Thank you for your support!
Kind regards,
Sebastian
Hi Sebastian,
Unfortunately there is no way around this in Yellowfin, what you're trying to do is configure how a query is run in Yellowfin.
Yellowfin just uses select statements.
You will need to do this via the DB somewhow :(.
Sorry for the bad news.
Regards,
David
Unfortunately there is no way around this in Yellowfin, what you're trying to do is configure how a query is run in Yellowfin.
Yellowfin just uses select statements.
You will need to do this via the DB somewhow :(.
Sorry for the bad news.
Regards,
David
Again thank you for your reply, David.