subtitle | title | keywords | linkcolor | licence | author | revision | url | toc-depth | links-as-notes | code-blocks-fontsize | latex-environment | pandoc-latex-admonition | width | height | theme | transition | transition-speed | progress | slideNumber | history | mouseWheel | title-transform | hide_author_in_slide | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Workshop 14 |
Nouveautés de PostgreSQL 14 |
|
PostgreSQL |
Dalibo & Contributors |
14 |
3 |
true |
small |
|
|
1200 |
768 |
white |
Convex |
fast |
true |
true |
true |
true |
none |
true |
Photographie d'Antoine Taveneaux, licence CC BY-SA 3.0, obtenue sur wikimedia.org.
Participez à ce workshop !
Pour des précisions, compléments, liens, exemples, et autres corrections et suggestions, soumettez vos Pull Requests dans notre dépôt :
https://github.com/dalibo/workshops/tree/master/fr
Licence : PostgreSQL
Ce workshop sera maintenu encore plusieurs mois après la sortie de la version 14.
\newpage
PostgreSQL 14 est sorti le 30 septembre 2021.
Les points principaux sont décrits dans le « press kit ».
Nous allons décrire ces nouveautés plus en détail.
\newpage
- Sécurité
- Configuration
- Outils clients
- Partitionnement
- Divers
\newpage
!include include/scram-par-defaut.md
!include include/99_new_roles.md
\newpage
!include include/100_parallel_leader_wildcard_to_log_line_prefix.md
!include include/101_idle_session_timeout.md
!include include/102_restore_command_on_reload.md
!include include/103_client_connection_check_interval.md
!include include/141_changements_mineurs_de_la_configuration.md
\newpage
!include include/105_dump_attach_partition.md
!include include/106-add-support-for-extension-in-pg_dump.md
\newpage
!include include/108_alter_table_detach_partition_concurrently.md
!include include/109_add_support_for_partitioned_tables_and_indexes_in_reindex.md
!include include/110_autovacuum_handle_analyze_for_partitioned_tables.md
\newpage
!include include/111_allow_configurable_lz4_toast_compression.md
!include include/112_add_option_process_toast_to_vacuum.md
!include include/107_add_tablespace_option_to_reindex.md
!include include/113_add_functions_to_wait_for_backend_termination.md
\newpage
\newpage
!include include/104_allow_pg_rewind_to_use_a_standby_server_as_the_source_system.md
!include include/114_new_libpq_option_to_prefer_standby_for_connection.md
\newpage
!include include/115_logical_replication_feature_in_pg14.md
\newpage
!include include/116_truncate_on_foreign_table.md
!include include/117_async_append.md
\newpage
!include include/118_function_string_to_table.md
!include include/119_create_or_replace_trigger.md
!include include/120_support_for_out_parameters_in_procedures.md
!include include/121-plpgsql-assignment-parsing.md
!include include/121-better-jsonb.md
!include include/122_range_agg_multiranges.md
!include include/123_group_by_distinct.md
!include include/124-sql-standard-function-body.md
!include include/125_search_and_cycle.md
!include include/126-truncating-timestamps-on-arbitrary-intervals-fct-date_bin.md
!include include/127_allow_an_alias_to_be_attached_directly_to_a_join_using.md
\newpage
!include include/129_nouvelle_vue_pg_stat_wal.md
!include include/133_simple_progress_reporting_for_copy_command.md
!include include/135-pg_stat_replicaton_slots.md
!include include/130_pg_stat_statements_new_features.md
!include include/131_add_session_statistics_to_pg_stat_database.md
!include include/132_compute_query_id.md
!include include/134_add_wait_start_column_to_pg_locks.md
\newpage
!include include/136-ameliorations-des-index-gist.md
!include include/136-ameliorations-des-index-btree.md
!include include/136-ameliorations-des-index-brin.md
!include include/137_improving_connection_scalability.md
!include include/tp-99_new_roles.md
!include include/tp-117_async_append.md
!include include/tp-104_allow_pg_rewind_to_use_a_standby_server_as_the_source_system.md