
"Users and developers can expect the release of PostgreSQL 18 in September, the new iteration of the popular open source database, promising new features to enhance analytics and distributed architectures. In July, the Stack Overflow survey showed that PostgreSQL had extended its lead as the most popular database for professional developers, 58 percent of whom use it, compared to 40 percent using MySQL and 30 percent using Microsoft SQL Server."
""With asynchronous I/O, what the CPU can now do is issue a read for data from disk, and instead of waiting for that data to come back, it can asynchronously issue multiple such read requests and take them in simultaneously," Shahid said. "The feature allows PostgreSQL to leverage the CPU more efficiently, instead of bottlenecking on I/O and disk, and especially with the read commands in analytical workloads that require lots of joins, and lots of parallel workload. It can significantly improve performance.""
PostgreSQL 18 will release in September and brings features aimed at improving analytics and support for distributed architectures. Market adoption has risen: 58 percent of professional developers use PostgreSQL, up from 52 percent, while MySQL and Microsoft SQL Server register 40 percent and 30 percent respectively. PostgreSQL has traditionally been used for OLTP rather than analytics. A new asynchronous I/O subsystem will let the database issue multiple read requests without waiting for disk responses, improving CPU utilization on modern storage like SSDs. Tests show up to 200–300 percent gains in some analytical workloads. Developers should consider hardware and concurrency configurations when deploying the feature.
Read at Theregister
Unable to calculate read time
Collection
[
|
...
]