> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to