Subj : PostgreSQL 18 released
To   : All
From : LWN.net
Date : Thu Sep 25 2025 15:15:09

PostgreSQL 18 released

Date:
Thu, 25 Sep 2025 14:08:19 +0000

Description:
Version
18 of the PostgreSQL database has been released. Notable
improvements in this release include "skip scan" lookups for
multicolumn B-tree indexes, virtual
generated columns , better text processing, oauth
authentication , and a new asynchronous I/O (AIO) subsystem to improve
performance: AIO lets PostgreSQL issue multiple I/O requests concurrently 
instead
of waiting for each to finish in sequence. This expands existing
readahead and improves overall throughput. AIO operations supported in
PostgreSQL 18 include sequential scans, bitmap heap scans, and
vacuum. Benchmarking has demonstrated performance gains of up to 3x in
certain scenarios. There are, of course, many other improvements and changes; 
see the release
notes for full details.

======================================================================
Link to news story:
https://lwn.net/Articles/1039483/


--- Mystic BBS v1.12 A49 (Linux/64)
 * Origin: tqwNet UK HUB @ hub.uk.erb.pw (1337:1/100)

.