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

Re: Domains versus Check Constraints

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Chander Ganesan <chander(at)otg-nc(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Domains versus Check Constraints
Date: 2007-05-27 16:34:22
Message-ID: 4659B30E.5000802@kaltenbrunner.cc (view raw or flat)
Thread:
Lists: pgsql-performance
Jim C. Nasby wrote:
> 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).

since 8.2 domain constraints are enforced everywhere ...


Stefan

In response to

pgsql-performance by date

Next:From: PFCDate: 2007-05-27 17:34:30
Subject: Re: Feature suggestion : FAST CLUSTER
Previous:From: Jim C. NasbyDate: 2007-05-27 16:08:31
Subject: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)

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