Django persistent database connection
Solution 1:
Django 1.6 has added persistent connections support (link to doc for latest stable Django ):
Persistent connections avoid the overhead of re-establishing a connection to the database in each request. They’re controlled by the CONN_MAX_AGE parameter which defines the maximum lifetime of a connection. It can be set independently for each database.
Solution 2:
Try PgBouncer - a lightweight connection pooler for PostgreSQL. Features:
- Several levels of brutality when rotating connections:
- Session pooling
- Transaction pooling
- Statement pooling
- Low memory requirements (2k per connection by default).