Re: Some questions about PostgreSQL’s design. - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Some questions about PostgreSQL’s design.
Date
Msg-id CA+hUKG+2j=kP-uh8rYo5qVmaXUThPgSpzSEHGK9QbuvOX-Lx1Q@mail.gmail.com
Whole thread Raw
In response to Some questions about PostgreSQL’s design.  (陈宗志 <baotiao@gmail.com>)
List pgsql-hackers
On Tue, Aug 20, 2024 at 8:55 PM 陈宗志 <baotiao@gmail.com> wrote:
> It seems like these issues have clear solutions, such as using
> DirectIO like InnoDB instead of buffered IO,

For this part: we recently added an experimental option to use direct
I/O (debug_io_direct).  We are working on the infrastructure needed to
make it work efficiently before removing the "debug_" prefix:
prediction of future I/O through a "stream" abstraction which we have
some early pieces of already, I/O combining (see new io_combine_limit
setting), and asynchronous I/O (work in progress, basically I/O worker
processes or io_uring or other OS-specific APIs).



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: race condition in pg_class
Next
From: Amit Kapila
Date:
Subject: Re: long-standing data loss bug in initial sync of logical replication