Re: [mail] Re: Windows Build System

From: Justin Clift <justin(at)postgresql(dot)org>
To: James Hubbard <jhubbard(at)mcs(dot)uvawise(dot)edu>
Cc: Vince Vielhaber <vev(at)michvhf(dot)com>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, Katie Ward <kward(at)peerdirect(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Curtis Faith <curtis(at)galtcapital(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [mail] Re: Windows Build System
Date: 2003-01-29 18:14:33
Message-ID: 3E381A09.3040306@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

James Hubbard wrote:
<snip>
> I open my mouth and insert foot: Where do I get any of these scientific
> tests to determine if the latest and greatest 7.3.x will not fall down
> on my favorite Unix?

For Open Source benchmarks, there is:

Open Source Database Benchmark:
http://osdb.sf.net

With this, you *want* to use the latest CVS version, as that can
generate it's own datasets of any size. The older, released versions
couldn't and you had to download databases of limited size.

Database Opensource Test Suite:
http://ltp.sourceforge.net/dotshowto.php

This works with DB2, Oracle, Sybase, MySQL, and PostgreSQL, and looks to
have been developed by IBM. Haven't yet used this, but did notice that
the configuration instructions make no reference to upping the memory
buffers. i.e. all of the tests they've done were probably with the
defaults (yuck!)

Emailed this group yesterday asking if they're open to suggestions for
improvement, and they said they definitely are. If anyone has specific
they'd like to let them know, they do seem open to it.

A commercial solution that people often mention is Benchmark Factory:

http://www.benchmarkfactory.com

Haven't personally used it, although it's apparently the software that
Great Bridge used for all of their testing.

Hope this helps.

Regards and best wishes,

Justin Clift

> James Hubbard

--
"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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message James Hubbard 2003-01-29 18:53:53 Re: [mail] Re: Windows Build System
Previous Message Vince Vielhaber 2003-01-29 18:04:11 Re: [mail] Re: Windows Build System