#Claude #DataProtection
#Claude #DataProtection
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.
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?
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.
go.bsky.app/SCZe42X
go.bsky.app/SCZe42X