TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

PostgreSQL 18 Beta 1 Released

10 pointsby jkatz0517 days ago

1 comment

kiwicopple17 days ago
This release includes Asynchronous I&#x2F;O (AIO):<p><a href="https:&#x2F;&#x2F;pganalyze.com&#x2F;blog&#x2F;postgres-18-async-io" rel="nofollow">https:&#x2F;&#x2F;pganalyze.com&#x2F;blog&#x2F;postgres-18-async-io</a><p>&gt; <i>Postgres has historically operated under a synchronous I&#x2F;O model, meaning every read request is a blocking system call. The database must pause and wait for the operating system to return the data before continuing.</i><p>&gt; <i>Postgres 18 introduces a new configuration parameter: io_method. This setting determines how read operations are dispatched under the hood, and whether they’re handled synchronously, offloaded to I&#x2F;O workers, or submitted directly to the kernel via io_uring.</i><p>This is a big deal - the blog post has benchmarks showing 2-3x improvements