Skip to content

PostgreSQL 16 New Features

GA source edition · 98 pages · 2023-09-19

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
GA2023-09-1998 PDF pages9 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 of notation
  3. Table 3 — Syntax rules
  4. Table 4 — WAL archive module API
  5. Table 5 — ASCII Conversion rule
  6. Table 6 — Modified options
  7. Table 7 — Add system catalogs and views
  8. Table 8 — System catalogs/views with additional columns
  9. Table 9 — System catalogs/views with modified output
  10. Table 10 — The pg_stat_io view
  11. Table 11 — The origin option setting
  12. Table 12 — Replication mode setting (PUBLISHER side)
  13. Table 13 — Replication mode setting (SUBSCRIBER side)
  14. Table 14 — Add syntaxes
  15. Table 15 — Add predefined roles
  16. Table 16 — Add Wait Events
  17. Table 17 — Renamed Wait Event
  18. Table 18 — Connection string require_auth
  19. Table 19 — Setting value
  20. Table 20 — Setting value
  21. Table 21 — Integer literal description
  22. Table 22 — Access privileges and the possible lock modes
  23. Table 23 — Added parameters
  24. Table 24 — Possible values
  25. Table 25 — Modified Parameters
  26. Table 26 — Parameters with default values changed
  27. Table 27 — Removed parameters
  28. Table 28 — Add/Remove options
  29. Table 29 — Add/Modify options
  30. Table 30 — Add/change options
  31. Table 31 — Compression level range
  32. Table 32 — File name explanation
  33. Table 33 — Command execution status
  34. Table 34 — Possible values
  35. Table 35 — Results of the pg_buffercache_summary function
  36. Table 36 — Return value of the pg_get_wal_block_info function
  37. Table 37 — Possible values for the analyze_sampling option
