django.contrib.gis.db.backends.postgis vs django.db.backends.postgresql_psycopg2

Question

If a gis application has some tables which don't have gis related columns, does the performance better when use multiple databases (django.db.backends.postgresql_psycopg2 and django.contrib.gis.db.backends.postgis) compared using django.contrib.gis.db.backends.postgis only?

Multiple Databases also introduce some performance overhead and complexity. Could anyone show me the best practice for this scenario?

Have you figured this out?? I started a gis app today and am wondering the same thing. any advice would be appreciated. — dm03514, Feb 29 '12 at 23:21

score 22 · Accepted Answer · answered Mar 17 '12 at 22:37

22

The performance difference will be almost completely invisible. django.contrib.gis.db.backends.postgis just extends django.db.backends.postgresql_psycopg2 to add the PostGiS types. It is definitely not worth going through the complexity of multiple databases just to use the two different backends.

answered Mar 17 '12 at 22:37

Christophe

2,052
1
19
24

Your answer save my day. – Chirag Maliwal Jan 29 '18 at 14:33

django.contrib.gis.db.backends.postgis vs django.db.backends.postgresql_psycopg2

1 Answers1