Postgres Pro
Downloads
Home   >   mailing lists

Re: the number of child tables --table partitioning - Mailing list pgsql-performance

From Ondrej Ivanič
Subject Re: the number of child tables --table partitioning
Date
Msg-id CAM6mieL6RFhhmFyhmMOGZew0O3NavBY4XnMsxQmVV+kxGFj=5A@mail.gmail.com
Whole thread Raw
In response to Re: the number of child tables --table partitioning  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: the number of child tables --table partitioning  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Tree view 
Hi,

On 30 September 2011 01:08, Kevin Grittner <Kevin.Grittner@wicourts.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.ivanic@gmail.com)

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: : Create table taking time
Next
From: Josh Berkus
Date:
Subject: Shortcutting too-large offsets?