Create the <filename>aqo</filename> extension using the following query:

</para>

<programlisting>

&quot;CREATE EXTENSION aqo;&quot;

CREATE EXTENSION aqo;

</programlisting>

</listitem>

</orderedlist>

SET aqo.mode='intelligent';

SELECT * FROM a, b WHERE a.id=b.id;

SET aqo.mode='manual';

SET aqo.mode='controlled';

-- Disable auto_tuning, enable both learn_aqo and use_aqo

-- for this query type:

<entry>Optimizes all queries together, regardless of the query type.</entry>

</row>

<row>

<entry><literal>manual</literal></entry>

<entry><literal>controlled</literal></entry>

<entry><emphasis role="strong">Default.</emphasis> Uses the default planner for all new queries, but can reuse the collected statistics for already known query types, if any.</entry>

</row>

<row>

intelligent mode. In other modes, new queries are not

appended to <structname>aqo_queries</structname> automatically.

You can change this behavior by setting the

<literal>auto_tuning</literal> variable toTRUE.</entry>

<literal>auto_tuning</literal> variable to<literal>true</literal>.</entry>

</row>

</tbody>

</tgroup>

<para>

To use <filename>mamonsu</filename>, you must have a <filename>zabbix</filename> account and a <filename>zabbix</filename> server set up, and install the

<filename>zabbix</filename> agent on the system you are going to monitor.</para>

<para>Pre-built <filename>mamonsu</filename>packages are

provided together with<productname>&productname;</productname>, buthave a

<para>A pre-built <filename>mamonsu</filename>package is provided together with

<productname>&productname;</productname>, buthas a

separate installer. Once you have installed both <productname>&productname;</productname> and <filename>mamonsu</filename>, complete the following

steps to set up metrics collection:

</para>

<orderedlist>

<listitem>

<para>

If you are starting from scratch, configure your <productname>&productname;</productname> instance andintialize a new database. For details, see

If you are starting from scratch, configure your <productname>&productname;</productname> instance andinitialize a new database. For details, see

<xref linkend="creating-cluster">.

</para>

</listitem>

<para>Set the <varname>ZABBIX_USER</varname> and <varname>ZABBIX_PASSWD</varname> variables to the login and password of your <filename>zabbix</filename> account, respectively.</para>

</listitem>

<listitem>

<para>Set the <varname>ZABBIX_URL</varname> to <literal>'http://zabbix/'</literal></para>

<para>Set the <varname>ZABBIX_URL</varname> to <literal>http://zabbix/</literal></para>

</listitem>

</itemizedlist>

<para>

<listitem>

<para>

Configure <filename>zabbix</filename>-related settings. You must

set <varname>address</varname>to the <filename>zabbix</filename> server address and specify the name of the <filename>zabbix</filename> host that will receive the collected metrics. You can find the hosts available for your account in the <filename>zabbix</filename> web interface under <emphasis role="srong"><guimenu>Configuration</guimenu></emphasis> > <emphasis role="srong"><guimenu>Hosts</guimenu></emphasis>.

set <varname>address</varname>to the <filename>zabbix</filename> server address and specify the name of the <filename>zabbix</filename> host that will receive the collected metrics. You can find the hosts available for your account in the <filename>zabbix</filename> web interface under <emphasis role="srong"><guimenu>Configuration</guimenu></emphasis> > <emphasis role="srong"><guimenu>Hosts</guimenu></emphasis>.

</para>

<programlisting>

[zabbix]

<para>

Based on the hardware information, <filename>mamonsu</filename>

enables you to make a generic optimization for your system and the

<productname>PostgreSQL</productname> instance:

<productname>&productname;</productname> instance:

</para>

<programlisting>

mamonsu tune