> I just checked the restrictions on the TPC-R and TPC-H schemas and it
> seems that all indexes are allowed in TPC-R and only those that index
> parts of primary or foreign keys are allowed in TPC-H.

That would be appropriate for this case though, yes?   That column is part of 
a foriegn key, unless I've totally lost track.

As I remarked before, Postgres does *not* automatically create indexes for 
FKs.   Many, but not all, other database products do, so comparing PostgreSQL 
against those products without the index is unfair.

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to