Re: Data Warehouse Reevaluation - MySQL vs Postgres --

Josh Berkus wrote:
>> - the use of inherited tables to partition this huge number of rows and
>> yet allow simple query access to it seems to work well, at least in
>> early validation tests
>> - had we simply taken the original database and "slammed" it into
>> Postgres with no further thought, we would not have seen the big
>> improvements, and thus the project might have been seen as a failure
>> (even though it saves substantial $)
>
>
> Any further thoughts on developing this into true table partitioning?
>

Just that I'd love to see it happen ;-)

Maybe someday I'll be able to find the time to work on it myself, but
for the moment I'm satisfied with the workarounds we've made.

Joe