Fix planner statistics and manages query plans

Fork

Add English document.

Added a set of English version of the document based on the
just-revised Japanese docuemnt.

Edit Japanese documents.

Make it up to date, fixed some wrong descriptions and removed some
items with less importance.

Make pg_dbms_stats workable for PG11

This commit let it follow to the cahnges on the master HEAD and rig
with a complete set of subsidiary files.

Update spec files for 1.3.9 release.

Update rpm spec files for 1.3.9 release.

Properly set privilege information to VariableStatData

As the fix for CVE-2017-7484, VariableStatData is required to be set
acl_ok properly and the locked stats will not be in effect if not. As
the result, pg_dbms_stats 1.3.8 doesn't work for the minor versions
since 9.2.21, 9.3.17, 9.4.12, 9.5.7 and 9.6.3. PG10 behaves so from
the first version. This commit fixes that.

The binaries built for the fixed versions can be loaded and work fine
on all minor versions containing pre-fixed versions, but the binaries
built for the pre-fixed versions still has the problem

The regression test was missing whether locked stats is 'actually
applied or not. The test items for the case is added.

The version is updated to 1.3.9.

Fix a misspelling in regression test

Version bumped up to 1.3.8.

Mainly for management reasons, version of pg_dbms_stats bumped up to
1.3.8. Since no functional changes has taken place, the change is made
only for the PostgreSQL 10 build. Other builds will be bumped up in
the future releases if any.

Prevent regtest being affected by autovacuum

The result of a test query in ut-common can contain an excessive
output caused by autovacuum. Excluded it to prevent regtest from
being disturbed.

Prepare RPM package build environment for Pg10

Added a spec file. Edited Makefile so that tar ball contains required
files for Pg10 version of pg_dbms_stats.

Add --build-id flag mandatory for RPM package build

Set flags for ld mandated by rpmbuild.

Drop support for PostgreSQL 9.1

9.1 has already been out of support so pg_dbms_stats will no longer be
updated for the PostgreSQL version. Several files and many branches in
C code required to support the version are removed by this commit.

Update copyright notice.

Change the year of the copyright notices.

Support PostgreSQL 10 beta 1

Just followed the changes made in PostgreSQL 10. Exnteded statistics
are not supported so far.

Stabilize regression test

Add ORDER BY to several queries that gave results in different
order. Separate pg_stat_reset() from other queries for sure resetting
of stats.

Update copyright notice

Update copyright notices in several files that have left unchaged so
far.

Support PostgreSQL9.6

No functional change needed so this patch just adds subsidary files
and edit Makefile so as to build and make RPM packages for PG9.6.

Tomokuni Fujita

Add .gitignore entries for file generated by building RPM files

Some .tar.gz files and RPMS directory are generated by "make rpms" but
should be ignored by git. Added them to .gitignore.

Merge pull request #36280 (fujii_masao/pg_dbms_stats/master into master).

Add .gitignore entries for files generated by build and regression test.

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)

Prepare for release 1.3.7

Support PostgreSQL 9.5.0.

Added support for PostgreSQL 9.5.0.

Refactor Makefile

Simplified Makefile. Makefile gets too complex and ugly so refactored
it for readability. This change also allows to share some script among
multiple PG versions if possible.

Follow the change of regression test framework.

pg_regress no longer installs extra modules since 9.5. This commit
makes Makefile to give --extra-install flag to pg_regress only when
required.

Remove misplaced space.

Removed a misplaced space placed after continuation backslash.

Rename a static function to avoid conflict.

CopyArrayEls is a static function but also has a definition for
different function in core header. Rename it CopyAnyArrayEls so that
compler doesn't complain.

Catch up the change of representation of view definition.

Representation of view definition was changed at 9.3.5 by commit
164acbe33c0951221b1ae2e5285c793f404a75a1.

Stabilize regression test.

Sort results to avoid altering of tuples in regression test.

Allow dbms_stats.prepare_statstweak() to take multi-word type names.

The function ends up with an error being given type names consists of
more than a word. This commit makes the spaces between keywords to be
replaced with underscores. The function takes the parameter as regtype
so every white space consists of exactly one space. Therefore
considering only the single-space case is enough.

Merge branch 'anyarray_work' of https://scm.sourceforge.jp/gitroot/pgdbmsstats/pg_dbms_stats into anyarray_work