Skip site navigation (1) Skip section navigation (2)

Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gurpreet Aulakh" <gaulakh(at)ecmarket(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)
Date: 2005-09-26 17:41:12
Message-ID: 643.1127756472@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Gurpreet Aulakh" <gaulakh(at)ecmarket(dot)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

In response to

pgsql-performance by date

Next:From: Ron PeacetreeDate: 2005-09-26 17:47:24
Subject: [PERFORM] A Better External Sort?
Previous:From: Gurpreet AulakhDate: 2005-09-26 17:10:56
Subject: Re: Query slower on 8.0.3 (Windows) vs 7.3 (cygwin)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group