Alvaro Herrera <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org