Jepsen: Amazon RDS for PostgreSQL 17.4

#1

Post by aphyr » Tue, Apr 29, 2025, 2:30 PM UTC

Jepsen: Amazon RDS for PostgreSQL 17.4
jepsen.io

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#2

Post by henning » Tue, Apr 29, 2025, 8:55 PM UTC

I thought this kind of bullshit was only supposed to happen in MongoDB!

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#3

Post by tibbar » Tue, Apr 29, 2025, 9:03 PM UTC

The submitted title buries the lede: RDS for PostgreSQL 17.4 does not properly implement snapshot isolation.

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#4

Post by kabes » Tue, Apr 29, 2025, 9:07 PM UTC

henning wrote: post #2

I thought this kind of bullshit was only supposed to happen in MongoDB!

Then you haven't read enough jepsen reports. Distributed system guarantees generally can't be trusted

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#5

Post by cr3ative » Tue, Apr 29, 2025, 9:07 PM UTC

This is in such a thick academic style that it is difficult to follow what the problem actually might be and how it would impact someone. This style of writing serves mostly to remind me that I am not a part of the world that writes like this, which makes me a little sad.

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#6

Post by __alexs » Tue, Apr 29, 2025, 9:13 PM UTC

kabes wrote: post #4

henning wrote: post #2

I thought this kind of bullshit was only supposed to happen in MongoDB!

Then you haven't read enough jepsen reports. Distributed system guarantees generally can't be trusted

Postgres is not a distributed system in this configuration usually though is it?

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#7

Post by colesantiago » Tue, Apr 29, 2025, 9:14 PM UTC

henning wrote: post #2

I thought this kind of bullshit was only supposed to happen in MongoDB!

Do people still use MongoDB in production?

I was quite surprised to read that Stripe uses MongoDB in the early days and still today and I can't imagine the sheer nightmares they must have faced using it for all these years.

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#8

Post by semiquaver » Tue, Apr 29, 2025, 9:15 PM UTC

__alexs wrote: post #6

kabes wrote: post #4

Earlier quoted context omitted.

Then you haven't read enough jepsen reports. Distributed system guarantees generally can't be trusted

Postgres is not a distributed system in this configuration usually though is it?

The result is for “Amazon RDS for PostgreSQL multi-AZ clusters” which are certainly a distributed system.

I’m not well versed in RDS but I believe that clustered is the only way to use it.

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#9

Post by bananapub » Tue, Apr 29, 2025, 9:16 PM UTC

henning wrote: post #2

I thought this kind of bullshit was only supposed to happen in MongoDB!

I think zookeeper is still the only distributed system that got through jepsen without dataloss bugs, though at high cost: https://aphyr.com/posts/291-jepsen-zookeeper

Re: Jepsen: Amazon RDS for PostgreSQL 17.4

#10

Post by joevandyk » Tue, Apr 29, 2025, 9:16 PM UTC

cr3ative wrote: post #5

This is in such a thick academic style that it is difficult to follow what the problem actually might be and how it would impact someone. This style of writing serves mostly to remind me that I am not a part of the world that writes like this, which makes me a little sad.

[flagged]