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

Re: Strange explain on partitioned tables

From: Gerald Fontenay <gvfontenay(at)lbl(dot)gov>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Strange explain on partitioned tables
Date: 2010-07-23 22:03:55
Message-ID: 4C4A11CB.6040800@lbl.gov (view raw or flat)
Thread:
Lists: pgsql-performance
> 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...

Thanks,
Gerald





In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2010-07-23 22:16:10
Subject: Re: Strange explain on partitioned tables
Previous:From: Craig JamesDate: 2010-07-23 21:47:23
Subject: Re: Using more tha one index per table

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