pg_dbms_stats

Fork

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

Add subsidiary functions to tweak dummy statistics.

pg_statictics has some columns of anyarray which cannot be updated
through ordinary SQL statements and dbms_stats.column_stats_locked
inherits the characteristic. Though, it is inconvenient for those who
wants to tweak statistics, especially MCV, HISTOGRAM and like which
are of anyarray type.

This commit adds some functions to handle dbms_stats.anyarray to
enable them to write dummy (locked) statistics by hand.

Anyarray values can be updated by steps like following.

=# SELECT dbms_stats.anyarray_basetype(stavalues1)
FROM dbms_stats.column_stats_locked
WHERE starelid = xxxx AND staattnum = x;
anyarray_basetype
-------------------
float4
(1 row)
=# SELECT dbms_stats.prepare_statstweak('float4');
-------------------------------------------------------------------------------
----
(func dbms_stats._realary_anyarray(real[]), cast (real[] AS dbms_stats.anyarra
y))
(1 row)
=# UPDATE dbms_stats.column_stats_locked
SET stavalues1 = '{1.1,2.2,3.3}'::float4[]
WHERE starelid = xxxx AND staattnum = x;
UPDATE 1

Support for 9.4 added officially.

Since PostgreSQL REL9_4_0 has been released, pg_dbms_stats became to
support 9.4. There's no functional change made and some fixes in the
steps to build RPM packages has been made.

Add subsidiary functions to tweak dummy statistics.

pg_statictics has some columns of anyarray which cannot be updated
through ordinary SQL statements and dbms_stats.column_stats_locked
inherits the characteristic. Though, it is inconvenient for those who
wants to tweak statistics, especially MCV, HISTOGRAM and like which
are of anyarray type.

This commit adds some functions to handle dbms_stats.anyarray to
enable them to write dummy (locked) statistics by hand.

Anyarray values can be updated by steps like following.

=# SELECT dbms_stats.anyarray_basetype(stavalues1)
FROM dbms_stats.column_stats_locked
WHERE starelid = xxxx AND staattnum = x;
anyarray_basetype
-------------------
float4
(1 row)
=# SELECT dbms_stats.prepare_statstweak('float4');
-------------------------------------------------------------------------------
----
(func dbms_stats._realary_anyarray(real[]), cast (real[] AS dbms_stats.anyarra
y))
(1 row)
=# UPDATE dbms_stats.column_stats_locked
SET stavalues1 = '{1.1,2.2,3.3}'::float4[]
WHERE starelid = xxxx AND staattnum = x;
UPDATE 1

Fix release date of 1.3.6 in SPEC files.

Fixed regression tests to avoid test failure for 9.1.

A test item added in ut-common at 1.3.5 failed for 9.1 because the
error message differs from later versions. Moved it to
version-specific tests.

Fixed import function according to the current stats table
configuration.

The stats tables prefixed by underscore have been removed in the last
release, but import function did not follow that change. It results in
failure of import_xxx_stats() for dump files of any version including
itself.

Fix target version of 9.4 regtests, which was no harm.

Prepare for 1.3.6

Change release number of spec files to 2.

The previous release was based on the funcion-version of
HeapTupleGetDatum() so they cannot be loaded on the minor versions
earlier than 9.1.14, 9.2.9 and 9.3.5 with link failure of
HeapTupleHeaderGetDatum.

I confirmed that the commit(*1) does not affect pg_dbms_stats and
decided to build rpm releases on 9.1.13, 9.2.8 and 9.3.4 after this.

There has been one bug after 1.3.5 was released but it is a bug in
error message of rarely used SQL function so no increment of version
number.

*1: d3c9f9c5b57d2a8a7ab065a6b942703854ec5e97 for 9.1
315442c01156d4f6c0f766ec51da090a613d03b8 for 9.2
edde59db1339397ec389d45e4c0d0f86064dad1a for 9.3
621a99a666ba1a27b852dc5ddc0e1b224c388f53 on master branch

Fix exception messages.

Exception messages in definitions of dbms_stats.restore(bid, relname,
colname) were incorrect. This causes incomprehensive message like this,

ERROR: too many parameters specified for RAISE

There's no harm other than the bogus message.

Edit ChangeLogs. Fixed some misspellings.

Correct permission of dummy statistics tables.

On the current implement, when planner requested the statistics
for a column, pg_dbms_stats takes it from the dummy statistics
tables via views which gives stats only of columns that the
current user can SELECT.
Under that way of restriction, pg_dbms_stats cannot read the
dummy statistcs of objects invisible from the current user so
accessing such objects via views will done using system
statistics, even if their statistics are locked.
This commit makes the dummy stats tables visible only by the
owner, then makes pg_dbms_stats access the dummy statistics as
the owner. It also changes the visibility/usability of some other
objects such as dbms_stats schema, some functions as a result.

Fix and modify regression test.

The delay of stats collector is expected up to 0.5s so 0.5s is not
enough for waiting.

Make environment for 1.3.5

Update RPM release number to 2.

default_version of pg_dbms_stats.control is corrected.

Version 1.3.4

Fix a bug that faultily invalidates stored stats for inheritance parents.

Internal on-memory cache mechanism wrongly handled stainherit
flag. This is resulted in a false response for inheritance parents,
which let the planner use the real statistic instead of the stored
one.