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