So here's a neat thing postgres 12.3 might do? Maybe I'm doing it wrong, not sure yet.

All these transactions are executed with SERIALIZABLE isolation over lists implemented as comma-separated TEXT fields. `r x [1, 2]` means we read the current value of row x and found it to be [1,2]. `a x 3` means "append 3 to x", like so:

insert into txn1 as t (id, val) values ($1, $2) on conflict (id) do update set val = concat(t.val, ',', $3) where = $4

rw is an anti-dep, ww and wr are deps.

· · Web · 0 · 0 · 0
Sign in to participate in the conversation

A single-user Mastodon instance for Jepsen announcements & discussion.