News for hackers. Stuff that matters.

A comment on The Many Faces of Distinct in PostgreSQL. Parent comment

Re:The Many Faces of Distinct in PostgreSQL by paulddraper on Monday May 22, 2023 @11:10AM (#36032468)
It's as resilient to race conditions as it could be. Does exactly what you'd expect, no?

That is annoying about sequences, I agree.

[ Parent | on HN ]
Re:The Many Faces of Distinct in PostgreSQL by richbell on Monday May 22, 2023 @12:01PM (#36033142)
> It's as resilient to race conditions *as it could be*. Does exactly what you'd expect, no?

While that that may be true, based on the hours I've spent scouring Stack Overflow and GitHub issues it seems that many people don't realize that it's only 99.999% resilient.

[ Parent | on HN ]
Re:The Many Faces of Distinct in PostgreSQL by paulddraper on Monday May 22, 2023 @03:41PM (#36035756)
Could you describe what you mean? What phenomenon? For the default transaction isolation level, or a different one?
[ Parent | on HN ]
Re:The Many Faces of Distinct in PostgreSQL by vore on Monday May 22, 2023 @05:33PM (#36036994)
It is 100% resilient short of your hard drive going through a microwave. It is almost definitely an application logic error if you are observing non-atomicity. What would non-atomicity even look like here? Only some columns being written?
[ Parent | on HN ]