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.
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. 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. That sounds reasonable… but what's the upper bound here? Kevin -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* blog: http://burtonator.wordpress.com … or check out my Google+ profile <https://plus.google.com/102718274791889610666/posts> <http://spinn3r.com>
