Re: Multiple indexes, huge table

From: Aram Fingal <fingal(at)multifactorial(dot)com>
To: Postgres-General General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multiple indexes, huge table
Date: 2012-09-06 23:17:57
Message-ID: DC18FA5E-3724-44F6-8774-205893C4A233@multifactorial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-09-06 23:19:42 Re: PostgreSQL server embedded in NAS firmware?
Previous Message Tom Lane 2012-09-06 23:00:17 Re: PostgreSQL server embedded in NAS firmware?