Re: Partitioning - Mailing list pgsql-performance

From Bernd Helmle
Subject Re: Partitioning
Date
Msg-id 6b147815b01253f9c9a22f0e896a8aa7@oopsware.de
Whole thread Raw
In response to Re: Partitioning  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Partitioning  ("Adam Rich" <adam.r@sbcglobal.net>)
List pgsql-performance


On Wed, 10 Jan 2007 15:30:16 -0600, Scott Marlowe <smarlowe@g2switchworks.com> wrote:

[...]

>
> And I don't think the mysql partition supports tablespaces either.
>

MySQL supports distributing partitions over multiple disks via the SUBPARTITION clause [1].
I leave it to you, wether their syntax is cleaner, more powerful or easier or ....;)


Bernd

[1] http://dev.mysql.com/doc/refman/5.1/en/partitioning-subpartitions.html

pgsql-performance by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: table partioning performance
Next
From: "Mikael Carneholm"
Date:
Subject: Re: Partitioning