|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.24 2003/01/25 23:10:27 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/perform.sgml,v 1.25 2003/01/27 22:40:56 momjian Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <chapter id="performance-tips"> |
@@ -109,8 +109,8 @@ regression=# EXPLAIN SELECT * FROM tenk1; |
109 | 109 | SELECT * FROM pg_class WHERE relname = 'tenk1'; |
110 | 110 | </programlisting> |
111 | 111 |
|
112 | | - you will find out that <classname>tenk1</classname> has233 disk |
113 | | - pages and 10000 rows. So the cost is estimated at233 page |
| 112 | + you will find out that <classname>tenk1</classname> has333 disk |
| 113 | + pages and 10000 rows. So the cost is estimated at333 page |
114 | 114 | reads, defined as costing 1.0 apiece, plus 10000 * <varname>cpu_tuple_cost</varname> which is |
115 | 115 | currently 0.01 (try <command>SHOW cpu_tuple_cost</command>). |
116 | 116 | </para> |
|