Re: Performance of DOMAINs - Mailing list pgsql-performance

From David Wheeler
Subject Re: Performance of DOMAINs
Date
Msg-id 0878A4AB-925F-4CB8-BB75-53340599825D@kineticode.com
Whole thread Raw
In response to Re: Performance of DOMAINs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Jun 21, 2006, at 13:08, Tom Lane wrote:

> There are some reports in the archives of particular usage patterns
> where they pretty much suck, because GetDomainConstraints() searches
> pg_constraint every time it's called.  We do what we can to avoid
> calling that multiple times per query, but for something like a simple
> INSERT ... VALUES into a domain column, the setup overhead is still
> bad.

I assume that there's no domain thingy that you already have that
could cache it, eh?

Sorry, I ask this as someone who knows no C and less about
PostgreSQL's internals.

Best,

David


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Poor performance - fixed by restart
Next
From: David Wheeler
Date:
Subject: Re: Performance of DOMAINs