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

Browse pgsql-performance by date

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