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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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