Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2DEE49FA354 for ; Thu, 11 Jan 2007 10:17:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 68898-08 for ; Thu, 11 Jan 2007 10:17:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp110.sbc.mail.re2.yahoo.com (smtp110.sbc.mail.re2.yahoo.com [68.142.229.95]) by postgresql.org (Postfix) with SMTP id 81A689FB1C3 for ; Thu, 11 Jan 2007 10:17:35 -0400 (AST) Received: (qmail 91170 invoked from network); 11 Jan 2007 14:17:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:X-MSMail-Priority:X-Mailer:X-MimeOLE:In-Reply-To:Importance; b=J+y458K7Ru9yGMcjEpuVZW8uddlWYBvkTVyROZR1MUq6kZ7U8pxwXnxCcWuqTs688/kWUAcgvJifqobsB9iKpazbUlvhVYtO52213eOsSlC+2KkRoZGgChv8QsuAbS6uZDstnRH4QMCHjPXipuFEu6XMyiFPeh9TkBQYUyvgVzA= ; Received: from unknown (HELO dualcore) (adam.r@sbcglobal.net@75.2.68.162 with login) by smtp110.sbc.mail.re2.yahoo.com with SMTP; 11 Jan 2007 14:17:34 -0000 X-YMail-OSG: iGzCHEMVM1kzJKo14.LuAbViNet3P58ncWEvuHSusR9ko5nOUI6U.cN0OsGqnTc6XPUvcZoOpYb3ouKIiSCjvPxfAdlChYaHWT73tQufBMOOW2J_J2tfnRmF2GZ3DVIFgd7g8yXLlMlDYPUTpoXpPFtsrw-- From: "Adam Rich" To: "'Bernd Helmle'" , "'Scott Marlowe'" Cc: "'Jim C. Nasby'" , "'Jeremy Haile'" , Subject: Re: Partitioning Date: Thu, 11 Jan 2007 08:18:39 -0600 Message-ID: <045101c7358b$644554a0$6400a8c0@dualcore> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826 In-Reply-To: <6b147815b01253f9c9a22f0e896a8aa7@oopsware.de> Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/172 X-Sequence-Number: 22773 Each partition can have its own disk, without using subpartitions. CREATE TABLE th (id INT, name VARCHAR(30), adate DATE) PARTITION BY LIST(YEAR(adate)) ( PARTITION p1999 VALUES IN (1995, 1999, 2003) DATA DIRECTORY = '/var/appdata/95/data' INDEX DIRECTORY = '/var/appdata/95/idx', PARTITION p2000 VALUES IN (1996, 2000, 2004) DATA DIRECTORY = '/var/appdata/96/data' INDEX DIRECTORY = '/var/appdata/96/idx', PARTITION p2001 VALUES IN (1997, 2001, 2005) DATA DIRECTORY = '/var/appdata/97/data' INDEX DIRECTORY = '/var/appdata/97/idx', PARTITION p2000 VALUES IN (1998, 2002, 2006) DATA DIRECTORY = '/var/appdata/98/data' INDEX DIRECTORY = '/var/appdata/98/idx' ); Subpartitions are just a way to break (parent) partitions up into smaller pieces. Those of course can be moved to other disks just like the main partitions. -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Bernd Helmle Sent: Thursday, January 11, 2007 6:51 AM To: Scott Marlowe Cc: Jim C. Nasby; Jeremy Haile; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Partitioning On Wed, 10 Jan 2007 15:30:16 -0600, Scott Marlowe 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly