PostgreSQL has an undeniably clever query planning system that auto-tunes based on the data in the system. This post looks under the covers at Postgres query plans, indexes, filters, and statistics.
A detailed look at the steps to create storage snapshots using pgBackRest delta restores for non-production use cases. This solves the need for frequent data copies combined with minimizing storage and thin provisioning.
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes meant to improve performance, but can cause limitations.
Paul Ramsey does a deep dive on number data types. Read about how to choose a number type that's most efficient for your data and storage requirements.
