A look at the new PostgreSQL 18 release.

💬 Topics:
- Asynchronous I/O;
- Query performance optimizations;
- Virtual generated columns;
- UUID version 7;
- Temporal constraints.

📚 Learn to Code with Scrimba (20% off Pro):
https://scrimba.com/?via=AwesomeCoding

Awesome Coding's resource offer curated lists of resources, tools, and libraries for software developers. Readers can learn about programming languages, frameworks, and development tools across various domains. With carefully selected recommendations and community contributions, Awesome Coding helps developers discover new tools and resources to enhance their productivity and skills.

Awesome

PostgreSQL 18 introduces significant performance improvements through asynchronous I/O support, delivering 2-3x better performance in read-heavy applications. Key features include smarter query optimization for OR/IN clauses, enhanced hash joins, virtual generated columns as default, UUID version 7 support with timestamp ordering, improved RETURNING clause functionality, and temporal constraints with WITHOUT OVERLAPS. The upgrade process is now smoother with preserved statistics, eliminating the need to rebuild planner statistics after major version upgrades.

Postgres 18 just dropped. Now is the best time to learn it...

<p>Postgresql didn’t “just drop”. It’s still in beta and has been since May. Not releasing until September or October.</p>
