X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0347DD1D2AA for ; Wed, 21 Apr 2004 10:31:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57905-09 for ; Wed, 21 Apr 2004 10:31:05 -0300 (ADT) Received: from smtp.casablanca.sk (smtp.casablanca.sk [81.0.239.6]) by svr1.postgresql.org (Postfix) with ESMTP id 766B4D1D26C for ; Wed, 21 Apr 2004 10:31:00 -0300 (ADT) Received: from omikron.sk (cepr.nustep.sk [81.0.222.49]) by smtp.casablanca.sk (8.12.9/8.12.9) with SMTP id i3LDXBI3028005 for ; Wed, 21 Apr 2004 15:33:11 +0200 Received: (qmail 11404 invoked from network); 21 Apr 2004 13:31:02 -0000 Received: from unknown (HELO stratos) (158.195.31.19) by 0 with SMTP; 21 Apr 2004 13:31:02 -0000 Message-ID: <037701c427a4$e41a38a0$0200a8c0@stratos> From: "Cestmir Hybl" To: "Paul Thomas" , "Nick Barr" Cc: References: <4086316B.4050304@chuckie.co.uk> <20040421135521.A23015@bacon> Subject: Re: MySQL vs PG TPC-H benchmarks Date: Wed, 21 Apr 2004 15:31:02 +0200 Organization: NUSTEP s.r.o. MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/347 X-Sequence-Number: 6647 > Looks like he's using the default postgresql.conf settings in which case > I'm not suprised at pg looking so slow. The question also is, IMHO, why the hell, postgreSQL still comes out of the box with so stupid configuration defaults, totally underestimated for todays average hardware configuration (1+GHz, 0.5+GB RAM, fast FSB, fast HDD). It seems to me better strategy to force that 1% of users to "downgrade" cfg. than vice-versa. regards ch