django-postgrespool2 2.0.1rc9

Postgres Connection Pooling for Django.

Django-PostgresPool2

This is a fork of original django-postgrespool.

Installation

Installing Django-PostgresPool2 is simple, with pip:

$ pip install django-postgrespool2

Usage

Using Django-PostgresPool2 is simple, just set django_postgrespool2 as your connection engine:

DATABASES = {
    'default': {
        'ENGINE': 'django_postgrespool2'

If you’re using the dj-database-url module:

import dj_database_url

DATABASES = {'default': dj_database_url.config(engine='django_postgrespool2')}

Everything should work as expected.

Configuration

Optionally, you can provide pool class to construct the pool (default sqlalchemy.pool.QueuePool) or additional options to pass to SQLAlchemy’s pool creation.

DATABASE_POOL_CLASS = 'sqlalchemy.pool.QueuePool'

DATABASE_POOL_ARGS = {
    'max_overflow': 10,
    'pool_size': 5,
    'recycle': 300
}

Here’s a basic explanation of two of these options:

• pool_size – The minimum number of connections to maintain in the pool.

• max_overflow – The maximum overflow size of the pool. This is not the maximum size of the pool.

The total number of “sleeping” connections the pool will allow is pool_size. The total simultaneous connections the pool will allow is pool_size + max_overflow.

As an example, databases in the Heroku Postgres starter tier have a maximum connection limit of 20. In that case your pool_size and max_overflow, when combined, should not exceed 20.

Check out the official SQLAlchemy Connection Pooling docs to learn more about the optoins that can be defined in DATABASE_POOL_ARGS.