X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 3CB12D1DEDC; Wed, 25 Feb 2004 11:34:45 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 20040-08; Wed, 25 Feb 2004 07:34:46 -0400 (AST)
Received: from crommail.cromwell-tools.co.uk
	(host217-40-164-180.in-addr.btopenworld.com [217.40.164.180])
	by svr1.postgresql.org (Postfix) with ESMTP
	id DD953D1BAA3; Wed, 25 Feb 2004 07:34:40 -0400 (AST)
Message-ID: <403C8893.2060301@cromwell.co.uk>
Date: Wed, 25 Feb 2004 11:35:47 +0000
From: Mark Gibson <gibsonm@cromwell.co.uk>
MIME-Version: 1.0
To: "Jonathan M. Gardner" <jgardner@jonathangardner.net>
Cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org,
	pgsql-performance@postgresql.org
Subject: Re: [HACKERS] Materialized View Summary
References: <200402240811.13013.jgardner@jonathangardner.net>
In-Reply-To: <200402240811.13013.jgardner@jonathangardner.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/330
X-Sequence-Number: 5854

Jonathan M. Gardner wrote:

> You can view my summary at
> http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
>
> Comments and suggestions are definitely welcome.
>
Fantastic, I was planning on a bit of materialized view investigations 
myself
when time permits, I'm pleased to see you've started the ball rolling.

I was thinking about your problem with mutable functions used in a 
materialized view.

How about eliminating the mutable functions as much as possible from the 
underlying
view definition, and create another view on top of the materialized view 
that has the mutable bits!
Giving you the best of both worlds.

I haven't tried this or thought it through very much - too busy - but 
I'd thought I'd throw
it in for a bit o' head scratching, and chin stroking :)

Cheers
-- 
Mark Gibson <gibsonm |AT| cromwell |DOT| co |DOT| uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.