Computer Science and Programming

Get Excited About Postgres 18

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.

❤9👍6

www.tgoop.com/computer_science_and_programming/1866

8.7K viewsOct 5 at 16:25

Get Excited About Postgres 18

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.

BY Computer Science and Programming