Examples
  1. Example 1 — Modify attributes of the bootstrap user
  2. Example 2 — Duplicate error in WAL archive settings
  3. Example 3 — Datetime expression that causes an error in PostgreSQL 16
  4. Example 4 — PostgreSQL 16 behavior
  5. Example 5 — Failure of the ALTER TABLE statement
  6. Example 6 — System column foreign key specification error
  7. Example 7 — Failure of the GRANT statement
  8. Example 8 — PostgreSQL 15 behavior
  9. Example 9 — PostgreSQL 16 behavior
  10. Example 10 — Failure of the RESET statement
  11. Example 11 — PostgreSQL 15 behavior
  12. Example 12 — PostgreSQL 16 behavior
  13. Example 13 — PostgreSQL 16 behavior
  14. Example 14 — PostgreSQL 16 behavior
  15. Example 15 — ECPG program with error
  16. Example 16 — Reference to the pg_ident_file_mapping view.
  17. Example 17 — Reset of the pg_stat_io view
  18. Example 18 — Setting for parallel apply
  19. Example 19 — The origin option setting
  20. Example 20 — Log of the COPY statements executed in initial data synchronization
  21. Example 21 — SUBSCRIPTION creation role
  22. Example 22 — Execute pg_log_standby_snapshot function (Primary instance)
  23. Example 23 — Parallel Hash Full Join execution plan
  24. Example 24 — Execute string_agg function
  25. Example 25 — Pg_hba.conf file with regular expressions
  26. Example 26 — Settings to include files
  27. Example 27 — Conversion of ICU locale 'C'
  28. Example 28 — Specifying custom rules
  29. Example 29 — Check custom rules
  30. Example 30 — Check UNICODE locale
  31. Example 31 — Checkpoint log
  32. Example 32 — Auto vacuum log
  33. Example 33 — Setting the required authentication method
  34. Example 34 — Random selection of connection destination
  35. Example 35 — Get PG_ROUTINE_OID
  36. Example 36 — The WAL sender process name
  37. Example 37 — Part of the test_ext_req_schema2--1.0.sql
  38. Example 38 — Part of the test_ext_req_schema3.control
  39. Example 39 — +Infinity notation
  40. Example 40 — Notation for integer literals
  41. Example 41 — Integer literal in the JSONPATH
  42. Example 42 — Hexadecimal notation of type NUMERIC
  43. Example 43 — Specifying underscores in the numeric literals
  44. Example 44 — Specify the DEFAULT option
  45. Example 45 — Specifying the DEFAULT option (file_fdw)
  46. Example 46 — User creation by the CREATEROLE attribute user
  47. Example 47 — SET ROLE statement for creation role
  48. Example 48 — Name abbreviation in the CREATE STATISTICS statement
  49. Example 49 — STORAGE clause of the CREATE TABLE statement
  50. Example 50 — STORAGE DEFAULT clause in the ALTER TABLE statement
  51. Example 51 — Setting the GENERIC_PLAN option
  52. Example 52 — WITH INHERIT clause
  53. Example 53 — WITH SET clause
  54. Example 54 — JSON Constructor
  55. Example 55 — IS JSON Clause
  56. Example 56 — Fractional seconds
  57. Example 57 — Omitting the database name
  58. Example 58 — Execute the VACUUM statement
  59. Example 59 — TOAST only VACUUM
  60. Example 60 — The BUFFER_USAGE_LIMIT option
  61. Example 61 — Subquery with the FROM clause
  62. Example 62 — PostgreSQL 16 behavior
  63. Example 63 — PostgreSQL 15 behavior
  64. Example 64 — SELECT statement for the example
  65. Example 65 — Execution plan in PostgreSQL 15
  66. Example 66 — Execution plan in PostgreSQL 16
  67. Example 67 — Execution plan in PostgreSQL 16
  68. Example 68 — Execution plan in PostgreSQL 15
  69. Example 69 — Execution plan in PostgreSQL 16
  70. Example 70 — Array_sample / array_shuffle function
  71. Example 71 — Any_value function
  72. Example 72 — Date_add / date_subtract function
  73. Example 73 — Erf / erfc functions
  74. Example 74 — Execution of generate_series function with specified interval
  75. Example 75 — Random_normal function
  76. Example 76 — Pg_read_file function
  77. Example 77 — Pg_split_walfile_name function
  78. Example 78 — Pg_stat_get_backend_subxact function
  79. Example 79 — Pg_input_is_valid function
  80. Example 80 — Pg_input_is_valid / pg_input_error_info function
  81. Example 81 — Pg_size_bytes function
  82. Example 82 — System_user function
  83. Example 83 — Specify the INDENT clause
  84. Example 84 — Execute the createuser command
  85. Example 85 — Execute initdb command with the --icu-rules option
  86. Example 86 — initdb command with the --set option
  87. Example 87 — Specifying the compression level to 'long'
  88. Example 88 — Execute the pg_bsd_indent command
  89. Example 89 — Execute the pg_dump command
  90. Example 90 — Help message of the pg_dump command
  91. Example 91 — Execute the pg_verifybackup command
  92. Example 92 — Execute the pg_waldump command with the --save-fullpage option
  93. Example 93 — Execute the pg_waldump command with the --timeline option
  94. Example 94 — Check command execution status
  95. Example 95 — External table partition information
  96. Example 96 — Binding variable settings
  97. Example 97 — Specifying the xheader_width option
  98. Example 98 — \watch metacommand with rerun count
  99. Example 99 — \drg metacommand
  100. Example 100 — vacuumdb command with specifying schema
  101. Example 101 — With the --no-process-main option
  102. Example 102 — The vacuumdb command with --buffer-usage-limit option
  103. Example 103 — Output of the query ID
  104. Example 104 — Execute the daitch_mokotoff function
  105. Example 105 — Execute the bt_multi_page_stats function
  106. Example 106 — Execute the pg_buffercache_summary function
  107. Example 107 — Execute the pg_buffercache_usage_counts function
  108. Example 108 — Select the pg_stat_statements view
  109. Example 109 — Execute the pg_get_wal_block_info function
  110. Example 110 — Execution log on the external table side
  111. Example 111 — Execute the ANALYZE statement
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