From: | Rod Taylor <rbt(at)rbt(dot)ca> |
---|---|
To: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | get_rels_with_domain() redone |
Date: | 2002-12-13 17:04:19 |
Message-ID: | 1039799059.61629.26.camel@jester |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachment | Content-Type | Size |
---|---|---|
domaincleanup.patch | text/plain | 14.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-12-13 19:55:16 | Re: [BUGS] Bug #718: request for improvement of /? to show |
Previous Message | Bruce Momjian | 2002-12-13 17:02:06 | Re: postmaster segfaults when pg_hba.cof is missing |