Re: Multiple indexes, huge table

[Aram Fingal <fingal@xxxxxxxxxxxxxxxxxx>]

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