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 aIKMcZOz5ZYeF6C9@ubby
Whole thread Raw
In response to Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
On Fri, Jul 18, 2025 at 06:40:58AM +0200, Laurenz Albe wrote:
> On Fri, 2025-07-18 at 00:57 +0200, Pierre Barre wrote:
> > Looking forward to your feedback and questions!
> 
> I think the biggest hurdle you will have to overcome is to
> convince notoriously paranoid DBAs that this tall stack
> provides reliable service, honors fsync() etc.

Is there a test suite that can be used to test PG's ACIDity in the face
of simulated power failures?

> Performance is great, but it is not everything.  If things
> perform surprisingly well, people become suspicious.

+1

> > P.S. The full project includes a custom NFS filesystem too.
> 
> "NFS" is a key word that does not inspire confidence in
> PostgreSQL circles...

Certainly NFSv3 should.  NFSv4 is much safer but I've no experience
running PG on it and I assume there will be cases where recovery from
network and/or server failures is slow.



pgsql-general by date:

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