Search Postgresql Archives

Re: nested view with outer joins - best practices

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Bohdan Linda <bohdan.linda@xxxxxxxxx>
Subject: Re: nested view with outer joins - best practices
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 09 Jun 2008 10:41:16 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Bohdan Linda <bohdan.linda@xxxxxxxxx> message dated "Mon, 09 Jun 2008 15:28:25 +0200"
In-reply-to: <20080609132825.GA19970@xxxxxxxxxxxxxxxxxxx>

Bohdan Linda <bohdan.linda@xxxxxxxxx> writes:
> 2) Will my plan get better with new version of pgsql ( currently its 8.0.x )

8.0 is incapable of reordering outer joins, which is likely the cause of
your problem.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: nested view with outer joins - best practices
  - From: Bohdan Linda

References:
- nested view with outer joins - best practices
  - From: Bohdan Linda

Prev by Date: Re: IN vs EXISTS
Next by Date: "connect by"
Previous by thread: nested view with outer joins - best practices
Next by thread: Re: nested view with outer joins - best practices
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux