Skip to content

PostgreSQL 10 New Features

Beta 1 source edition · 101 pages · 2017-05-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
Beta 12017-05-22101 PDF pages16 chapters

This book describes the Beta 1 source document. Its examples and compatibility notes reflect that snapshot.

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 — option specification
  5. Table 5 — Added catalog
  6. Table 6 — Related configuration parameters
  7. Table 7 — Behavior at mismatch occurrence
  8. Table 8 — Added system catalog list
  9. Table 9 — pg_hba_file_rules catalog
  10. Table 10 — pg_partitioned_table catalog
  11. Table 11 — pg_publication catalog
  12. Table 12 — pg_publication_rel catalog
  13. Table 13 — pg_publication_tables catalog
  14. Table 14 — pg_sequence catalog
  15. Table 15 — pg_sequences catalog
  16. Table 16 — pg_stat_subscription catalog
  17. Table 17 — pg_statistic_ext catalog
  18. Table 18 — pg_subscription catalog
  19. Table 19 — pg_subscription_rel catalog
  20. Table 20 — System catalog with columns added
  21. Table 21 — Changed name
  22. Table 22 — Added role
  23. Table 23 — Value to be output to the wait_event_type column
  24. Table 24 — Added column (pg_policy catalog)
  25. Table 25 — Added column (pg_policies catalog)
  26. Table 26 — Added parameters
  27. Table 27 — Changed configuration parameters (from pg_settings catalog)
  28. Table 28 — Parameters with default values changed
  29. Table 29 — Deprecated parameters
