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

Re: Domains versus Check Constraints

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Chander Ganesan <chander(at)otg-nc(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Domains versus Check Constraints
Date: 2007-05-27 15:59:42
Message-ID: 20070527155942.GN92628@nasby.net (view raw or flat)
Thread:
Lists: 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(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2007-05-27 16:05:38
Subject: Re: Simulate database fragmentation
Previous:From: Jim C. NasbyDate: 2007-05-27 15:53:38
Subject: Re: Feature suggestion : FAST CLUSTER

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