· 1 min · PostgreSQL

Beyond the B-Tree: GIST and GIN Indexes

Explore index types beyond PostgreSQL's default B-Tree. Learn when to reach for GiST, GIN, and BRIN indexes to solve real performance problems.

0 comments

· 1 min · Django

Django 1.8 and PostgreSQL at Djangocon 2015

Django 1.8 brings powerful new PostgreSQL features to your web framework. Discover what's new in our DjangoCon 2015 slides.

1 comment

· 1 min · PostgreSQL

PostgreSQL and JSON: 2015

Slides from my PGConf US 2015 talk on JSON in PostgreSQL are now available for download.

0 comments

· 1 min · PostgreSQL

Logical Decoding and JSON Talks at FOSDEM

Slides from talks on PostgreSQL logical decoding and JSON handling are now online.

0 comments

· 4 min · PostgreSQL

When LIMIT attacks

PostgreSQL sometimes picks an unexpectedly slow index-based plan when a LIMIT clause is present, especially when column statistics don't reflect data…

6 comments

· 1 min · PostgreSQL

“Be Very Afraid: Backup and Disaster Planning” at PGConf.EU

Slides from "Be Very Afraid: Backup and Disaster Planning" are now online. Learn how to protect your PostgreSQL data when things go wrong.

5 comments

· 1 min · PostgreSQL

“Finding and Repairing Database Corruption” at PGConf.EU

Finding and repairing database corruption is tricky—here are the slides from a deep dive into detection and recovery techniques.

0 comments

· 1 min · Language Issues

Why I prefer Python to Java, in two code samples.

Verify HTTPS connections against a custom root CA certificate instead of the system trust store.

4 comments

· 5 min · Django

Why I Resigned as Djangocon US 2014 Program Chair

A program chair's resignation from Djangocon US 2014 exposes organizational failures and interpersonal conflict that nearly derailed the conference.

0 comments

· 1 min · Django

Djangocon 2014 US CFP Closes Soon

DjangoCon US 2014 is accepting talk and tutorial proposals until July 15—submit yours today.

0 comments