Search Postgresql Archives

Re: Favorite Tom Lane quotes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 2008-12-01 at 22:51 -0500, justin wrote:

> On idiotic benchmark comparisons "Try to carry 500 people from Los
> Angeles to Tokyo in an F-15. No? Try to win a dogfight in a 747. No?
> But they both fly, so it must be useful to compare them... especially
> on the basis of the most simplistic test case you can think of. For
> extra points, use *only one* test case. Perhaps this paper can be
> described as "comparing an F-15 to a 747 on the basis of required
> runway length

We used that analogy for comparing database benchmarks as far back as
1989-90 at Teradata. My memory is it was invented to counter claims that
DB2 "was faster" after some disastrous initial benchmark results while
attempting a straight database migration. The contrast was that the
client/server overhead of each request *was* higher, though the parallel
database could perform actions much faster when it eventually got
started. The original analogy was a comparison of the passenger carrying
capacity, since a jet fighter could only carry ~1 person while the
airliner could carry 100s, yet the jet fighter could obviously deliver 1
person much faster to a destination. (At the time, the concept of
client/server was widely laughed at). Joke -> Threat -> Obvious.

That thought led to the development at BA of a system specifically
designed to offload large SQL queries from the mainframe DB2 system. BA
knew how to judge database systems and use them for what they were good
at. (They continued to use TPF also, because of its speed of hash index
implementation, amongst other optimisations).

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux