On Mon, Jun 09, 2008 at 04:41:16PM +0200, Tom Lane wrote:
> 8.0 is incapable of reordering outer joins, which is likely the cause of
> your problem.
Thank you, will try.
Bohdan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
Bohdan Linda <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-
Hello,
I have noted one very strange thing which I would like to discuss with
you. I have noted that outer joins on nested views takes heavily longer
than the inner ones. Example:
REATE VIEW ports_view AS
SELECT
ports.pid,
nodes.nname
FROM
ports JOIN nodes ON nodes.nid = ports.pnod
