News for hackers. Stuff that matters.
Re:Soft Deletion Probably Isn't Worth It by setr on Wednesday January 10, 2024 @02:36PM (#38942177)
Why materialize? A normal view is sufficient
Re:Soft Deletion Probably Isn't Worth It by rawgabbit on Wednesday January 10, 2024 @02:51PM (#38942323)
It was to answer the OP question. Querying a materialized view is essentially the same as querying the original table. The MV allows for automated indexes etc.
Re:Soft Deletion Probably Isn't Worth It by setr on Thursday January 11, 2024 @03:54AM (#38949567)
I mean... a normal view hits all of the same properties, and is literally querying the original table. Materialization is an entirely orthogonal concern as far as I can think of.