Re: Materialized Views in PostgreSQL

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, jm(at)poure(dot)com
Subject: Re: Materialized Views in PostgreSQL
Date: 2005-09-12 16:23:49
Message-ID: 200509120923.49437.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jean-Michel,

> Are there any plans to integrate materialized views written in plain C in
> the future. This can help gain a lot of time in Web applications.

We actually have some university code implementing materialized view handling
in the planner code. However, I keep not getting around to reviewing &
documenting it.

Jonathan's piece is actually an excellent article on how to implement
mattviews in user-space. Mostly, it just needs to be linked from somewhere
in the PostgreSQL.org pages.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kurt Roeckx 2005-09-12 17:28:46 Re: -fPIC
Previous Message Josh Berkus 2005-09-12 16:13:02 Re: Spinlocks, yet again: a new test case