Jim Nasby <jnasby@xxxxxxxxx> writes: > I'm also wondering if it's time to raise those limits. Yeah, possibly. The current default values were set on machines much smaller/slower than most current hardware. I think also that the collapse limits were invented mainly to keep people out of GEQO's clutches, but we've made some significant fixes in GEQO since then. Maybe the real answer is to make the default collapse limits much higher, and lower geqo_threshold to whatever we think the threshold of pain is for applying the regular planner. 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
