Em 30-09-2011 14:01, Merlin Moncure escreveu:
2011/9/29 Ondrej Ivanič:
Hi,
On 30 September 2011 01:08, Kevin Grittner 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..
2011/9/29 Ondrej Ivanič :
> Hi,
>
> On 30 September 2011 01:08, Kevin Grittner
> 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...
yeah -- the system was
Hi,
On 30 September 2011 01:08, Kevin Grittner 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.iva...@gmail.com)
--
Sent via pgsql
Jian Shi wrote:
[moving the last sentence to the top]
> The system is 32-bit Linux, dual core, 4G memory. Postgres version
> is 8.1.21.
Version 8.1 is out of support and doesn't perform nearly as well as
modern versions.
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy
T
Hey,
Is there a suggested number of child tables for table partitioning, I ran a
stress test on a master
table (with 800 thousand rows), trying to create 500,000 child tables for it,
each child table has 2
indexes and 3 constraints (Primary key and foreign key). I wrote a script to do
it: aft
