pgsql: Increase the default value of cpu_index_tuple_cost from 0.001 to

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Increase the default value of cpu_index_tuple_cost from 0.001 to
Date: 2006-06-05 03:03:42
Message-ID: 20060605030342.613209FA5C3@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Increase the default value of cpu_index_tuple_cost from 0.001 to 0.005.
This shouldn't affect simple indexscans much, while for bitmap scans that
are touching a lot of index rows, this seems to bring the estimates more
in line with reality. Per recent discussion.

Modified Files:
--------------
pgsql/doc/src/sgml:
config.sgml (r1.60 -> r1.61)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.diff?r1=1.60&r2=1.61)
pgsql/src/backend/utils/misc:
postgresql.conf.sample (r1.178 -> r1.179)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.178&r2=1.179)
pgsql/src/include/optimizer:
cost.h (r1.74 -> r1.75)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/cost.h.diff?r1=1.74&r2=1.75)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2006-06-05 03:55:00 pgsql: Have psql history save \e editor contents to history before query
Previous Message Tom Lane 2006-06-05 02:49:59 pgsql: Add a GUC parameter seq_page_cost, and use that everywhere we