X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 56801D1B4E3 for ; Fri, 3 Oct 2003 06:01:57 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 63077-09 for ; Fri, 3 Oct 2003 03:01:11 -0300 (ADT) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by svr1.postgresql.org (Postfix) with ESMTP id 1ED00D1B51A for ; Fri, 3 Oct 2003 03:01:10 -0300 (ADT) Received: from klaster.net (core-1.citynet.pl [80.48.135.69]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 21C922B3CC; Fri, 3 Oct 2003 08:00:32 +0200 (CEST) Message-ID: <3F7D103D.3070801@klaster.net> Date: Fri, 03 Oct 2003 07:59:25 +0200 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.5) Gecko/20030916 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: CN Cc: pgsql-performance@postgresql.org Subject: Re: Is This My Speed Limit? References: <20031003021407.6DC2F63D07@smtp.us2.messagingengine.com> In-Reply-To: <20031003021407.6DC2F63D07@smtp.us2.messagingengine.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=IN_REP_TO, QUOTED_EMAIL_TEXT, RCVD_IN_OSIRUSOFT_COM, REFERENCES, REPLY_WITH_QUOTES, USER_AGENT_MOZILLA_UA X-Spam-Level: X-Archive-Number: 200310/77 X-Sequence-Number: 3825 > Hi! > > It's just my curiosity. I wonder if there is any way to break my speed > limit on AMD 450Mhz: > Hash Join (cost=189.79..1508.67 rows=11203 width=48) (actual > time=129.20..1780.53 rows=9912 loops=1) > Hash Join (cost=208.74..1751.68 rows=11203 width=58) (actual > time=135.87..1113.69 rows=9912 loops=1) Well, it looks like a speed limit. I wouldn't expect better speed for queries returning 10000 rows. Regards, Tomasz Myrta