<!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.67 2005/03/1403:59:22 momjian Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.68 2005/03/1406:49:48 neilc Exp $ -->

<chapter id="charset">

<title>Localization</>

</listitem>

</varlistentry>

<variablelist>

<varlistentry>

<term><ulink url="ftp://ftp.ora.com/pub/examples/nutshell/ujip/doc/cjk.inf"></ulink></term>

<!--

$PostgreSQL: pgsql/doc/src/sgml/planstats.sgml,v 1.2 2005/02/27 01:17:34 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/planstats.sgml,v 1.3 2005/03/14 06:49:48 neilc Exp $

-->

<chapter id="planner-stats-details">

----------+-----------

345 | 10000

</programlisting>

The planner will check the <structfield>relpages<structfield> estimate

(this is a cheap operation) and if incorrect may scale

<structfield>reltuples<structfield> to obtain a row estimate. In this case it

does not, thus:

The planner will check the <structfield>relpages</structfield>

estimate(this is a cheap operation) and if incorrect may scale

<structfield>reltuples</structfield> to obtain a row estimate. In this

case itdoes not, thus:

<programlisting>

rows = 10000

This is due to the join method being nested-loop, with

<classname>tenk1</classname> being in the outer loop. The operator is just

our familiar <literal>=<literal>, however the restriction function is

our familiar <literal>=</literal>, however the restriction function is

obtained from the <structfield>oprjoin</structfield> column of

<classname>pg_operator</classname> - and is <function>eqjoinsel</function>.

Additionally we use the statistical information for both

<!--

$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.308 2005/03/13 09:36:30 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.309 2005/03/14 06:49:48 neilc Exp $

-->

<chapter Id="runtime">

<prompt>$</prompt> <userinput>sysctl -w kernel.shmall=2097152</userinput>

</screen>

In addition these settings can be saved between reboots in

<filename>/etc/sysctl.conf.

<filename>/etc/sysctl.conf</filename>.

</para>

<para>