New to Postgres 18, features like asynchronous i/o, uuid v7, b-tree skip scans, and virtual generated columns.

CrunchyData's platform is a central hub for PostgreSQL professionals and database administrators, offering insights into PostgreSQL deployment, administration, and optimization. Through articles, tutorials, and case studies, CrunchyData offers insights into PostgreSQL features, replication strategies, and high availability architectures. Readers can learn about database performance tuning, backup and recovery procedures, and security best practices to ensure the reliability and security of their PostgreSQL deployments.

Crunchy Data

PostgreSQL 18 introduces significant performance improvements including asynchronous I/O for faster reads, UUID v7 support for better indexing, B-tree skip scans for multi-column indexes, virtual generated columns as the default, and OAuth 2.0 authentication support. The async I/O feature allows workers to batch reads and optimize idle time, while UUID v7 provides better locality through timestamp-based prefixes. Skip scans enable using multi-column indexes even when leading columns aren't in query conditions, and virtual generated columns compute values on-the-fly without storage overhead.

Get Excited About Postgres 18

Postgres versions are packed with other improvements

<p>I am cooking up the front end atm, but with pg I cannot wait to play DBA! 🙃 ☺️  So nice I can stay in a modern, open sauce kitchen while cooking with all the utensils I need! (json(like nosql schemas), geo and vector ect.)</p>
