| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Joel Fradkin <jfradkin(at)wazagua(dot)com> |
| Cc: | "'Andreas Pflug'" <pgadmin(at)pse-consulting(dot)de>, "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-performance(at)postgresql(dot)org, ac(at)wazagua(dot)com, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, wheyliger(at)wazagua(dot)com, "'Steve Hatt'" <shatt(at)wazagua(dot)com> |
| Subject: | Re: Joel's Performance Issues WAS : Opteron vs Xeon |
| Date: | 2005-04-22 18:30:54 |
| Message-ID: | 20050422183054.GB14419@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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[(at)]dcc(dot)uchile(dot)cl>)
"Use it up, wear it out, make it do, or do without"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Ristola | 2005-04-22 18:39:12 | Re: Bad n_distinct estimation; hacks suggested? |
| Previous Message | Bruce Momjian | 2005-04-22 18:03:54 | Re: Joel's Performance Issues WAS : Opteron vs Xeon |