On Mar 20, 2007, at 11:20 AM, Heiko W.Rupp wrote:
partition through the master
table abould halfed the speed with 4 partitions and made a 50%
increase for 2 partitions.
Please note: this is not representative in any kind!
I fully intend to build knowledge of the partitions into the insert
My question is how small to make each inherited piece? If I do
modulo 10, then each sub-table will be between 32 and 34 million
rows today based on current distribution.
You might try this with various sizes.
I did some testing lateley and found out that insert performance -
even if only
I've got one logging table that is over 330 million rows to store 6
months' worth of data. It consists of two integers and a 4-character
long string. I have one primary key which is the two integers, and
an additional index on the second integer.
I'm planning to use inheritance to split t