CentOS7.9 postgres12.11 回归测试Regression Test
上传源码包
[root@vm-centos79 ~]# cd /opt/
[root@vm-centos79 opt]# ll
total 245680
-rw-r--r-- 1 root root 74554190 Sep 27 15:57 jdk-8u361-linux-aarch64.tar.gz
-rw-r--r-- 1 root root 138762230 Sep 27 15:57 jdk-8u361-linux-x64.tar.gz
-rw-r--r-- 1 root root 27583446 Sep 27 15:50 postgresql-12.11.tar.gz
drwxr-xr-x 2 root root 4096 Sep 27 23:07 tar
drwxr-xr-x 3 root root 4096 Sep 20 09:07 tpcc
-rw-r--r-- 1 root root 10658203 Sep 27 23:09 tpcc.tar.gz
解压源码包
[root@vm-centos79 opt]# tar xf postgresql-12.11.tar.gz
[root@vm-centos79 opt]# ll
total 245684
-rw-r--r-- 1 root root 74554190 Sep 27 15:57 jdk-8u361-linux-aarch64.tar.gz
-rw-r--r-- 1 root root 138762230 Sep 27 15:57 jdk-8u361-linux-x64.tar.gz
drwxrwxrwx 6 1107 1107 4096 May 10 2022 postgresql-12.11
-rw-r--r-- 1 root root 27583446 Sep 27 15:50 postgresql-12.11.tar.gz
drwxr-xr-x 2 root root 4096 Sep 27 23:07 tar
drwxr-xr-x 3 root root 4096 Sep 20 09:07 tpcc
-rw-r--r-- 1 root root 10658203 Sep 27 23:09 tpcc.tar.gz
安装报错，依赖readline、zlib 包
[root@vm-centos79 postgresql-12.11]# yum install readline*
[root@vm-centos79 postgresql-12.11]# yum install zlib*
configure
[root@vm-centos79 postgresql-12.11]# ./configure --prefix=/u01/postgresql/12
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking which template to use... linux
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for gcc option to accept ISO C99... -std=gnu99
checking for g++... no
checking for c++... no
checking whether we are using the GNU C++ compiler... no
checking whether g++ accepts -g... no
checking for gawk... gawk
.............................................................省略N行..........................................
checking thread safety of required library functions... yes
checking whether gcc -std=gnu99 supports -Wl,--as-needed... yes
configure: using compiler=gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44)
configure: using CFLAGS=-Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2
configure: using CPPFLAGS= -D_GNU_SOURCE
configure: using LDFLAGS= -Wl,--as-needed
configure: creating ./config.status
config.status: creating GNUmakefile
config.status: creating src/Makefile.global
config.status: creating src/include/pg_config.h
config.status: creating src/include/pg_config_ext.h
config.status: creating src/interfaces/ecpg/include/ecpg_config.h
config.status: linking src/backend/port/tas/dummy.s to src/backend/port/tas.s
config.status: linking src/backend/port/posix_sema.c to src/backend/port/pg_sema.c
config.status: linking src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c
config.status: linking src/include/port/linux.h to src/include/pg_config_os.h
config.status: linking src/makefiles/Makefile.linux to src/Makefile.port
[root@vm-centos79 postgresql-12.11]#
执行 make
[root@vm-centos79 postgresql-12.11]# make
make -C ./src/backend generated-headers
make[1]: Entering directory `/opt/postgresql-12.11/src/backend'
make -C catalog distprep generated-header-symlinks
make[2]: Entering directory `/opt/postgresql-12.11/src/backend/catalog'
make[2]: Nothing to be done for `distprep'.
prereqdir=`cd './' >/dev/null && pwd` && \
cd '../../../src/include/catalog/' && for file in pg_proc_d.h pg_type_d.h pg_attribute_d.h pg_class_d.h pg_attrdef_d.h pg_constraint_d.h pg_inherits_d.h pg_index_d.h pg_operator_d.h pg_opfamily_d.h pg_opclass_d.h pg_am_d.h pg_amop_d.h pg_amproc_d.h pg_language_d.h pg_largeobject_metadata_d.h pg_largeobject_d.h pg_aggregate_d.h pg_statistic_ext_d.h pg_statistic_ext_data_d.h pg_statistic_d.h pg_rewrite_d.h pg_trigger_d.h pg_event_trigger_d.h pg_description_d.h pg_cast_d.h pg_enum_d.h pg_namespace_d.h pg_conversion_d.h pg_depend_d.h pg_database_d.h pg_db_role_setting_d.h pg_tablespace_d.h pg_pltemplate_d.h pg_authid_d.h pg_auth_members_d.h pg_shdepend_d.h pg_shdescription_d.h pg_ts_config_d.h pg_ts_config_map_d.h pg_ts_dict_d.h pg_ts_parser_d.h pg_ts_template_d.h pg_extension_d.h pg_foreign_data_wrapper_d.h pg_foreign_server_d.h pg_user_mapping_d.h pg_foreign_table_d.h pg_policy_d.h pg_replication_origin_d.h pg_default_acl_d.h pg_init_privs_d.h pg_seclabel_d.h pg_shseclabel_d.h pg_collation_d.h pg_partitioned_table_d.h pg_range_d.h pg_transform_d.h pg_sequence_d.h pg_publication_d.h pg_publication_rel_d.h pg_subscription_d.h pg_subscription_rel_d.h schemapg.h; do \
rm -f $file && ln -s "$prereqdir/$file" . ; \
done
touch ../../../src/include/catalog/header-stamp
make[2]: Leaving directory `/opt/postgresql-12.11/src/backend/catalog'
make -C utils distprep generated-header-symlinks
make[2]: Entering directory `/opt/postgresql-12.11/src/backend/utils'
make[2]: Nothing to be done for `distprep'.
prereqdir=`cd './' >/dev/null && pwd` && \
cd '../../../src/include/utils/' && for file in fmgroids.h fmgrprotos.h errcodes.h; do \
rm -f $file && ln -s "$prereqdir/$file" . ; \
done
touch ../../../src/include/utils/header-stamp
sed -f ./Gen_dummy_probes.sed probes.d >probes.h
cd '../../../src/include/utils/' && rm -f probes.h && \
ln -s "../../../src/backend/utils/probes.h" .
make[2]: Leaving directory `/opt/postgresql-12.11/src/backend/utils'
prereqdir=`cd 'parser/' >/dev/null && pwd` && \
cd '../../src/include/parser/' && rm -f gram.h && \
ln -s "$prereqdir/gram.h" .
prereqdir=`cd 'storage/lmgr/' >/dev/null && pwd` && \
cd '../../src/include/storage/' && rm -f lwlocknames.h && \
ln -s "$prereqdir/lwlocknames.h" .
make[1]: Leaving directory `/opt/postgresql-12.11/src/backend'
make -C src all
make[1]: Entering directory `/opt/postgresql-12.11/src'
make -C common all
................................................................省略N行..........................................
make -C test/perl all
make[2]: Entering directory `/opt/postgresql-12.11/src/test/perl'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/opt/postgresql-12.11/src/test/perl'
make[1]: Leaving directory `/opt/postgresql-12.11/src'
make -C config all
make[1]: Entering directory `/opt/postgresql-12.11/config'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/opt/postgresql-12.11/config'
All of PostgreSQL successfully made. Ready to install.
执行 make install 安装
[root@vm-centos79 postgresql-12.11]# make install
make -C ./src/backend generated-headers
make[1]: Entering directory `/opt/postgresql-12.11/src/backend'
make -C catalog distprep generated-header-symlinks
make[2]: Entering directory `/opt/postgresql-12.11/src/backend/catalog'
make[2]: Nothing to be done for `distprep'.
make[2]: Nothing to be done for `generated-header-symlinks'.
make[2]: Leaving directory `/opt/postgresql-12.11/src/backend/catalog'
make -C utils distprep generated-header-symlinks
make[2]: Entering directory `/opt/postgresql-12.11/src/backend/utils'
make[2]: Nothing to be done for `distprep'.
make[2]: Nothing to be done for `generated-header-symlinks'.
make[2]: Leaving directory `/opt/postgresql-12.11/src/backend/utils'
make[1]: Leaving directory `/opt/postgresql-12.11/src/backend'
make -C src install
make[1]: Entering directory `/opt/postgresql-12.11/src'
make -C common install
make[2]: Entering directory `/opt/postgresql-12.11/src/common'
.........................................................省略N行.......................................
make[1]: Leaving directory `/opt/postgresql-12.11/src'
make -C config install
make[1]: Entering directory `/opt/postgresql-12.11/config'
/usr/bin/mkdir -p '/u01/postgresql/12/lib/pgxs/config'
/usr/bin/install -c -m 755 ./install-sh '/u01/postgresql/12/lib/pgxs/config/install-sh'
/usr/bin/install -c -m 755 ./missing '/u01/postgresql/12/lib/pgxs/config/missing'
make[1]: Leaving directory `/opt/postgresql-12.11/config'
PostgreSQL installation complete.
创建postgres用户
####【执行Regression测试需要将 源码路径属组改为非root，这里为postgres用户】
[root@vm-centos79 postgresql-12.11]# useradd -m postgres -d /home/postgres -s /bin/bash
[root@vm-centos79 postgresql-12.11]# chown -R postgres.postgres /opt/
[root@vm-centos79 postgresql-12.11]# su - postgres
Last login: Thu Apr 11 09:36:02 CST 2024 on pts/0
[postgres@vm-centos79 ~]$
[postgres@vm-centos79 ~]$ cd /opt/postgresql-12.11/
[postgres@vm-centos79 postgresql-12.11]$ ll
总用量 1240
-rw-r--r--. 1 postgres postgres 445 5月 10 2022 aclocal.m4
drwxrwxrwx. 2 postgres postgres 4096 5月 10 2022 config
-rw-r--r--. 1 postgres postgres 437118 4月 11 09:26 config.log
-rwxr-xr-x. 1 postgres postgres 40161 4月 11 09:26 config.status
-rwxr-xr-x. 1 postgres postgres 581932 5月 10 2022 configure
-rw-r--r--. 1 postgres postgres 86602 5月 10 2022 configure.in
drwxrwxrwx. 56 postgres postgres 4096 5月 10 2022 contrib
-rw-r--r--. 1 postgres postgres 1192 5月 10 2022 COPYRIGHT
drwxrwxrwx. 3 postgres postgres 87 5月 10 2022 doc
-rw-r--r--. 1 postgres postgres 4284 4月 11 09:26 GNUmakefile
-rw-r--r--. 1 postgres postgres 4284 5月 10 2022 GNUmakefile.in
-rw-r--r--. 1 postgres postgres 284 5月 10 2022 HISTORY
-rw-r--r--. 1 postgres postgres 62466 5月 10 2022 INSTALL
-rw-r--r--. 1 postgres postgres 1665 5月 10 2022 Makefile
-rw-r--r--. 1 postgres postgres 1212 5月 10 2022 README
drwxrwxrwx. 16 postgres postgres 4096 4月 11 09:26 src
drwxr-xr-x. 4 postgres postgres 28 4月 11 09:30 tmp_install
[postgres@vm-centos79 postgresql-12.11]$
[postgres@vm-centos79 postgresql-12.11]$
执行测试 make installcheck
[postgres@vm-centos79 postgresql-12.11]$ make installcheck
make -C ./src/backend generated-headers
make[1]: 进入目录“/opt/postgresql-12.11/src/backend”
make -C catalog distprep generated-header-symlinks
make[2]: 进入目录“/opt/postgresql-12.11/src/backend/catalog”
make[2]: 对“distprep”无需做任何事。
make[2]: 对“generated-header-symlinks”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/backend/catalog”
make -C utils distprep generated-header-symlinks
make[2]: 进入目录“/opt/postgresql-12.11/src/backend/utils”
make[2]: 对“distprep”无需做任何事。
make[2]: 对“generated-header-symlinks”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/backend/utils”
make[1]: 离开目录“/opt/postgresql-12.11/src/backend”
make -C src/test/regress installcheck
make[1]: 进入目录“/opt/postgresql-12.11/src/test/regress”
make -C ../../../src/port all
make[2]: 进入目录“/opt/postgresql-12.11/src/port”
make[2]: 对“all”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/port”
make -C ../../../src/common all
make[2]: 进入目录“/opt/postgresql-12.11/src/common”
make[2]: 对“all”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/common”
make -C ../../../contrib/spi
make[2]: 进入目录“/opt/postgresql-12.11/contrib/spi”
make[2]: 对“all”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/contrib/spi”
rm -rf ./testtablespace
mkdir ./testtablespace
../../../src/test/regress/pg_regress --inputdir=. --bindir='/u01/postgresql/12/bin' --dlpath=. --max-concurrent-tests=20 --schedule=./serial_schedule
(using postmaster on Unix socket, port 5432)
============== dropping database "regression" ==============
NOTICE: database "regression" does not exist, skipping
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test tablespace ... ok 165 ms
test boolean ... ok 37 ms
test char ... ok 29 ms
test name ... ok 23 ms
test varchar ... ok 11 ms
test text ... ok 23 ms
test int2 ... ok 11 ms
test int4 ... ok 24 ms
test int8 ... ok 19 ms
test oid ... ok 9 ms
test float4 ... ok 16 ms
test float8 ... ok 44 ms
test bit ... ok 27 ms
test numeric ... ok 138 ms
test txid ... ok 14 ms
test uuid ... ok 27 ms
test enum ... ok 45 ms
test money ... ok 21 ms
test rangetypes ... ok 143 ms
test pg_lsn ... ok 11 ms
test regproc ... ok 10 ms
test strings ... ok 60 ms
test numerology ... ok 21 ms
test point ... ok 19 ms
test lseg ... ok 17 ms
test line ... ok 9 ms
test box ... ok 41 ms
test path ... ok 17 ms
test polygon ... ok 141 ms
test circle ... ok 11 ms
test date ... ok 46 ms
test time ... ok 10 ms
test timetz ... ok 9 ms
test timestamp ... ok 346 ms
test timestamptz ... ok 377 ms
test interval ... ok 35 ms
test inet ... ok 29 ms
test macaddr ... ok 22 ms
test macaddr8 ... ok 24 ms
test tstypes ... ok 24 ms
test geometry ... ok 42 ms
test horology ... ok 41 ms
test regex ... ok 543 ms
test oidjoins ... ok 94 ms
test type_sanity ... ok 62 ms
test opr_sanity ... ok 131 ms
test misc_sanity ... ok 18 ms
test comments ... ok 28 ms
test expressions ... ok 23 ms
test create_function_1 ... ok 11 ms
test create_type ... ok 23 ms
test create_table ... ok 233 ms
test create_function_2 ... ok 10 ms
test copy ... ok 214 ms
test copyselect ... ok 24 ms
test copydml ... ok 24 ms
test insert ... ok 222 ms
test insert_conflict ... ok 97 ms
test create_misc ... ok 97 ms
test create_operator ... ok 17 ms
test create_procedure ... ok 25 ms
test create_index ... ok 462 ms
test create_index_spgist ... ok 227 ms
test create_view ... ok 142 ms
test index_including ... ok 70 ms
test index_including_gist ... ok 205 ms
test create_aggregate ... ok 17 ms
test create_function_3 ... ok 28 ms
test create_cast ... ok 14 ms
test constraints ... ok 84 ms
test triggers ... ok 418 ms
test select ... ok 43 ms
test inherit ... ok 271 ms
test typed_table ... ok 44 ms
test vacuum ... ok 147 ms
test drop_if_exists ... ok 51 ms
test updatable_views ... ok 299 ms
test roleattributes ... ok 27 ms
test create_am ... ok 31 ms
test hash_func ... ok 11 ms
test errors ... ok 12 ms
test infinite_recurse ... ok 383 ms
test sanity_check ... ok 85 ms
test select_into ... ok 38 ms
test select_distinct ... ok 21 ms
test select_distinct_on ... ok 7 ms
test select_implicit ... ok 19 ms
test select_having ... ok 19 ms
test subselect ... ok 105 ms
test union ... ok 63 ms
test case ... ok 38 ms
test join ... ok 206 ms
test aggregates ... ok 130 ms
test transactions ... ok 51 ms
test random ... ok 24 ms
test portals ... ok 61 ms
test arrays ... ok 115 ms
test btree_index ... ok 183 ms
test hash_index ... ok 109 ms
test update ... ok 206 ms
test delete ... ok 20 ms
test namespace ... ok 15 ms
test prepared_xacts ... ok 24 ms
test brin ... ok 141 ms
test gin ... ok 125 ms
test gist ... ok 666 ms
test spgist ... ok 305 ms
test privileges ... ok 383 ms
test init_privs ... ok 16 ms
test security_label ... ok 115 ms
test collate ... ok 199 ms
test matview ... ok 225 ms
test lock ... ok 41 ms
test replica_identity ... ok 60 ms
test rowsecurity ... ok 222 ms
test object_address ... ok 57 ms
test tablesample ... ok 33 ms
test groupingsets ... ok 78 ms
test drop_operator ... ok 19 ms
test password ... ok 58 ms
test identity ... ok 80 ms
test generated ... ok 151 ms
test join_hash ... ok 572 ms
test create_table_like ... ok 133 ms
test alter_generic ... ok 66 ms
test alter_operator ... ok 18 ms
test misc ... ok 46 ms
test async ... ok 7 ms
test dbsize ... ok 7 ms
test misc_functions ... ok 282 ms
test sysviews ... ok 38 ms
test tsrf ... ok 28 ms
test tid ... ok 24 ms
test tidscan ... ok 24 ms
test rules ... ok 209 ms
test psql ... ok 99 ms
test psql_crosstab ... ok 20 ms
test amutils ... ok 10 ms
test stats_ext ... ok 448 ms
test select_parallel ... ok 464 ms
test write_parallel ... ok 67 ms
test publication ... ok 59 ms
test subscription ... ok 23 ms
test select_views ... ok 59 ms
test portals_p2 ... ok 11 ms
test foreign_key ... ok 478 ms
test cluster ... ok 752 ms
test dependency ... ok 51 ms
test guc ... ok 34 ms
test bitmapops ... ok 197 ms
test combocid ... ok 75 ms
test tsearch ... ok 123 ms
test tsdicts ... ok 79 ms
test foreign_data ... ok 239 ms
test window ... ok 96 ms
test xmlmap ... ok 30 ms
test functional_deps ... ok 29 ms
test advisory_lock ... ok 10 ms
test indirect_toast ... ok 114 ms
test equivclass ... ok 54 ms
test json ... ok 81 ms
test jsonb ... ok 114 ms
test json_encoding ... ok 10 ms
test jsonpath ... ok 16 ms
test jsonpath_encoding ... ok 12 ms
test jsonb_jsonpath ... ok 44 ms
test plancache ... ok 40 ms
test limit ... ok 19 ms
test plpgsql ... ok 303 ms
test copy2 ... ok 52 ms
test temp ... ok 58 ms
test domain ... ok 139 ms
test rangefuncs ... ok 90 ms
test prepare ... ok 26 ms
test conversion ... ok 20 ms
test truncate ... ok 119 ms
test alter_table ... ok 711 ms
test sequence ... ok 62 ms
test polymorphism ... ok 61 ms
test rowtypes ... ok 75 ms
test returning ... ok 26 ms
test largeobject ... ok 96 ms
test with ... ok 78 ms
test xml ... ok 45 ms
test partition_join ... ok 186 ms
test partition_prune ... ok 328 ms
test reloptions ... ok 35 ms
test hash_part ... ok 21 ms
test indexing ... ok 340 ms
test partition_aggregate ... ok 301 ms
test partition_info ... ok 40 ms
test event_trigger ... ok 69 ms
test fast_default ... ok 106 ms
test stats ... ok 615 ms
=======================
All 194 tests passed.
=======================
make[1]: 离开目录“/opt/postgresql-12.11/src/test/regress”
[postgres@vm-centos79 postgresql-12.11]$
指定并发度MAX_CONNECTIONS=10 执行测试
[postgres@vm-centos79 postgresql-12.11]$ make MAX_CONNECTIONS=10 installcheck
make -C ./src/backend generated-headers
make[1]: 进入目录“/opt/postgresql-12.11/src/backend”
make -C catalog distprep generated-header-symlinks
make[2]: 进入目录“/opt/postgresql-12.11/src/backend/catalog”
make[2]: 对“distprep”无需做任何事。
make[2]: 对“generated-header-symlinks”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/backend/catalog”
make -C utils distprep generated-header-symlinks
make[2]: 进入目录“/opt/postgresql-12.11/src/backend/utils”
make[2]: 对“distprep”无需做任何事。
make[2]: 对“generated-header-symlinks”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/backend/utils”
make[1]: 离开目录“/opt/postgresql-12.11/src/backend”
make -C src/test/regress installcheck
make[1]: 进入目录“/opt/postgresql-12.11/src/test/regress”
make -C ../../../src/port all
make[2]: 进入目录“/opt/postgresql-12.11/src/port”
make[2]: 对“all”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/port”
make -C ../../../src/common all
make[2]: 进入目录“/opt/postgresql-12.11/src/common”
make[2]: 对“all”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/src/common”
make -C ../../../contrib/spi
make[2]: 进入目录“/opt/postgresql-12.11/contrib/spi”
make[2]: 对“all”无需做任何事。
make[2]: 离开目录“/opt/postgresql-12.11/contrib/spi”
rm -rf ./testtablespace
mkdir ./testtablespace
../../../src/test/regress/pg_regress --inputdir=. --bindir='/u01/postgresql/12/bin' --dlpath=. --max-concurrent-tests=20 --schedule=./serial_schedule
(using postmaster on Unix socket, port 5432)
============== dropping database "regression" ==============
DROP DATABASE
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test tablespace ... ok 166 ms
test boolean ... ok 26 ms
test char ... ok 9 ms
test name ... ok 20 ms
test varchar ... ok 10 ms
test text ... ok 23 ms
test int2 ... ok 10 ms
test int4 ... ok 13 ms
test int8 ... ok 18 ms
test oid ... ok 9 ms
test float4 ... ok 17 ms
test float8 ... ok 70 ms
test bit ... ok 27 ms
test numeric ... ok 137 ms
test txid ... ok 13 ms
test uuid ... ok 17 ms
test enum ... ok 46 ms
test money ... ok 14 ms
test rangetypes ... ok 148 ms
test pg_lsn ... ok 28 ms
test regproc ... ok 16 ms
test strings ... ok 57 ms
test numerology ... ok 13 ms
test point ... ok 15 ms
test lseg ... ok 14 ms
test line ... ok 10 ms
test box ... ok 44 ms
test path ... ok 15 ms
test polygon ... ok 183 ms
test circle ... ok 11 ms
test date ... ok 26 ms
test time ... ok 10 ms
test timetz ... ok 9 ms
test timestamp ... ok 359 ms
test timestamptz ... ok 386 ms
test interval ... ok 39 ms
test inet ... ok 24 ms
test macaddr ... ok 13 ms
test macaddr8 ... ok 16 ms
test tstypes ... ok 19 ms
test geometry ... ok 33 ms
test horology ... ok 33 ms
test regex ... ok 319 ms
test oidjoins ... ok 49 ms
test type_sanity ... ok 66 ms
test opr_sanity ... ok 174 ms
test misc_sanity ... ok 16 ms
test comments ... ok 6 ms
test expressions ... ok 17 ms
test create_function_1 ... ok 20 ms
test create_type ... ok 16 ms
test create_table ... ok 232 ms
test create_function_2 ... ok 8 ms
test copy ... ok 212 ms
test copyselect ... ok 17 ms
test copydml ... ok 19 ms
test insert ... ok 228 ms
test insert_conflict ... ok 124 ms
test create_misc ... ok 94 ms
test create_operator ... ok 15 ms
test create_procedure ... ok 25 ms
test create_index ... ok 493 ms
test create_index_spgist ... ok 203 ms
test create_view ... ok 135 ms
test index_including ... ok 70 ms
test index_including_gist ... ok 154 ms
test create_aggregate ... ok 19 ms
test create_function_3 ... ok 28 ms
test create_cast ... ok 11 ms
test constraints ... ok 84 ms
test triggers ... ok 424 ms
test select ... ok 22 ms
test inherit ... ok 274 ms
test typed_table ... ok 37 ms
test vacuum ... ok 120 ms
test drop_if_exists ... ok 27 ms
test updatable_views ... ok 313 ms
test roleattributes ... ok 20 ms
test create_am ... ok 35 ms
test hash_func ... ok 13 ms
test errors ... ok 12 ms
test infinite_recurse ... ok 157 ms
test sanity_check ... ok 77 ms
test select_into ... ok 31 ms
test select_distinct ... ok 11 ms
test select_distinct_on ... ok 6 ms
test select_implicit ... ok 13 ms
test select_having ... ok 10 ms
test subselect ... ok 67 ms
test union ... ok 49 ms
test case ... ok 16 ms
test join ... ok 192 ms
test aggregates ... ok 107 ms
test transactions ... ok 55 ms
test random ... ok 12 ms
test portals ... ok 48 ms
test arrays ... ok 89 ms
test btree_index ... ok 153 ms
test hash_index ... ok 150 ms
test update ... ok 490 ms
test delete ... ok 12 ms
test namespace ... ok 13 ms
test prepared_xacts ... ok 19 ms
test brin ... ok 140 ms
test gin ... ok 108 ms
test gist ... ok 423 ms
test spgist ... ok 145 ms
test privileges ... ok 304 ms
test init_privs ... ok 6 ms
test security_label ... ok 12 ms
test collate ... ok 50 ms
test matview ... ok 127 ms
test lock ... ok 21 ms
test replica_identity ... ok 56 ms
test rowsecurity ... ok 251 ms
test object_address ... ok 36 ms
test tablesample ... ok 26 ms
test groupingsets ... ok 41 ms
test drop_operator ... ok 10 ms
test password ... ok 75 ms
test identity ... ok 80 ms
test generated ... ok 143 ms
test join_hash ... ok 533 ms
test create_table_like ... ok 149 ms
test alter_generic ... ok 54 ms
test alter_operator ... ok 13 ms
test misc ... ok 48 ms
test async ... ok 5 ms
test dbsize ... ok 9 ms
test misc_functions ... ok 22 ms
test sysviews ... ok 19 ms
test tsrf ... ok 21 ms
test tid ... ok 18 ms
test tidscan ... ok 42 ms
test rules ... ok 564 ms
test psql ... ok 96 ms
test psql_crosstab ... ok 18 ms
test amutils ... ok 11 ms
test stats_ext ... ok 499 ms
test select_parallel ... ok 533 ms
test write_parallel ... ok 28 ms
test publication ... ok 46 ms
test subscription ... ok 14 ms
test select_views ... ok 58 ms
test portals_p2 ... ok 8 ms
test foreign_key ... ok 490 ms
test cluster ... ok 235 ms
test dependency ... ok 34 ms
test guc ... ok 26 ms
test bitmapops ... ok 128 ms
test combocid ... ok 16 ms
test tsearch ... ok 73 ms
test tsdicts ... ok 25 ms
test foreign_data ... ok 223 ms
test window ... ok 98 ms
test xmlmap ... ok 22 ms
test functional_deps ... ok 21 ms
test advisory_lock ... ok 8 ms
test indirect_toast ... ok 116 ms
test equivclass ... ok 33 ms
test json ... ok 54 ms
test jsonb ... ok 111 ms
test json_encoding ... ok 9 ms
test jsonpath ... ok 19 ms
test jsonpath_encoding ... ok 6 ms
test jsonb_jsonpath ... ok 30 ms
test plancache ... ok 34 ms
test limit ... ok 20 ms
test plpgsql ... ok 295 ms
test copy2 ... ok 55 ms
test temp ... ok 48 ms
test domain ... ok 148 ms
test rangefuncs ... ok 83 ms
test prepare ... ok 16 ms
test conversion ... ok 8 ms
test truncate ... ok 121 ms
test alter_table ... ok 695 ms
test sequence ... ok 64 ms
test polymorphism ... ok 65 ms
test rowtypes ... ok 66 ms
test returning ... ok 19 ms
test largeobject ... ok 101 ms
test with ... ok 62 ms
test xml ... ok 34 ms
test partition_join ... ok 162 ms
test partition_prune ... ok 327 ms
test reloptions ... ok 34 ms
test hash_part ... ok 15 ms
test indexing ... ok 365 ms
test partition_aggregate ... ok 253 ms
test partition_info ... ok 26 ms
test event_trigger ... ok 75 ms
test fast_default ... ok 94 ms
test stats ... ok 566 ms
=======================
All 194 tests passed.
=======================
make[1]: 离开目录“/opt/postgresql-12.11/src/test/regress”
[postgres@vm-centos79 postgresql-12.11]$
扫一扫
6万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
