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

Reply via email to