Re: About asynchronous I/O

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: About asynchronous I/O
Date: 2026-06-23 14:19:57
Message-ID: 20260623141957.GM32053@p46.dedyn.io;lightning.p46.dedyn.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jun 23, 2026 at 10:05:42AM -0400, Ron Johnson wrote:
> On Tue, Jun 23, 2026 at 9:59 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
> wrote:
> > On Jun 23, 2026, at 7:04 AM, JOHN WIENCEK <jwiencek3(at)comcast(dot)net> wrote:
> > > Can your application assume the risk of lost transactions in the event
> > of a database crash?
> >
> > Pretty sure that's not a risk here...
>
> Because WAL writing is sync io?

That, and because AIO is read-only in Postgres so far (including in the
upcoming PG19).

Michael

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Raj 2026-06-28 16:23:00 Major upgrade in patroni cluster
Previous Message Ron Johnson 2026-06-23 14:05:42 Re: About asynchronous I/O