Mark Mielke wrote:
> FYI, my triggers are perhaps 10 lines each, and I believe I have three
> triggers in the 1500 ms -> 1 ms example. I have a view and a summary
> table. I update the summary table from the view. In my opinion, this
> solution is very manageable given the 1500:1 performance improvement
> it grants me.
But you had to modify your queries. I would think that a materialized
views implementation worth its salt would put the view to work on the
original, unmodified queries.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support