Re: Indexed views?

Tiago Wright <tiagowright(at)gmail(dot)com> writes:
> For example, consider the view
> CREATE VIEW vw_lot AS
> SELECTproductid,lotid,parentlotid,lottype,lotname,productname
> FROMlot
> NATURALJOINproduct;

> where productname is in the product table, and lotname in the lot
> table. I would be interested in creating an index such as

> CREATE INDEX ix_vw_lot ON vw_lot (lotname, productname);

What purpose would this serve that indexes on the separate tables
wouldn't serve?

> The index would be enough to cover 90% of the queries against
> lot the lot and inventory tables.

This sounds to me like you are suffering from a common misconception.
Postgres cannot answer queries from the contents of indexes alone.

regards, tom lane