Hi, i am trying "materialized views" in Postgresql 9.6.1. Regarding Andy Calson suggestion:
>>I do very similar thing, log all my webstats to PG, but querying millions of >>rows is always going to be slow. I use a summary table. They seems to work fine. One question: the materialized view is stored into disk, not in ram. Is it right? Does anyone use them with success on hundreds of millions of record? Thank you again! /F