3 ms·
I do not see how this would be implemented without introducing extra locking which would harm concurrency, which would remove some of the performance advantage
by jeltz 15y ago
I do not see how this would be implemented without introducing extra locking which would harm concurrency, which would remove some of the performance advantage of having MVCC.
Now I see it could be worth taking that penalty on specified tables, jsut like you do for indexes. And some databases do support this in a more general form: materialized views.
- fusiongyro 15y agoI think you could fake this proposal with triggers. It might be worth seeing what the additional cost is.
- scotty79 15y agoProper solution (not fake with triggers) should be at most as costly as having partial index on the table.