On Jul 13, 2009, at 1:06 PM, Simon Riggs wrote:
Not just because of this but I wonder if we might benefit from an optimizer setting specifically aimed at the foolishnesses of automatically generated SQL.
+1. And it's not just ORMs that do stupid things, I've seen crap like this come out of users too (not this exact case, but similar).
Perhaps what we really want is an "optimization level" GUC so that users can tell the backend how much overhead they want the optimizer to spend on trying to work around stupidity... :)
-- Decibel!, aka Jim C. Nasby, Database Architect deci...@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers