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 04413D1B8E8 for ; Wed, 16 Jun 2004 16:15:31 -0300 (ADT) 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 01804-05 for ; Wed, 16 Jun 2004 19:15:30 +0000 (GMT) Received: from zaphod.uchicago.edu (zaphod.uchicago.edu [128.135.72.61]) by svr1.postgresql.org (Postfix) with ESMTP id 4DB01D1B7D4 for ; Wed, 16 Jun 2004 16:15:27 -0300 (ADT) Received: from [128.135.72.37] (mathlab09.uchicago.edu [128.135.72.37]) by zaphod.uchicago.edu (8.12.10/8.12.10) with ESMTP id i5GJFSwc004156 for ; Wed, 16 Jun 2004 14:15:28 -0500 Subject: Basic Postgresql Performance Question From: Bill To: pgsql-performance@postgresql.org Content-Type: text/plain Message-Id: <1087413327.3207.9.camel@mathlab09.uchicago.edu> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Wed, 16 Jun 2004 14:15:27 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/161 X-Sequence-Number: 7219 Hi, I currently have a mysql server running with a database of around 800 gb. The problem is that the server is old (500 MHz Pentium III with 512 MB RAM) and I want to change this to a new server and convert the existing database to Postgresql on Debian (I assume that Postgresql offers better performance for complex read only queries on large databases), though I was wondering if 1. It is possible to have some sort of load-balancing through buying many computers without replication, i.e have one server which has the databases and then other servers which has no database but just exists to balance the memory and processor load? (I have heard this is possible with C-JDBC)It is difficult to have enough space to replicate a 600 gb database across all computers) 2. It is advantageous to buy AMD 64 rather than the Pentium IV? Any thoughts? Thanks.