Re:Ask HN: 120M rows Postgres – how can I speed up queries?
by gigatexal on Thursday November 07, 2019 @03:07PM
(#21476816)
Just to be super clear don’t use the triggers to rebuild the view every time but merely to add one to the sum’d account when a row matches — I wasn’t sure I made that clear. Good luck! And do put up a blog post or something if it works out
[ Parent
| on HN ]
Re:Ask HN: 120M rows Postgres – how can I speed up queries?
by dbnewbie on Thursday November 07, 2019 @06:46PM
(#21478660)
OK that makes sense, and I’ll do a bit of reading on materialized view functionality before actually implementing anything.
Re:Ask HN: 120M rows Postgres – how can I speed up queries?
by gigatexal on Friday November 08, 2019 @01:30PM
(#21485207)
Again not my idea. It was suggested to me in response to the very problem you’re having. I’m just so happy to have it as an idea that I didn’t want to keep it to myself. Here’s the link. https://hashrocket.com/blog/posts/materialized-view-strategi...