pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: alan bryan <alan.bryan@gmail.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance tuning on FreeBSD
Date: Tue, 4 Mar 2008 01:15:53 -0800
Message-ID: <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0803032005020.23114@westnet.com>
References: <892916310803031539scffd5bchcce5a848b3a57a32@mail.gmail.com>
	<Pine.GSO.4.64.0803032005020.23114@westnet.com>

On Mon, Mar 3, 2008 at 5:11 PM, Greg Smith <gsmith@gregsmith.com> wrote:
> On Mon, 3 Mar 2008, alan bryan wrote:
>
>  >> pgbench -c 100 -t 1000 testdb
>
> > tps = 558.013714 (excluding connections establishing)
>  >
>  > Just for testing, I tried turning off fsync and got:
>
> > tps = 4061.662041 (excluding connections establishing)
>
>  This is odd.  ~500 is what I expect from this test when there is no write
>  cache to accelerate fsync, while ~4000 is normal for your class of
>  hardware when you have such a cache.  Since you say your 3Ware card is
>  setup with a cache and a BBU, that's suspicious--you should be able to get
>  around 4000 with fsync on.  Any chance you have the card set to
>  write-through instead of write-back?  That's the only thing that comes to
>  mind that would cause this.
>
>  --
>  * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
>


According to 3dm2 the cache is on.  I even tried setting The StorSave
preference to "Performance" with no real benefit.  There seems to be
something really wrong with disk performance.  Here's the results from
bonnie:

File './Bonnie.2551', size: 104857600
Writing with putc()...done
Rewriting...done
Writing intelligently...done
Reading with getc()...done
Reading intelligently...done
Seeker 1...Seeker 2...Seeker 3...start 'em...done...done...done...
             -------Sequential Output-------- ---Sequential Input-- --Random--
             -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks---
Machine    MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU  /sec %CPU
         100  9989  4.8  6739  1.0 18900  7.8 225973 98.5 1914662
99.9 177210.7 259.7

This is on FreeBSD 7.0-Release.  I tried ULE and 4BSD schedulers with
no difference.  Maybe I'll try FreeBSD 6.3 to see what that does?



view thread (10+ messages)  latest in thread

Message-ID: <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com>
Permalink:  ../892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com/
Also on:    postgresql.org/message-id/892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: alan.bryan@gmail.com, gsmith@gregsmith.com
  Subject: Re: Performance tuning on FreeBSD
  In-Reply-To: <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com>
  References: <892916310803031539scffd5bchcce5a848b3a57a32@mail.gmail.com> <Pine.GSO.4.64.0803032005020.23114@westnet.com> <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox