X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CB6A8D1B99D for ; Thu, 21 Aug 2003 13:28:46 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 67430-03 for ; Thu, 21 Aug 2003 13:28:16 -0300 (ADT) Received: from mta7.adelphia.net (mta7.adelphia.net [68.168.78.193]) by svr1.postgresql.org (Postfix) with ESMTP id 7B2C6D1B94A for ; Thu, 21 Aug 2003 13:27:57 -0300 (ADT) Received: from potentialtech.com ([24.53.179.151]) by mta7.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030821162743.KFOO1349.mta7.adelphia.net@potentialtech.com>; Thu, 21 Aug 2003 12:27:43 -0400 Message-ID: <3F44F2FD.3080903@potentialtech.com> Date: Thu, 21 Aug 2003 12:27:41 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tomka Gergely Cc: pgsql-performance@postgresql.org Subject: Re: Tests References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/305 X-Sequence-Number: 3121 Tomka Gergely wrote: > http://195.199.65.92/~horvaths/pgperformance.html > > One of my friend do these tests. We think about the best filesystem for > the Linux/Postgres systems. > > The four test was: > > teszt1 - 10.000 inserts > teszt2 - 10.inserts, 10 in one trans. > teszt3 - 14.000.000 inserts, 1.000 in one trans. > teszt4 - "Select count(*)" on the big table. > > What test are interesting? Plese give us tips and ideas. The guy has time > for other test. It's a shame you didn't test ufs+softupdates. I'd be curious to see how it stacked up against the others. -- Bill Moran Potential Technologies http://www.potentialtech.com