On Mon, Aug 4, 2014 at 12:42 PM, Kevin Burton <bur...@spinn3r.com> wrote:
> What's a reasonable range for the max number of tables? We have an > append-only table system and I've been thinking of moving them to using > hourly / partitioned tables. > "Low Numbers of Hundreds" > This means I can do things like easily drop older tables if I run out of > disk space. It also means that I can fadvise the most recent tables and > force them into table cache. > If you have to use fadvise to do this, you are almost certainly Doing It Wrong. > But what's the max number of tables? If I'm doing hourly tables and have > 30 days of them this would be 720 individual tables. > Probably pushing it. =Rob
