OSDN Git Service

Add stats-injection feature.
authorKyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
Fri, 25 Mar 2016 06:44:20 +0000 (15:44 +0900)
committerKyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
Fri, 25 Mar 2016 06:52:10 +0000 (15:52 +0900)
commit1fb9bb99423091704123fa0c71263b462241e424
tree9af6b89903f5aec352a34d645dd6b291091c3fae
parenta913d5fa59708bbf0823864a6a3d565042fc907f
Add stats-injection feature.

pg_dbms_stats potentially have an ability to give arbitrary stats to
the planner but some stats items are of anyarray type so they were
impossible to be modified using SQL commands. This commit provides
some subsidiary functions that enable administrators to modify
anyarray stuffs in dbms_stats.column_stats_locked by arbitrary values.
(Only Japanese doc is provided so far)
20 files changed:
Makefile
doc/pg_dbms_stats-ja.html [changed mode: 0644->0755]
expected/init-9.5.out [new file with mode: 0644]
expected/ut-9.5.out [new file with mode: 0644]
expected/ut-common.out
ext_scripts/pg_dbms_stats--1.3.6--1.3.7-9.1.sql
ext_scripts/pg_dbms_stats--1.3.6--1.3.7-9.2.sql
ext_scripts/pg_dbms_stats--1.3.6--1.3.7-9.3.sql
ext_scripts/pg_dbms_stats--1.3.6--1.3.7-9.4.sql
ext_scripts/pg_dbms_stats--1.3.7-9.1.sql
ext_scripts/pg_dbms_stats--1.3.7-9.2.sql
ext_scripts/pg_dbms_stats--1.3.7-9.3.sql
ext_scripts/pg_dbms_stats--1.3.7-9.4.sql
ext_scripts/pg_dbms_stats--1.3.7-9.5.sql
input/ut_imp_exp-9.5.source [new file with mode: 0644]
output/ut_imp_exp-9.5.source [new file with mode: 0644]
pg_dbms_stats.c
sql/init-9.5.sql [new file with mode: 0644]
sql/ut-9.5.sql [new file with mode: 0644]
sql/ut-common.sql