Re: Performance impact of hundreds of partitions - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Performance impact of hundreds of partitions
Date
Msg-id 20100421201242.GD3762@alvh.no-ip.org
Whole thread Raw
In response to Re: Performance impact of hundreds of partitions  (Vick Khera <vivek@khera.org>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Avoiding surrogate keys
Next
From: "I. B."
Date:
Subject: Returning a char from a C-language function