Aiven for PostgreSQL® 18 is now available

We're excited to announce that Aiven for PostgreSQL® 18 is now available on the Aiven platform. This major release brings a host of new features, performance improvements, and extensions to make your database even more powerful.

Here are some of the key highlights you can start using today:

• Asynchronous I/O subsystem: Significantly boosts performance for sequential scans, bitmap heap scans, and vacuums by queuing multiple read requests.
• Faster joins and GROUP BY: Experience improved performance and lower memory usage for these common operations.
• Parallel GIN indexes: Create GIN indexes in parallel to dramatically reduce maintenance time.
• NOT ENFORCED constraints: A new option that allows you to add CHECK and foreign key constraints without them being enforced, useful for data migration and schema evolution.
• Skip scans for B-tree indexes: This new capability improves performance for specific queries by allowing the index to "skip" over irrelevant data.
• Improved locking performance: Enjoy better performance in high-contention databases as queries that access many relations now have improved locking.

Learn more about this release and what it means for you:

• Full PostgreSQL 18 release notes
• Aiven for PostgreSQL service version lifecycle