Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
You’ve got PostGISqueries up and running—now what? If you completed the 15-minute quickstart, you’ve seen the basics: creating spatial tables, inserting points, and running simple distance queries. But PostGIS offers so much more. In this follow-up guide, I’ll show you five immediately useful PostGIS techniques that go beyond simple point queries. These are practical patterns […]
If you’ve ever wanted to add spatial capabilities to your PostgreSQL database but weren’t sure where to start, this guide is for you. In just 15 minutes, you’ll go from enabling the PostGIS extension to visualizing your first geographic data on a map. What is PostGIS? PostGIS is a powerful open-source extension that transforms PostgreSQL […]
PostgreSQL has quietly crossed an important line in the last year: AI with Postgres is no longer a science project, it is genuinely competitive with specialized vector databases at production scale. From “possible” to “competitive” For a long time, the story around AI and Postgres sounded like “you can do it if you really want […]
The PostgreSQL 18 async I/O feature has generated a lot of excitement—and for good reason. Lab benchmarks show 2–3× better read throughput on cloud storage compared to synchronous I/O. But if you’re expecting to downsize your AWS RDS instances by 3× and pocket massive savings, I have news: real-world deployments tell a more nuanced story. […]
Working with JSON in PostgreSQL has evolved from a novelty to a production necessity. After spending years optimizing JSON workloads across dozens of deployments, I’ve seen engineers make the same mistakes—and discover the same performance breakthroughs. Here are the JSON tricks that separate production-ready code from amateur hour.1. JSONB vs JSON: Stop Using JSON This […]
1. Learn PostgreSQL (latest edition) “Learn PostgreSQL” (recent editions target PostgreSQL 15–16) is a beginner-friendly, end-to-end introduction that stays useful even after you’re no longer a beginner. It walks through SQL basics, core internals like transactions and MVCC, replication, security, backups, and monitoring, with hands-on exercises that resemble real production use cases.goodreads+1 Why a PostgreSQL […]
PostgreSQL continues to dominate as the most admired and widely adopted relational database, and the ecosystem around it is richer than ever. If you work with Postgres in production, choosing a few high‑signal blogs to follow can keep you ahead of performance issues, new features, and architectural best practices. 1. Planet PostgreSQL: The Community Firehose […]
When PostgreSQL 18 dropped in September 2025, the async I/O subsystem was the headline feature that had database administrators and performance engineers buzzing. Six months into production deployments across diverse infrastructure environments, we now have enough real-world data to move beyond the release notes and understand how async I/O actually performs in the wild. This […]
The PostgreSQL community released PostgreSQL 18 in September 2025, marking one of the most significant performance improvements in the database’s history. If you’re running read-heavy workloads or operating in cloud environments, this release deserves your immediate attention.The Game-Changer: Asynchronous I/O The headline feature in PostgreSQL 18 is the new asynchronous I/O (AIO) subsystem. This isn’t […]
In PostgreSQL, TO_DATE is for dates only, so when your string includes both date and time you must use TO_TIMESTAMP or a cast to a timestamp type instead. TO_DATE vs TO_TIMESTAMP TO_DATE(text, format) converts a string into a date, so any time portion in the input is ignored, even if the format mask includes time […]
