Re: Performance of DOMAINs

[David Wheeler <david(at)kineticode(dot)com>]

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