X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E1BE49FA65C for ; Wed, 21 Jun 2006 14:03:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 20096-07 for ; Wed, 21 Jun 2006 14:03:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 398D69F9CC1 for ; Wed, 21 Jun 2006 14:03:48 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 21 Jun 2006 17:03:41 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 21 Jun 2006 12:03:41 -0500 Subject: Re: Speeding up query, Joining 55mil and 43mil records. From: Scott Marlowe To: nicky Cc: pgsql-performance@postgresql.org In-Reply-To: <44994DE7.5070801@valuecare.nl> References: <44994DE7.5070801@valuecare.nl> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1150909421.26538.135.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 21 Jun 2006 12:03:41 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/409 X-Sequence-Number: 19766 On Wed, 2006-06-21 at 08:47, nicky wrote: > Hello People, SNIPPAGE > The query above takes around 42 minutes. > > However, i also have a wimpy desktop machine with 1gb ram. Windows > with MSSQL 2000 (default installation), same database structure, same > indexes, same query, etc and it takes 17 minutes. The big difference > makes me think that i've made an error with my PostgreSQL > configuration. I just can't seem to figure it out. What is the difference between the two plans (i.e. explain on both boxes and compare)