From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gurpreet Aulakh <gaulakh@ecmarket.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)
Date: Mon, 26 Sep 2005 13:41:12 -0400
Message-ID: <643.1127756472@sss.pgh.pa.us> (raw)
In-Reply-To: <IGEGINLEEDLANNHAAKCMKEDJCCAA.gaulakh@ecmarket.com>
References: <IGEGINLEEDLANNHAAKCMKEDJCCAA.gaulakh@ecmarket.com>
"Gurpreet Aulakh" <gaulakh@ecmarket.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, gaulakh@ecmarket.com
Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)
In-Reply-To: <643.1127756472@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox