PostgreSQL 11

Major features

  • Improvements to partitioning functionality
  • Improvements to parallelism
  • SQL stored procedures that support embedded transactions (initial commit e4128ee7)
  • Optional Just-in-Time (JIT) compilation for some SQL code
  • Expanded support for window functions
  • Covering indexes can now be created (commit 8224de4f)
  • ALTER TABLE ... ADD COLUMN with a non-null constant default no longer requires a table rewrite (initial commit 16828d5c)

SQL changes

Added:

Modified:

Backend changes

General

  • the data directory can now be made group-readable (commit c37b3d08)
  • WAL segment size is now configurable when initdb is run (commit fc49e24f)

background workers

  • bgw_type field added; the value set here will be visible in pg_stat_activity's backend_type column instead of the generic value "background worker", and also shown as the ps process display label (commit 5373bc2a)
  • background workers can attach to databases which normally disallow connections (commit eed1ce72)

Storage parameters

Added:

Internals

  • Initial catalog data format substantially refactored (commit 372728b0)

System catalogue changes

Tables

Modified:

Views

Modified:

System function changes

Added:

Indexing changes

SP-GiST

  • ^@ operator ("starts with") added (commit 710d90da)

Configuration changes

Added:

Removed:

  • replacement_sort_tuples (commit 8b304b8b)

Users/roles

  • Following default roles added (commit 0fdc8495):
    • pg_read_server_files
    • pg_write_server_files
    • pg_execute_server_program

Foreign data wrapper changes

  • INSERT, UPDATE, and COPY on partitioned tables can now properly route rows to foreign partitions (commit 3d956d95)

Server utilities

Added:

Modified:

Core utilities

Modified:

psql changes

  • \gdesc command added (commit 49ca462e)
  • variables showing success/failure of SQL queries added (commit 69835bc8)
  • add test for the existence of a variable (commit d57c7a7c)
  • environment variable PSQL_PAGER added, to control psql's pager (commit 5e8304fd)
  • tab completion functionality made server-independent (commit 722408bc)
  • quit and exit commands added, similar to MySQL's command line client (commit df9f599b)

Contrib modules

Added:

Modified:

Removed:

Testing

Test modules

Added: