Postgres Connection Pooling for Django, powered by SQLAlchemy.
Clone or download
kennethreitz Merge pull request #29 from j00bar/patch-1
Use psycopg2 attr to test connection usability
Latest commit ce83a4d Jan 2, 2018
Failed to load latest commit information.
django_postgrespool Merge pull request #29 from j00bar/patch-1 Jan 2, 2018
.gitignore removing things that are part of django Jun 28, 2014
LICENSE lawyer up Sep 27, 2012 manifest Sep 27, 2012
README.rst Update README.rst May 21, 2015 v0.3.0 Aug 29, 2014



This is a simple Postgres Connection Pooling backend for Django 1.4+, powered by the lovely and beautiful SQLAlchemy.


Using Django-PostgresPool is simple, just set django_postgrespool as your connection engine:

    'default': {
        'ENGINE': 'django_postgrespool'

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

import dj_database_url

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

If you're using south:

    'default': 'south.db.postgresql_psycopg2'

Everything should work as expected.


Installing Django-PostgresPool is simple, with pip:

$ pip install django-postgrespool


Optionally, you can provide additional options to pass to SQLAlchemy's pool creation:

    '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.

Django 1.3 Support

django-postgrespool currently supports Django 1.4 and greater. See this ticket for 1.3 support.