Li Jin <l...@tripadvisor.com> writes:
> Anyone knows why the planner is doing this?

WITH is an optimization fence.  This is intentional and documented.

                        regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to