• Tom Lane's avatar
    Simplify a couple of pg_dump and psql \d queries about index constraints · e6555b43
    Tom Lane authored
    by joining to pg_constraint.conindid, instead of the former technique of
    joining indirectly through pg_depend.  This is much more straightforward
    and probably faster as well.  I had originally desisted from changing these
    queries when conindid was added because I was worried about losing
    performance, but if we join on conrelid as well as conindid then the index
    on conrelid can be used when pg_constraint is large.
    e6555b43
describe.c 96.4 KB