On 12/1/05 10:00 PM, Mark wrote: > For example, I have a ~10 billion row, ~1TB table, time partitioned, > with about 10-20 million rows per day. I need "interactive" > performance (2-10 seconds) response on queries that are confined > to 2-3 days data. Obviously, I can't scan a TB table each time. > In Oracle, the I/O pruning is simple to setup, and then automatic, > with partitioning. > > Are there similar facilities in MySQL, or the others?
Postgres 8.1 supports basic partitioning: http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html If anyone has a 10 billion row MySQL table, partitioned or otherwise, that that they can actually do useful work with, I'd like to hear about it... :) -John