Re: Partitioning / Clustering - Mailing list pgsql-performance

From Neil Conway
Subject Re: Partitioning / Clustering
Date
Msg-id 42818C7A.7020207@samurai.com
Whole thread Raw
In response to Re: Partitioning / Clustering  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Partitioning / Clustering  (Josh Berkus <josh@agliodbs.com>)
List 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 by date:

Previous
From: Sam Vilain
Date:
Subject: Re: Prefetch
Next
From: Josh Berkus
Date:
Subject: Re: Partitioning / Clustering