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/guc.c | |
| 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/guc.c')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 00dac28c27e..8e3be6fe371 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.482 2008/12/02 02:00:32 alvherre Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.483 2008/12/13 19:13:44 tgl Exp $ * *-------------------------------------------------------------------- */ @@ -1245,7 +1245,7 @@ static struct config_int ConfigureNamesInt[] = "column-specific target set via ALTER TABLE SET STATISTICS.") }, &default_statistics_target, - 10, 1, 1000, NULL, NULL + 100, 1, 10000, NULL, NULL }, { {"from_collapse_limit", PGC_USERSET, QUERY_TUNING_OTHER, |