On Wed, Mar 20, 2013 at 7:13 AM, jg <jg@rilk.com> wrote:
Now, there is a partition rotation script, that suppress old tables when some size limit happens. Let suppose, that this script runs and suppress only one table qith few days of data, then recreates a new empty one.
It sounds like you are using partitioned tables. your partitions should be divided up such that they help optimize your queries. that is, minimize the number of partitions you need to scan for any given query.
That said, try to make is so that this cleanup script purges whole partitions, not just deleting some rows. That way new data will fill in space without fragmentation.