|
49 | 49 |
|
50 | 50 | <listitem> |
51 | 51 | <!-- |
52 | | -Author: Robert Haas <rhaas@postgresql.org> |
53 | | -2016-11-30 [6d46f4783] Improve hash index bucket split behavior. |
54 | | -Author: Robert Haas <rhaas@postgresql.org> |
55 | | -2017-02-07 [293e24e50] Cache hash index's metapage in rel->rd_amcache. |
56 | | -Author: Robert Haas <rhaas@postgresql.org> |
57 | | -2017-02-27 [b0f18cb77] hash: Refactor bucket squeeze code. |
58 | | -Author: Robert Haas <rhaas@postgresql.org> |
59 | | -2017-02-27 [30df93f69] hash: Refactor overflow page allocation. |
60 | | -Author: Robert Haas <rhaas@postgresql.org> |
61 | | -2017-04-03 [ea69a0dea] Expand hash indexes more gradually. |
| 52 | +Created from "Improve hash bucket split performance" item |
62 | 53 | --> |
63 | 54 | <para> |
64 | | -Improve hash bucket split performance by reducing locking requirements |
65 | | -(Amit Kapila, Mithun Cy) |
| 55 | +<application>pg_upgrade</>-ed hash indexes from previous major Postgres versions must be rebuilt. |
66 | 56 | </para> |
67 | 57 |
|
68 | 58 | <para> |
69 | | -Also cache hash index meta-information for faster lookups. Additional |
70 | | -hash performance improvements have also been made. <application>pg_upgrade</>'d hash |
71 | | -indexes from previous major Postgres versions must be rebuilt. |
| 59 | +Major hash index performance improvements necessitated this requirement. |
72 | 60 | </para> |
73 | 61 | </listitem> |
74 | 62 |
|
@@ -475,6 +463,30 @@ warning message about their use. |
475 | 463 | </para> |
476 | 464 | </listitem> |
477 | 465 |
|
| 466 | +<listitem> |
| 467 | +<!-- |
| 468 | +Author: Robert Haas <rhaas@postgresql.org> |
| 469 | +2016-11-30 [6d46f4783] Improve hash index bucket split behavior. |
| 470 | +Author: Robert Haas <rhaas@postgresql.org> |
| 471 | +2017-02-07 [293e24e50] Cache hash index's metapage in rel->rd_amcache. |
| 472 | +Author: Robert Haas <rhaas@postgresql.org> |
| 473 | +2017-02-27 [b0f18cb77] hash: Refactor bucket squeeze code. |
| 474 | +Author: Robert Haas <rhaas@postgresql.org> |
| 475 | +2017-02-27 [30df93f69] hash: Refactor overflow page allocation. |
| 476 | +Author: Robert Haas <rhaas@postgresql.org> |
| 477 | +2017-04-03 [ea69a0dea] Expand hash indexes more gradually. |
| 478 | +--> |
| 479 | +<para> |
| 480 | +Improve hash bucket split performance by reducing locking requirements |
| 481 | +(Amit Kapila, Mithun Cy) |
| 482 | +</para> |
| 483 | + |
| 484 | +<para> |
| 485 | +Also cache hash index meta-information for faster lookups. Additional |
| 486 | +hash performance improvements have also been made. |
| 487 | +</para> |
| 488 | +</listitem> |
| 489 | + |
478 | 490 | <listitem> |
479 | 491 | <!-- |
480 | 492 | Author: Robert Haas <rhaas@postgresql.org> |
|