Re: Partitioning / Clustering

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Mischa Sandberg <mischa(dot)sandberg(at)telus(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Partitioning / Clustering
Date: 2005-05-11 01:48:48
Message-ID: 42816480.5050108@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mischa Sandberg wrote:
> Quoting Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>:
>
>
>>>This is why I mention partitioning. It solves this issue by storing
>>>different data sets on different machines under the same schema.
>>>These seperate chunks of the table can then be replicated as well for
>>>data redundancy and so on. MySQL are working on these things
>>
>>*laff*
>>Yeah, like they've been working on views for the last 5 years, and
>>still haven't released them :D :D :D
>
>
> ?
> http://dev.mysql.com/doc/mysql/en/create-view.html
> ...for MySQL 5.0.1+ ?

Yes but MySQL 5 isn't out yet (considered stable).

Sincerely,

Joshua D. Drake

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2005-05-11 01:51:49 Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
Previous Message Mischa Sandberg 2005-05-11 01:34:26 Re: Partitioning / Clustering