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

From Pierre Barre
Subject Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance
Date
Msg-id e70e1669-4f00-47dc-a221-537f33ef882c@app.fastmail.com
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
> "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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Is there any limit on the number of rows to import using copy command
Next
From: Nico Williams
Date:
Subject: Re: PostgreSQL on S3-backed Block Storage with Near-Local Performance