Re: Data Warehouse Reevaluation - MySQL vs Postgres --

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Дата
Msg-id 41487D3D.1040509@joeconway.com
обсуждение исходный текст
Ответ на Re: Data Warehouse Reevaluation - MySQL vs Postgres --  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Data Warehouse Reevaluation - MySQL vs Postgres --
Следующее
От: Ron St-Pierre
Дата:
Сообщение: Re: [GENERAL] disk performance benchmarks