Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YS9Cw-0004Do-Up for pgsql-committers@arkaria.postgresql.org; Sun, 01 Mar 2015 19:07:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YS9Cw-0000JJ-7m for pgsql-committers@arkaria.postgresql.org; Sun, 01 Mar 2015 19:07:18 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YS9Cu-0000JA-8K for pgsql-committers@postgresql.org; Sun, 01 Mar 2015 19:07:16 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YS9Cq-0003Ml-Rj for pgsql-committers@postgresql.org; Sun, 01 Mar 2015 19:07:14 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YS9Cp-00027D-Qg for pgsql-committers@postgresql.org; Sun, 01 Mar 2015 19:07:11 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.80) (envelope-from ) id 1YS9Cp-0005sw-Ft for pgsql-committers@postgresql.org; Sun, 01 Mar 2015 19:07:11 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Use the typcache to cache constraints for domain types. Message-Id: Date: Sun, 01 Mar 2015 19:07:11 +0000 X-Pg-Spam-Score: -6.9 (------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org VXNlIHRoZSB0eXBjYWNoZSB0byBjYWNoZSBjb25zdHJhaW50cyBmb3IgZG9t YWluIHR5cGVzLgoKUHJldmlvdXNseSwgd2UgY2FjaGVkIGRvbWFpbiBjb25z dHJhaW50cyBmb3IgdGhlIGxpZmUgb2YgYSBxdWVyeSwgb3IKcmVhbGx5IGZv ciB0aGUgbGlmZSBvZiB0aGUgRm1nckluZm8gc3RydWN0IHRoYXQgd2FzIHVz ZWQgdG8gaW52b2tlCmRvbWFpbl9pbigpIG9yIGRvbWFpbl9jaGVjaygpLiAg QnV0IHBscGdzcWwgKGFuZCBwcm9iYWJseSBvdGhlciBwbGFjZXMpCmFyZSBz ZXQgdXAgdG8gY2FjaGUgc3VjaCBGbWdySW5mb3MgZm9yIHRoZSB3aG9sZSBs aWZlc3BhbiBvZiBhIHNlc3Npb24sCndoaWNoIG1lYW50IHRoZXkgY291bGQg YmUgZW5mb3JjaW5nIHJlYWxseSBzdGFsZSBzZXRzIG9mIGNvbnN0cmFpbnRz LgpPbiB0aGUgb3RoZXIgaGFuZCwgc2VhcmNoaW5nIHBnX2NvbnN0cmFpbnQg b25jZSBwZXIgcXVlcnkgZ2V0cyBraW5kIG9mCmV4cGVuc2l2ZSB0b286IHRl c3Rpbmcgc2F5cyB0aGF0IGFzIG11Y2ggYXMgaGFsZiB0aGUgcnVudGltZSBv ZiBhCnRyaXZpYWwgcXVlcnkgc3VjaCBhcyAiU0VMRUNUIDA6OmRvbWFpbnR5 cGUiIHdlbnQgaW50byB0aGF0LgoKVG8gZml4IHRoaXMsIGRlbGVnYXRlIHRo ZSByZXNwb25zaWJpbGl0eSBmb3IgdHJhY2tpbmcgYSBkb21haW4ncwpjb25z dHJhaW50cyB0byB0aGUgdHlwY2FjaGUsIHdoaWNoIGhhcyB0aGUgaW5mcmFz dHJ1Y3R1cmUgbmVlZGVkIHRvCmRldGVjdCBzeXNjYWNoZSBpbnZhbGlkYXRp b24gZXZlbnRzIHRoYXQgc2lnbmFsIHBvc3NpYmxlIGNoYW5nZXMuClRoaXMg bm90IG9ubHkgcmVtb3ZlcyB1bm5lY2Vzc2FyeSByZXBlYXQgcmVhZHMgb2Yg cGdfY29uc3RyYWludCwKYnV0IGVuc3VyZXMgdGhhdCB3ZSBuZXZlciBhcHBs eSBzdGFsZSBjb25zdHJhaW50IGRhdGE6IHdoYXRldmVyIHdlCnVzZSBpcyB0 aGUgY3VycmVudCBkYXRhIGFjY29yZGluZyB0byBzeXNjYWNoZSBydWxlcy4K ClVuZm9ydHVuYXRlbHksIHRoZSBjdXJyZW50IGNvbmZpZ3VyYXRpb24gb2Yg dGhlIHN5c3RlbSBjYXRhbG9ncyBtZWFucwp3ZSBoYXZlIHRvIGZsdXNoIGNh Y2hlZCBkb21haW4tY29uc3RyYWludCBkYXRhIHdoZW5ldmVyIGVpdGhlciBw Z190eXBlCm9yIHBnX2NvbnN0cmFpbnQgY2hhbmdlcywgd2hpY2ggaGFwcGVu cyByYXRoZXIgYSBsb3QgKGVnLCBjcmVhdGlvbiBvcgpkZWxldGlvbiBvZiBh IHRlbXAgdGFibGUgd2lsbCBkbyBpdCkuICBJdCBtaWdodCBiZSB3b3J0aCBy ZWFycmFuZ2luZwp0aGluZ3MgdG8gc3BsaXQgcGdfY29uc3RyYWludCBpbnRv IHR3byBjYXRhbG9ncywgb2Ygd2hpY2ggdGhlIGRvbWFpbgpjb25zdHJhaW50 IG9uZSB3b3VsZCBwcm9iYWJseSBiZSB2ZXJ5IGxvdy10cmFmZmljLiAgVGhh dCdzIGEgam9iIGZvcgphbm90aGVyIHBhdGNoIHRob3VnaCwgYW5kIGluIGFu eSBjYXNlIHRoaXMgcGF0Y2ggc2hvdWxkIGltcHJvdmUgbWF0dGVycwptYXRl cmlhbGx5IGV2ZW4gd2l0aCB0aGF0IGhhbmRpY2FwLgoKVGhpcyBwYXRjaCBt YWtlcyB1c2Ugb2YgdGhlIHJlY2VudGx5LWFkZGVkIG1lbW9yeSBjb250ZXh0 IHJlc2V0IGNhbGxiYWNrCmZlYXR1cmUgdG8gbWFuYWdlIHRoZSBsaWZlc3Bh biBvZiBkb21haW4gY29uc3RyYWludCBjYWNoZXMsIHNvIHRoYXQgd2UKZG9u J3QgcmlzayBkZWxldGluZyBhIGNhY2hlIHRoYXQgbWlnaHQgYmUgaW4gdGhl IG1pZHN0IG9mIGV2YWx1YXRpb24uCgpBbHRob3VnaCB0aGlzIGlzIGEgYnVn IGZpeCBhcyB3ZWxsIGFzIGEgcGVyZm9ybWFuY2UgaW1wcm92ZW1lbnQsIG5v CmJhY2stcGF0Y2guICBUaGVyZSBoYXZlbid0IGJlZW4gbWFueSBpZiBhbnkg ZmllbGQgY29tcGxhaW50cyBhYm91dApzdGFsZSBkb21haW4gY29uc3RyYWlu dCBjaGVja3MsIHNvIGl0IGRvZXNuJ3Qgc2VlbSB3b3J0aCB0YWtpbmcgdGhl CnJpc2sgb2YgbW9kaWZ5aW5nIGRhdGEgc3RydWN0dXJlcyBhcyBiYXNpYyBh cyBNZW1vcnlDb250ZXh0cyBpbiBiYWNrCmJyYW5jaGVzLgoKQnJhbmNoCi0t LS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOGFiYjNjZGEwZGRjMDBhMGFiOTg5 NzdhMTYzM2E5NWI5NzA2OGQ0ZQoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvY29tbWFuZHMvdGFibGVjbWRzLmMgICAgIHwg ICAgNCArLQpzcmMvYmFja2VuZC9jb21tYW5kcy90eXBlY21kcy5jICAgICAg fCAgMTI3IC0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNR dWFsLmMgICAgICB8ICAgMTMgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2Rv bWFpbnMuYyAgICAgIHwgICA3OCArKystLS0tCnNyYy9iYWNrZW5kL3V0aWxz L2NhY2hlL3R5cGNhY2hlLmMgICB8ICA0MDUgKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrLQpzcmMvaW5jbHVkZS9jb21tYW5kcy90eXBlY21k cy5oICAgICAgfCAgICAyIC0Kc3JjL2luY2x1ZGUvbm9kZXMvZXhlY25vZGVz LmggICAgICAgIHwgICAgNSArLQpzcmMvaW5jbHVkZS91dGlscy90eXBjYWNo ZS5oICAgICAgICAgfCAgIDM3ICsrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9kb21haW4ub3V0IHwgICAzMCArKysKc3JjL3Rlc3QvcmVncmVzcy9z cWwvZG9tYWluLnNxbCAgICAgIHwgICAyNyArKysKMTAgZmlsZXMgY2hhbmdl ZCwgNTQ3IGluc2VydGlvbnMoKyksIDE4MSBkZWxldGlvbnMoLSkKCgotLSAK U2VudCB2aWEgcGdzcWwtY29tbWl0dGVycyBtYWlsaW5nIGxpc3QgKHBnc3Fs LWNvbW1pdHRlcnNAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0 byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1jb21taXR0ZXJzCg==