comment = 'Functions to truncates the temporary table and does not grow pg_class size'

default_version = '1.0'

module_pathname = '$libdir/fasttrun'

relocatable = true

relocatable = true

comment = 'Introduce operator == which returns true when operands are equal or both are nulls.'

default_version = '1.0'

module_pathname = '$libdir/fulleq'

relocatable = true

relocatable = true

<programlisting>

max_locks_per_transaction = 256

</programlisting>

<para>Typically, <productname>1C</productname> solutions use a lot of temporary tables. Every backend process usually contains multiple temporary tables. When closing a connection, <productname>&productname;</productname> tries to drop all temporary tables in a singletransactio, so this transaction may use a lot of locks. If the number of locks exceeds the <varname>max_locks_per_transaction</varname> value, the transaction will fail, leaving multiple orphaned temporary tables.

<para>Typically, <productname>1C</productname> solutions use a lot of temporary tables. Every backend process usually contains multiple temporary tables. When closing a connection, <productname>&productname;</productname> tries to drop all temporary tables in a singletransaction, so this transaction may use a lot of locks. If the number of locks exceeds the <varname>max_locks_per_transaction</varname> value, the transaction will fail, leaving multiple orphaned temporary tables.

</para>

</listitem>

</itemizedlist>

<link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link>

table. The <function>dump_statistic</> function generates <literal>INSERT</>

statements which can later be applied to a compatible database. The extension

should be installed on the recipient server in order tosuccessfuly restore

should be installed on the recipient server in order tosuccessfully restore

statistical data since these statements heavily rely on the provided functions.

</para>

<para>

The <productname>&productname;</productname> equivalence operator is

defined to return NULL when both operands are NULLs. However, the Microsoft

SQL Servers familytraditionaly defines other semantic for equivalence

SQL Servers familytraditionally defines other semantic for equivalence

operator, where operator returns TRUE in the case of both nulled operands.

This module provides such operator with MSSQL semantic.

</para>

including the current wait events for all processes and background

workers.</simpara>

</listitem>

<listitem>

<simpara><application>pg_tsparser</application> module is an alternative text search parser.</simpara>

</listitem>

</itemizedlist>

</para>

Unfortunately, jsonb have no statistics yet. That's why JsQuery

optimizer has to do imperative decision while selecting

conditions to be evaluated using index. This decision is made by

assumtion that some condition types are less selective than

assumption that some condition types are less selective than

others. Optimizer divides conditions into following selectivity

class (listed by descending of selectivity).

</para>

<itemizedlist>

<listitem>

<para>

Case insensitivecomparation

Case insensitivecomparison

</para>

</listitem>

<listitem>

<listitem>

<para>

Time &mdash; time it took topeform the backup.

Time &mdash; time it took toperform the backup.

</para>

</listitem>

<title>Overview</title>

<para>

Each nonutility query statement (SELECT/INSERT/UPDATE/DELETE) after

optimization/planning stage is translated into plan tree wich is kind of

optimization/planning stage is translated into plan tree, which is kind of

imperative representation of declarative SQL query. EXPLAIN ANALYZE

request allows to demonstrate execution statistics gathered from each

node of plan tree (full time of execution, number of rows emitted to upper

</listitem>

<listitem>

<para>

format - EXPLAIN format to be used for plans printing,posible values:

format - EXPLAIN format to be used for plans printing,possible values:

text, xml, json, yaml.

</para>

</listitem>

</para>

<para>

Calling role have to be superuser or member of the role whose backend is

being called.Othrewise function prints ERROR message

being called.Otherwise function prints ERROR message

<literal>permission denied</literal>.

</para>

</sect2>