From: | tgl(at)svr1(dot)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Tweak planner to use a minimum size estimate of 10 pages for a |
Date: | 2005-03-24 19:14:50 |
Message-ID: | 20050324191450.08E5E5342B@svr1.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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.
Modified Files:
--------------
pgsql/src/backend/optimizer/util:
plancat.c (r1.100 -> r1.101)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/plancat.c.diff?r1=1.100&r2=1.101)
pgsql/src/test/regress/expected:
join.out (r1.22 -> r1.23)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/join.out.diff?r1=1.22&r2=1.23)
polymorphism.out (r1.6 -> r1.7)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/polymorphism.out.diff?r1=1.6&r2=1.7)
rules.out (r1.95 -> r1.96)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.95&r2=1.96)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-03-24 19:15:12 | pgsql: Tweak planner to use a minimum size estimate of 10 pages for a |
Previous Message | Bruce Momjian | 2005-03-24 18:16:18 | pgsql: Set socket timer to 58 instead of 60 minutes for hour-old |