• R/O
  • HTTP
  • SSH

pg_hint_plan: List of commits

firtst release

Rev. Time Author
8c71c47 PG92 REL92_1_1_3 2014-12-22 21:06:37 Kyotaro Horiguchi

Prepare for 1.1.3.

90830fa 2014-12-22 20:51:43 Kyotaro Horiguchi

Fixed a bug related to SQL statements in PL/pgSQL functions.

At least since 9.1, true query strings of SQL statements executed in
PL/pgSQL functions were found that were not obtained correctly by the
previous implement, it is because that PLpgSQL_stmt variable did not
have proper query string to be read for hints. Instead, it is changed
to read them from the top of error_context_stack in
pg_hint_plan_planner(). This change made a slight difference in
behavior which doesn't affect its work so a part of the regtest was
also changed. And added some regression tests for it.

Regression tests for PL/pgSQL added.

Tests for defined PL/pgSQL functions are omitted from regression
tests so added it.

b27943b 2014-12-22 20:51:09 Kyotaro Horiguchi

Fix the method to write query number in debug print.

Query numbers in debug output should be written using qnostr, not qno.

b52b491 REL92_1_1_2 2014-12-19 16:11:21 Kyotaro Horiguchi

Prepare for release 1.1.2.

224510a 2014-12-19 16:11:21 Kyotaro Horiguchi

Remove unnecessary tracker code from documentations.

b9e6db7 2014-12-19 15:55:10 Kyotaro Horiguchi

Added English documentation.

b2d04ea 2014-12-19 15:55:10 Kyotaro Horiguchi

Some fix and addition to the japaneses document.

It lacked the description about joni direction enforcement so added
it. Addition to it, added html language specification and updated
target PostgreSQL versions and OS version.

da636e5 2014-12-17 10:49:22 Kyotaro Horiguchi

Fix to remove plpgsql query string on non-local exit.

Pl/pgsql query string stored internally squatted after an execution
error then pg_hint_plan afterward read it for hints and ignores really
given ones. This commit makes it erased at the end of transaction.

e0c4be9 2014-12-17 10:41:48 Kyotaro Horiguchi

Fix about unexpectedly living plpgsql query string.

pg_hint_plan forgot to erase plpgsql query strings when it is NOT a
static statement, so it continued to read hints from the remenbered
wrong query string after using dynamic execution of a statement. This
commit makes it to be erased for any types of pl/pgsql statement.

0a400e6 2014-12-16 16:58:38 Kyotaro Horiguchi

Enhance debug output.

Added new debug output levels detailed and verbose. These let you see
more verbose information about what pg_hint_plan does internally.

a284f79 REL92_1_1_1 2014-09-18 11:58:11 Kyotaro Horiguchi

Fix a bug that index restriction by name doesn't work for UPDATEs on
inheritance parent.

Inheritance planner doesn't claim for the inheritance parent relation,
so pg_hint_plan_get_relation_info cannot have the chance to prepare
the index spec information for chlid relations. This change make the
function to try to find parent relation even if it is called for the
children with inhparent == false from the first.

d84beeb 2014-09-17 15:26:57 Kyotaro Horiguchi

Stabilize regtest

7dbca52 2014-09-17 11:49:38 Kyotaro Horiguchi

Remove unused struct member

a1fd9fb 2014-09-05 13:22:09 Kyotaro Horiguchi

RPM automation

3ef56b7 2014-09-05 13:21:52 Kyotaro Horiguchi

Change version to 1.1.1.

7cd601e 2014-09-05 13:20:04 Kyotaro Horiguchi

Fixed a bug that rows hint can be omitted on some condition.

A hint for higer level may be canceled by unnecessary reestimation
caused by a rows hint for lower level.

During making a joinrel, if there's a rows hint just matches the
joinrelids, and has already been applied on an earlier try for the same
joinrelids, and if there's another rows hint which is applicable on
either component of the join, the change of rownums made earlier is
canceled by the 'another' hint causing reestimation of the joinrel.
Finally the effect of the former hint disappears.

ce19272 2014-01-30 15:42:06 Takashi Suzuki


5e5bbe2 2014-01-24 11:21:46 Takashi Suzuki



33c8421 2014-01-24 11:18:54 Takashi Suzuki


356c4f7 2014-01-21 11:43:05 Takashi Suzuki


6225c96 2014-01-20 16:14:18 Takashi Suzuki


7342e27 2014-01-20 16:10:51 Takashi Suzuki


2c3793d 2014-01-20 13:31:29 Takashi Suzuki



b051e3c 2014-01-20 11:09:56 Takashi Suzuki


2ca7f98 2014-01-17 17:20:56 Takashi Suzuki


d2ef83e 2014-01-17 17:16:36 Takashi Suzuki


04dfdb1 2014-01-17 17:12:28 Takashi Suzuki



a7c3fa5 2014-01-17 16:57:06 Takashi Suzuki

bug fix #3

59a7733 2014-01-17 16:56:40 Takashi Suzuki

bug fix #2



636ab52 2014-01-17 16:53:07 Takashi Suzuki



Show on old repository browser