diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-05 03:03:42 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-05 03:03:42 +0000 |
| commit | e4de635a2ba10dcc6fdb972f87fb25953d8d3001 (patch) | |
| tree | a6262df8a6f38a39ad222147749222f41d2210ad /src | |
| parent | eed6c9ed7e243948e440ed1388591b7fa28f5827 (diff) | |
| download | postgresql-e4de635a2ba10dcc6fdb972f87fb25953d8d3001.tar.gz postgresql-e4de635a2ba10dcc6fdb972f87fb25953d8d3001.zip | |
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.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 | ||||
| -rw-r--r-- | src/include/optimizer/cost.h | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 0499223d110..ee5adaa2ff2 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -178,7 +178,7 @@ #seq_page_cost = 1.0 # measured on an arbitrary scale #random_page_cost = 4.0 # same scale as above #cpu_tuple_cost = 0.01 # same scale as above -#cpu_index_tuple_cost = 0.001 # same scale as above +#cpu_index_tuple_cost = 0.005 # same scale as above #cpu_operator_cost = 0.0025 # same scale as above #effective_cache_size = 1000 # typically 8KB each diff --git a/src/include/optimizer/cost.h b/src/include/optimizer/cost.h index 5d9a6c821c7..ae3f0171fab 100644 --- a/src/include/optimizer/cost.h +++ b/src/include/optimizer/cost.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2006, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/optimizer/cost.h,v 1.74 2006/06/05 02:49:58 tgl Exp $ + * $PostgreSQL: pgsql/src/include/optimizer/cost.h,v 1.75 2006/06/05 03:03:42 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -24,7 +24,7 @@ #define DEFAULT_SEQ_PAGE_COST 1.0 #define DEFAULT_RANDOM_PAGE_COST 4.0 #define DEFAULT_CPU_TUPLE_COST 0.01 -#define DEFAULT_CPU_INDEX_TUPLE_COST 0.001 +#define DEFAULT_CPU_INDEX_TUPLE_COST 0.005 #define DEFAULT_CPU_OPERATOR_COST 0.0025 #define DEFAULT_EFFECTIVE_CACHE_SIZE 1000.0 /* measured in pages */ |