Nightly Prune

Chad Engler Chad.Engler at
Thu Feb 7 14:20:13 EST 2013

I'm writing the prune script in Node, and the dates are stored as int timestamps so that isn't an issue.


I was under the impression that secondary indexes only worked on the LevelDB backend, we have a solid write throughput (maybe 10ish writes per second) and very little read (aside from the prune). Would we see significant performance degradation by switching from Bitcask?




From: riak-users [mailto:riak-users-bounces at] On Behalf Of Stephan Kepser
Sent: Thursday, February 07, 2013 1:50 PM
To: riak-users at
Subject: Re: Nightly Prune


Hi Chad,

I recommend looking at secondary indexes. You can set up a secondary index with the relevant date from your entry. Note that there is no data type date, only string or integer. But you can easily convert a date into a string or an integer for your query purposes. Secondary indexes even provide you with a way to query for date ranges. And they are fast. So, I think they'd serve your purpose.



Dr. Stephan Kepser | Senior IT-Consultant

codecentric AG | Merscheider Straße 1 | 42699 Solingen | Deutschland
tel: +49 (0) 212.23362845 | fax: +49 (0) 212.23362879 | mobil: +49 (0) 151.52883635 | | |

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the riak-users mailing list