Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 479D29FA372
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 11 Jan 2007 08:51:28 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 95128-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 11 Jan 2007 08:51:02 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from dd1514.kasserver.com (dd1514.kasserver.com [81.209.148.206])
	by postgresql.org (Postfix) with ESMTP id 9210C9F95CB
	for <pgsql-performance@postgresql.org>;
	Thu, 11 Jan 2007 08:51:18 -0400 (AST)
Received: by dd1514.kasserver.com (Postfix, from userid 30)
	id 3CA672D4FC9; Thu, 11 Jan 2007 13:51:12 +0100 (CET)
To: Scott Marlowe <smarlowe@g2switchworks.com>
Subject: Re: Partitioning
MIME-Version: 1.0
Date: Thu, 11 Jan 2007 13:51:12 +0100
From: Bernd Helmle <mailings@oopsware.de>
Cc: Jim C. Nasby <jim@nasby.net>, Jeremy Haile <jhaile@fastmail.fm>,
	pgsql-performance@postgresql.org
In-Reply-To: <1168464615.20602.211.camel@state.g2switchworks.com>
References: <1168464615.20602.211.camel@state.g2switchworks.com>
Message-ID: <6b147815b01253f9c9a22f0e896a8aa7@oopsware.de>
X-Sender: mailings@oopsware.de
User-Agent: RoundCube Webmail/0.1b
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/169
X-Sequence-Number: 22770




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