
Have any organizations run TPC benchmarks against PostgreSQL other than
the old and much maligned GreatBridge benchmark? It is unfortunate that
there are not any moderately standard benchmarks available regarding
PostgreSQL. I do not need to say "PgSQL is better than X", but it would
be nice to at least say "it has been tested at load level X and works
fine". Failing that, all we have is anecdotes and conjecture. :/

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey@refractions.net
     | Phone: (250) 885-0632
     \_

Mon, 29 Jul 2002 13:36:14 -0700
Paul Ramsey <pramsey@refractions.net>
TPC-* Benchmarks
Hi Paul,

You might want to take at look at the Open Source Database Benchmark
project:

http://www.sf.net/projects/osdb

This is an implementation (by Andy Riebs from Compaq) of the AS3AP
database benchmark, and works with PostgreSQL, MySQL, and one other
database too from memory.  You're probably best off to get the latest
version from CVS as there have been a few good enhancements since the
latest code snapshot.

If you need any further help, please let me know.  There is a PostgreSQL
Advocacy and Marketing site which will come online over time
(http://advocacy.postgresql.org), and if you have suggestions regarding
the publishing of benchmarks, this is probably the place they will be
implemented.

Hope this helps.

:-)

Regards and best wishes,

Justin Clift


Paul Ramsey wrote:
> 
> Have any organizations run TPC benchmarks against PostgreSQL other than
> the old and much maligned GreatBridge benchmark? It is unfortunate that
> there are not any moderately standard benchmarks available regarding
> PostgreSQL. I do not need to say "PgSQL is better than X", but it would
> be nice to at least say "it has been tested at load level X and works
> fine". Failing that, all we have is anecdotes and conjecture. :/
> 
> --
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey@refractions.net
>      | Phone: (250) 885-0632
>      \_
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

Tue, 30 Jul 2002 07:14:48 +1000
Justin Clift <justin@postgresql.org>
Re: TPC-* Benchmarks
Try here:

http://osdb.sourceforge.net/

Chris


> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Paul Ramsey
> Sent: Tuesday, 30 July 2002 4:36 AM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] TPC-* Benchmarks
> 
> 
> 
> Have any organizations run TPC benchmarks against PostgreSQL other than
> the old and much maligned GreatBridge benchmark? It is unfortunate that
> there are not any moderately standard benchmarks available regarding
> PostgreSQL. I do not need to say "PgSQL is better than X", but it would
> be nice to at least say "it has been tested at load level X and works
> fine". Failing that, all we have is anecdotes and conjecture. :/
> 
> -- 
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey@refractions.net
>      | Phone: (250) 885-0632
>      \_
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 


Tue, 30 Jul 2002 09:47:19 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: TPC-* Benchmarks