From owner-freebsd-performance@FreeBSD.ORG Thu Jan 31 22:03:16 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 6BE3016A417 for ; Thu, 31 Jan 2008 22:03:16 +0000 (UTC) (envelope-from ivoras@gmail.com) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.181]) by mx1.freebsd.org (Postfix) with ESMTP id 32EBA13C45A for ; Thu, 31 Jan 2008 22:03:16 +0000 (UTC) (envelope-from ivoras@gmail.com) Received: by py-out-1112.google.com with SMTP id u52so1200882pyb.10 for ; Thu, 31 Jan 2008 14:03:15 -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=TixOIHh6ND+J7JNlVyrbFJbN0HsXzLNDdVq2w3Lam3k=; b=qNN4VkfvNW0iMxiAMzZtZOgCoR48OZZWSdwiIbyThvIYdfI+6r0F6H3HP43HjHoS+YTYOSl92u2wgd9N3/Qll/oh7OKV1R1yZ7S1NCLH1p9TmL0aZ34n/TqB1vJHOHGlyv74Sb1L3G6WlpBBZHmAb7PXhoTr6VeFK0bWqaiiWrI= 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=q+HnN1n7yK2SfBuIuss9+gF1E4MZcd7hLG/Di3GL+iQoz3gyMU71fAo+h09O/WMjxzSM6FJopsvBBNm0whW4TTMS0DcqyOCHLy3Q3s5L5l9ncLxLPzvByC8BC181yjXHgNyu8HRxGifU9e+kSdz42LcFTsS4RoJyqMNukXRbVZg= Received: by 10.140.163.3 with SMTP id l3mr1924266rve.22.1201816994495; Thu, 31 Jan 2008 14:03:14 -0800 (PST) Received: by 10.141.63.14 with HTTP; Thu, 31 Jan 2008 14:03:14 -0800 (PST) Message-ID: <9bbcef730801311403r45c54036v36b97450d0c37a65@mail.gmail.com> Date: Thu, 31 Jan 2008 23:03:14 +0100 From: "Ivan Voras" Sender: ivoras@gmail.com To: "Niki Denev" In-Reply-To: <2e77fc10801311242n12c5b2bcseaa2b717f95c21b5@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47A043FD.9090607@FreeBSD.org> <47A0CD11.802@FreeBSD.org> <9bbcef730801301157n25684018y3d43bfdd0301a8dd@mail.gmail.com> <2e77fc10801310826v2fabb5g594840241784fc7@mail.gmail.com> <2e77fc10801311242n12c5b2bcseaa2b717f95c21b5@mail.gmail.com> X-Google-Sender-Auth: 69e8ff22a18fee38 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 22:03:16 -0000 On 31/01/2008, Niki Denev wrote: > 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 Ok, under these circumstances+gjournal it's maybe possible to get numbers that low. I am testing operations on small files so my whole configuration is: set size 4096 65536 set read 8192 set write 8192 set number 10000 set transactions 40000 set subdirectories 1000