Re: Domains versus Check Constraints - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Domains versus Check Constraints
Date
Msg-id 20070527155942.GN92628@nasby.net
Whole thread Raw
In response to Domains versus Check Constraints  (Chander Ganesan <chander@otg-nc.com>)
Responses Re: Domains versus Check Constraints  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-performance
On Tue, May 22, 2007 at 12:56:21PM -0400, Chander Ganesan wrote:
> Are there any performance improvements that come from using a domain
> over a check constraint (aside from the ease of management component)?

No. Plus support for domain constraints isn't universal (plpgsql doesn't
honor them, for example).
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Feature suggestion : FAST CLUSTER
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Simulate database fragmentation