Skip site navigation (1) Skip section navigation (2)

pgsql: Increase the default value of default_statistics_target from 10

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Increase the default value of default_statistics_target from 10
Date: 2008-12-13 19:13:44
Message-ID: 20081213191344.848EE7563FE@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        config.sgml (r1.199 -> r1.200)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.199&r2=1.200)
        perform.sgml (r1.68 -> r1.69)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/perform.sgml?r1=1.68&r2=1.69)
    pgsql/doc/src/sgml/ref:
        alter_table.sgml (r1.101 -> r1.102)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_table.sgml?r1=1.101&r2=1.102)
        analyze.sgml (r1.24 -> r1.25)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/analyze.sgml?r1=1.24&r2=1.25)
    pgsql/src/backend/commands:
        analyze.c (r1.128 -> r1.129)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/analyze.c?r1=1.128&r2=1.129)
        tablecmds.c (r1.272 -> r1.273)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.272&r2=1.273)
    pgsql/src/backend/tsearch:
        ts_typanalyze.c (r1.3 -> r1.4)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/ts_typanalyze.c?r1=1.3&r2=1.4)
    pgsql/src/backend/utils/misc:
        guc.c (r1.482 -> r1.483)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.482&r2=1.483)
        postgresql.conf.sample (r1.247 -> r1.248)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample?r1=1.247&r2=1.248)

pgsql-committers by date

Next:From: Jaime CasanovaDate: 2008-12-14 06:02:11
Subject: Re: pgsql: Document that non-data journaling is a recommended mount option.
Previous:From: Tom LaneDate: 2008-12-13 02:29:22
Subject: pgsql: Remove pg_plan_queries()'s now-useless needSnapshot parameter.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group