X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 950B053233 for ; Fri, 22 Apr 2005 15:31:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22399-03 for ; Fri, 22 Apr 2005 18:30:57 +0000 (GMT) Received: from sunsite.dcc.uchile.cl (sunsite.dcc.uchile.cl [192.80.24.2]) by svr1.postgresql.org (Postfix) with ESMTP id C44A25323A for ; Fri, 22 Apr 2005 15:30:55 -0300 (ADT) Received: from anakena.dcc.uchile.cl (anakena [192.80.24.6]) by sunsite.dcc.uchile.cl (8.12.11/8.12.11) with ESMTP id j3MIUsi3006849; Fri, 22 Apr 2005 14:30:54 -0400 (CLT) Received: by anakena.dcc.uchile.cl (Postfix, from userid 4151) id 1D70C530AC; Fri, 22 Apr 2005 14:30:54 -0400 (CLT) Date: Fri, 22 Apr 2005 14:30:54 -0400 From: Alvaro Herrera To: Joel Fradkin Cc: "'Andreas Pflug'" , "'Dave Page'" , pgsql-performance@postgresql.org, ac@wazagua.com, "Joshua D. Drake" , wheyliger@wazagua.com, "'Steve Hatt'" Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon Message-ID: <20050422183054.GB14419@dcc.uchile.cl> References: <4268C833.8080302@pse-consulting.de> <000401c54763$dd684620$797ba8c0@jfradkin> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <000401c54763$dd684620$797ba8c0@jfradkin> User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.341 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200504/620 X-Sequence-Number: 12017 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 () "Use it up, wear it out, make it do, or do without"