"Gurpreet Aulakh" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly