Re: Indexed views?

Tiago Wright <tiagowright@gmail.com> writes:
> For example, consider the view
> CREATE VIEW vw_lot AS
> �SELECT�productid,�lotid,�parentlotid,�lottype,�lotname,�productname
> ���FROM�lot
> NATURAL�JOIN�product;

> 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