Skip to content

PostgreSQL 11 New Features

GA source edition · 87 pages · 2018-10-22

WITH EXAMPLES · ENGLISH SOURCE EDITION

Explore the features, SQL examples, and compatibility changes documented by Noriyoshi Shinoda.

Start reading Print this bookOriginal PDF on GitHub
GA2018-10-2287 PDF pages13 chapters

Contents

Reference indexes

The opening chapter includes the first numbered table, Table 1. The indexes below collect the book’s other native numbered components.

Tables
  1. Table 1 — Version
  2. Table 2 — Examples notation
  3. Table 3 — Syntax rules
  4. Table 4 — Related parameter name
  5. Table 5 — Simple INSERT statement
  6. Table 6 — Simple UPDATE statement (No tuple movement between partitions)
  7. Table 7 — Simple DELETE statement
  8. Table 8 — TRUNCATE statement
  9. Table 9 — When a tuple is moved between partitions by executing an UPDATE statement
  10. Table 10 — INSERT ON CONFLICT DO NOTHING (With conflict)
  11. Table 11 — System catalogs with columns added
  12. Table 12 — Catalogs with columns deleted
  13. Table 13 — Value is now stored information_schema catalog of the schema
  14. Table 14 — Added ROLE
  15. Table 15 — Added hash functions
  16. Table 16 — Added parameters
  17. Table 17 — Changed configuration parameters
  18. Table 18 — Parameters with default values changed
  19. Table 19 — Obsoleted parameter
  20. Table 20 — Added parameters
  21. Table 21 — The Variable indicating execution result of SQL statement
  22. Table 22 — Default setting
  23. Table 23 — -C ORACLE setting
  24. Table 24 — Added options for pg_resetwal command
  25. Table 25 — Option for pg_controldata command
  26. Table 26 — Provided functions
Examples
  1. Example 1 — CREATE FUNCTION statement with WITH clause
  2. Example 2 — TO_NUMBER function
  3. Example 3 — TO_NUMBER function
  4. Example 4 — Parallel Hash
  5. Example 5 — Parallel Append
  6. Example 6 — Parallelization of CREATE TABLE AS SELECT statement
  7. Example 7 — Parallelization of CREATE MATERIALIZED VIEW statement
  8. Example 8 — Parallelization of SELECT INTO statement
  9. Example 9 — Create HASH Partitioned table
  10. Example 10 — Create partition
  11. Example 11 — Confirmation of table structure
  12. Example 12 — Error when there are not enough partitions
  13. Example 13 — Error in the INSERT statement
  14. Example 14 — Partition elimination
  15. Example 15 — Catalogs for Hash Partition table
  16. Example 16 — Creating DEFAULT partition (LIST partition)
  17. Example 17 — Attach DEFAULT partition (LIST partition)
  18. Example 18 — DEFAULT partition restriction
  19. Example 19 — UPDATE statement to move the partition (preparation of data)
  20. Example 20 — UPDATE statement to move partitions (update and confirm data)
  21. Example 21 — Create index
  22. Example 22 — Check auto-created index
  23. Example 23 — Attaching a table
  24. Example 24 — Individual deletion of automatically created index
  25. Example 25 — Create the primary key in the partitioned table
  26. Example 26 — Attached table and primary key
  27. Example 27 — Create primary key without partition key column
  28. Example 28 — Attach a table with a different primary key
  29. Example 29 — Partitions and Unique Constraints with FOREIGN TABLE
  30. Example 30 — Partitioned table and INSERT ON CONFLICT statement
  31. Example 31 — INSERT ON CONFLICT statement across partitions
  32. Example 32 — Execution plan in the default state
  33. Example 33 — Execution plan with Partition-Wise Join enabled
  34. Example 34 — Execution plan with Partition-Wise Aggregate enabled
  35. Example 35 — Partitioned table and Foreign key
  36. Example 36 — Executed SQL statement for test
  37. Example 37 — Execution plan on PostgreSQL 10
  38. Example 38 — Execution plan on PostgreSQL 11
  39. Example 39 — Control Partition Pruning
  40. Example 40 — Specify TRUNCATE clause in CREATE PUBLICATION statement
  41. Example 41 — Set replication start LSN to current LSN
  42. Example 42 — Refer pg_stat_activity catalog
  43. Example 43 — Refer pg_attribute catalog
  44. Example 44 — pg_read_server_files role
  45. Example 45 — Execution plan of SQL using JIT compilation features
  46. Example 46 — Test case
  47. Example 47 — Lock status on PostgreSQL 10
  48. Example 48 — Lock status on PostgreSQL 11
  49. Example 49 — pgproto definition file
  50. Example 50 — backup_label file
  51. Example 51 — Execution of LOCK TABLE statement for the view
  52. Example 52 — Executing LOCK TABLE statement to MATERIALIZED VIEW
  53. Example 53 — STATISTICS value for function index column
  54. Example 54 — Execution of VACUUM, ANALYZE statement for multiple tables
  55. Example 55 — Output "aggressively"
  56. Example 56 — Execution plan of PostgreSQL 10
  57. Example 57 — Execution plan of PostgreSQL 11
  58. Example 58 — INCLUDE clause with CREATE INDEX statement
  59. Example 59 — INCLUDE clause with CREATE TABLE statement
  60. Example 60 — The option of CREATE INDEX statement
  61. Example 61 — Storage option for CREATE TABLE statement
  62. Example 62 — Parallel query executed in EXPLAIN statement
  63. Example 63 — SHA512 hash function
  64. Example 64 — json_to_tsvector function
  65. Example 65 — websearch_to_tsquery function
  66. Example 66 — ^@ operator
  67. Example 67 — Casting from JSONB type
  68. Example 68 — PROCEDURE creation
  69. Example 69 — Execute PROCEDURE (1)
  70. Example 70 — Execute PROCEDURE (2)
  71. Example 71 — List of PROCEDURE
  72. Example 72 — Display PROCEDURE definition
  73. Example 73 — Transaction control in PROCEDURE
  74. Example 74 — CONSTANT clause and changing value error
  75. Example 75 — NOT NULL clause and initial value
  76. Example 76 — SET TRANSACTION statement
  77. Example 77 — Parameter parallel_leader_participation = on
  78. Example 78 — Parameter parallel_leader_participation = off
  79. Example 79 — Parameter log_parser_stats (Linux)
  80. Example 80 — \gdesc command
  81. Example 81 — SQL execution result variable
  82. Example 82 — String output declaration
  83. Example 83 — String output declaration
  84. Example 84 — Fetch the column data
  85. Example 85 — Specify DO CONTINUE clause
  86. Example 86 — initdb --wal-segsize option
  87. Example 87 — initdb --allow-group-access option
  88. Example 88 — pg_dumpall command with specifying the character encoding
  89. Example 89 — pg_ctl command
  90. Example 90 — pg_basebackup command
  91. Example 91 — Batch mode operation
  92. Example 92 — Usage of pg_verify_checksums command
  93. Example 93 — Execute pg_verify_checksums command
  94. Example 94 — Use amcheck module
  95. Example 95 — Create B-Tree Gin index
  96. Example 96 — Execution plan on PostgreSQL 10
  97. Example 97 — Execution plan on PostgreSQL 11
  98. Example 98 — jsonb_plpython module
  99. Example 99 — jsonb_plperl module
  100. Example 100 — bt_metap function
  101. Example 101 — strict_word_similarity function
  102. Example 102 — Partition with FOREIGN TABLE
  103. Example 103 — The behavior of PostgreSQL 10
  104. Example 104 — The behavior of PostgreSQL 11
  105. Example 105 — Execution plan of PostgreSQL 10
  106. Example 106 — Execution plan of PostgreSQL 11
Figures

Source edition

The source chapter order, wording, examples, and publication credits are retained. PDF page markers link the reading edition to the original document. Source identity and coverage · About the collection