In a large scale time series row-store DB (Oracle), I&#39;m accustomed to partitioning fact tables on time.  This has has a couple of benefits:<div>- since queries always include predicates on the time field, partition elimination can help a lot</div>
<div>- when the time based partitions map one-to-one with tablespaces, removing old data is extremely fast.  (when you&#39;ve reached the maximum data retention period, you need to remove data as fast as you can load it).</div>
<div><br></div><div>Are there any features in monetdb that would facilitate these needs (or ameliorate them)?</div><div><br></div><div>TIA,</div><div>-david</div>