Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id BBF851337C31 for ; Thu, 7 Oct 2010 12:07:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 99806-05-2 for ; Thu, 7 Oct 2010 15:07:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 79D771337BB9 for ; Thu, 7 Oct 2010 12:07:33 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id B7553348015; Thu, 7 Oct 2010 08:07:26 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fVI61069VduM; Thu, 7 Oct 2010 08:07:21 -0700 (PDT) Received: from perhan.alvh.no-ip.org (unknown [190.95.9.205]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 33510348012; Thu, 7 Oct 2010 08:07:21 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 51C466E609; Thu, 7 Oct 2010 11:07:18 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: Greg Smith , Robert Haas , Heikki Linnakangas , Simon Riggs , pgsql-hackers Subject: Re: On Scalability From: Alvaro Herrera To: Vincenzo Romano In-reply-to: References: <1280423526.8613.36.camel@jd-desktop.unknown.charter.com> <1280425184.8613.41.camel@jd-desktop.unknown.charter.com> <1280427410.8613.44.camel@jd-desktop.unknown.charter.com> <4CAD769D.9090301@enterprisedb.com> <1286437290.2304.192.camel@ebony> <4CAD7BED.4050009@enterprisedb.com> <4CADDA06.5070002@2ndquadrant.com> Date: Thu, 07 Oct 2010 11:07:18 -0400 Message-Id: <1286463959-sup-8255@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201010/464 X-Sequence-Number: 171504 Excerpts from Vincenzo Romano's message of jue oct 07 10:44:34 -0400 2010: > Do you mean the check constraint is used as plain text to be (somehow) executed? > If this is the case, then you (all) are perfectly and obviously right > and I'm just fishing > for bicycles in the sea. Yeah, hence this thread hasn't advanced things very much in any useful direction. That we need to improve the partitioning implementation is already known. -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support