PostgreSQL versions

• https://www.postgresql.org/about/featurematrix/

• https://pgpedia.info/postgresql-versions/index.html

• https://www.postgresql.org/docs/release/

• https://www.postgresql.org/list/pgsql-announce/

• https://www.postgresql.org/developer/core/

• https://en.wikipedia.org/wiki/PostgreSQL#Release_history

https://www.postgresql.fastware.com/blog/discussing-postgresql-what-changes-in-version-16

• PostgreSQL 17 (DEV)
• PostgreSQL 16 (2023-09-14)
• PostgreSQL 15 (2022-10-13)
  • Annnonces de la sortie
  • Les nouveautés de PostgreSQL 15
    • Performances
    • Fiabilité
    • Administration
  • Le manuel en accès libre
  • En détail
    • Public schema change in PostgreSQL 15
• PostgreSQL 14 (2021-09-30)
  • Description par Dalibo
  • Description par postgresqlweekly
  • Introduction
  • Performance
    • B-Tree
    • index GiST
    • index SP-GiST
    • MATERIALIZED VIEW
    • postgres_fdw
  • Partitionnement
  • Types de données + SQL ( datemultirange )
  • Implementation of subscripting for jsonb
    • Implementation
    • Annonce
  • SQL-Standard
  • Administration
  • Autres nouveautés
    • date_bin function A function for converting a timestamp to the start of the nearest specified interval
    • Index bloat reduced in PostgreSQL v14
    • Hashes
    • multirange A data type for storing multiple non-overlapping ranges
• PostgreSQL 13.4 (2021-08-12)
• PostgreSQL 13 (2020-09-24 => 2025-11-??)
  • Migration to Version 13
  • Overview
  • Articles
    • PostgreSQL 13 s’accompagne d’améliorations significatives de son système d’indexation
    • PostgreSQL 13 (released September 2020) by 2ndQuadrant
    • Mettre à jour PostgreSQL pour améliorer les performances
  • Changes
    • Partitioning
  • Autovacuum
  • Allow invisible PROMPT2 in psql
  • Enable BEFORE row-level triggers for partitioned tables
  • Allow pg_stat_statements to track planning statistics
  • Add the option to report WAL usage in EXPLAIN and auto_explain
  • partitioning-improvements-in-postgresql-13
  • Unicode normalization in PostgreSQL 13
  • PostgreSQL 13: LIMIT … WITH TIES
  • Extended Statistics Improvements in Postgres 13
  • TLS Related Updates in PostgreSQL 13 by Cary Huang
    • Introduction
    • Conclusion
• PostgreSQL 12.8 (2021-08-12)
• PostgreSQL 12 (2019-10-03 => 2024-11-14) SQL/JSON path expression support; generated columns
  • Announce
    • In english
    • En français
  • Indexing & Constraints
    • Announce (https://www.postgresql.org/about/press/presskit12/)
    • Covering indexes for GiST (INCLUDE)
    • K-nearest neighbor SP-GiST Support
  • SQL
    • Announce (https://www.postgresql.org/about/press/presskit12/)
    • COPY FROM WHERE
    • JSON Path
  • Data Definition Language (DDL)
    • Announce (https://www.postgresql.org/about/press/presskit12/)
    • CREATE ACCESS METHOD
    • Rebuilding Indexes Concurrently
    • Generated Columns
  • Performance
    • Accelerated partition pruning
    • CREATE STATISTICS - most-common values (MCV) statistics collection
    • Inlined Common Table Expressions (WITH queries)
  • Partitioning & Inheritance
    • 2ndquadrant: Partitioning performance
    • Foreign Key references for partitioned tables
  • Backup, Restore, Data Integrity, & Replication
    • Enable/Disable page checksums in an offline cluster
  • Configuration Management
    • Fractional input for “integer” values
  • Security
    • Announce (https://www.postgresql.org/about/press/presskit12/)
    • GSSAPI client and server-side encryption
    • LDAP server discovery
    • Multifactor authentication via valid client SSL certificate
  • Internationalisation
    • Announce (https://www.postgresql.org/about/press/presskit12)
    • Nondeterministic Collations
  • psql
  • Upgrade considerations
• PostgreSQL 11 (2018-10-18 => 2023-11-09) Increased robustness and performance for partitioning
  • Sortie de PostgreSQL 11 le jeudi 18 octobre 2018
• PostgreSQL 7.3 (2002-11-27) schema (namespace) support added
  • Major features