Skip site navigation (1) Skip section navigation (2)

get_rels_with_domain() redone

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 (view raw or flat)
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

pgsql-patches by date

Next:From: Peter EisentrautDate: 2002-12-13 19:55:16
Subject: Re: [BUGS] Bug #718: request for improvement of /? to show
Previous:From: Bruce MomjianDate: 2002-12-13 17:02:06
Subject: Re: postmaster segfaults when pg_hba.cof is missing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group