"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