News for hackers. Stuff that matters.
Re:Oracle vs. PostgreSQL – A Comment by nycdotnet on Saturday May 30, 2020 @05:26PM (#23364895)
SQL Server partially supports it - indexes for example are not versioned which causes snapshot transactions to fail if someone rebuilds an index - even if it’s not in scope of the snapshot.
Re:Oracle vs. PostgreSQL – A Comment by throwaway_pdp09 on Saturday May 30, 2020 @05:42PM (#23365025)
That doesn't sound right by my experience, Could you give a link please? I'm concerned I've not heard of this. Probably because it's MVCC/snapshot isolation which I'm not familiar with.