What is a good value for CONN_MAX_AGE in Django?

django database-connection django-1.6
Brendan Nee picture Brendan Nee · Nov 12, 2013 · Viewed 22.1k times · Source

Django 1.6 now supports CONN_MAX_AGE to pool database connections.

By default, the value is 0 (no pooling). What is a sensible value for this option?

Answer

MGP picture MGP · Feb 12, 2014

This value depends on the traffic of your site, the more traffic the more seconds to retain the connection, I'd recommend setting a relatively small value like 60 and tuning it accordingly to the usage pattern.



Edit (2018):

Like @jcyrss pointed out, this method has its quirks, for future reference I'd recommend handing out pooling to something like pgbouncer instead.

Related questions

How to debug "could not receive data from client: Connection reset by peer"

I'm running a django-celery application on Ubuntu-12.04. When I run a celery task from my web interface, I get the following error, taken form postgresql-9.3 logfile (maximum level of log): 2013-11-12 13:57:01 GMT tss_usr 8113 LOG: could not receive data …

Read More
Necessity of explicit cursor.close()

From time to time, I'm executing raw queries using connection.cursor() instead of using ORM (since it is definitely not a silver bullet). I've noticed that in several places I don't call explicit cursor.close() after I'm done with database. …

Read More
'pip' is not recognized as an internal or external command

I'm running into a weird error when trying to install Django on my computer. This is the sequence that I typed into my command line: C:\Python34> python get-pip.py Requirement already up-to-date: pip in c:\python34\lib\site-packages …

Read More