Vick Khera wrote:
> On Wed, Apr 21, 2010 at 6:45 AM, Leonardo F <m_lists@yahoo.it> wrote:
> > "The partitioning code isn't designed to scale beyond a few dozen partitions"
> >
> > Is it mainly a planning problem or an execution time problem?
> >
>
> I'll bet that is related to the planning and constraint exclusion
> parts. I have a couple of tables split into 100 partitions, and they
> work extremely well.
Keep in mind that 100 is only 8 dozen ...
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.