News for hackers. Stuff that matters.

A comment on Scalable incremental data aggregation on Postgres and Citus.

Re:Scalable incremental data aggregation on Postgres and Citus by CplNobbs on Monday June 18, 2018 @02:58PM (#17340739)
Isnt there a race condition ? you get the sequence before acquiring a lock.
[ Parent | on HN ]
Re:Scalable incremental data aggregation on Postgres and Citus by kdmytro on Monday June 18, 2018 @03:33PM (#17341021)
I don't think so. The lock there just ensures that no pending transactions are going to write new rows with smaller sequence number.
[ Parent | on HN ]
Re:Scalable incremental data aggregation on Postgres and Citus by CplNobbs on Monday June 18, 2018 @05:58PM (#17341979)
got it - my bad
[ Parent | on HN ]