Re: Strange explain on partitioned tables

From: Gerald Fontenay <gvfontenay(at)lbl(dot)gov>
To: pgsql-performance(at)postgresql(dot)org
Cc: Gerald Fontenay <gvfontenay(at)lbl(dot)gov>
Subject: Re: Strange explain on partitioned tables
Date: 2010-07-26 21:26:45
Message-ID: 4C4DFD95.4000901@lbl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joshua D. Drake wrote:
> On Fri, 2010-07-23 at 15:03 -0700, Gerald Fontenay wrote:
>
>>> The PostgreSQL partitioning system is aimed to support perhaps a
>>> hundred inherited tables. You can expect to get poor performance on
>>> queries if you create 1000 of them.
>>>
>> Hi,
>>
>> Why is that you would expect poor performance for say 1000 or more? I
>> have a ~1000 inherited tables and I don't see any significant slowdowns.
>> I only ever access a single inherited table at a time though in this
>> situation. I suppose I am using inheritance only for organization in
>> this case...
>>
>
> It is variable based on workload and as I recall has to do with the
> planning time. As the number of children increases, so does the planning
> time.
>
> Joshua D. Drake
>
>
>
Thank you for your response. So if I query only my target child table,
this should be "just like" any other single table wrt planning right? I
have thousands of these tables. (I suppose that I'm only using
inheritance for the sake of organization in this situation...)

Thanks!
Gerald

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2010-07-26 22:28:04 Re: Testing Sandforce SSD
Previous Message Greg Spiegelberg 2010-07-26 21:23:20 Re: Testing Sandforce SSD