Skip to content

Commit ea0b638

Browse files
dmpgprodmpgpro
committed
Merge branch 'PGPRO9_6' into PGPRO9_6_pathman
2 parents 097cf95 + 234771b commit ea0b638

File tree

2 files changed

+46
-19
lines changed

2 files changed

+46
-19
lines changed

‎doc/src/sgml/pgpathman.sgml

Lines changed: 25 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -140,7 +140,6 @@ CREATE EXTENSION pg_pathman;
140140
create_hash_partitions(relation REGCLASS,
141141
attribute TEXT,
142142
partitions_count INTEGER,
143-
partition_name TEXT DEFAULT NULL,
144143
partition_data BOOLEAN DEFAULT TRUE)
145144
</programlisting>
146145
<para>
@@ -154,8 +153,8 @@ create_hash_partitions(relation REGCLASS,
154153
to finish and the table will be locked until transaction
155154
commits. See <literal>partition_table_concurrently()</literal>
156155
for a lock-free way to migrate data. Partition creation callback
157-
is invoked for each partition if set beforehand (see
158-
<literal>set_part_init_callback()</literal>).
156+
is invoked for each partition if set beforehand
157+
(see <literal>set_init_callback()</literal>).
159158
</para>
160159
<programlisting>
161160
create_range_partitions(relation REGCLASS,
@@ -243,6 +242,17 @@ create_range_update_trigger(parent REGCLASS)
243242
</sect3>
244243
<sect3 id="post-creation-partition-management">
245244
<title>Post-creation partition management</title>
245+
<programlisting>
246+
replace_hash_partition(old_partition REGCLASS,
247+
new_partition REGCLASS,
248+
lock_parent BOOL DEFAULT TRUE)
249+
</programlisting>
250+
<para>
251+
Replaces specified partition of HASH-partitioned table with another table.
252+
The <literal>lock_parent</literal> parameter will prevent any INSERT/UPDATE/ALTER TABLE
253+
queries to parent table.
254+
</para>
255+
246256
<programlisting>
247257
split_range_partition(partition REGCLASS,
248258
value ANYELEMENT,
@@ -390,7 +400,15 @@ set_init_callback(relation REGCLASS, callback REGPROC DEFAULT 0)
390400
&quot;parttype&quot;: &quot;1&quot;,
391401
&quot;partition&quot;: &quot;abc_0&quot;
392402
}
393-
</programlisting>
403+
</programlisting>
404+
<programlisting>
405+
set_set_spawn_using_bgw(relation REGCLASS, value BOOLEAN)
406+
</programlisting>
407+
<para>
408+
When INSERTing new data beyond the partitioning range,
409+
use SpawnPartitionsWorker to create new partitions in a
410+
separate transaction.
411+
</para>
394412
</sect3>
395413
</sect2>
396414
<sect2 id="views-and-tables">
@@ -403,9 +421,7 @@ CREATE TABLE IF NOT EXISTS pathman_config (
403421
partrel REGCLASS NOT NULL PRIMARY KEY,
404422
attname TEXT NOT NULL,
405423
parttype INTEGER NOT NULL,
406-
range_interval TEXT,
407-
408-
CHECK (parttype IN (1, 2)) /* check for allowed part types */ );
424+
range_interval TEXT);
409425
</programlisting>
410426
<para>
411427
This table stores a list of partitioned tables.
@@ -419,7 +435,8 @@ CREATE TABLE IF NOT EXISTS pathman_config_params (
419435
partrel REGCLASS NOT NULL PRIMARY KEY,
420436
enable_parent BOOLEAN NOT NULL DEFAULT TRUE,
421437
auto BOOLEAN NOT NULL DEFAULT TRUE,
422-
init_callback REGPROCEDURE NOT NULL DEFAULT 0);
438+
init_callback REGPROCEDURE NOT NULL DEFAULT 0,
439+
spawn_using_bgw BOOLEAN NOT NULL DEFAULT FALSE);
423440
</programlisting>
424441
<para>
425442
This table stores optional parameters which override standard

