Re: Auto Partitioning using unix time

[JinNo Kim]

Is the event feature an anticipated replacement for
the auto generation of new partitions, or is it a
suggested work around? I ask specifically because
I've been toying with migrating our existing 5.5
billion row dataset to a partitioned solution and
recently received a new requirement for approx 4.5
billion rows of storage (short term - data import
is occurring now on 4.1, different schema from
the previous project).

Based upon our current disk capacity and the data
rates, I expect to be in the ~20 billion row range
in ~6 months (10 billion existing + ~45
million/day new records). I haven't bothered to
figure out when we'll be out of space - that's
coming soon.

^
| _explains my recent absence from the boards


Just asking for a little clarification (I know
the reqs for auto-part have not yet been
submitted - sorry, my bad been very occupied
recently).

-JNK