pgsql: Tweak planner to use a minimum size estimate of 10 pages for a
От | tgl@svr1.postgresql.org (Tom Lane) |
---|---|
Тема | pgsql: Tweak planner to use a minimum size estimate of 10 pages for a |
Дата | |
Msg-id | 20050324191512.0DCA85343F@svr1.postgresql.org обсуждение исходный текст |
Список | 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. 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 по дате отправления: