1 (This file is obsolete. Please see commit messages instead.)
3 2014-11-13 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
4 * pg_dbms_stats.c: Fixed a bug that locked statistics won't be
5 effective when accessing tables without select privilege via
7 On the current implement, when planner requested the statistics
8 for a column, pg_dbms_stats takes it from the dummy statistics
9 tables via views which gives stats only of columns that the
10 current user can SELECT.
11 Under that way it works, pg_dbms_stats cannot read the dummy
12 statistics of objects invisible from the current user so accessing
13 such objects via views will done using system statistics, even if
14 their statistics are locked.
15 In order to resolve the problem, privileges for the dummy stats
16 tables and the user under which pg_dbms_stats accesses them are
19 2014-11-06 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
20 * pg_dbms_stats.control: Correct default_version.
22 2014-09-16 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
23 * pg_dbms_stats.c: Fix a bug that inheritance state was wrongly
24 handled. This was resulted in a failure of statistics locking for
27 2014-08-25 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
28 * pg_dbms_stats.c: Fixed a bug that relation ids which are the
29 keys for the relation statistics cache was mistakenly treated as
30 strings. This causes a false match between oids having a
31 intermediate 0x00 byte and identical lower bytes (for the little
32 endian case). Returning the wrong statistics cache can result in
33 server crash, or at least unexpected plans.
34 * pg_dbms_stats-1.3.3.sql: Lock granularity for pg_dbms_stats's
35 operations was raised. Simultaneous lock operations on different
36 tables no longer block each other.
38 2014-06-06 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
39 * pg_dbms_stats.c: pg_dbms_stats no more causes planner to access
40 repeatedly to the tables of pg_dbms_stats for nonexistent saved
41 statistics during considering access paths involving tables or
42 indexes that don't have their statistics 'lock'ed. This change
43 improves the performance especially for light weight (which means
44 taking less than a few milliseconds) queries on no-locked
47 * pg_dbms_stats.c: Fix a bug potentially causes SEGV crash.
49 * pg_dbms_stats--*.sql, pg_dbms_stats.control: Now declares the
50 right version to the extension framework. ALTER EXTENSION can be
51 used to upgrade from the older versions.
53 2013-11-07 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
54 * Fixed a bug potentially cause SEGV after changing column data
55 types on 'lock'ed tables
57 * Added clean_up_stats() function, which erases all saved
58 statistics left alone after deleting tables before unlocking
61 2013-11-07 Kyotaro Horiguchi <horiguchi.kyotaro@lab.ntt.co.jp>
62 * First published version.