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 BCE853A470A for ; Thu, 20 Jan 2005 14:30:47 +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 07047-06 for ; Thu, 20 Jan 2005 14:30:28 +0000 (GMT) Received: from relay.snowman.net (relay.snowman.net [66.92.160.56]) by svr1.postgresql.org (Postfix) with ESMTP id 115863A45B9 for ; Thu, 20 Jan 2005 14:30:30 +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 j0KEURIA017833 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Thu, 20 Jan 2005 09:30:27 -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 j0KEUjcK010235 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Thu, 20 Jan 2005 09:30:45 -0500 Received: (from sfrost@localhost) by ns.snowman.net (8.13.1/8.13.1/Submit) id j0KEUjnL010233; Thu, 20 Jan 2005 09:30:45 -0500 Date: Thu, 20 Jan 2005 09:30:45 -0500 From: Stephen Frost To: =?iso-8859-1?Q?Herv=E9?= Piedvache Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering Message-ID: <20050120143045.GN10437@ns.snowman.net> Mail-Followup-To: =?iso-8859-1?Q?Herv=E9?= Piedvache , pgsql-performance@postgresql.org References: <200501201503.31241.herve@elma.fr> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="8xrkxCw8NdvQ1PPj" Content-Disposition: inline In-Reply-To: <200501201503.31241.herve@elma.fr> 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: 09:27:53 up 355 days, 9:23, 8 users, load average: 0.18, 0.12, 0.09 User-Agent: Mutt/1.5.6+20040907i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.017 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/272 X-Sequence-Number: 9962 --8xrkxCw8NdvQ1PPj Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * Herv? Piedvache (herve@elma.fr) wrote: > Is there any solution with PostgreSQL matching these needs ... ? You might look into pg_pool. Another possibility would be slony, though I'm not sure it's to the point you need it at yet, depends on if you can handle some delay before an insert makes it to the slave select systems. > Do we have to backport our development to MySQL for this kind of problem ? Well, hopefully not. :) > Is there any other solution than a Cluster for our problem ? Bigger server, more CPUs/disks in one box. Try to partition up your data some way such that it can be spread across multiple machines, then if you need to combine the data have it be replicated using slony to a big box that has a view which joins all the tables and do your big queries against that. Just some thoughts. Stephen --8xrkxCw8NdvQ1PPj 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) iD8DBQFB78CVrzgMPqB3kigRAtYCAJwI/YJlqadWGNSNJgdYLXQhoHwRJACfbEPm UEWaQ8XGRcGInTJxXiFvAEQ= =gNO+ -----END PGP SIGNATURE----- --8xrkxCw8NdvQ1PPj--