Skip site navigation (1) Skip section navigation (2)

Re: Strange explain on partitioned tables

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: gvfontenay(at)lbl(dot)gov
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange explain on partitioned tables
Date: 2010-07-23 22:16:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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

Joshua D. Drake

-- Major Contributor
Command Prompt, Inc: - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering |

In response to


pgsql-performance by date

Next:From: Greg SmithDate: 2010-07-24 05:12:28
Subject: Re: Strange explain on partitioned tables
Previous:From: Gerald FontenayDate: 2010-07-23 22:03:55
Subject: Re: Strange explain on partitioned tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group