Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit34980b9

Browse files
committed
Merge branch 'PGPROEE9_6' into mtm-stm
2 parents3ec747a +ddfcf9a commit34980b9

File tree

44 files changed

+2933
-422
lines changed

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

44 files changed

+2933
-422
lines changed

‎.ci/build_and_test_world

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2,6 +2,7 @@
22
if [-z"$TCLCONFIG" ];then
33
[-x /usr/lib/tcl8.5/tclConfig.sh ]&& TCLCONFIG=/usr/lib/tcl8.5
44
[-x /usr/lib/tcl8.6/tclConfig.sh ]&& TCLCONFIG=/usr/lib/tcl8.6
5+
[-x /usr/lib64/tclConfig.sh ]&& TCLCONFIG=/usr/lib64/tclConfig.sh
56
fi
67
[-n"$TCLCONFIG" ]&&export TCLCONFIG
78
echo TCLCONFIG=${TCLCONFIG}

‎.ci/run

Lines changed: 22 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5,4 +5,25 @@
55

66
set -e
77

8-
./.ci/build_and_test_world
8+
if ["`id -un`"="root" ];then
9+
if [-d".ci" ];then
10+
if ["`uname`"="Darwin" ];then
11+
if! [-e /Users/ci ];then
12+
echo"Error: User ci not found."
13+
exit 1
14+
fi
15+
chown -R ci.
16+
[-e~/.ci.env ]&&source~/.ci.env
17+
else
18+
groupadd ci
19+
useradd -g ci ci
20+
chown -R ci:ci.
21+
fi
22+
su ci -c ./.ci/build_and_test_world
23+
else
24+
echo"Error: .ci not found"
25+
exit 1
26+
fi
27+
else
28+
./.ci/build_and_test_world
29+
fi

‎.ci/run.cmd

Lines changed: 68 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,68 @@
1+
@echooff
2+
PATH=C:\Windows\system32;C:\Perl64\bin;C:\msys64\usr\bin
3+
4+
IF"%ARCH%"==""SETARCH=X86
5+
IF"%ARCH%"=="x86"SETARCH=X86
6+
IF"%ARCH%"=="x64"SETARCH=X64
7+
IF"%SDK%"==""SETSDK=SDK71
8+
9+
echo ARCH=%ARCH%
10+
echo SDK=%SDK%
11+
12+
IF%SDK%== SDK71SETDEPENDENCIES_BIN_DIR=C:\pgfarm\deps_%ARCH%_%SDK%
13+
IF%SDK%== MSVC2013SETDEPENDENCIES_BIN_DIR=C:\pgfarm\deps_%ARCH%
14+
15+
SETPERL32_PATH=C:\Perl
16+
SETPERL64_PATH=C:\Perl64
17+
SETPYTHON32_PATH=C:\Python27x86
18+
SETPYTHON64_PATH=C:\Python27x64
19+
20+
IF%SDK%== SDK71 (
21+
CALL"C:\Program Files\Microsoft SDKs\Windows\v7.1\Bin\SetEnv" /%ARCH%||GOTO :ERROR
22+
ECHOON
23+
)
24+
25+
IF%SDK%== MSVC2013 (
26+
IF%ARCH%== X86CALL"C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\vcvarsall" x86||GOTO :ERROR
27+
ECHOON
28+
IF%ARCH%== X64CALL"C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\vcvarsall" amd64||GOTO :ERROR
29+
ECHOON
30+
)
31+
32+
>src\tools\msvc\config.plECHO use strict;
33+
>>src\tools\msvc\config.plECHO use warnings;
34+
>>src\tools\msvc\config.plECHO our $config = {
35+
>>src\tools\msvc\config.plECHO asserts^=^> 0^,^# --enable-cassert
36+
>>src\tools\msvc\config.plECHO^# integer_datetimes^=^>1,
37+
>>src\tools\msvc\config.plECHO^# float4byval^=^>1,
38+
>>src\tools\msvc\config.plECHO^# float8byval^=^>0,
39+
>>src\tools\msvc\config.plECHO^# blocksize^=^> 8,
40+
>>src\tools\msvc\config.plECHO^# wal_blocksize^=^> 8,
41+
>>src\tools\msvc\config.plECHO^# wal_segsize^=^> 16,
42+
>>src\tools\msvc\config.plECHO ldap^=^> 1,
43+
>>src\tools\msvc\config.plECHO nls^=^> '%DEPENDENCIES_BIN_DIR%\libintl',
44+
>>src\tools\msvc\config.plECHO tcl^=^> undef,
45+
IF%ARCH%== X64 (>>src\tools\msvc\config.plECHO perl^=^> '%PERL64_PATH%', )
46+
IF%ARCH%== X86 (>>src\tools\msvc\config.plECHO perl^=^> '%PERL32_PATH%', )
47+
IF%ARCH%== X64 (>>src\tools\msvc\config.plECHO python^=^> '%PYTHON64_PATH%', )
48+
IF%ARCH%== X86 (>>src\tools\msvc\config.plECHO python^=^> '%PYTHON32_PATH%', )
49+
>>src\tools\msvc\config.plECHO openssl^=^> '%DEPENDENCIES_BIN_DIR%\openssl',
50+
>>src\tools\msvc\config.plECHO uuid^=^> '%DEPENDENCIES_BIN_DIR%\uuid',
51+
>>src\tools\msvc\config.plECHO xml^=^> '%DEPENDENCIES_BIN_DIR%\libxml2',
52+
>>src\tools\msvc\config.plECHO xslt^=^> '%DEPENDENCIES_BIN_DIR%\libxslt',
53+
>>src\tools\msvc\config.plECHO iconv^=^> '%DEPENDENCIES_BIN_DIR%\iconv',
54+
>>src\tools\msvc\config.plECHO zlib^=^> '%DEPENDENCIES_BIN_DIR%\zlib',
55+
>>src\tools\msvc\config.plECHO icu^=^> '%DEPENDENCIES_BIN_DIR%\icu'
56+
>>src\tools\msvc\config.plECHO^};
57+
>>src\tools\msvc\config.plECHO 1^;
58+
59+
type .\src\tools\msvc\config.pl
60+
61+
perl src\tools\msvc\build.pl||GOTO :ERROR
62+
63+
GOTO :DONE
64+
:ERROR
65+
ECHO Failed with error #%errorlevel%.
66+
EXIT /b%errorlevel%
67+
:DONE
68+
ECHO Done.