Examples
  1. Example 1 — Create LIST partition table
  2. Example 2 — Create child table
  3. Example 3 — Reference table definition
  4. Example 4 — Execution of INSERT statement on parent table
  5. Example 5 — Obtain partition information
  6. Example 6 — Create RANGE Partition Table
  7. Example 7 — Create child table
  8. Example 8 — Reference table definition
  9. Example 9 — Execution of INSERT statement on parent table
  10. Example 10 — Access to child table
  11. Example 11 — UNBOUNDED designation
  12. Example 12 — Split UNBOUNDED partition
  13. Example 13 — Create a table with the same structure as the parent table
  14. Example 14 — Attach a partition
  15. Example 15 — Detach a partition
  16. Example 16 — TRUNCATE for parent table
  17. Example 17 — COPY for parent table
  18. Example 18 — Adding and deleting columns from the parent table
  19. Example 19 — Hierarchical partition
  20. Example 20 — Partition-identifiable SQL and execution plan
  21. Example 21 — Partition-unspecified SQL and execution plan
  22. Example 22 — Information of the parent table
  23. Example 23 — Information of child table
  24. Example 24 — Partition using function
  25. Example 25 — RANGE partition and NULL value
  26. Example 26 — Partition with different structure child table
  27. Example 27 — Add primary key to parent table
  28. Example 28 — Update partitioned column
  29. Example 29 — ATTACH of the partition containing the tuple
  30. Example 30 — Partition where column values overlap
  31. Example 31 — ATTACH for FOREIGN TABLE
  32. Example 32 — SQL executed on the remote instance
  33. Example 33 — fail of INSERT statement
  34. Example 34 — Index creation failure
  35. Example 35 — Search pg_stat_subscription catalog
  36. Example 36 — Replication Slot status
  37. Example 37 — Create replication target table (master / slave instance)
  38. Example 38 — PUBLICATION object creation (master instance)
  39. Example 39 — Create SUBSCRIPTION object (slave instance)
  40. Example 40 — Log that detected primary key violation on SUBSCRIPTION side
  41. Example 41 — Worker restart log
  42. Example 42 — Session disconnection log
  43. Example 43 — Partition tables and replication
  44. Example 44 — Parallel query with PREPARE and EXECUTE statements
  45. Example 45 — Parallel Index Scan
  46. Example 46 — Parallel Index Only Scan
  47. Example 47 — SubPlan and parallel query
  48. Example 48 — Parallel Merge Join
  49. Example 49 — Parallel Bitmap Heap Scan
  50. Example 50 — Reference pg_sequences catalog
  51. Example 51 — Search for a sequence (PostgreSQL 9.6)
  52. Example 52 — Search for a sequence (PostgreSQL 10)
  53. Example 53 — Referencing pg_stat_activity catalog
  54. Example 54 — Create temporary replication slot
  55. Example 55 — Instance start log (partially omitted)
  56. Example 56 — Create hash index (PostgreSQL 10)
  57. Example 57 — Create hash index (PostgreSQL 9.6)
  58. Example 58 — Custom Scan Callback
  59. Example 59 — Inner Unique Join
  60. Example 60 — EXPLAIN SUMMARY
  61. Example 61 — Execute VACUUM VERBOSE statement
  62. Example 62 — Quorum-based synchronous replication
  63. Example 63 — Creating tables and POLICY (PERMISSIVE + RESTRICTIVE)
  64. Example 64 — Confirmation of execution plan (PERMISSIVE + RESTRICTIVE)
  65. Example 65 — Create POLICIES in RESTRICTIVE mode
  66. Example 66 — Confirmation of execution plan (RESTRICTIVE + RESTRICTIVE)
  67. Example 67 — UPDATE statement with ROW keyword
  68. Example 68 — Creating extended statistics with the CREATE STATISTICS statement
  69. Example 69 — Confirm the information of the table that created the extended statistics
  70. Example 70 — Confirm extended statistics
  71. Example 71 — GENERATED ALWAYS
  72. Example 72 — OVERRIDING SYSTEM VALUE clause
  73. Example 73 — GENERATED BY DEFAULT
  74. Example 74 — Change of ENUM type by ALTER TYPE statement
  75. Example 75 — Specify SMALLINT type in CREATE SEQUENCE statement
  76. Example 76 — COPY statement for VIEW
  77. Example 77 — Enhancement of BRIN index
  78. Example 78 — UNENCRYPTED clause
  79. Example 79 — Delete element from JSONB array
  80. Example 80 — pg_current_logfile function
  81. Example 81 — xmltable function
  82. Example 82 — regexp_match function
  83. Example 83 — pg_ls_logdir / pg_ls_waldir functions
  84. Example 84 — txid_status function
  85. Example 85 — to_date (PostgreSQL 9.6)
  86. Example 86 — to_date (PostgreSQL 10)
  87. Example 87 — make_date (PostgreSQL 9.6)
  88. Example 88 — make_date (PostgreSQL 10)
  89. Example 89 — execute method / cursor method
  90. Example 90 — subtransaction syntax
  91. Example 91 — Lack max_logical_replication_workers parameters
  92. Example 92 — Parameter log_line_prefix default
  93. Example 93 — Default setting of pg_hba.conf file
  94. Example 94 — Display table information (PostgreSQL 9.6)
  95. Example 95 — Display table information (PostgreSQL 10)
  96. Example 96 — Added output of \timing command
  97. Example 97 — \gx command
  98. Example 98 — \set command
  99. Example 99 — \if command
  100. Example 100 — -Ft option and -Xstream option
  101. Example 101 — Temporary replication slot creation log.
  102. Example 102 — Error when there is no margin in the number of replication slots
  103. Example 103 — Output in --verbose mode
  104. Example 104 — SQL for local execution
  105. Example 105 — Remote execution SQL (from log_statement = 'all' log)
  106. Example 106 — FULL JOIN between remote tables
  107. Example 107 — Program specified file_fdw module
  108. Example 108 — Examples of programs executed
  109. Example 109 — Execution of bt_index_check function
  110. Example 110 — pgstathashindex function
  111. Example 111 — GiST index creation for columns of UUID type and ENUM type
  112. Example 112 — pg_stat_statements view
Figures
  1. Figure 1 — Version notation
  2. Figure 2 — Structure of table partition using inheritance table
  3. Figure 3 — Partitioning table structure
  4. Figure 4 — Object structure
  5. Figure 5 — Cascade replication

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