News for hackers. Stuff that matters.
Re:Supabase Acquires OrioleDB by Cwizard on Tuesday April 16, 2024 @04:09PM (#40056562)
> It implements row-level WAL (Write-Ahead Log) and a non-persistent undo log. This significantly reduces IO operations for write transactions.

What is the downside of doing this? I assume there is a tradeoff?

Re:Supabase Acquires OrioleDB by akorotkov on Wednesday April 17, 2024 @07:56AM (#40063316)
Sure, there are downsides. 1. The replay of WAL records becomes somewhat more CPU-expensive. But at the same time, OrioleDB can do that in parallel. 2. Replace becomes not the file-level equivalent of primary. Thus, you, for instance, can't continue file-level incremental backup started taken from the primary with the replica. Nevertheless, I strongly believe that row-level WAL is a great win on average, and opens brilliant perspectives for further developments.