Hi, On 30 September 2011 01:08, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> 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@xxxxxxxxx) -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance