Exploding runtime: How nested loops can destroy speed
What will happen if the PostgreSQL optimizer underestimates the number of rows involved in nested loops? Includes ways to fix the problem.
paginators - The story about voluntary pain in PostgreSQL
If you want to display millions of entries on your website, you definitely turn to paginators. Here's how you do it right using PostgreSQL.
Inheritance - One more reason to love PostgreSQL
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.
PostgreSQL exclusion constraints: Beyond UNIQUE
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]
PostgreSQL instance-level encryption
Business critical applications require full encryption to match legal requirements. We published a patch to provide full database encryption.
BRIN indexes: Correlation, correlation, correlation
BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exaggerate and use them far too frequently.
Watch command - how to watch a PostgreSQL database
How to use the watch command: allows you to watch the program output change over time. It is therefore a perfect tool to track down errors.
UNIX sockets vs. localhost: PostgreSQL Performance advice
Unix sockets vs. localhost: We posted a lot of tuning advice on this blog already. Now we thought we would […]
Beating Uber with a PostgreSQL prototype
How to beat the latency of Uber's geo-fencing query by just using nice PostgreSQL code and 30 minutes of programming time.
Migrating from Oracle: One word about pg_type
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.
