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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster