Re: Partitioning / Clustering

From: Mischa Sandberg
Subject: Re: Partitioning / Clustering
Date: ,
Msg-id: 1115775266.42816122ec4e3@webmail.telus.net
(view: Whole thread, Raw)
In response to: Re: Partitioning / Clustering  (Christopher Kings-Lynne)
Responses: Re: Partitioning / Clustering  ("Joshua D. Drake")
Re: Partitioning / Clustering  (Christopher Kings-Lynne)
List: pgsql-performance

Tree view

Partitioning / Clustering  (Alex Stapleton, )
 Re: Partitioning / Clustering  (John A Meinel, )
  Re: Partitioning / Clustering  ("Adam Haberlach", )
   Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (, )
    Re: Partitioning / Clustering  (Mischa Sandberg, )
   Re: Partitioning / Clustering  (John A Meinel, )
    Re: Partitioning / Clustering  (PFC, )
     Re: Partitioning / Clustering  ("Jim C. Nasby", )
   Re: Partitioning / Clustering  (Bruno Wolff III, )
  Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Josh Berkus, )
    Re: Partitioning / Clustering  (Neil Conway, )
     Re: Partitioning / Clustering  ("Joshua D. Drake", )
      Re: Partitioning / Clustering  (Neil Conway, )
       Re: Partitioning / Clustering  (Josh Berkus, )
        Re: Partitioning / Clustering  (Neil Conway, )
   Re: Partitioning / Clustering  (Mischa Sandberg, )
    Re: Partitioning / Clustering  ("Jim C. Nasby", )
     Re: Partitioning / Clustering  (Mischa Sandberg, )
      Re: Partitioning / Clustering  (Tom Lane, )
   Re: Partitioning / Clustering  (Christopher Kings-Lynne, )
    Re: Partitioning / Clustering  (Mischa Sandberg, )
     Re: Partitioning / Clustering  ("Joshua D. Drake", )
     Re: Partitioning / Clustering  (Christopher Kings-Lynne, )
      Re: Partitioning / Clustering  (Mischa Sandberg, )
 Re: Partitioning / Clustering  (Simon Riggs, )
  Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Christopher Kings-Lynne, )
    Re: Partitioning / Clustering  (Simon Riggs, )
   Re: Partitioning / Clustering  (Greg Stark, )
 Re: Partitioning / Clustering  ("David Roussel", )
  Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Alex Stapleton, )
  Re: Partitioning / Clustering  (Josh Berkus, )
   Re: Partitioning / Clustering  (PFC, )
   Re: Partitioning / Clustering  (PFC, )
  Re: Partitioning / Clustering  ("Jim C. Nasby", )
  Re: Partitioning / Clustering  (PFC, )
   Re: Partitioning / Clustering  (Alex Stapleton, )
   Re: Partitioning / Clustering  (Alex Turner, )
    Re: Partitioning / Clustering  (Alex Stapleton, )
     Re: Partitioning / Clustering  (Alex Turner, )
      Re: Partitioning / Clustering  (John A Meinel, )
       Re: Partitioning / Clustering  (Josh Berkus, )
        Re: Partitioning / Clustering  (Alex Stapleton, )
  Re: Partitioning / Clustering  (PFC, )
 Re: Partitioning / Clustering  (Josh Berkus, )

Quoting Christopher Kings-Lynne <>:

> > 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+ ?



pgsql-performance by date:

From: Simon Riggs
Date:
Subject: Re: Partitioning / Clustering
From: Neil Conway
Date:
Subject: Re: Partitioning / Clustering