Thread

1. Re: benchmarking postgres

   Dann Corbit <dcorbit@connx.com> — 2002-02-13T07:09:01Z

   Why not attach a hundred users and run the same test.  MySQL will be
   licking *everyone's* boots.  Each and every program listed would
   positively slam them into the floor and grind their face in the dirt
   (unless they have made some monumental improvements recently).
   
   If a single user database is wanted, MySQL is just the ticket.  When it
   gets a bunch of users and has to do complex stuff, it goes into the
   toilet.
   
   As far as benchmarks go, TPC-C, TPC-H, TPC-W and TPC-R would be
   interesting.  Trying to beat a toy database under silly conditions is a
   waste of time.
   
   -----Original Message-----
   From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au]
   Sent: Tuesday, February 12, 2002 10:40 PM
   To: Hackers
   Subject: [HACKERS] benchmarking postgres
   
   
   Look at this: (top one)
   
   http://www.mysql.com/information/benchmarks.html
   
   Does anyone feel like running the MySQL benchmark against postgres 7.2
   to
   see if there's been a real speed improvement??
   
   Chris
   
   
   ---------------------------(end of broadcast)---------------------------
   TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
   
   

2. Re: benchmarking postgres

   bpalmer <bpalmer@crimelabs.net> — 2002-02-13T11:56:14Z

   On Tue, 12 Feb 2002, Dann Corbit wrote:
   
   > Why not attach a hundred users and run the same test.  MySQL will be
   > licking *everyone's* boots.  Each and every program listed would
   > positively slam them into the floor and grind their face in the dirt
   > (unless they have made some monumental improvements recently).
   >
   >> http://www.mysql.com/information/benchmarks.html
   >>
   >> Does anyone feel like running the MySQL benchmark against postgres 7.2
   >> to
   >> see if there's been a real speed improvement??
   
   Why don't we have some pretty graphs like that on the postgres site?  I
   agree that the mysql tests against single user are useless,  but users see
   the FUD of pretty pictures and are mislead.  If mysql is giving out
   information like that,  shouldn't we also have some pretty pictures?  If
   they exist,  i've never seen them on the main site.
   
   Thoughts..
   
   - Brandon
   
   
   ----------------------------------------------------------------------------
    c: 646-456-5455                                            h: 201-798-4983
    b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5