Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Tweak planner to use a minimum size estimate of 10 pages for a - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Tweak planner to use a minimum size estimate of 10 pages for a
Date
Msg-id 20050324191512.0DCA85343F@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Tweak planner to use a minimum size estimate of 10 pages for a
never-yet-vacuumed relation.  This restores the pre-8.0 behavior of
avoiding seqscans during initial data loading, while still allowing
reasonable optimization after a table has been vacuumed.  Several
regression test cases revert to 7.4-like behavior, which is probably
a good sign.  Per gripes from Keith Browne and others.

Tags:
----
REL8_0_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        plancat.c (r1.100 -> r1.100.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/plancat.c.diff?r1=1.100&r2=1.100.4.1)
    pgsql/src/test/regress/expected:
        join.out (r1.22 -> r1.22.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join.out.diff?r1=1.22&r2=1.22.4.1)
        polymorphism.out (r1.6 -> r1.6.4.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/polymorphism.out.diff?r1=1.6&r2=1.6.4.1)
        rules.out (r1.95 -> r1.95.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.95&r2=1.95.4.1)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Tweak planner to use a minimum size estimate of 10 pages for a
Next
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Force PG client applications to link to non-shared libpgport