=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= <fabriziome...@gmail.com> writes: > On Fri, Mar 20, 2015 at 4:37 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >>>> We could fix it by, say, having CheckConstraintFetch() sort the >>>> constraints by name after loading them.
> Isn't better do this to read pg_constraint in name order? > - conscan = systable_beginscan(conrel, ConstraintRelidIndexId, true, > + conscan = systable_beginscan(conrel, ConstraintNameNspIndexId, true, Surely not. That would end up having to read *all* of pg_constraint, not only the rows applicable to the current relation. We could get the index to do the work for us if we changed it from an index on conrelid to one on conrelid, conname. However, seeing that that would bloat the index by a factor of sixteen, it hardly sounds like a free fix either. I really think that a quick application of qsort is the best-performing way to do this. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers