Re: Partitioning

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Jim C(dot) Nasby <jim(at)nasby(dot)net>, Jeremy Haile <jhaile(at)fastmail(dot)fm>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Partitioning
Date: 2007-01-11 12:51:12
Message-ID: 6b147815b01253f9c9a22f0e896a8aa7@oopsware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 10 Jan 2007 15:30:16 -0600, Scott Marlowe <smarlowe(at)g2switchworks(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mikael Carneholm 2007-01-11 12:59:20 Re: Partitioning
Previous Message Simon Riggs 2007-01-11 12:15:50 Re: table partioning performance