Обсуждение: Perfomance test figures

On Mon, Mar 20, 2006 at 09:59:54PM -0800, Amit Soni wrote:
> Hi All,
>
>   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 possible pls. share procedure also, that how you
havedone the same? 

Sadly, there's very little in the way of meaningful benchmarks,
especially ones that aren't ancient. A SQLite user recently did some
testing, but his workload was a single-user case, something that SQLite
is ideally suited for (and not very interesting for anything in the
enterprise world).

I've been wanting to do a PostgreSQL vs MySQL head-to-head using DBT2
for some time. I even have hardware to do it on. What I haven't been
able to find is the time. If this is something you'd be interested in
helping with, please let me know. Depending on how much work you wanted
to do there could be money in it as well (Pervasive would pay for a
performance comparison whitepaper).
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

On 3/21/06, Amit Soni <amit@datumglobal.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