Re: Postgres Benchmark Results - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Postgres Benchmark Results
Date
Msg-id 20070521210522.GN62346@nasby.net
Whole thread Raw
In response to Postgres Benchmark Results  (PFC <lists@peufeu.com>)
Responses Re: Postgres Benchmark Results
List pgsql-performance
On Sun, May 20, 2007 at 04:58:45PM +0200, PFC wrote:
>
>     I felt the world needed a new benchmark ;)
>     So : Forum style benchmark with simulation of many users posting and
> viewing forums and topics on a PHP website.
>
>     http://home.peufeu.com/ftsbench/forum1.png

Any chance of publishing your benchmark code so others can do testing?
It sounds like a useful, well-thought-out benchmark (even if it is
rather specialized).

Also, I think it's important for you to track how long it takes to
respond to requests, both average and maximum. In a web application no
one's going to care if you're doing 1000TPS if it means that every time
you click on something it takes 15 seconds to get the next page back.
With network round-trip times and what-not considered I'd say you don't
want it to take any more than 200-500ms between when a request hits a
webserver and when the last bit of data has gone back to the client.

I'm guessing that there's about 600MB of memory available for disk
caching? (Well, 600MB minus whatever shared_buffers is set to).
--
Jim Nasby                                      decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Postgres Benchmark Results
Next
From: Vivek Khera
Date:
Subject: Re: 121+ million record table perf problems