| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: On Scalability |
| Date: | 2010-07-29 17:39:44 |
| Message-ID: | 1280425184.8613.41.camel@jd-desktop.unknown.charter.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2010-07-29 17:52:12 | Re: On Scalability |
| Previous Message | Vincenzo Romano | 2010-07-29 17:34:20 | Re: On Scalability |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2010-07-29 17:52:12 | Re: On Scalability |
| Previous Message | Josh Berkus | 2010-07-29 17:39:14 | Re: Pooling in Core WAS: Need help in performance tuning. |