drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Artem Trush <vetri...@gmail.com>
Subject Changing the scope of output_batch_size option
Date Wed, 04 Nov 2020 10:16:53 GMT
Hi Drill Devs!
I have a question about the "output_batch_size" option. Is it safe to
change the scope of this parameter from system to both system and
session level? If not, what can happen?
The problem arose due to a performance issue in certain queries and
changing this option helps. But due to the fact that it is setted at
the system level, all executable queries began to absorb more memory
and as a result - out of memory issue. So, the solution to the problem
is to allow users to change this parameter at the session level to
affect only certain queries, without affecting all others at the
system.

Mime
View raw message