Re: [HACKERS] Indexed views?

[Joshua D. Drake]

Tiago Wright wrote:
Are there any plans to support indexed views, or cross-table indexes,
or any form of "materialized views" in postgresql? How complex would
the implementation be? Indexed views are sometimes the best way to
improve the performance of complex queries.
 

The planner will use an index across multiple tables, even when called 
from a view as long as the comparing
tables are of the same type...

As far as materialized views, you can use triggers to create them.
Sincerely,
Joshua D. Drake


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


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]