Re: On Scalability - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: On Scalability
Date
Msg-id 1280425184.8613.41.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: On Scalability  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: On Scalability
Next
From: "Joshua D. Drake"
Date:
Subject: Re: On Scalability