Git vs Mercurial
Mercurial explains things patiently; Git sighs and rolls its eyes. Choose based on your project, not your preferences.
WordPress to Django+PostgreSQL, Part 4: Configuring Apache, Django, PostgreSQL
Set up Django, PostgreSQL, and Apache to serve your first web app. Step-by-step installation gets your Django project running on mod_wsgi.
WordPress to Django+PostgreSQL, Part 3: Installing Apache, Python 2.6, psycopg2, and mod_wsgi
Install Apache, Python 2.6, psycopg2, and mod_wsgi to get Django running on CentOS with PostgreSQL.
WordPress to Django+PostgreSQL: Part 2, Configuring PostgreSQL
Set up PostgreSQL on your VPS: create a postgres user, initialize a database cluster, enable PL/pgSQL and UUID functions, and configure automatic startup on…
The Mighty GUCS: A guide to the essential PostgreSQL settings you need to know
Watch the SFPUG October 2009 meeting video on GUCs (Grand Unified Configuration). Available for direct download or streaming on Vimeo.
WordPress to Django+PostgreSQL: Part 1, Installing PostgreSQL
Building PostgreSQL from source on CentOS 5.3: install dependencies, compile with OpenSSL and UUID support, and get ready to configure your database.
WordPress to Django+PostgreSQL: Introduction
Migrating a WordPress blog to Django and PostgreSQL on a bare VPS.
Getting PostgreSQL 8.4 to only listen on Unix sockets
PostgreSQL's `listen_addresses` parameter has a secret empty-string setting that disables TCP/IP entirely, leaving only Unix sockets active.
Only NATURAL: JOIN clauses vs WHERE conditions
NATURAL JOIN shortcuts can silently break when you add columns with matching names. Learn why explicit ON and USING clauses are safer and often more readable.
SFPUG: Statistics and Postgres – How the Planner Sees Your Data
Watch the September 8, 2009 SFPUG meeting video on PostgreSQL statistics and optimization techniques.