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: (view raw, whole thread or download thread mbox)
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:

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


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-2017 The PostgreSQL Global Development Group