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