Re: Partitioned table limitation

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Goboxe
> Sent: Monday, October 01, 2007 2:18 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Partitioned table limitation
>
> Hi,
>
> Are there any limitations on number of child tables that can be use
> in
> partitioned table?
>
> [snip]

We currently use partitioning by date and id, with 1/4 a year of dates and
approximately 10 IDs (and slowly increasing). Each partition runs from
around 1 million to 20 million rows.

Whether it's recommended or not, I don't know. But for us, the partitioning
works exactly as advertised. As with anything new, I'd take the time to
setup a simple test to see if it works for you, too.

In particular, be sure to check the documentation on caveats. You'll find
these a little stricter than partitioning issues in Oracle or SQL Server.

HTH,
Paul