Jenny,
> create index i_l_partkey on lineitem (l_partkey);
> I do not have any foreign key defined. Does the spec require foreign
> keys?
>
> When you create a foreign key reference, does PG create an index
> automatically?
No. A index is not required to enforce a foriegn key, and is sometimes not
useful (for example, FK fields with only 3 possible values).
So it may be that you need to create an index on that field.
--
Josh Berkus
Aglio Database Solutions
San Francisco