Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Domains versus Check Constraints
- From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
- To: "Jim C. 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: Sun, 27 May 2007 18:34:22 +0200
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
- References:
- Domains versus Check Constraints
- From: Chander Ganesan
- Re: Domains versus Check Constraints
- From: Jim C. Nasby
- Domains versus Check Constraints
- Prev by Date: Re: Performance Problem with Vacuum of bytea table (PG 8.0.13)
- Next by Date: Re: Feature suggestion : FAST CLUSTER
- Previous by thread: Re: Domains versus Check Constraints
- Next by thread: Drop table vs Delete record
- Indexes: