Skip to content

PostgreSQL 9.6 New Features

Beta 1 source edition · 53 pages · 2016-06-06

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 12016-06-0653 PDF pages13 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 rule
  4. Table 4 — Added system Catalogs
  5. Table 5 — pg_config Catalog
  6. Table 6 — pg_stat_wal_receiver Catalog
  7. Table 7 — pg_stat_progress_vacuum Catalog
  8. Table 8 — pg_init_privs Catalog
  9. Table 9 — Modified catalogs
  10. Table 10 — Added column to pg_replication_slots Catalog
  11. Table 11 — Added columns to pg_stat_activity Catalog
  12. Table 12 — Added column to pg_proc Catalog
  13. Table 13 — Added columns to pg_aggregate Catalog
  14. Table 14 — Columns of pg_am Catalog
  15. Table 15 — Changed in Contrib modules
  16. Table 16 — Functions in the pg_visibility module
  17. Table 17 — Added and modified backslash commands
  18. Table 18 — Added Parameters
  19. Table 19 — Changed Parameters
  20. Table 20 — Parameters the default value of which is changed
  21. Table 21 — Added functions
  22. Table 22 — Related parameters for parallel processing
  23. Table 23 — The output of the EXPLAIN statement
  24. Table 24 — Major PARALLEL UNSAFE standard functions
  25. Table 25 — Major RESTRICTED PARALLEL SAFE standard functions
  26. Table 26 — The value of wait_event_type column
Examples
  1. Example 1 — Query for pg_config Catalog
  2. Example 2 — Query for pg_stat_wal_receiver Catalog
  3. Example 3 — Query for pg_stat_progress_vacuum Catalog
  4. Example 4 — fetch_size option
  5. Example 5 — Executed SQL statement (from log file)
  6. Example 6 — Specify extensions option
  7. Example 7 — pg_visibility module
  8. Example 8 — Creating a bloom module and the execution plan
  9. Example 9 — Execution of heap_page_items function
  10. Example 10 — Specifying the prompt
  11. Example 11 — Reference of the VIEW definition
  12. Example 12 — Executes the output result
  13. Example 13 — \watch and \pset title
  14. Example 14 — Specify the --slot option
  15. Example 15 — Automatic termination of the idle transaction
  16. Example 16 — Change of SYSLOG output
  17. Example 17 — Parameter log_line_prefix
  18. Example 18 — Parameter wal_level
  19. Example 19 — Specify the DELETE statement to COPY statement
  20. Example 20 — No RETURNING clause error
  21. Example 21 — ALTER TABLE ADD COLUMN IF NOT EXISTS statement
  22. Example 22 — Enhancement of the ALTER TABLESPACE statement
  23. Example 23 — CREATE EXTENSION CASCADE statement
  24. Example 24 — Function jsonb_insert
  25. Example 25 — num_nulls / num_nonnulls functions
  26. Example 26 — current_setting function
  27. Example 27 — Execute pg_control_init function
  28. Example 28 — Execute pg_control_checkpoint function
  29. Example 29 — Execute pg_control_recovery function
  30. Example 30 — pg_current_xlog_flush_location function
  31. Example 31 — parse_ident function
  32. Example 32 — pg_size_bytes function
  33. Example 33 — pg_blocking_pids function
  34. Example 34 — pg_start_backup / pg_stop_backup functions
  35. Example 35 — Execution plan of parallel processing.
  36. Example 36 — Execution plan of parallel processing
  37. Example 37 — The difference of the execution plan by the use of PARALLEL UNSAFE function
  38. Example 38 — User-defined functions and PARALLEL SAFE
  39. Example 39 — The part of create_parallel_paths function
  40. Example 40 — Waiting by two LOCK TABLE IN EXCLUSIVE statements
  41. Example 41 — Waiting by SELECT FOR UPDATE statement and UPDATE statement
  42. Example 42 — Sort Push-down
  43. Example 43 — DELETE statement in PostgreSQL 9.5
  44. Example 44 — DELETE statement in PostgreSQL 9.6
  45. Example 45 — Join Push-down
  46. Example 46 — Multiple synchronous standby server replication
  47. Example 47 — Role names starting from "pg_"
Figures
  1. Figure 1 — Parallel Seq Scan / Parallel Aggregate

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