Re: Re: [COMMITTERS] pgsql: Rewrite GEQO's gimme_tree function so that it always finds a
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2009-11-09T15:57:03Z
Lists: pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes: > I've stopped the query more than 10 times now and EVERY SINGLE ONE > finds it in list_concat_unique_ptr(). :-( Too bad you don't have debug symbols ... it'd be interesting to see how long that list is. > It's also using about 12x as much RAM as the GEQO version. No surprise. GEQO is designed to constrain its memory use, the exhaustive planner not so much. regards, tom lane