X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A21BD8BA316 for ; Fri, 18 Feb 2005 23:27:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35377-09 for ; Fri, 18 Feb 2005 23:27:35 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id B712E8BA0FA for ; Fri, 18 Feb 2005 23:27:37 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 9C1FF31E33; Sat, 19 Feb 2005 00:27:37 +0100 (MET) From: Gaetano Mendola X-Newsgroups: pgsql.performance Subject: Re: PostgreSQL clustering VS MySQL clustering Date: Sat, 19 Feb 2005 00:27:07 +0100 Organization: Hub.Org Networking Services Lines: 27 Message-ID: References: <200501201503.31241.herve@elma.fr> <200501201536.08656.herve@elma.fr> <41EFC26A.4070605@familyhealth.com.au> <200501201542.06645.herve@elma.fr> <41EFC569.6030800@familyhealth.com.au> <20050120150847.GQ10437@ns.snowman.net> <20050121013204.GL67721@decibel.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <20050121013204.GL67721@decibel.org> X-Enigmail-Version: 0.90.1.1 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/267 X-Sequence-Number: 10596 Jim C. Nasby wrote: > On Thu, Jan 20, 2005 at 10:08:47AM -0500, Stephen Frost wrote: > >>* Christopher Kings-Lynne (chriskl@familyhealth.com.au) wrote: >> >>>PostgreSQL has replication, but not partitioning (which is what you want). >> >>It doesn't have multi-server partitioning.. It's got partitioning >>within a single server (doesn't it? I thought it did, I know it was >>discussed w/ the guy from Cox Communications and I thought he was using >>it :). > > > No, PostgreSQL doesn't support any kind of partitioning, unless you > write it yourself. I think there's some work being done in this area, > though. Seen my last attempts to perform an horizontal partition I have to say that postgres do not support it even if you try to write it yourself (see my post "horizontal partion" ). Regards Gaetano Mendola