pgsql: Partially revert my patch of 2008-11-12 that installed a limit on

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Partially revert my patch of 2008-11-12 that installed a limit on
Date: 2009-05-11 17:56:14
Message-ID: 20090511175614.E0EAF754067@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Partially revert my patch of 2008-11-12 that installed a limit on the number
of AND/OR clause branches that predtest.c would attempt to deal with. As
noted in bug #4721, that change disabled proof attempts for sizes of problems
that people are actually expecting it to work for. The original complaint
it was trying to solve was O(N^2) behavior for long IN-lists, so let's try
applying the limit to just ScalarArrayOpExprs rather than everything.
Another case of "foolish consistency" I fear.

Back-patch to 8.2, same as the previous patch was.

Tags:
----
REL8_3_STABLE

Modified Files:
--------------
pgsql/src/backend/optimizer/util:
predtest.c (r1.19.2.1 -> r1.19.2.2)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/predtest.c?r1=1.19.2.1&r2=1.19.2.2)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2009-05-11 17:56:22 pgsql: Partially revert my patch of 2008-11-12 that installed a limit on
Previous Message Tom Lane 2009-05-11 17:56:08 pgsql: Partially revert my patch of 2008-11-12 that installed a limit on