| From: | David Wheeler <david(at)kineticode(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL Performance List <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance of DOMAINs |
| Date: | 2006-06-22 18:11:36 |
| Message-ID: | 0878A4AB-925F-4CB8-BB75-53340599825D@kineticode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wheeler | 2006-06-22 18:18:12 | Re: Performance of DOMAINs |
| Previous Message | Tom Lane | 2006-06-22 16:24:44 | Re: Poor performance - fixed by restart |