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: (view raw, whole thread or download thread mbox)
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      512.569.9461 (cell)

In response to


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-2017 The PostgreSQL Global Development Group