get_rels_with_domain() redone
get_rels_with_domain() redone
От:
Rod Taylor <rbt@rbt.ca>
Дата:
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 PGP Key: http://www.rbt.ca/rbtpub.asc