Some time ago, an excellent tutorial on materialized views with PostgreSQL was pointed at this address.... http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Patrick > -------------------------------------------------------------------------- ----------------- > Patrick Fiche > email : [EMAIL PROTECTED] > tél : 01 69 29 36 18 > -------------------------------------------------------------------------- ----------------- > > > -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Peter Eisentraut Sent: mercredi 24 novembre 2004 11:15 To: Net Virtual Mailing Lists Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Creating index on a view? Net Virtual Mailing Lists wrote: > My question is regarding creating an index on a view, or perhaps > another way to accomplish this. Views are just macro expansions of queries (in a manner of speaking). To make queries on views use indexes, you create the indexes on the underlying tables in the same way as if you had typed in the expanded view query yourself. (In your example, you'd just need the usual indexes on the primary keys.) If what you want is that the creation of an index on a view automatically materializes that view (don't other database systems do that?), then you will have to implement that manually in PostgreSQL, with triggers and a bunch of code. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Protected by Polesoft Lockspam http://www.polesoft.com/refer.html ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
