Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> One thing I was toying with was to add an index to pg_constraint on,
>> say, (confrelid, conrelid), and to replace the existing seqscans for FK
>> constraints with scans using this index.
> I think there is more than one place that would benefit from such an
> index. Probably turn into a syscache as well?
Yeah, that was in the back of my mind too, but I haven't looked through
the code to see. A syscache wouldn't work because it's not a unique key.
regards, tom lane