‎configure

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2770,7 +2770,7 @@ else
27702770
fi
27712771

27722772

2773-
PGPRO_VERSION="$PACKAGE_VERSION.2"
2773+
PGPRO_VERSION="$PACKAGE_VERSION.1"
27742774
PGPRO_PACKAGE_NAME="PostgresPro"
27752775
PGPRO_EDITION="enterprise"
27762776

‎configure.in

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -38,7 +38,7 @@ AC_DEFINE_UNQUOTED(PG_MAJORVERSION, "$PG_MAJORVERSION", [PostgreSQL major versio
3838
PGAC_ARG_REQ(with, extra-version, [STRING], [append STRING to version],
3939
[PG_VERSION="$PACKAGE_VERSION$withval"],
4040
[PG_VERSION="$PACKAGE_VERSION"])
41-
PGPRO_VERSION="$PACKAGE_VERSION.2"
41+
PGPRO_VERSION="$PACKAGE_VERSION.1"
4242
PGPRO_PACKAGE_NAME="PostgresPro"
4343
PGPRO_EDITION="enterprise"
4444
AC_SUBST(PGPRO_PACKAGE_NAME)

‎contrib/pg_pathman/META.json

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
"name":"pg_pathman",
33
"abstract":"Partitioning tool",
44
"description":"The `pg_pathman` module provides optimized partitioning mechanism and functions to manage partitions.",
5-
"version":"1.4.2",
5+
"version":"1.4.3",
66
"maintainer": [
77
"Ildar Musin <i.musin@postgrespro.ru>",
88
"Dmitry Ivanov <d.ivanov@postgrespro.ru>",
@@ -24,7 +24,7 @@
2424
"pg_pathman": {
2525
"file":"pg_pathman--1.4.sql",
2626
"docfile":"README.md",
27-
"version":"1.4.2",
27+
"version":"1.4.3",
2828
"abstract":"Partitioning tool"
2929
}
3030
},

‎contrib/pg_pathman/Makefile

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -47,6 +47,7 @@ REGRESS = pathman_array_qual \
4747
pathman_rowmarks\
4848
pathman_runtime_nodes\
4949
pathman_update_trigger\
50+
pathman_upd_del\
5051
pathman_utility_stmt
5152

5253
EXTRA_REGRESS_OPTS=--temp-config=$(top_srcdir)/$(subdir)/conf.add

‎contrib/pg_pathman/README.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -263,7 +263,7 @@ Update RANGE partitioned table interval. Note that interval must not be negative
263263
```plpgsql
264264
set_enable_parent(relation REGCLASS, valueBOOLEAN)
265265
```
266-
Include/exclude parent table into/from query plan. In original PostgreSQL planner parent table is always included into query plan even if it's empty which can lead to additional overhead. You can use`disable_parent()` if you are never going to use parent table as a storage. Default value depends on the`partition_data` parameter that was specified during initial partitioning in`create_range_partitions()`or`create_partitions_from_range()` functions. If the`partition_data` parameter was`true` then all data have already been migrated to partitions and parent table disabled. Otherwise it is enabled.
266+
Include/exclude parent table into/from query plan. In original PostgreSQL planner parent table is always included into query plan even if it's empty which can lead to additional overhead. You can use`disable_parent()` if you are never going to use parent table as a storage. Default value depends on the`partition_data` parameter that was specified during initial partitioning in`create_range_partitions()`function. If the`partition_data` parameter was`true` then all data have already been migrated to partitions and parent table disabled. Otherwise it is enabled.
267267

268268
```plpgsql
269269
set_auto(relation REGCLASS, valueBOOLEAN)

‎contrib/pg_pathman/expected/pathman_basic.out

Lines changed: 3 additions & 90 deletions
Original file line numberDiff line numberDiff line change
@@ -1653,100 +1653,13 @@ EXPLAIN (COSTS OFF) SELECT * FROM test.range_rel WHERE dt > '2010-12-15';
16531653
-> Seq Scan on range_rel_14
16541654
(4 rows)
16551655

1656-
/* Temporary table for JOINs */
1657-
CREATE TABLE test.tmp (id INTEGER NOT NULL, value INTEGER NOT NULL);
1658-
INSERT INTO test.tmp VALUES (1, 1), (2, 2);
1659-
/* Test UPDATE and DELETE */
1660-
EXPLAIN (COSTS OFF) UPDATE test.range_rel SET value = 111 WHERE dt = '2010-06-15';/* have partitions for this 'dt' */
1661-
QUERY PLAN
1662-
--------------------------------------------------------------------------------
1663-
Update on range_rel_6
1664-
-> Seq Scan on range_rel_6
1665-
Filter: (dt = 'Tue Jun 15 00:00:00 2010'::timestamp without time zone)
1666-
(3 rows)
1667-
1668-
UPDATE test.range_rel SET value = 111 WHERE dt = '2010-06-15';
1669-
SELECT * FROM test.range_rel WHERE dt = '2010-06-15';
1670-
id | dt | value
1671-
-----+--------------------------+-------
1672-
166 | Tue Jun 15 00:00:00 2010 | 111
1673-
(1 row)
1674-
1675-
EXPLAIN (COSTS OFF) DELETE FROM test.range_rel WHERE dt = '2010-06-15';/* have partitions for this 'dt' */
1676-
QUERY PLAN
1677-
--------------------------------------------------------------------------------
1678-
Delete on range_rel_6
1679-
-> Seq Scan on range_rel_6
1680-
Filter: (dt = 'Tue Jun 15 00:00:00 2010'::timestamp without time zone)
1681-
(3 rows)
1682-
1683-
DELETE FROM test.range_rel WHERE dt = '2010-06-15';
1684-
SELECT * FROM test.range_rel WHERE dt = '2010-06-15';
1685-
id | dt | value
1686-
----+----+-------
1687-
(0 rows)
1688-
1689-
EXPLAIN (COSTS OFF) UPDATE test.range_rel SET value = 222 WHERE dt = '1990-01-01';/* no partitions for this 'dt' */
1690-
QUERY PLAN
1691-
--------------------------------------------------------------------------------
1692-
Update on range_rel
1693-
-> Seq Scan on range_rel
1694-
Filter: (dt = 'Mon Jan 01 00:00:00 1990'::timestamp without time zone)
1695-
(3 rows)
1696-
1697-
UPDATE test.range_rel SET value = 111 WHERE dt = '1990-01-01';
1698-
SELECT * FROM test.range_rel WHERE dt = '1990-01-01';
1699-
id | dt | value
1700-
----+----+-------
1701-
(0 rows)
1702-
1703-
EXPLAIN (COSTS OFF) DELETE FROM test.range_rel WHERE dt < '1990-01-01';/* no partitions for this 'dt' */
1704-
QUERY PLAN
1705-
--------------------------------------------------------------------------------
1706-
Delete on range_rel
1707-
-> Seq Scan on range_rel
1708-
Filter: (dt < 'Mon Jan 01 00:00:00 1990'::timestamp without time zone)
1709-
(3 rows)
1710-
1711-
DELETE FROM test.range_rel WHERE dt < '1990-01-01';
1712-
SELECT * FROM test.range_rel WHERE dt < '1990-01-01';
1713-
id | dt | value
1714-
----+----+-------
1715-
(0 rows)
1716-
1717-
EXPLAIN (COSTS OFF) UPDATE test.range_rel r SET value = t.value FROM test.tmp t WHERE r.dt = '2010-01-01' AND r.id = t.id;
1718-
QUERY PLAN
1719-
--------------------------------------------------------------------------------------------
1720-
Update on range_rel_1 r
1721-
-> Hash Join
1722-
Hash Cond: (t.id = r.id)
1723-
-> Seq Scan on tmp t
1724-
-> Hash
1725-
-> Index Scan using range_rel_1_pkey on range_rel_1 r
1726-
Filter: (dt = 'Fri Jan 01 00:00:00 2010'::timestamp without time zone)
1727-
(7 rows)
1728-
1729-
UPDATE test.range_rel r SET value = t.value FROM test.tmp t WHERE r.dt = '2010-01-01' AND r.id = t.id;
1730-
EXPLAIN (COSTS OFF) DELETE FROM test.range_rel r USING test.tmp t WHERE r.dt = '2010-01-02' AND r.id = t.id;
1731-
QUERY PLAN
1732-
--------------------------------------------------------------------------------------------
1733-
Delete on range_rel_1 r
1734-
-> Hash Join
1735-
Hash Cond: (t.id = r.id)
1736-
-> Seq Scan on tmp t
1737-
-> Hash
1738-
-> Index Scan using range_rel_1_pkey on range_rel_1 r
1739-
Filter: (dt = 'Sat Jan 02 00:00:00 2010'::timestamp without time zone)
1740-
(7 rows)
1741-
1742-
DELETE FROM test.range_rel r USING test.tmp t WHERE r.dt = '2010-01-02' AND r.id = t.id;
17431656
/* Create range partitions from whole range */
17441657
SELECT drop_partitions('test.range_rel');
1745-
NOTICE:44 rows copied from test.range_rel_1
1658+
NOTICE:45 rows copied from test.range_rel_1
17461659
NOTICE: 31 rows copied from test.range_rel_3
17471660
NOTICE: 30 rows copied from test.range_rel_4
17481661
NOTICE: 31 rows copied from test.range_rel_5
1749-
NOTICE:29 rows copied from test.range_rel_6
1662+
NOTICE:30 rows copied from test.range_rel_6
17501663
NOTICE: 31 rows copied from test.range_rel_7
17511664
NOTICE: 31 rows copied from test.range_rel_8
17521665
NOTICE: 30 rows copied from test.range_rel_9
@@ -1939,6 +1852,6 @@ ORDER BY partition;
19391852
DROP TABLE test.provided_part_names CASCADE;
19401853
NOTICE: drop cascades to 2 other objects
19411854
DROP SCHEMA test CASCADE;
1942-
NOTICE: drop cascades to29 other objects
1855+
NOTICE: drop cascades to28 other objects
19431856
DROP EXTENSION pg_pathman CASCADE;
19441857
DROP SCHEMA pathman CASCADE;

‎contrib/pg_pathman/expected/pathman_calamity.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -12,7 +12,7 @@ SELECT debug_capture();
1212
SELECT get_pathman_lib_version();
1313
get_pathman_lib_version
1414
-------------------------
15-
10402
15+
10403
1616
(1 row)
1717

1818
set client_min_messages = NOTICE;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp