diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-09-25 22:12:24 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-09-25 22:12:24 +0000 |
| commit | 0f8fc35a5a9824d4f50edef49ce000f104ca5e74 (patch) | |
| tree | 0d1d548f2bab9e4b6cac58d9e07dff84b421752d /src | |
| parent | ffae5cc5a6024b4e25ec920ed5c4dfac649605f8 (diff) | |
| download | postgresql-0f8fc35a5a9824d4f50edef49ce000f104ca5e74.tar.gz postgresql-0f8fc35a5a9824d4f50edef49ce000f104ca5e74.zip | |
Increase default value of effective_cache_size to 128MB, per 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 40a205a501a..13408899dc3 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -195,7 +195,7 @@ #cpu_tuple_cost = 0.01 # 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 = 8000kB +#effective_cache_size = 128MB # - Genetic Query Optimizer - diff --git a/src/include/optimizer/cost.h b/src/include/optimizer/cost.h index e0250f5f396..ce61e261a95 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.80 2006/09/19 22:49:53 tgl Exp $ + * $PostgreSQL: pgsql/src/include/optimizer/cost.h,v 1.81 2006/09/25 22:12:24 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -27,7 +27,7 @@ #define DEFAULT_CPU_INDEX_TUPLE_COST 0.005 #define DEFAULT_CPU_OPERATOR_COST 0.0025 -#define DEFAULT_EFFECTIVE_CACHE_SIZE 1000 /* measured in pages */ +#define DEFAULT_EFFECTIVE_CACHE_SIZE 16384 /* measured in pages */ /* |