Postgres Pro
Downloads
Home   >   mailing lists

Re: Finding foreign keys that are missing indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: Finding foreign keys that are missing indexes
Date
Msg-id 18295.1230511356@sss.pgh.pa.us
Whole thread Raw
In response to Re: Finding foreign keys that are missing indexes  (plu 12 <plutard12@hotmail.com>)
List pgsql-general
Tree view 
plu 12 <plutard12@hotmail.com> writes:
> Technically, would we also need to worry about constraints that are a prefix of an index? e.g., that an index on (f1,
f2)would be usable for a constraint on (f1)? 

I guess you could, but it seems overly complicated for something that's
just meant to locate trouble spots.

            regards, tom lane

pgsql-general by date:

Previous
From: plu 12
Date:
Subject: Re: Finding foreign keys that are missing indexes
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: having two database clusters?