3 ms·
> If pg was olap there wouldn’t exist any competition out there. What does this actually mean? If PG were an OLAP database it probably wouldn't have full ACID
by hodgesrm 4y ago
> If pg was olap there wouldn’t exist any competition out there.
What does this actually mean? If PG were an OLAP database it probably wouldn't have full ACID support, because pure OLAP workloads typically don't do a lot of updates. And it would have a lot of hooks around storage like compression codecs that don't give a lot of value in an OLTP database. Finally it would probably be eventually consistent because it's expensive to ensure data consistency across a large, distributed dataset.
So it wouldn't really be PG at that point.