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
Does anyone use them with success on hundreds of millions of record?
Thank you again!
/F