Re: [PERFORM] Materialized Views

2006-01-16 Thread Michael Riess
Thanks! Of course I know that I can build materialized views with triggers, but so far I've avoided using triggers altogether ... I would really appreciate something like "create view foo (select * from b) materialize on query". But I'll look into your blog entry, thanks again! Mike On Mon

Re: [PERFORM] Materialized Views

2006-01-16 Thread me
hi mike In particular I'm interested in a view which materializes whenever queried, and is invalidated as soon as underlying data is changed. from the german pgsql list earlier last week: http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html this seems to be pretty much what

Re: [PERFORM] Materialized Views

2006-01-16 Thread Frank Wiles
On Mon, 16 Jan 2006 15:36:53 +0100 Michael Riess <[EMAIL PROTECTED]> wrote: > Hi, > > I've been reading an interesting article which compared different > database systems, focusing on materialized views. I was wondering how > the postgresql developers feel about this feature ... is it planned >

[PERFORM] Materialized Views

2006-01-16 Thread Michael Riess
Hi, I've been reading an interesting article which compared different database systems, focusing on materialized views. I was wondering how the postgresql developers feel about this feature ... is it planned to implement materialized views any time soon? They would greatly improve both perfor