i use Infinidb4. It is not really clear how partitions are working.
For example, i need partitions for each (or last) 30days on a date column. I need this for fast partition drops.
How i can configure this?
Is this possibile like mysql partitions?
With calShowPartitions i see always only one partition...
In the AdminGuide i found this:
Quote:The size of a partition is defined by two Calpont.xml settings - FilesPerColumnPartition and ExtentsPerSegmentFile. The default settings for these are FilesPerColumnPartition=4 and ExtentsPerSegmentFile=2. This equates to partition sizes of 4 * 2 * 8M = 64M rows. This setting is key as it defines the number of rows that can be rolled off at a time when dropping or disabling a partition.
What does this mean exactly? On each 64M rows one partition is automatically created?
Can someone explain this to me more detailed.
Thanks in advance.