Skip site navigation (1) Skip section navigation (2)

Re: Postgres Benchmark Results

From: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
To: PFC <lists(at)peufeu(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres Benchmark Results
Date: 2007-05-20 16:41:36
Message-ID: 46507A40.505@tweakers.net (view raw or flat)
Thread:
Lists: pgsql-performance
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
> 

In response to

Responses

pgsql-performance by date

Next:From: PFCDate: 2007-05-20 17:09:38
Subject: Re: Postgres Benchmark Results
Previous:From: PFCDate: 2007-05-20 14:58:45
Subject: Postgres Benchmark Results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group