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:
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 =
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