diff options
| -rw-r--r-- | doc/src/sgml/perform.sgml | 6 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 3 |
2 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/perform.sgml b/doc/src/sgml/perform.sgml index 2e42d020e42..af7f855a50c 100644 --- a/doc/src/sgml/perform.sgml +++ b/doc/src/sgml/perform.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.25 2003/01/27 22:40:56 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.26 2003/01/28 03:34:29 momjian Exp $ --> <chapter id="performance-tips"> @@ -109,8 +109,8 @@ regression=# EXPLAIN SELECT * FROM tenk1; SELECT * FROM pg_class WHERE relname = 'tenk1'; </programlisting> - you will find out that <classname>tenk1</classname> has 333 disk - pages and 10000 rows. So the cost is estimated at 333 page + you will find out that <classname>tenk1</classname> has 233 disk + pages and 10000 rows. So the cost is estimated at 233 page reads, defined as costing 1.0 apiece, plus 10000 * <varname>cpu_tuple_cost</varname> which is currently 0.01 (try <command>SHOW cpu_tuple_cost</command>). </para> diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 2e7d63024b7..4f4ef3f4554 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -121,7 +121,8 @@ # panic #client_min_messages = notice # Values, in order of decreasing detail: # debug5, debug4, debug3, debug2, debug1, - # log, info, notice, warning, error + # log, info, notice, warning, error, + # panic(off) #silent_mode = false #log_connections = false |