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

Re: Outer joins and Seq scans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sami Dalouche <skoobi(at)free(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Outer joins and Seq scans
Date: 2007-10-28 23:45:14
Message-ID: 10339.1193615114@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Sami Dalouche <skoobi(at)free(dot)fr> writes:
> So, the version of postgres I use is :
> samokk(at)samlaptop:~/Desktop $ dpkg -l | grep postgres
> ii  postgresql-8.2                             8.2.5-1.1

OK.  I think you have run afoul of a bug that was introduced in 8.2.5
that causes it not to realize that it can interchange the ordering of
certain outer joins.  Is there any chance you can apply the one-line
patch shown here:
http://archives.postgresql.org/pgsql-committers/2007-10/msg00374.php

If rebuilding packages is not to your taste, possibly a down-rev to
8.2.4 would be the easiest solution.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Dimitri FontaineDate: 2007-10-29 09:48:14
Subject: Re: Outer joins and Seq scans
Previous:From: Sami DaloucheDate: 2007-10-28 22:55:46
Subject: Re: Outer joins and Seq scans

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