Re: Materialized Views in PostgreSQL

Поиск
Список
Период
Сортировка
От Dann Corbit
Тема Re: Materialized Views in PostgreSQL
Дата
Msg-id D425483C2C5C9F49B5B7A41F8944154757D0A6@postal.corporate.connx.com
обсуждение исходный текст
Ответ на Materialized Views in PostgreSQL  (Jean-Michel Pouré <jm@poure.com>)
Ответы Re: Materialized Views in PostgreSQL  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
> owner@postgresql.org] On Behalf Of Tino Wildenhain
> Sent: Monday, September 12, 2005 3:04 AM
> To: jm@poure.com
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Materialized Views in PostgreSQL
>
> Jean-Michel Pouré schrieb:
> > Dear friends and all,
> >
> > Johnathan Gardner did a wonderful job on materialized views:
> > http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
> >
> > 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.
>
> I fail to see how C would improve the situation here because you just
> send queries to the backend in those functions. You can use
> the recipes on that page just as they are. If you feel like,
> make them a contrib module you can easily apply to a situation.
>
> Not sure how an implemenation "in database" could look like.
> Maybe SQL standard reserves something for materialized views
> I dont know?

http://research.csc.ncsu.edu/selftune/

I think someone is working on merging this stuff back into the PostgreSQL core.  Not sure what the current status is.

> Regards
> Tino
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kurt Roeckx
Дата:
Сообщение: Re: -fPIC
Следующее
От: "Michael Paesold"
Дата:
Сообщение: Re: Spinlocks, yet again: analysis and proposed patches