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.
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]
PostgreSQL "auto_explain" functionality is a useful debugging helper that many people don't know about. Describes setup and use cases.
Business critical applications require full encryption to match legal requirements. We published a patch to provide full database encryption.
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.
WAL compression is a new feature of PostgreSQL 9.5 that not many are yet aware of. This post provides a test case highlighting the benefits.
A short how to on quickly spotting bloated PostgreSQL tables - 2 different methods. We also show how to artificially generate table bloat.
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: We posted a lot of tuning advice on this blog already. Now we thought we would […]
How to beat the latency of Uber's geo-fencing query by just using nice PostgreSQL code and 30 minutes of programming time.
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.
