Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance

From: "Pierre Barre" <pierre(at)barre(dot)sh>
To: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
Date: 2025-07-24 18:12:19
Message-ID: e70e1669-4f00-47dc-a221-537f33ef882c@app.fastmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "NFS" is a key word that does not inspire confidence in
PostgreSQL circles...

Coming back to this, I just implemented 9P, which should translates to proper semantics for FSYNC.

mount -t 9p -o trans=tcp,port=5564,version=9p2000.L,msize=65536,access=user 127.0.0.1 /mnt/9p

Best,
Pierre

On Fri, Jul 18, 2025, at 06:40, 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.
>
> Performance is great, but it is not everything. If things
> perform surprisingly well, people become suspicious.
>
>> P.S. The full project includes a custom NFS filesystem too.
>
> "NFS" is a key word that does not inspire confidence in
> PostgreSQL circles...
>
> Yours,
> Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nico Williams 2025-07-24 19:41:37 Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
Previous Message Adrian Klaver 2025-07-24 14:48:04 Re: Is there any limit on the number of rows to import using copy command