Re: Partitioning / Clustering

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Partitioning / Clustering
Дата
Msg-id 42818C7A.7020207@samurai.com
обсуждение исходный текст
Ответ на Re: Partitioning / Clustering  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Partitioning / Clustering  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Joshua D. Drake wrote:
> Neil Conway wrote:
>> Oh? What's wrong with MySQL's clustering implementation?
>
> Ram only tables :)

Sure, but that hardly makes it not "usable". Considering the price of
RAM these days, having enough RAM to hold the database (distributed over
the entire cluster) is perfectly acceptable for quite a few people.

(Another deficiency is in 4.0, predicates in queries would not be pushed
down to storage nodes -- so you had to stream the *entire* table over
the network, and then apply the WHERE clause at the frontend query node.
That is fixed in 5.0, though.)

-Neil

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

Предыдущее
От: Sam Vilain
Дата:
Сообщение: Re: Prefetch
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Partitioning / Clustering