RE: How to implement connection pool in superset to maintain DB sessions.

2021-05-03 Thread Thammaneni, Srinivasa Rao
Hi Max, Thanks for the feedback. I have enabled the connection pool with QueuePool and tried to see the utilization of connection pool with help of "Pool.checkedout()" method by following below reference and official sqlalchemy documentation as well. But I couldn't see the "utilization of

Re: How to implement connection pool in superset to maintain DB sessions.

2021-04-30 Thread Maxime Beauchemin
One thing that may not be intuitive is the fact that each web "worker" will create its own pool, so a gunicorn process with 4 workers and a pool of 20 you can expect up to 80 connections. Max On Fri, Apr 30, 2021 at 6:08 AM Thammaneni, Srinivasa Rao < sthamman...@teksystems.com> wrote: > Hi

How to implement connection pool in superset to maintain DB sessions.

2021-04-30 Thread Thammaneni, Srinivasa Rao
Hi Team, i am using superset0.36 version, have observed superset is creating more no.of db sessions when dashboards/reports are running continuously. Sometimes due to high load/no.of schedule jobs are running db sessions are breaking. I thought to see whether connection pool creation for