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 843C1D1B8BD for ; Tue, 26 Aug 2003 16:38:04 -0300 (ADT) 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 13415-09 for ; Tue, 26 Aug 2003 16:37:31 -0300 (ADT) Received: from home.samurai.com (home.samurai.com [205.207.28.66]) by svr1.postgresql.org (Postfix) with ESMTP id 08628D1B8AD for ; Tue, 26 Aug 2003 16:37:29 -0300 (ADT) Received: by home.samurai.com (Postfix, from userid 1014) id 964B42622B; Tue, 26 Aug 2003 15:37:29 -0400 (EDT) Date: Tue, 26 Aug 2003 15:37:29 -0400 From: Neil Conway To: Jeff Cc: Darcy Buskermolen , "pgsql-performance@postgresql.org" Subject: Re: Sun vs a P2. Interesting results. Message-ID: <20030826193729.GG64198@home.samurai.com> References: <200308261201.55733.darcy@wavefire.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/345 X-Sequence-Number: 3161 On Tue, Aug 26, 2003 at 03:05:12PM -0400, Jeff wrote: > On Tue, 26 Aug 2003, Darcy Buskermolen wrote: > > I'm still seeing differences in the planner estimates, have you run a VACUUM > > ANALYZE prior to running these tests? > > > I did. I shall retry that.. but the numbers (the cost estimates) are > pretty close on both. the actual times are very different. I don't see why you need to bother, the query plans & cost estimates are similar enough I doubt that's the problem. > As I said in my first email IO isn't the problem here - the data set is > small enough that it is all cached (~10MB). iostat reports 0 activity on > the disks on both the sun and p2. Would it be possible to get a profile (e.g. gprof output) for a postgres backend executing the query on the Sun machine? -Neil