News for hackers. Stuff that matters.

A comment on Squeeze the hell out of the system you have. Parent comment

Re:Squeeze the hell out of the system you have by r00fus on Friday August 11, 2023 @08:06PM (#37095532)
Would it be possible to simply use a materialized view for table1_join_table2?
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by Izkata on Saturday August 12, 2023 @01:22PM (#37102319)
The problem there would be how they fall out of date, and updating them is a heavy operation.

An alternative I've heard before is using triggers with regular tables, so updating one automatically updates the relevant other ones.

[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by r00fus on Tuesday August 15, 2023 @03:48PM (#37138469)
Materialized views allow insert/update mechanics on many platforms. Alternatively you can refresh them.
[ Parent | on HN ]