X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B44A9D975A for ; Mon, 26 Sep 2005 14:41:35 -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 50718-06 for ; Mon, 26 Sep 2005 17:41:27 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id B38AFD9716 for ; Mon, 26 Sep 2005 14:41:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8QHfCp8000644; Mon, 26 Sep 2005 13:41:12 -0400 (EDT) To: "Gurpreet Aulakh" Cc: pgsql-performance@postgresql.org Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin) In-reply-to: References: Comments: In-reply-to "Gurpreet Aulakh" message dated "Mon, 26 Sep 2005 10:10:56 -0700" Date: Mon, 26 Sep 2005 13:41:12 -0400 Message-ID: <643.1127756472@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/356 X-Sequence-Number: 14664 "Gurpreet Aulakh" writes: > While testing 8.1, I found that simple joins take longer in 8.1 than 8.0. > For example the sub query > SELECT doc.doc_documentid FROM document AS doc LEFT JOIN folder_document ON > doc.doc_documentid = folder_document.doc_documentId LEFT JOIN document as > root ON doc.doc_internalRootXref = root.doc_documentId > is actually slower on 8.1 than 8.0. With no more detail than that, this report is utterly unhelpful. Let's see the table schemas and the EXPLAIN ANALYZE results in both cases. regards, tom lane