<!--

$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">

SELECT * FROM pg_class WHERE relname = 'tenk1';

</programlisting>

you will find out that <classname>tenk1</classname> has333 disk

pages and 10000 rows. So the cost is estimated at333 page

you will find out that <classname>tenk1</classname> has233 disk

pages and 10000 rows. So the cost is estimated at233 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>

# 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