diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-12-13 19:13:44 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-12-13 19:13:44 +0000 |
| commit | 65e3ea76417d1baab158fd8305ebed4f43141c7a (patch) | |
| tree | 289f332ba577bcbd9794c3e11ef2b3b89cb078be /src/backend/utils/misc/postgresql.conf.sample | |
| parent | b69bde774982ac4497cec9c9fe0190097890292f (diff) | |
| download | postgresql-65e3ea76417d1baab158fd8305ebed4f43141c7a.tar.gz postgresql-65e3ea76417d1baab158fd8305ebed4f43141c7a.zip | |
Increase the default value of default_statistics_target from 10 to 100,
and its maximum value from 1000 to 10000. ALTER TABLE SET STATISTICS
similarly now allows a value up to 10000. Per discussion.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index f886ef74b21..bf85ae083c6 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -210,7 +210,7 @@ # - Other Planner Options - -#default_statistics_target = 10 # range 1-1000 +#default_statistics_target = 100 # range 1-10000 #constraint_exclusion = off #cursor_tuple_fraction = 0.1 # range 0.0-1.0 #from_collapse_limit = 8 |