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 1CF0A8B9C01 for ; Mon, 31 Jan 2005 14:54:38 +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 76049-05 for ; Mon, 31 Jan 2005 14:54:15 +0000 (GMT) Received: from www.postgresql.com (unknown [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 855F88B9CAA for ; Mon, 31 Jan 2005 14:49:14 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by www.postgresql.com (Postfix) with ESMTP id 263249A81F9 for ; Mon, 31 Jan 2005 04:17:30 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 71so713162wra for ; Sun, 30 Jan 2005 20:16:30 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=p9pa17GNeZYPWgorzzzp+yGsPV0r/omKlbPVrtiLNHJrhOeKEPEDSQsFzmNKFtN/CnCYG0Er+InjEOmQoZ1+kUJE+/X5ClkrUlxj35+z9MmtbG1lW8jzd9gsLe3I0+aonS4EfrrOeVloPV7N8555aHWFn6OqxfK9mdZdtq7SUA0= Received: by 10.54.38.69 with SMTP id l69mr40076wrl; Sun, 30 Jan 2005 20:15:07 -0800 (PST) Received: by 10.54.18.59 with HTTP; Sun, 30 Jan 2005 20:15:07 -0800 (PST) Message-ID: <33c6269f0501302015490d9274@mail.gmail.com> Date: Sun, 30 Jan 2005 23:15:07 -0500 From: Alex Turner Reply-To: alex@neteconomist.com To: Merlin Moncure Subject: Re: PostgreSQL clustering VS MySQL clustering Cc: pgsql-performance@postgresql.org In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A75F5@Herge.rcsinc.local> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6EE64EF3AB31D5448D0007DD34EEB3412A75F5@Herge.rcsinc.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/627 X-Sequence-Number: 10317 fsync on. Alex Turner NetEconomist On Fri, 28 Jan 2005 11:19:44 -0500, Merlin Moncure wrote: > > With the right configuration you can get very serious throughput. The > > new system is processing over 2500 insert transactions per second. We > > don't need more RAM with this config. The disks are fast enough. > > 2500 transaction/second is pretty damn fast. > > fsync on/off? > > Merlin > >