Обсуждение: get_rels_with_domain() redone

Поиск
Список
Период
Сортировка

get_rels_with_domain() redone

От
Rod Taylor
Дата:
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

Вложения