create_hash_partitions(relation REGCLASS,

attribute TEXT,

partitions_count INTEGER,

partition_name TEXT DEFAULT NULL,

partition_data BOOLEAN DEFAULT TRUE)

</programlisting>

<para>

to finish and the table will be locked until transaction

commits. See <literal>partition_table_concurrently()</literal>

for a lock-free way to migrate data. Partition creation callback

is invoked for each partition if set beforehand (see

<literal>set_part_init_callback()</literal>).

is invoked for each partition if set beforehand

(see<literal>set_init_callback()</literal>).

</para>

<programlisting>

create_range_partitions(relation REGCLASS,

</sect3>

<sect3 id="post-creation-partition-management">

<title>Post-creation partition management</title>

<programlisting>

replace_hash_partition(old_partition REGCLASS,

new_partition REGCLASS,

lock_parent BOOL DEFAULT TRUE)

</programlisting>

<para>

Replaces specified partition of HASH-partitioned table with another table.

The <literal>lock_parent</literal> parameter will prevent any INSERT/UPDATE/ALTER TABLE

queries to parent table.

</para>

<programlisting>

split_range_partition(partition REGCLASS,

value ANYELEMENT,

&quot;parttype&quot;: &quot;1&quot;,

&quot;partition&quot;: &quot;abc_0&quot;

}

</programlisting>

</programlisting>

<programlisting>

set_set_spawn_using_bgw(relation REGCLASS, value BOOLEAN)

</programlisting>

<para>

When INSERTing new data beyond the partitioning range,

use SpawnPartitionsWorker to create new partitions in a

separate transaction.

</para>

</sect3>

</sect2>

<sect2 id="views-and-tables">

partrel REGCLASS NOT NULL PRIMARY KEY,

attname TEXT NOT NULL,

parttype INTEGER NOT NULL,

range_interval TEXT,

CHECK (parttype IN (1, 2)) /* check for allowed part types */ );

range_interval TEXT);

</programlisting>

<para>

This table stores a list of partitioned tables.

partrel REGCLASS NOT NULL PRIMARY KEY,

enable_parent BOOLEAN NOT NULL DEFAULT TRUE,

auto BOOLEAN NOT NULL DEFAULT TRUE,

init_callback REGPROCEDURE NOT NULL DEFAULT 0);

init_callback REGPROCEDURE NOT NULL DEFAULT 0,

spawn_using_bgw BOOLEAN NOT NULL DEFAULT FALSE);

</programlisting>

<para>

This table stores optional parameters which override standard

<title>Postgres Pro 9.6.1.2</title>

<note>

<title>Release Date</title>

<simpara>2016-12-__</simpara>

<simpara>2016-12-09</simpara>

</note>

<sect2>

<title>Overview</title>

<para>This release is based on <productname>PostgresPro</productname>

9.6.1.1 and upstream PostgreSQL patches.</para>

<para>Major enhancements over <productname>Postgres Pro</productname>

9.6.1.1 include:</para>

<para>Several modules to support 1C Enterprise added:</para>

<itemizedlist>

<listitem>

<para><application>plantuner</application> (See <xref linkend="plantuner">)</para>

</listitem>

</itemizedlist>

<para>Also, following core changes were added to support 1C:</para>

<itemizedlist>

<listitem>

<para>Optimization of range conditions in the WHERE clause</para>

</listitem>

</itemizedlist>

<para>Modules has been updated</para>

<itemizedlist>

<listitem><para><application>pg_pathman</application> to version 1.2.2 (See <xref linkend="pg-pathman">)</para></listitem>

</itemizedlist>

<para>

Backup manager <application>pg_arman</application> has been replaced

to <application>pg_probackup</application> (Version 1.0).

</para>

</sect2>

<sect2>

<title>Migration to Version 9.6.1.2</title>

</itemizedlist>

<para>Modules has been ported from Postgres Pro 9.5</para>

<itemizedlist>

<listitem>

<para><application>hunspell-dict</application> (See <xref linkend="hunspell-dict">)</para>

<para><application>jsquery</application> (See <xref linkend="jsquery">)</para>

<para><application>pg_variables</application> (See <xref linkend="pg-variables">)</para>

<para><application>pg_pathman</application> (See <xref linkend="pg-pathman">)</para>

<para><application>pg_query_state</application> (See <xref linkend="pg-query-state">)</para>

<para><application>shared-ispell</application> (See <xref linkend="shared-ispell">)</para>

<para><application>sr_plan</application> (See <xref linkend="sr-plan">)</para>

<para><application>dump_stat</application> (See <xref linkend="dump-stat">)</para>

</listitem>

<listitem><para><application>hunspell-dict</application> (See <xref linkend="hunspell-dict">)</para></listitem>

<listitem><para><application>jsquery</application> (See <xref linkend="jsquery">)</para></listitem>

<listitem><para><application>pg_variables</application> (See <xref linkend="pg-variables">)</para></listitem>

<listitem><para><application>pg_pathman</application> (See <xref linkend="pg-pathman">)</para></listitem>

<listitem><para><application>pg_query_state</application> (See <xref linkend="pg-query-state">)</para></listitem>

<listitem><para><application>shared-ispell</application> (See <xref linkend="shared-ispell">)</para></listitem>

<listitem><para><application>sr_plan</application> (See <xref linkend="sr-plan">)</para></listitem>

<listitem><para><application>dump_stat</application> (See <xref linkend="dump-stat">)</para></listitem>

</itemizedlist>

<para>Tools has been ported from Postgres Pro 9.5</para>

<itemizedlist>