|
|
|
|
|
|
by cadbox1
1429 days ago
|
|
|
I wanted incremental refresh in Postgres as well and found that you can manage your own table to get something close. Basically you create a regular table in place of a materialised one, only aggregate data newer than what's currently in the table then store the new aggregates in table. Repeat this an interval. https://github.com/cadbox1/prawn-stack/blob/master/src/backe... I use this to show page view data aggregated by hour without calculating it on each request using Lambda https://prawn.cadell.dev/ |
|
|