X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 376C19FAC76 for ; Thu, 22 Jun 2006 15:11:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19160-09 for ; Thu, 22 Jun 2006 15:11:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail3.sea5.speakeasy.net (mail3.sea5.speakeasy.net [69.17.117.5]) by postgresql.org (Postfix) with ESMTP id B41E39FA68D for ; Thu, 22 Jun 2006 15:11:40 -0300 (ADT) Received: (qmail 2587 invoked from network); 22 Jun 2006 18:11:39 -0000 Received: from dsl093-038-250.pdx1.dsl.speakeasy.net (HELO [192.168.1.21]) (davidw@[66.93.38.250]) (envelope-sender ) by mail3.sea5.speakeasy.net (qmail-ldap-1.03) with RC4-SHA encrypted SMTP for ; 22 Jun 2006 18:11:39 -0000 In-Reply-To: <15919.1150920496@sss.pgh.pa.us> References: <54D833BE-A58F-47B8-B070-2AEDC0802468@kineticode.com> <15919.1150920496@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <0878A4AB-925F-4CB8-BB75-53340599825D@kineticode.com> Cc: PostgreSQL Performance List Content-Transfer-Encoding: 7bit From: David Wheeler Subject: Re: Performance of DOMAINs Date: Thu, 22 Jun 2006 11:11:36 -0700 To: Tom Lane X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/451 X-Sequence-Number: 19808 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