Re: the number of child tables --table partitioning

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: the number of child tables --table partitioning
Date: 2011-09-29 21:12:41
Message-ID: CAM6mieL6RFhhmFyhmMOGZew0O3NavBY4XnMsxQmVV+kxGFj=5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 30 September 2011 01:08, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
>> Is there a suggested number of child tables for table
>> partitioning,
>
> Generally, don't go over about 100 partitions per table.

Having 365 partitions per table is fine...

--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2011-09-30 00:39:28 Shortcutting too-large offsets?
Previous Message Merlin Moncure 2011-09-29 16:52:46 Re: : Create table taking time