News for hackers. Stuff that matters.
Re:OrioleDB – solving some PostgreSQL wicked problems by glogla on Friday February 25, 2022 @02:55AM (#30464708)
On of the major differences between Oracle and Postgres was this - Postgres kept old versions of rows around to be vacuumed, while Oracle moves them to "undo segment". So they are copying the Oracle design.

That has its own set of tradeoffs - if you're running a long transaction with higher level of serialization, the database has to look for old data in the undo segment which is not only likely vastly slower than normal table, but might not even have the data anymore (any ETL developer have probably seen "Snapshot too old" error from Oracle).

It probably is better tradeoff for some workloads, like high volume of updates with no long-running transactions, but it is more of a different design choice than a "fix" by itself.

Re:OrioleDB – solving some PostgreSQL wicked problems by akorotkov on Saturday February 26, 2022 @03:05PM (#30481311)
> That has its own set of tradeoffs - if you're running a long transaction with higher level of serialization, the database has to look for old data in the undo segment which is not only likely vastly slower than normal table, but might not even have the data anymore (any ETL developer have probably seen "Snapshot too old" error from Oracle).

I would say "Snapshot too old" isn't essential drawback of undo log. DBMS can keep the the undo log records until all snapshots, which needs them, are released. And this is how OrioleDB behaves. This is also kind of "bloat", but cleanup is cheaper. You just have to cut unclaimed undo log instead of expensive vacuum.

Re:OrioleDB – solving some PostgreSQL wicked problems by Ginden on Friday February 25, 2022 @01:19PM (#30470341)
Yes, it made me wary - design choice with different tradeoffs is portrayed as "better".
Re:OrioleDB – solving some PostgreSQL wicked problems by zigzag312 on Friday February 25, 2022 @03:45AM (#30465030)
Isn't the goal to have multiple storage engines, so you could use the one that best fits your needs? Current storage engine probably won't be removed when this is merged.