Django's QuerySet caching and default fetch behavior can silently consume gigabytes of memory on large result sets.

Stop writing result[4]—psycopg2.3 beta now lets you fetch query results as named tuples with intuitive dot notation.

PostgreSQL 9.0's streaming replication will be a game-changer for small businesses managing critical data—finally making high availability something a casual…

Users claim they don't need replication—until they lose a day's data.

What does "web scale" actually mean? Let's move past the marketing speak and pin down some numbers for what constitutes truly high-volume database performance.

Django connections pile up in "Idle in Transaction" state because it skips COMMIT for read-only queries. Here's why it happens and how to fix it.

I need more information about the post to write an accurate teaser.

ORMs promise to hide SQL's complexity—but often hide its power instead. See why raw queries sometimes win.

Slides from an introduction to PostgreSQL talk are now online.

Watch the archived video from the February 9, 2010 San Francisco PostgreSQL User Group meeting.