Re: Query Rewrite for Materialized Views (Postgres Extension) - Mailing list pgsql-hackers

From Dent John
Subject Re: Query Rewrite for Materialized Views (Postgres Extension)
Date
Msg-id 2E510F8A-E156-403D-9696-0243D22C29A2@QQdd.eu
Whole thread Raw
In response to Re: Query Rewrite for Materialized Views (Postgres Extension)  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: Query Rewrite for Materialized Views (Postgres Extension)
List pgsql-hackers
I commented to Corey (privately) that, while my rewrite extension has gotten me a server that responds quickly to
aggregatequeries, the constant need to refresh the supporting MVs means the system’s load average is constant and much
higherthan before. I’m happy with the tradeoff for now, but it’s a huge waste of energy, and I’m sure it must thrash my
disk.

I’m very interested in what other people think of Corey’s idea.

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Speedup of relation deletes during recovery
Next
From: Tom Lane
Date:
Subject: Re: Transform for pl/perl