Try
Home   >   mailing lists

Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance - Mailing list pgsql-general

From Nico Williams
Subject Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
Date
Msg-id aIKNLuEis1DQEOGv@ubby
Whole thread Raw
In response to Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance  ("Pierre Barre" <pierre@barre.sh>)
Responses Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
List pgsql-general
Tree view 
On Fri, Jul 18, 2025 at 12:57:39PM +0200, Pierre Barre wrote:
> - Postgres configured accordingly memory-wise as well as with
>   synchronous_commit = off, wal_init_zero = off and wal_recycle = off.

Bingo.  That's why it's fast (synchronous_commit = off).  It's also why
it's not safe _unless_ you have a local, fast, persistent ZIL device
(which I assume you don't).

Nico
--

pgsql-general by date:

Previous
From: Nico Williams
Date:
Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
Next
From: "Pierre Barre"
Date:
Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance