Re: TPC-R benchmarks

Oleg,

> 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