On Sep 6, 2012, at 5:54 PM, Tom Lane wrote:
That sounds like you lack an index on the referencing column of the
foreign key constraint. Postgres doesn't require you to keep such
an index, but it's a really good idea if you ever update the referenced
column.
Thanks. You're right. That column (which is a foreign key) is a component of a multi-column index but I don't have an index just for it.
-Aram