By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,086 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,086 IT Pros & Developers. It's quick & easy.

materialized view

P: n/a
PostgreSql support materialized views ???

if not, there is something similar??
Thanks
Esteban kemp
Nov 23 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Esteban Kemp schrieb:
PostgreSql support materialized views ???

if not, there is something similar??

This feature is not yet implemented.

take a look at

http://jonathangardner.net/PostgreSQ.../matviews.html

Daniel.
Nov 23 '05 #2

P: n/a
Esteban,

El 01/09/2004 3:09 PM, Esteban Kemp en su mensaje escribio:
PostgreSql support materialized views ???


There is a good doc about this at:

http://www.varlena.com/varlena/Gener.../matviews.html
--
Sinceramente,
Josué Maldonado.
"Al contacto del amor todo el mundo se vuelve poeta" - Platon

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #3

P: n/a
Hi guys,

I installed PostgreSQL without readline
(--without-readline), but how can add the readline
support right now??

Am I supposed to reconfigure/make/make install to do
that????

Regards,

Marcelo Pereira
Brazil

__________________________________________________ _____
Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade!
http://br.acesso.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #4

P: n/a
On Wed, 2004-09-01 at 15:09, Esteban Kemp wrote:
PostgreSql support materialized views ???

if not, there is something similar??


PostgreSQL supports triggers which let you implement it yourself.
Luckily for you and I, someone else has already done most of the work
and made a documentation set for it.

http://jonathangardner.net/PostgreSQ.../matviews.html
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #5

P: n/a
On Wed, Sep 01, 2004 at 05:09:06PM -0400, Esteban Kemp wrote:
PostgreSql support materialized views ???

if not, there is something similar??


Hi Esteban,

Postgres doesn't support materialized views, although I think there was
some talk of implementing them a few months ago. Try searching
pgsql.ru about this.

There are several possible present alternatives, depending on your
situation. First off, if your query on a view is running too slowly,
look into optimizing the query itself to make it as fast as possible.
If it's still too slow, and if either your data are relatively static
or you don't need up-to-the-minute accuracy, the simplest solution is
probably to just turn the view into a static table via "create table t as
select * from v", then update that table periodically. This usually
works well enough for my needs.

If you need up-to-the-minute accuracy, you could turn the view itself
into a table, then create triggers or rules on the tables used by the
view to keep everything synched.

So the answer really depends on how the view is defined, what you
plan to use it for, and how often your database is updated.

- Jeremy

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #6

P: n/a
MaRCeLO PeReiRA wrote:
I installed PostgreSQL without readline
(--without-readline), but how can add the readline
support right now??

Am I supposed to reconfigure/make/make install to do
that????


Yes.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #7

P: n/a
On Wed, Sep 01, 2004 at 06:30:05PM -0300, MaRCeLO PeReiRA wrote:
I installed PostgreSQL without readline (--without-readline), but how
can add the readline support right now??

Am I supposed to reconfigure/make/make install to do that????


Yes. Maybe you can recompile only psql to save some time ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Amanece. (Ignacio Reyes)
El Cerro San Cristóbal me mira, cínicamente, con ojos de virgen"
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.