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 35CB63A47F0 for ; Thu, 20 Jan 2005 15:09:03 +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 11554-08 for ; Thu, 20 Jan 2005 15:08:43 +0000 (GMT) Received: from relay.snowman.net (relay.snowman.net [66.92.160.56]) by svr1.postgresql.org (Postfix) with ESMTP id 1E2883A4752 for ; Thu, 20 Jan 2005 15:08:46 +0000 (GMT) Received: from ns.snowman.net (ns.snowman.net [10.10.0.2]) by relay.snowman.net (8.13.1/8.13.1/Debian-19) with ESMTP id j0KF8Tnb018438 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Thu, 20 Jan 2005 10:08:29 -0500 Received: from ns.snowman.net (localhost [127.0.0.1]) by ns.snowman.net (8.13.1/8.13.1/Debian-19) with ESMTP id j0KF8lQ4012019 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Thu, 20 Jan 2005 10:08:47 -0500 Received: (from sfrost@localhost) by ns.snowman.net (8.13.1/8.13.1/Submit) id j0KF8l3m012017; Thu, 20 Jan 2005 10:08:47 -0500 Date: Thu, 20 Jan 2005 10:08:47 -0500 From: Stephen Frost To: Christopher Kings-Lynne Cc: =?iso-8859-1?Q?Herv=E9?= Piedvache , pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering Message-ID: <20050120150847.GQ10437@ns.snowman.net> Mail-Followup-To: Christopher Kings-Lynne , =?iso-8859-1?Q?Herv=E9?= Piedvache , pgsql-performance@postgresql.org 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> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="F+K/njrK4+2xOJ0g" Content-Disposition: inline In-Reply-To: <41EFC569.6030800@familyhealth.com.au> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 10:07:53 up 355 days, 10:03, 8 users, load average: 0.28, 0.24, 0.19 User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.015 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/292 X-Sequence-Number: 9982 --F+K/njrK4+2xOJ0g Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * 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 :). > So, your only option is Oracle or another very expensive commercial=20 > database. Or partition the data at the application layer. Stephen --F+K/njrK4+2xOJ0g Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFB78l/rzgMPqB3kigRAkNkAJ0WDBq6zNz9CAl/2AemXBBskqsX1QCglHZ0 v8spVpSyyvXq0l5yV+noJ/0= =CA1o -----END PGP SIGNATURE----- --F+K/njrK4+2xOJ0g--