get_rels_with_domain() redone - Mailing list pgsql-patches

From Rod Taylor
Subject get_rels_with_domain() redone
Date
Msg-id 1039799059.61629.26.camel@jester
Whole thread Raw
List pgsql-patches
Tom,

I've been unable to time a difference here on a DB with 20 tables -- but
perhaps you will be able to on whatever box you ran the first one on.  I
didn't notice the initial version was slow -- but can certainly see how
it would be on a large db.

Scan of pg_depend for attributes using the domain.  Each resulting
attribute is double checked.


I'll work out the locking aspect shortly.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment

pgsql-patches by date:

Previous
From: Joe Conway
Date:
Subject: SETOF input parameters (was Re: [HACKERS] proposal: array utility functions phase 1)
Next
From: Peter Eisentraut
Date:
Subject: Re: [BUGS] Bug #718: request for improvement of /? to show