Re:New Features Coming in PostgreSQL 10
by gnaritas on Saturday April 08, 2017 @10:15PM
(#14070111)
It is possible, that's how I do it, and it doesn't really affect performance at all. You just don't do it real time, the triggers just kick an id into a queue and you have a background task work the queue updating the materialized table from the view it's a copy of just for the id's in the queue.
[ Parent
| on HN ]
There are no comments on this comment yet.