Re: Performance tuning on FreeBSD

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Ivan Voras <ivoras(at)geri(dot)cc(dot)fer(dot)hr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance tuning on FreeBSD
Date: 2008-03-04 16:25:25
Message-ID: Pine.GSO.4.64.0803041118150.8745@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 4 Mar 2008, Ivan Voras wrote:

> I'm curious about the math behind this - is ~4000 burst or sustained
> rate?

Average, which is not quite burst or sustained. No math behind it, just
looking at a few samples of pgbench data on similar hardware. A system
like this one is profiled at
http://www.kaltenbrunner.cc/blog/index.php?/archives/21-8.3-vs.-8.2-a-simple-benchmark.html
for example.

> For common BBU cache sizes (256M, 512M), filling that amount with data
> is pretty trivial.

I don't have any good numbers handy but I think the burst is >6000, you
only get that for a few seconds before all the caches fill and the rate
drops considerably.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-03-04 17:19:17 Re: Ramifications of turning off Nested Loops for slow queries
Previous Message Kevin Grittner 2008-03-04 16:18:43 Re: Ramifications of turning off Nested Loops for slow queries