Vick Khera wrote: > On Wed, Apr 21, 2010 at 6:45 AM, Leonardo F <m_lists@xxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general