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 75655D1B926 for ; Thu, 21 Aug 2003 15:17:39 -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 01367-04 for ; Thu, 21 Aug 2003 15:17:09 -0300 (ADT) Received: from mta8.adelphia.net (mta8.adelphia.net [68.168.78.196]) by svr1.postgresql.org (Postfix) with ESMTP id A3850D1B8B6 for ; Thu, 21 Aug 2003 15:17:07 -0300 (ADT) Received: from potentialtech.com ([24.53.179.151]) by mta8.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030821181701.QYKZ1354.mta8.adelphia.net@potentialtech.com>; Thu, 21 Aug 2003 14:17:01 -0400 Message-ID: <3F450C9B.6000201@potentialtech.com> Date: Thu, 21 Aug 2003 14:16:59 -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=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/308 X-Sequence-Number: 3124 Tomka Gergely wrote: > 2003-08-21 ragyogó napján Bill Moran ezt üzente: > > >>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. > > Shame? I smell here a harcore BSD fighter :) Well, I suppose ... > Maybe sometime he run > tests on *SD, but now we need linux data. "He" has had it on his list of things to do for months. And if I ever get enough free moments, I will test *both* BSD and Linux, because I'm terribly biased towards BSD because that's all I use. In addition to being interested in how FreeBSD's ufs+softupdates compares to the variety of Linux journalling filesystems, I'm also interested to compare FreeBSD's performance on ext2fs and FAT to Linux's peformance on those same filesystems. It's a "shame" because I simply haven't found the time yet. -- Bill Moran Potential Technologies http://www.potentialtech.com