‎doc/src/sgml/release-pro-9.6.sgml

Lines changed: 21 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -4,14 +4,15 @@
44
<title>Postgres Pro 9.6.1.2</title>
55
<note>
66
<title>Release Date</title>
7-
<simpara>2016-12-__</simpara>
7+
<simpara>2016-12-09</simpara>
88
</note>
99
<sect2>
1010
<title>Overview</title>
1111
<para>This release is based on <productname>PostgresPro</productname>
1212
9.6.1.1 and upstream PostgreSQL patches.</para>
1313
<para>Major enhancements over <productname>Postgres Pro</productname>
1414
9.6.1.1 include:</para>
15+
1516
<para>Several modules to support 1C Enterprise added:</para>
1617
<itemizedlist>
1718
<listitem>
@@ -30,6 +31,7 @@
3031
<para><application>plantuner</application> (See <xref linkend="plantuner">)</para>
3132
</listitem>
3233
</itemizedlist>
34+
3335
<para>Also, following core changes were added to support 1C:</para>
3436
<itemizedlist>
3537
<listitem>
@@ -39,6 +41,16 @@
3941
<para>Optimization of range conditions in the WHERE clause</para>
4042
</listitem>
4143
</itemizedlist>
44+
45+
<para>Modules has been updated</para>
46+
<itemizedlist>
47+
<listitem><para><application>pg_pathman</application> to version 1.2.2 (See <xref linkend="pg-pathman">)</para></listitem>
48+
</itemizedlist>
49+
50+
<para>
51+
Backup manager <application>pg_arman</application> has been replaced
52+
to <application>pg_probackup</application> (Version 1.0).
53+
</para>
4254
</sect2>
4355
<sect2>
4456
<title>Migration to Version 9.6.1.2</title>
@@ -135,16 +147,14 @@
135147
</itemizedlist>
136148
<para>Modules has been ported from Postgres Pro 9.5</para>
137149
<itemizedlist>
138-
<listitem>
139-
<para><application>hunspell-dict</application> (See <xref linkend="hunspell-dict">)</para>
140-
<para><application>jsquery</application> (See <xref linkend="jsquery">)</para>
141-
<para><application>pg_variables</application> (See <xref linkend="pg-variables">)</para>
142-
<para><application>pg_pathman</application> (See <xref linkend="pg-pathman">)</para>
143-
<para><application>pg_query_state</application> (See <xref linkend="pg-query-state">)</para>
144-
<para><application>shared-ispell</application> (See <xref linkend="shared-ispell">)</para>
145-
<para><application>sr_plan</application> (See <xref linkend="sr-plan">)</para>
146-
<para><application>dump_stat</application> (See <xref linkend="dump-stat">)</para>
147-
</listitem>
150+
<listitem><para><application>hunspell-dict</application> (See <xref linkend="hunspell-dict">)</para></listitem>
151+
<listitem><para><application>jsquery</application> (See <xref linkend="jsquery">)</para></listitem>
152+
<listitem><para><application>pg_variables</application> (See <xref linkend="pg-variables">)</para></listitem>
153+
<listitem><para><application>pg_pathman</application> (See <xref linkend="pg-pathman">)</para></listitem>
154+
<listitem><para><application>pg_query_state</application> (See <xref linkend="pg-query-state">)</para></listitem>
155+
<listitem><para><application>shared-ispell</application> (See <xref linkend="shared-ispell">)</para></listitem>
156+
<listitem><para><application>sr_plan</application> (See <xref linkend="sr-plan">)</para></listitem>
157+
<listitem><para><application>dump_stat</application> (See <xref linkend="dump-stat">)</para></listitem>
148158
</itemizedlist>
149159
<para>Tools has been ported from Postgres Pro 9.5</para>
150160
<itemizedlist>

0 commit comments

Comments
 (0)