Re: Postgres vr.s Oracle

Jonah H. Harris wrote:
> On Sun, Dec 14, 2008 at 8:38 PM, justin <justin@emproshunts.com> wrote:
>
>> Here is the current  TPC-E [H, C] top 10
>> where is oracle???
>>
>
> Where you should be looking is at the price/performance benchmarks,
> because that's where Postgres plays.  Last time I checked Postgres on
> a TPC-C, albeit being 100% free, was anywhere from $4.00 to $6.00 per
> transaction depending on the hardware.  Compare that to Oracle's $0.68
> or SQL Server's $0.84.
Where are you getting the $4 and $6 per transaction for PostgreSql.  i
just search through this list
http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=dbms
it does not contain PostgreSql entry.
all of the less than $1.00 per transaction  are last the few years.

Oracle only just in the last year dropped to below $1.00 it mixed bag
from $3 to $52 (back on 2001)
> Yeah, I expect the normal it's just an
> industry benchmark, it's not fair, it's not representative of real
> workloads or real performance response.
>
First Step in testing and comparing is agree on a Standard that everyone
can agree to.  Second step test the system without cheating which
numerous software including Oracle, MS, and IBM have.
> Or, just for the fun of it, run Postgres on the 100GB TPC-H and let me
> know what you get for price/performance... then compare that to SQL
> Server's result from 2006.
>
>