Re: On Scalability

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: jd(at)commandprompt(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: On Scalability
Date: 2010-07-29 17:52:12
Message-ID: AANLkTim7HQQz=qGfW=xDhx-8HNppYxXF48NjnU2-XiNt@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

2010/7/29 Joshua D. Drake <jd(at)commandprompt(dot)com>:
> 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, polynomially or what?

Do you think I should ask somewhere else?
Any hint?

>> 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.

Thanks anyway.

--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS NAVTA PERITVS

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2010-07-29 18:16:50 Re: On Scalability
Previous Message Joshua D. Drake 2010-07-29 17:39:44 Re: On Scalability

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2010-07-29 18:16:50 Re: On Scalability
Previous Message Joshua D. Drake 2010-07-29 17:39:44 Re: On Scalability