Re: Performance tuning on FreeBSD - Mailing list pgsql-performance

From Ivan Voras
Subject Re: Performance tuning on FreeBSD
Date
Msg-id fqj9i1$ipv$1@ger.gmane.org
Whole thread Raw
In response to Re: Performance tuning on FreeBSD  ("alan bryan" <alan.bryan@gmail.com>)
List pgsql-performance
alan bryan wrote:

> 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?

Generally, you should set the "size" parameter to be twice the RAM
you've got (or use bonnie++ which will auto-size it), but anyway,
something is definitely wrong with your drives, controller or the
driver. Switching schedulers won't help you, and trying different
releases will only help you if the problem is in the driver. Try asking
on the freebsd-performance @ freebsd.org list.

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: How to allocate 8 disks
Next
From: Alvaro Herrera
Date:
Subject: Re: Performance problems deleting data