From owner-freebsd-performance@FreeBSD.ORG Thu Jan 31 20:42:09 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3ED1F16A468 for ; Thu, 31 Jan 2008 20:42:09 +0000 (UTC) (envelope-from ndenev@gmail.com) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.190]) by mx1.freebsd.org (Postfix) with ESMTP id 15CD013C4F9 for ; Thu, 31 Jan 2008 20:42:08 +0000 (UTC) (envelope-from ndenev@gmail.com) Received: by rv-out-0910.google.com with SMTP id g13so697779rvb.43 for ; Thu, 31 Jan 2008 12:42:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; bh=bn1MGkRQqN//fO8GvLPaRy6uMPGGthZqh5xbl3q1wMs=; b=Mxvs/biBApLnSlPjtDbWQEMMIdhrfONVvNT7MzxvM+L/zwi69fksUMc8TecbcdaO/+X+o83aaki412V0Fia6h/EoeJqQsuTk1SC68JHMQOszPQoCpUJju2V6101RN5Ec7fxhzZHphWesRid/XkVjD3Dh9eeL29KI+rngFq+yS1Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=IG9QOmWFqc4ZwsTAcJ/Op5UD+XxLeWXVOMQz6EjbFLhXI/6deOAxw2EtVMWevc2u9N+k0KkNiE594phQVKa/c60bPvZVt73qAHk5a1X9ITTX3nPprZ1rDj/S8wmLs6hrL+nOXMWTe8V8xyIcUmOe23jmzIpNFMKWVcVeOa+wrAk= Received: by 10.140.207.3 with SMTP id e3mr1840129rvg.194.1201812126094; Thu, 31 Jan 2008 12:42:06 -0800 (PST) Received: by 10.141.170.18 with HTTP; Thu, 31 Jan 2008 12:42:06 -0800 (PST) Message-ID: <2e77fc10801311242n12c5b2bcseaa2b717f95c21b5@mail.gmail.com> Date: Thu, 31 Jan 2008 22:42:06 +0200 From: "Niki Denev" Sender: ndenev@gmail.com To: "Ivan Voras" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47A043FD.9090607@FreeBSD.org> <47A0CD11.802@FreeBSD.org> <9bbcef730801301157n25684018y3d43bfdd0301a8dd@mail.gmail.com> <2e77fc10801310826v2fabb5g594840241784fc7@mail.gmail.com> X-Google-Sender-Auth: 424608be102b7833 X-Mailman-Approved-At: Thu, 31 Jan 2008 21:31:07 +0000 Cc: freebsd-performance@freebsd.org Subject: Re: postgresql-performance using sysbench X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 31 Jan 2008 20:42:09 -0000 On Jan 31, 2008 10:16 PM, Ivan Voras wrote: > Niki Denev wrote: > > > HZ=1000 > > Time: > > 239 seconds total > > 122 seconds of transactions (4 per second) > > > What do you think? > > This is a very low result :) I don't know your machine or the parameters > you used with postmark but even FreeBSD on two striped 7.5 kRPM drives > can achieve ~~ 110 tps (so ~~ 50 for a single drive). In the same > circumstances and with the right file system - reiserfs in this case - > Linux can achieve close to 900 tps (170 tps with ext3). This is the kind > of difference I am talking about. A change of 4 tps to 6 tps is not > generally useful. > > What settings are you using for postmark? I ran postmark with default settings, and only changed "size" to "4096 4096000", so it could create files varying in size from 4K to 3.9M The machine is dualcore core2duo and has two 10Krpm scsi disks in geom_mirror and geom_journal on top of them. I guess that this may be because of geom_journal performance penalty, having to write everything two times. Ubench too shows no significant difference, although its not using disk subsystem at all. HZ=250 Ubench CPU: 322604 Ubench MEM: 152835 -------------------- Ubench AVG: 237719 HZ=1000 Ubench CPU: 321800 Ubench MEM: 152807 -------------------- Ubench AVG: 237303 Maybe i'll try also "bonnie++"