Re: Postgres Benchmark Results

I assume red is PostgreSQL and green is MySQL. That reflects my own
benchmarks with those two.

But I don't fully understand what the graph displays. Does it reflect
the ability of the underlying database to support a certain amount of
users per second given a certain database size? Or is the growth of the
database part of the benchmark?

Btw, did you consider that older topics are normally read much less and
almost never get new postings? I think the size of the "active data set"
is more dependent on the amount of active members than on the actual
amount of data available.
That can reduce the impact of the size of the database greatly, although
we saw very nice gains in performance on our forum (over 22GB of
messages) when replacing the databaseserver with one with twice the
memory, cpu's and I/O.

Best regards,

Arjen

On 20-5-2007 16:58 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
>
> One of those curves is "a very popular open-source database which
> claims to offer unparallelled speed".
> The other one is of course Postgres 8.2.3 which by popular belief is
> "full-featured but slow"
>
> What is your guess ?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>