Databases
Postgres indexes beyond the basics: partial, expression and covering
A plain B-tree index on the right column solves most problems. For the rest, Postgres has index types that are smaller, faster and more precise.
Tag
#postgres
Every story tagged #postgres.
Databases
Full-text search without a search cluster
Before you add a dedicated search engine, check what your database already does. Postgres and SQLite both ship capable full-text search.
Databases
Database connection pooling, explained
Hitting "too many connections" errors is a rite of passage. Understanding how pools work — in your app and in front of your database — makes them go away.