Oliver Mannion

@nzl.bsky.social

Software, machine learning, people.

TIL transaction isolation and durability in ACID are orthogonal. eg: when synchronous_commit=off then COMMIT in Postgres doesn’t mean a transaction has persisted durably to disk, just that it’s in the WAL see this fantastic thread and the linked PR comments.

Chris@chris.blue · 2y ago

What does #postgres do if you set: synchronous_commit=off default_transaction_isolation=read committed And then do: INSERT SELECT Will the SELECT see reads that have potentially not yet been written to the WAL?

Would be nice if the Bluesky app could be still be used with stale content when there’s no or low data available (eg: in-flight wifi). Doesn’t seem to boot. Whereas Twitter works.