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.