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.
Quote of the Day
When an application's lock strategy feels more broken than cautious, it's time to rethink your approach to concurrency.
Quote of the Day
Hovercrafts sound fun until you realize they have no brakes, slide sideways in the wind, and the authorities banned them from roads for good reason.
SFPUG: Windowing and Common Table Expressions
Watch the August 2009 San Francisco PostgreSQL User Group meeting. Video available for streaming or download.
Quote of the Day
Dijkstra's famous quip reminds us that asking "can machines think" is as misguided as asking "can submarines swim"—the real questions are about capability and…