I was watching a very large recursive CTE get built today and this CTE involves on the order of a dozen or so "loops" joining the initial table against existing tables. It struck me that - every time through the loop the tables were sorted and then joined and that it would be much more efficient if the tables remained in a sorted state and could avoid being re-sorted each time through the loop. Am I missing something here? I am using PG 8.4 if that matters.
-- Jon -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
