Re: Partitioned table limitation
От | paul rivers |
---|---|
Тема | Re: Partitioned table limitation |
Дата | |
Msg-id | 004c01c80451$e2b601a0$6301a8c0@parzifal обсуждение исходный текст |
Ответ на | Partitioned table limitation (Goboxe <hadzramin.ar@gmail.com>) |
Ответы |
Re: Partitioned table limitation
|
Список | pgsql-general |
> -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of Goboxe > Sent: Monday, October 01, 2007 2:18 AM > To: pgsql-general@postgresql.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
В списке pgsql-general по дате отправления: