Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit45e3d8a

Browse files
committed
doc: move hash info to new section and split out growth item
Reported-by: Amit Kapila
1 parentcef5dbb commit45e3d8a

File tree

1 file changed

+72
-52
lines changed

1 file changed

+72
-52
lines changed

‎doc/src/sgml/release-10.sgml

Lines changed: 72 additions & 52 deletions
Original file line numberDiff line numberDiff line change
@@ -49,14 +49,16 @@
4949

5050
<listitem>
5151
<!--
52-
Created from "Improve hash bucket split performance" item
52+
Copied here from this commit:
53+
Author: Robert Haas <rhaas@postgresql.org>
54+
2017-04-03 [ea69a0dea] Expand hash indexes more gradually.
5355
-->
5456
<para>
5557
<application>pg_upgrade</>-ed hash indexes from previous major Postgres versions must be rebuilt.
5658
</para>
5759

5860
<para>
59-
Major hashindex performance improvements necessitated this requirement.
61+
Major hashstorage improvements necessitated this requirement.
6062
</para>
6163
</listitem>
6264

@@ -450,130 +452,148 @@ processes for non-parallel purposes.
450452

451453
<listitem>
452454
<!--
453-
Author:Robert Haas <rhaas@postgresql.org>
454-
2017-03-14 [c11453ce0] hash: Add write-ahead loggingsupport.
455+
Author:Andrew Dunstan <andrew@dunslane.net>
456+
2017-03-31 [e306df7f9] Full Text Searchsupport for <type>JSON</> and <type>JSONB</>
455457
-->
456458
<para>
457-
Addwrite-ahead loggingsupportto hash indexes (Amit Kapila)
459+
Addfull text searchsupportfor <type>JSON</> and <type>JSONB</> (Dmitry Dolgov)
458460
</para>
459461

460462
<para>
461-
This makes hash indexes crash-safe and replicated, and removes the
462-
warning message about their use.
463+
This is accessed via <function>ts_headline()</> and to_tsvector. RIGHT SECTION?
463464
</para>
464465
</listitem>
465466

466467
<listitem>
467468
<!--
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.
469+
Author: Tom Lane <tgl@sss.pgh.pa.us>
470+
2016-08-23 [77e290682] Create an SP-GiST opclass for inet/cidr.
478471
-->
479472
<para>
480-
Improve hash bucket split performance by reducing locking requirements
481-
(Amit Kapila, Mithun Cy)
473+
Add <acronym>SP-GiST</> index support for <type>INET</> and <type>CIDR</> data types (Emre Hasegeli)
482474
</para>
483475

484476
<para>
485-
Also cache hash index meta-information for faster lookups. Additional
486-
hash performance improvements have also been made.
477+
These data types already had GiST support.
487478
</para>
488479
</listitem>
489480

490481
<listitem>
491482
<!--
492-
Author:Robert Haas <rhaas@postgresql.org>
493-
2017-03-15 [6977b8b7f] Port single-pagebtree vacuum logic to hash indexes.
483+
Author:Teodor Sigaev <teodor@sigaev.ru>
484+
2017-03-23 [218f51584] Reducepagelocking in <acronym>GIN</> vacuum
494485
-->
495486
<para>
496-
Allow single-pagehash pruning (Ashutosh Sharma)
487+
Reducepagelocking during vacuuming of <acronym>GIN</> indexes (Andrey Borodin)
497488
</para>
498489
</listitem>
499490

500491
<listitem>
501492
<!--
502-
Author:Andrew Dunstan <andrew@dunslane.net>
503-
2017-03-31 [e306df7f9] Full Text Search support for <type>JSON</> and <type>JSONB</>
493+
Author:Alvaro Herrera <alvherre@alvh.no-ip.org>
494+
2017-04-01 [7526e1022] BRIN auto-summarization
504495
-->
505496
<para>
506-
Add full text search support for <type>JSON</> and <type>JSONB</> (Dmitry Dolgov)
497+
Cause <acronym>BRIN</> index summarization to happen more aggressively (&Aacute;lvaro
498+
Herrera)
507499
</para>
508500

509501
<para>
510-
This is accessed via <function>ts_headline()</> and to_tsvector. RIGHT SECTION?
502+
Specifically, summarize the previous page range when a new page range is
503+
created.
511504
</para>
512505
</listitem>
513506

514507
<listitem>
515508
<!--
516-
Author:Tom Lane <tgl@sss.pgh.pa.us>
517-
2016-08-23 [77e290682] Create an SP-GiST opclass for inet/cidr.
509+
Author:Alvaro Herrera <alvherre@alvh.no-ip.org>
510+
2017-04-01 [c655899ba] BRIN de-summarization
518511
-->
519512
<para>
520-
Add <acronym>SP-GiST</> index support for <type>INET</> and <type>CIDR</> data types (Emre Hasegeli)
513+
Add function <function>brin_desummarize_range()</> to remove <acronym>BRIN</> summarization of a
514+
specified range (&Aacute;lvaro Herrera)
521515
</para>
522516

523517
<para>
524-
These data types already had GiST support.
518+
This allows future <acronym>BRIN</> index summarization to be more compact. CLARIFY
525519
</para>
526520
</listitem>
527521

522+
</itemizedlist>
523+
524+
<sect5>
525+
<title><link linkend="indexes-types">Hash Indexes</link></title>
526+
527+
<itemizedlist>
528+
528529
<listitem>
529530
<!--
530-
Author:Teodor Sigaev <teodor@sigaev.ru>
531-
2017-03-23 [218f51584] Reduce page locking in <acronym>GIN</> vacuum
531+
Author:Robert Haas <rhaas@postgresql.org>
532+
2017-03-14 [c11453ce0] hash: Add write-ahead logging support.
532533
-->
533534
<para>
534-
Reduce page locking during vacuuming of <acronym>GIN</> indexes (Andrey Borodin)
535+
Add write-ahead logging support to hash indexes (Amit Kapila)
536+
</para>
537+
538+
<para>
539+
This makes hash indexes crash-safe and replicated, and removes the
540+
warning message about their use.
535541
</para>
536542
</listitem>
537543

538544
<listitem>
539545
<!--
540-
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
541-
2017-04-01 [7526e1022] BRIN auto-summarization
546+
Author: Robert Haas <rhaas@postgresql.org>
547+
2016-11-30 [6d46f4783] Improve hash index bucket split behavior.
548+
Author: Robert Haas <rhaas@postgresql.org>
549+
2017-02-07 [293e24e50] Cache hash index's metapage in rel->rd_amcache.
550+
Author: Robert Haas <rhaas@postgresql.org>
542551
-->
543552
<para>
544-
Cause <acronym>BRIN</> index summarization to happen more aggressively (&Aacute;lvaro
545-
Herrera)
553+
Improve hash bucket split performance by reducing locking requirements
554+
(Amit Kapila, Mithun Cy)
546555
</para>
547556

548557
<para>
549-
Specifically, summarize the previous page range when a new page range is
550-
created.
558+
Also cache hash index meta-information for faster lookups.
551559
</para>
552560
</listitem>
553561

554562
<listitem>
555563
<!--
556-
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
557-
2017-04-01 [c655899ba] BRIN de-summarization
564+
Author: Robert Haas <rhaas@postgresql.org>
565+
2017-02-27 [b0f18cb77] hash: Refactor bucket squeeze code.
566+
Author: Robert Haas <rhaas@postgresql.org>
567+
2017-02-27 [30df93f69] hash: Refactor overflow page allocation.
568+
Author: Robert Haas <rhaas@postgresql.org>
569+
2017-04-03 [ea69a0dea] Expand hash indexes more gradually.
558570
-->
559571
<para>
560-
Add function <function>brin_desummarize_range()</> to remove <acronym>BRIN</> summarization of a
561-
specified range (&Aacute;lvaro Herrera)
572+
Improve efficiency of hash index growth (Amit Kapila, Mithun Cy)
562573
</para>
574+
</listitem>
563575

576+
<listitem>
577+
<!--
578+
Author: Robert Haas <rhaas@postgresql.org>
579+
2017-03-15 [6977b8b7f] Port single-page btree vacuum logic to hash indexes.
580+
-->
564581
<para>
565-
This allows future <acronym>BRIN</> index summarization to be more compact. CLARIFY
582+
Allow single-page hash pruning (Ashutosh Sharma)
566583
</para>
567584
</listitem>
568585

569-
</itemizedlist>
570-
571-
</sect4>
586+
</itemizedlist>
572587

573-
<sect4>
574-
<title>Locking</title>
588+
</sect5>
575589

576-
<itemizedlist>
590+
</sect4>
591+
592+
<sect4>
593+
594+
<title>Locking</title>
595+
596+
<itemizedlist>
577597

578598
<listitem>
579599
<!--

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp