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 skybrian on Friday August 11, 2023 @03:46PM (#37093110)
I’m wondering if indexes and materialized views can be used to do basically the same thing? That is, assuming they contain all the columns you want.
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by latchkey on Friday August 11, 2023 @04:09PM (#37093380)
The issue is writes, not reads.
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by giantrobot on Friday August 11, 2023 @04:14PM (#37093442)
There's always money in the banana sta...materialized views. Materialized views will get you quite a ways on read heavy workloads.
[ Parent | on HN ]
Re:Squeeze the hell out of the system you have by Izkata on Saturday August 12, 2023 @01:25PM (#37102341)
As long as you're okay with the reads being a little out of date after writes occur.
[ Parent | on HN ]