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

Re: Perfomance test figures

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Amit Soni" <amit(at)datumglobal(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Perfomance test figures
Date: 2006-03-21 14:03:20
Message-ID: b42b73150603210603jb8fd04dme992b65cb0854cac@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 3/21/06, Amit Soni <amit(at)datumglobal(dot)com> wrote:
> I want to compare performance of postgresql database with some other
> database.
>
> Somebody must have done some performance testing.
>
> Can you pls. share that data (performance figures) with me? And if possibleu
> pls. share procedure also, that how you have done the same?

Unfortunately, most database tests are synthetic and not very helpful.
 Compounding the problem is that the 'best' way to use the database
differs between platforms (case in point: with postgresql you want to
use stored procedures for simple qeries, and with mysql you don't want
to use them).

There are a couple of public benchmarks out there...you could try
hitting one of them.  But this is no substitute for developing
simulations of your workload and doing your own in-house benchmarks.

is there a particular reason for wanting to compare various sql databases?

merlin

In response to

pgsql-performance by date

Next:From: Markus BertheauDate: 2006-03-21 14:10:56
Subject: Re: Postmaster using only 4-5% CPU
Previous:From: Guillaume CottenceauDate: 2006-03-21 13:30:22
Subject: Re: planner with index scan cost way off actual cost, advices to tweak cost constants?

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