Re: Performance tuning on FreeBSD

From: Ivan Voras <ivoras(at)geri(dot)cc(dot)fer(dot)hr>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance tuning on FreeBSD
Date: 2008-03-04 10:54:25
Message-ID: fqj9i1$ipv$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-04 11:57:40 Re: Performance problems deleting data
Previous Message Ivan Voras 2008-03-04 10:45:52 Re: How to allocate 8 disks