Sam Vilain wrote:
There are some clearly defined areas where this certainly is the right answer. Oracle still has some killer OLAP features in its Enterprise product compared to Postgres; off the top of my head:- bitmap indexes (though the latest version of Bizgres, a Postgres extension, supports these)
[...] As an Oracle person, having little experience with other databases, I reading these informative comments, and this one in particular is close to my concerns. So followup question: are any of these other systems good with large'ish databases? I have multi-TB Oracle databases that I'd like to explore on a "free" database. Is that realistic? My current system relies heavily on partitions, bitmap indexes, table compression, though I can live without query rewrite. 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? Thanks! Mark
