pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: 'Andreas Pflug' <pgadmin@pse-consulting.de>
Cc: 'Dave Page' <dpage@vale-housing.co.uk>
Cc: pgsql-performance@postgresql.org, ac@wazagua.com, "Joshua D. Drake" <jd@commandprompt.com>
Cc: wheyliger@wazagua.com, "'Steve Hatt'" <shatt@wazagua.com>
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Date: Fri, 22 Apr 2005 14:30:54 -0400
Message-ID: <20050422183054.GB14419@dcc.uchile.cl> (raw)
In-Reply-To: <000401c54763$dd684620$797ba8c0@jfradkin>
References: <4268C833.8080302@pse-consulting.de>
	<000401c54763$dd684620$797ba8c0@jfradkin>

On Fri, Apr 22, 2005 at 01:51:08PM -0400, Joel Fradkin wrote:
> I just finished testing Postgres, MYSQL, and MSSQL on my machine (2 gigs
> internal XP).
> 
> I have adjusted the postgres config to what I think is an ok place and have
> mysql default and mssql default.
>
> Using Aqua studio a program that hooks to all three I have found:
> 
>       Initial exec  Second exec  Returning 331,640 records on all 3 database
> MSSQL    468ms          16ms              2 mins 3  secs
> MYSQL   14531ms       6625ms              2 mins 42 secs 
> Postgr  52120ms      11702ms              2 mins 15 secs

One further question is: is this really a meaningful test?  I mean, in
production are you going to query 300000 rows regularly?  And is the
system always going to be used by only one user?  I guess the question
is if this big select is representative of the load you expect in
production.

What happens if you execute the query more times?  Do the times stay the
same as the second run?

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Use it up, wear it out, make it do, or do without"



view thread (41+ messages)  latest in thread

Message-ID: <20050422183054.GB14419@dcc.uchile.cl>
Permalink:  ../20050422183054.GB14419@dcc.uchile.cl/
Also on:    postgresql.org/message-id/20050422183054.GB14419@dcc.uchile.cl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: alvherre@dcc.uchile.cl, jfradkin@wazagua.com, pgadmin@pse-consulting.de, dpage@vale-housing.co.uk, jd@commandprompt.com, shatt@wazagua.com
  Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
  In-Reply-To: <20050422183054.GB14419@dcc.uchile.cl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox