[jira] [Commented] (AIRFLOW-5870) Optimise pool query and allow infinite pool for tasks
[ https://issues.apache.org/jira/browse/AIRFLOW-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16972465#comment-16972465 ] ASF subversion and git services commented on AIRFLOW-5870: -- Commit e991948c4bf7d8c9971365fe494a622772f3a5ad in airflow's branch refs/heads/v1-10-test from Alex Guziel [ https://gitbox.apache.org/repos/asf?p=airflow.git;h=e991948 ] [AIRFLOW-5870] Allow -1 for pool size and optimise pool query (#6520) (cherry-picked from commit 4a12041ac06a038e0af68ce3e19e46200d2f6376) > Optimise pool query and allow infinite pool for tasks > - > > Key: AIRFLOW-5870 > URL: https://issues.apache.org/jira/browse/AIRFLOW-5870 > Project: Apache Airflow > Issue Type: Improvement > Components: scheduler >Affects Versions: 1.10.6 >Reporter: Alex Guziel >Assignee: Alex Guziel >Priority: Major > Fix For: 1.10.7 > > > Pools do not allow infinite sized pools. Infinite sized pools can make > queries much cheaper > > The count() query in Pool query for number of tasks running was slow and this > change fixes it (as described here): > [https://stackoverflow.com/questions/12941416/how-to-count-rows-with-select-count-with-sqlalchemy] > Also here: > [https://stackoverflow.com/questions/14754994/why-is-sqlalchemy-count-much-slower-than-the-raw-query] > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (AIRFLOW-5870) Optimise pool query and allow infinite pool for tasks
[ https://issues.apache.org/jira/browse/AIRFLOW-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16971787#comment-16971787 ] ASF subversion and git services commented on AIRFLOW-5870: -- Commit 0573f064b016f4e4f8494d8e061f571428096b70 in airflow's branch refs/heads/v1-10-test from Alex Guziel [ https://gitbox.apache.org/repos/asf?p=airflow.git;h=0573f06 ] [AIRFLOW-5870] Allow -1 for pool size and optimise pool query (#6520) (cherry-picked from commit 4a12041ac06a038e0af68ce3e19e46200d2f6376) > Optimise pool query and allow infinite pool for tasks > - > > Key: AIRFLOW-5870 > URL: https://issues.apache.org/jira/browse/AIRFLOW-5870 > Project: Apache Airflow > Issue Type: Improvement > Components: scheduler >Affects Versions: 1.10.6 >Reporter: Alex Guziel >Assignee: Alex Guziel >Priority: Major > Fix For: 1.10.7 > > > Pools do not allow infinite sized pools. Infinite sized pools can make > queries much cheaper > > The count() query in Pool query for number of tasks running was slow and this > change fixes it (as described here): > [https://stackoverflow.com/questions/12941416/how-to-count-rows-with-select-count-with-sqlalchemy] > Also here: > [https://stackoverflow.com/questions/14754994/why-is-sqlalchemy-count-much-slower-than-the-raw-query] > > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (AIRFLOW-5870) Optimise pool query and allow infinite pool for tasks
[ https://issues.apache.org/jira/browse/AIRFLOW-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16971178#comment-16971178 ] ASF subversion and git services commented on AIRFLOW-5870: -- Commit 01413c091469377c65d41cdb85f7b8b5267d054c in airflow's branch refs/heads/v1-10-test from Alex Guziel [ https://gitbox.apache.org/repos/asf?p=airflow.git;h=01413c0 ] [AIRFLOW-5870] Allow -1 for pool size and optimise pool query (#6520) > Optimise pool query and allow infinite pool for tasks > - > > Key: AIRFLOW-5870 > URL: https://issues.apache.org/jira/browse/AIRFLOW-5870 > Project: Apache Airflow > Issue Type: Improvement > Components: scheduler >Affects Versions: 1.10.6 >Reporter: Alex Guziel >Assignee: Alex Guziel >Priority: Major > Fix For: 1.10.7 > > > Pools do not allow infinite sized pools. Infinite sized pools can make > queries much cheaper -- This message was sent by Atlassian Jira (v8.3.4#803005)