Skip to content

PostgreSQL 9.5 New Features

Alpha 2 source edition · 77 pages · 2015-08-07

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
Alpha 22015-08-0777 PDF pages11 chapters

This book describes the Alpha 2 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 rule
  4. Table 4 — Added system Catalogs
  5. Table 5 — pg_file_settings Catalog
  6. Table 6 — pg_policy Catalog
  7. Table 7 — pg_policies Catalog
  8. Table 8 — pg_stat_ssl Catalog
  9. Table 9 — pg_transform Catalog
  10. Table 10 — Modified catalogs
  11. Table 11 — Added column to pg_replication_slots Catalog
  12. Table 12 — Added column to pg_settings Catalog
  13. Table 13 — Added columns to pg_stat_statements Catalog
  14. Table 14 — Added columns to pg_tables Catalog
  15. Table 15 — Changed in Contrib modules
  16. Table 16 — Added Hook
  17. Table 17 — Environment variables for OOM Killer support
  18. Table 18 — Command-line parameters
  19. Table 19 — Added / modified backslash command
  20. Table 20 — Added Parameters
  21. Table 21 — Changed Parameters
  22. Table 22 — Parameters the default value of which is changed
  23. Table 23 — Alternative parameters for checkpoint_segments
  24. Table 24 — Executed triggers
  25. Table 25 — Syntax for IMPORT FOREIGN SCHEMA statement
  26. Table 26 — IMPORT FOREIGN SCHEMA statement OPTIONS clause
  27. Table 27 — Information obtaining functions
  28. Table 28 — Return value of pg_event_trigger_table_rewrite_reason function
  29. Table 29 — Syntax for CREATE POLICY statement
  30. Table 30 — Choices for Parameter row_security
  31. Table 31 — Functions that have been added to the pageinspect module
  32. Table 32 — Data Type
Examples
  1. Example 1 — Reload parameter file
  2. Example 2 — Join pg_stat_replication Catalog and pg_replication_slots Catalog
  3. Example 3 — Archiving of last segment
  4. Example 4 — Error messages on parameter settings
  5. Example 5 — Error messages during target instance start
  6. Example 6 — Execute pg_rewind command
  7. Example 7 — --jobs parameter’s limit
  8. Example 8 — --jobs parameter and processes
  9. Example 9 — Setting the pager_min_lines
  10. Example 10 — \set ECHO errors
  11. Example 11 — Error message
  12. Example 12 — \watch output \timing information
  13. Example 13 — Output of -latency-limit parameter
  14. Example 14 — Behavior at the specified -f parameter
  15. Example 15 — reindexdb -v Option
  16. Example 16 — Setting parameter for each table
  17. Example 17 — Error by pause_at_recovery_target setting
  18. Example 18 — Prepare table and data
  19. Example 19 — ON CONFLICT clause samples
  20. Example 20 — DO UPDATE clause samples
  21. Example 21 — ON CONFLICT Clause and Execution Plan
  22. Example 22 — INSERT ON CONLICT statement for the partition table#1
  23. Example 23 — INSERT ON CONLICT statement for the partition table#2
  24. Example 24 — Change to UNLOGGED TABLE
  25. Example 25 — Change of pg_class Catalog
  26. Example 26 — Execution of the IMPORT FOREIGN SCHEMA statement
  27. Example 27 — Behavior that cause an error
  28. Example 28 — DEFAULT with Sequence
  29. Example 29 — Prepare data and lock tuple
  30. Example 30 — SELECT by the other session
  31. Example 31 — Create parent table
  32. Example 32 — Create child table on the remote instance
  33. Example 33 — Create External Tables
  34. Example 34 — Check FOREIGN TABLE Definition with INHERITS Clause
  35. Example 35 — Check the Execution Plan
  36. Example 36 — CURRENT_USER Clause
  37. Example 37 — Preparation of tables
  38. Example 38 — Syntax up to PostgreSQL 9.4
  39. Example 39 — Syntax for PostgreSQL 9.5
  40. Example 40 — Execution Plan for TABLESAMPLE SYSTEM
  41. Example 41 — Execution Plan for TABLESAMPLE BERNOULLI
  42. Example 42 — REINDEX SCHEMA statement
  43. Example 43 — REINDEX (VERBOSE)
  44. Example 44 — ROLLUP (Output the subtotal values for each column c1)
  45. Example 45 — CHECK constraint in the CREATE FOREIGN TABLE statement
  46. Example 46 — Execution plan and CHECK constraint
  47. Example 47 — Enhance CREATE EVENT TRIGGER statement
  48. Example 48 — ASSERT statement
  49. Example 49 — Parameter plpgsql.check_asserts
  50. Example 50 — Add and Replace
  51. Example 51 — Delete element
  52. Example 52 — Delete elements of the nested structure
  53. Example 53 — Replace element
  54. Example 54 — Add element #1
  55. Example 55 — Add element #2
  56. Example 56 — Formatting jsonb
  57. Example 57 — Omit null fields.
  58. Example 58 — Enhancement of generate_series Function
  59. Example 59 — Enable Row Level Security to the table
  60. Example 60 — CREATE POLICY statement
  61. Example 61 — Effect of the policy
  62. Example 62 — Create the table and store the data
  63. Example 63 — Create index and check
  64. Example 64 — Check the size of files (storage)
  65. Example 65 — Execution plan for BTREE index
  66. Example 66 — Execution plan for BRIN index (default parameter value)
  67. Example 67 — Execution plan for BRIN index (pages_per_range=64)
  68. Example 68 — Execution plan for BRIN index (pages_per_range=512)
  69. Example 69 — Example of brin_page_items function
  70. Example 70 — Obtain of options information
  71. Example 71 — Parameter cluster_name
  72. Example 72 — Additional sort information
  73. Example 73 — Log of slave instance connection
  74. Example 74 — Log of pg_basebackup command
  75. Example 75 — search pg_class catalog
Figures
  1. Figure 1 — FOREIGN TABLE INHERIT
  2. Figure 2 — Access Control by Row Level Security
  3. Figure 3 — Structure of BRIN INDEX

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