X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9AEBBD1CAE1 for ; Tue, 3 Feb 2004 15:51:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81260-07 for ; Tue, 3 Feb 2004 11:51:02 -0400 (AST) Received: from jefftrout.com (h00a0cc4084e5.ne.client2.attbi.com [24.128.241.68]) by svr1.postgresql.org (Postfix) with SMTP id D15B6D1C7F7 for ; Tue, 3 Feb 2004 11:50:58 -0400 (AST) Received: (qmail 33725 invoked from network); 3 Feb 2004 15:51:07 -0000 Received: from localhost (HELO squeegit) (threshar@127.0.0.1) by localhost with SMTP; 3 Feb 2004 15:51:07 -0000 Date: Tue, 3 Feb 2004 10:53:49 -0500 From: Jeff To: "Rigmor Ukuhe" Cc: josh@agliodbs.com, pgsql-advocacy@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Message-Id: <20040203105349.2f700477.threshar@torgo.978.org> In-Reply-To: References: <20040203085203.5c5f926c.threshar@torgo.978.org> X-Mailer: Sylpheed version 0.9.9 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/16 X-Sequence-Number: 3587 On Tue, 3 Feb 2004 16:02:00 +0200 "Rigmor Ukuhe" wrote: > > script [I also decided to use this perl script for testing PG to be > > fair]. > > > > For one client mysql simply screamed. > > > > If already have test case set up, you could inform us, from where > Postgres starts to beat MySql. Because if with 5 clients it still > "screams" then i would give it a try in case of that kind of > requirements. > I just checked (to see about restarting the innodb test) and it appears that it'll take a bit of work to get the machine up and running. I don't have time right now to do further testing. However, you could try it out. Not sure at what point it will topple, in my case it didn't matter if it ran good with 5 clients as I'll always have many more clients than 5. -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/