Jacob Kaplan-Moss

7 items tagged β€œpostgres”

πŸ“Œ SectorLabs/django-postgres-extra

Adds (among other features) upsert (ON CONFLICT ...) support for Django/Postgres. #

πŸ“Œ PostgreSQL Exercises #
πŸ“Œ pgRouting

Geographic routing algorithms on top of PostGIS. #

πŸ“Œ Replication, Clustering, and Connection Pooling - PostgreSQL Wiki

Nice high-level comparison of the various PostgreSQL replication, clustering, load balancing, and connection pooling solutions. #

πŸ“Œ Feeding the Cloud: Finding the size of a Postgres database on disk

We were just discussing the easiest way to do this at LPDN last night. #

πŸ“Œ Amazon Web Services Blog: 100% on Amazon Web Services: Soocial.com

A look at one app’s AWS architecture. Nginx, HAProxy, Rails, pgpool II, PostgreSQL, and RabbitMQ. I didn’t realize that pgpool II did sharding at the balancer layer; that makes this kind of set up much easier. #

πŸ“Œ Josh Berkus: Finding Useless Indexes #