Skip site navigation (1) Skip section navigation (2)

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:22
Message-ID: 20090511175622.22A06754067@cvs.postgresql.org (view raw or flat)
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_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        predtest.c (r1.10.2.4 -> r1.10.2.5)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/predtest.c?r1=1.10.2.4&r2=1.10.2.5)

pgsql-committers by date

Next:From: User BmomjianDate: 2009-05-12 00:26:02
Subject: pg-migrator - pg_migrator: Fix handling of multiple table extents.
Previous:From: Tom LaneDate: 2009-05-11 17:56:14
Subject: pgsql: Partially revert my patch of 2008-11-12 that installed a limit on

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group