| 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 |