Postgres SQL HTX

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 […]

The PostgreSQL Global Development Group has released PostgreSQL 18.1 on November 13, 2025. This minor release brings critical security fixes and important bug corrections for users running PostgreSQL 18.0. What’s New in PostgreSQL 18.1 This maintenance release focuses on stability and security improvements rather than new features. Users running PostgreSQL 18.X can upgrade without requiring […]