> 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.
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
In response to
pgsql-performance by date
|Next:||From: Joshua D. Drake||Date: 2010-07-23 22:16:10|
|Subject: Re: Strange explain on partitioned tables|
|Previous:||From: Craig James||Date: 2010-07-23 21:47:23|
|Subject: Re: Using more tha one index per table|