Dave Cramer <pg@xxxxxxxxxxxxx> writes: > This query is a couple orders of magnitude slower the first result is > 9.2.1, the second 9.1 Hm, the planner's evidently doing the wrong thing inside the recursive union, but not obvious why. Can you extract a self-contained test case? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance