Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id C5B4F633914 for ; Thu, 29 Jul 2010 14:40:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 71738-07 for ; Thu, 29 Jul 2010 17:40:04 +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 AFEE16336F1 for ; Thu, 29 Jul 2010 14:40:04 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 58A3B348035; Thu, 29 Jul 2010 10:39:58 -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 TJ4nf45N0nGd; Thu, 29 Jul 2010 10:39:55 -0700 (PDT) Received: from [75.142.153.107] (unknown [75.142.153.107]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id A3C02348002; Thu, 29 Jul 2010 10:39:55 -0700 (PDT) Subject: Re: On Scalability From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Vincenzo Romano Cc: pgsql-hackers@postgresql.org In-Reply-To: References: <1280423526.8613.36.camel@jd-desktop.unknown.charter.com> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Thu, 29 Jul 2010 10:39:44 -0700 Message-ID: <1280425184.8613.41.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-5 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201007/1526 X-Sequence-Number: 166715 On Thu, 2010-07-29 at 19:34 +0200, Vincenzo Romano wrote: > I expect that a more complex schema will imply higher workloads > on the query planner. What I don't know is how the increase in the > workload will happen: linearly, sublinearly, polinomially or what? > > Significant testing would require a prototype implementation with > an almost complete feed of data from the current solution. > But I'm at the feasibility study stage and have not enough resources > for that. > > Thanks anyway for the insights, Joshua. > Does the 60-100 tables limit applies to a single level > of inheritance? Or is it more general? I do not currently have experience (except that it is possible) with multi-level inheritance and postgresql. > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt