Add server variable password_expiration_warning_threshold to warn about password expiration (Gilles Darold, Nathan Bossart) \u00a7
The default warning period is seven days.
", "text": "Add server variable password_expiration_warning_threshold to warn about password expiration (Gilles Darold, Nathan Bossart) \u00a7 The default warning period is seven days.", "title": "Add server variable password_expiration_warning_threshold to warn about password expiration", "commits": ["1d92e0c2c"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "7c339ee9b358a11a561d28ca346ffcac404600694f6da2b380ae9bb7cd6af403", "section_path": ["Compatibility"], "commit_groups": [["1d92e0c2c"]], "identity_text": "Add server variable password_expiration_warning_threshold to warn about password expiration (Gilles Darold, Nathan Bossart) The default warning period is seven days.", "commit_aliases": ["1d92e0c2c"], "source_commits": ["1d92e0c2c"], "source_entry_id": "19.0/migration/001", "db_id": "0ee1d9c8286e1e1c3bca823c4ad8e489", "patch_ids": ["095ffa220dd9def37aacae10519edc44"], "statement_hash": "ed4b6567c72fb14f34d3ff078e46845e06ac97abc4729230f6ded8d82025c9a1", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-c33e9c850ed0c4c0", "migration": true}, {"id": "19.0-4ae2c09be676b418", "cves": [], "html": "Issue a warning after successful MD5 password authentication (Nathan Bossart) \u00a7
\nThe warning can be disabled via server variable md5_password_warnings. MD5 passwords were marked as deprecated in PostgreSQL 18.
Remove RADIUS support (Thomas Munro) \u00a7
\nPostgreSQL only supported RADIUS over UDP, which is unfixably insecure.
", "text": "Remove RADIUS support (Thomas Munro) \u00a7 PostgreSQL only supported RADIUS over UDP, which is unfixably insecure.", "title": "Remove RADIUS support", "commits": ["a1643d40b"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "b6868a5d55a4fbb9bf73a4ae19630c1778ac28754527bdd8b67b584d64f02e99", "section_path": ["Compatibility"], "commit_groups": [["a1643d40b"]], "identity_text": "Remove RADIUS support (Thomas Munro) PostgreSQL only supported RADIUS over UDP, which is unfixably insecure.", "commit_aliases": ["a1643d40b"], "source_commits": ["a1643d40b"], "source_entry_id": "19.0/migration/003", "db_id": "46f63ce5de5d054a9ff5ef111cb12f89", "patch_ids": ["fa7631c26a75fe98210f67a23a547046"], "statement_hash": "bb5a1ec62f0b8029c0c2d01824ad69a33b4621e98c08fea042bb2990d855978d", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-22c41cab584065b7", "migration": true}, {"id": "19.0-2c213911526432f1", "cves": [], "html": "Force standard_conforming_strings to always be on in the database server (Tom Lane) \u00a7
Dumps created using pre-PostgreSQL 19 versions of pg_dump or pg_dumpall, and using standard_conforming_strings = off, will not properly load into PostgreSQL 19 and later servers. Users should create dumps using PostgreSQL 19 or later versions of these applications, or use standard_conforming_strings = on.
Client applications still support operations with servers having standard_conforming_strings = off, for compatibility with old servers. The server variable escape_string_warning has been removed as unnecessary.
Disallow carriage returns and line feeds in database, role, and tablespace names (Mahendra Singh Thalor) \u00a7
\npg_upgrade will also disallow upgrading of clusters that use such names. This was changed to avoid security problems.
", "text": "Disallow carriage returns and line feeds in database, role, and tablespace names (Mahendra Singh Thalor) \u00a7 pg_upgrade will also disallow upgrading of clusters that use such names. This was changed to avoid security problems.", "title": "Disallow carriage returns and line feeds in database, role, and tablespace names", "commits": ["b380a56a3"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "d9d6648afb875ea815d9ead2982f136ba6f41ae97c8305e53b58b65c7486235a", "section_path": ["Compatibility"], "commit_groups": [["b380a56a3"]], "identity_text": "Disallow carriage returns and line feeds in database, role, and tablespace names (Mahendra Singh Thalor) pg_upgrade will also disallow upgrading of clusters that use such names. This was changed to avoid security problems.", "commit_aliases": ["b380a56a3"], "source_commits": ["b380a56a3"], "source_entry_id": "19.0/migration/005", "db_id": "0f8efb4cff76fe54d45530b1262f678a", "patch_ids": ["4c82032b0e66552171db30560a84fcf6"], "statement_hash": "ad32dd3c8f6a910d242148086becb69efd82cd95622b540fa6f3ad7a4e16f429", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-07f0137a38635d0b", "migration": true}, {"id": "19.0-e5009c4b0e44386f", "cves": [], "html": "Change the default index opclasses for inet and cidr data types from btree_gist to GiST (Tom Lane) \u00a7 \u00a7
The btree_gist inet/cidr opclasses are broken because they can exclude rows that should be returned. pg_upgrade will disallow upgrading of clusters with btree_gist inet/cidr indexes.
Disallow system columns from being used in COPY FROM ... WHERE (Tom Lane) \u00a7
The values of such columns were not well-defined.
", "text": "Disallow system columns from being used in COPY FROM ... WHERE (Tom Lane) \u00a7 The values of such columns were not well-defined.", "title": "Disallow system columns from being used in COPY FROM ... WHERE", "commits": ["21c69dc73"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "10e8dbc64b58cb2e6f2e54867daffca75598a704fdd023899c025327e183c54c", "section_path": ["Compatibility"], "commit_groups": [["21c69dc73"]], "identity_text": "Disallow system columns from being used in COPY FROM ... WHERE (Tom Lane) The values of such columns were not well-defined.", "commit_aliases": ["21c69dc73"], "source_commits": ["21c69dc73"], "source_entry_id": "19.0/migration/007", "db_id": "778475a1b837861f70094d5ceb2c5e00", "patch_ids": ["4b03e5cd2822d97a82583c446462a0fc"], "statement_hash": "579a9ff0903438067962eb326e682f0081809e9b7f29423e0d2af99e7d40eed6", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-940009c2e7beae07", "migration": true}, {"id": "19.0-28887c6175f1aca5", "cves": [], "html": "Change a json_array() call which returns no rows to return an empty JSON array (Richard Guo) \u00a7
This previously returned NULL.
Cause transactions to pass their READ ONLY and DEFERRABLE status to postgres_fdw sessions (Etsuro Fujita) \u00a7
This means READ ONLY transactions can no longer modify rows processed by postgres_fdw sessions.
Change default of max_locks_per_transaction from 64 to 128 (Heikki Linnakangas) \u00a7
Lock size allocation has changed, so effectively settings must now be doubled to match their capacity in previous releases.
", "text": "Change default of max_locks_per_transaction from 64 to 128 (Heikki Linnakangas) \u00a7 Lock size allocation has changed, so effectively settings must now be doubled to match their capacity in previous releases.", "title": "Change default of max_locks_per_transaction from 64 to 128", "commits": ["79534f906"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "77109b01dcfb7956ff1d2d5d39ab548e9520cfe4164c1927463934a1cf43e715", "section_path": ["Compatibility"], "commit_groups": [["79534f906"]], "identity_text": "Change default of max_locks_per_transaction from 64 to 128 (Heikki Linnakangas) Lock size allocation has changed, so effectively settings must now be doubled to match their capacity in previous releases.", "commit_aliases": ["79534f906"], "source_commits": ["79534f906"], "source_entry_id": "19.0/migration/010", "db_id": "b49e1630d4751a0a3391d1c9cda2c73c", "patch_ids": ["39ca5de25df82eeade6fa15b148cba38"], "statement_hash": "b047f9fc149f0588327f77f9adf686e5da4c3cc852f9df57e36cee3c9a3ff845", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-0f6fe2deb41d452f", "migration": true}, {"id": "19.0-2d1995791bfba273", "cves": [], "html": "Change JIT to be disabled by default (Jelte Fennema-Nio) \u00a7
\nPreviously JIT was enabled by default, and activated based on optimizer costs, but this costing has been determined to be unreliable. This change requires sites that are doing many large analytical queries to manually enable JIT.
", "text": "Change JIT to be disabled by default (Jelte Fennema-Nio) \u00a7 Previously JIT was enabled by default, and activated based on optimizer costs, but this costing has been determined to be unreliable. This change requires sites that are doing many large analytical queries to manually enable JIT.", "title": "Change JIT to be disabled by default", "commits": ["7f8c88c2b"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "d5d7f48ee4c1effa36bf0427d8b159eb540c0335fb0e7d37c451e2f950663546", "section_path": ["Compatibility"], "commit_groups": [["7f8c88c2b"]], "identity_text": "Change JIT to be disabled by default (Jelte Fennema-Nio) Previously JIT was enabled by default, and activated based on optimizer costs, but this costing has been determined to be unreliable. This change requires sites that are doing many large analytical queries to manually enable JIT.", "commit_aliases": ["7f8c88c2b"], "source_commits": ["7f8c88c2b"], "source_entry_id": "19.0/migration/011", "db_id": "6b3e754eb033e05517d5e01c53cbb26f", "patch_ids": ["df6972f1b29556533e8f1d64ffe7c753"], "statement_hash": "532c84b6fa800a1060de0ff778f814cfac6bef59a00a8aff7b59d1e42bb1bef4", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-2d1995791bfba273", "migration": true}, {"id": "19.0-b1c1710fd414582c", "cves": [], "html": "Rename column sync_error_count to sync_table_error_count in system view pg_stat_subscription_stats (Vignesh C) \u00a7
This is necessary since sequence errors are now tracked separately.
", "text": "Rename column sync_error_count to sync_table_error_count in system view pg_stat_subscription_stats (Vignesh C) \u00a7 This is necessary since sequence errors are now tracked separately.", "title": "Rename column sync_error_count to sync_table_error_count in system view pg_stat_subscription_stats", "commits": ["3edaf29fa"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "a14e8b11a625b613af50951c94510fbe64a46f611fc59e78fcaaffe25b659690", "section_path": ["Compatibility"], "commit_groups": [["3edaf29fa"]], "identity_text": "Rename column sync_error_count to sync_table_error_count in system view pg_stat_subscription_stats (Vignesh C) This is necessary since sequence errors are now tracked separately.", "commit_aliases": ["3edaf29fa"], "source_commits": ["3edaf29fa"], "source_entry_id": "19.0/migration/012", "db_id": "70cd59be0b3b3c22c3c028193c91e416", "patch_ids": ["612943743e97964090c65bd7f4cdedca"], "statement_hash": "1f4f95c0813c6e77c441fd924e4b2ab8e496ff881eefbd3447d3f107e05fe57e", "relations": [{"rule": 2, "type": "related", "target": "9a6f7f73dea73507b7e7d161044aa58a", "evidence": {"same_day": false, "patch_ids": ["612943743e97964090c65bd7f4cdedca"]}}], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-b1c1710fd414582c", "migration": true}, {"id": "19.0-81577b68a3e9a3cd", "cves": [], "html": "Rename wait event type BUFFERPIN to BUFFER (Andres Freund) \u00a7
Change index access method handlers to use a static IndexAmRoutines structure, rather than dynamically allocated ones (Matthias van de Meent) \u00a7
Remove optimizer hook get_relation_info_hook and add better-placed hook build_simple_rel_hook (Robert Haas) \u00a7
", "text": "Remove optimizer hook get_relation_info_hook and add better-placed hook build_simple_rel_hook (Robert Haas) \u00a7", "title": "Remove optimizer hook get_relation_info_hook and add better-placed hook build_simple_rel_hook", "commits": ["91f33a2ae"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "a9ee2d58ff00b61b8ad6674b0481dbe65812e81f01e72a6177ac42169670f1b5", "section_path": ["Compatibility"], "commit_groups": [["91f33a2ae"]], "identity_text": "Remove optimizer hook get_relation_info_hook and add better-placed hook build_simple_rel_hook (Robert Haas)", "commit_aliases": ["91f33a2ae"], "source_commits": ["91f33a2ae"], "source_entry_id": "19.0/migration/015", "db_id": "9eb7c5f55e60c1774249ad77a6e3e680", "patch_ids": ["ad735bfab9018bd4e9455caa63620d0e"], "statement_hash": "1262304b32f806dbc40ddb3a8a7dbc07bd5c934aa44cbe10f9aae2da5a799e17", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-6aed8df8f1048b04", "migration": true}, {"id": "19.0-57a268be8495814f", "cves": [], "html": "Change psql's \\crosstabview command to honor the \\pset null setting (Chao Li) \u00a7
Remove MULE_INTERNAL encoding (Thomas Munro) \u00a7
This encoding was complex and rarely used. Databases using it will need to be dumped and restored with a different encoding.
", "text": "Remove MULE_INTERNAL encoding (Thomas Munro) \u00a7 This encoding was complex and rarely used. Databases using it will need to be dumped and restored with a different encoding.", "title": "Remove MULE_INTERNAL encoding", "commits": ["77645d44e"], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/19.0/#RELEASE-19-MIGRATION", "source_hash": "bbd1a72fdae94e463059def85d49a5f2971302c20887b0b7f5942e747617ecb3", "section_path": ["Compatibility"], "commit_groups": [["77645d44e"]], "identity_text": "Remove MULE_INTERNAL encoding (Thomas Munro) This encoding was complex and rarely used. Databases using it will need to be dumped and restored with a different encoding.", "commit_aliases": ["77645d44e"], "source_commits": ["77645d44e"], "source_entry_id": "19.0/migration/017", "db_id": "23f95991b047086faa8e13abfe46f775", "patch_ids": ["8d7fc34088b380faed06d973ad51df33"], "statement_hash": "0bcba35e6ec3fed48fcf47b2a0c8c06360235579f1c905251cbb0ae5c682c2e8", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=19.0#19.0-b575f973d52cf40d", "migration": true}, {"id": "19.0-cae3ff8856e5964e", "cves": [], "html": "Allow NOT IN clauses to be converted to more efficient ANTI JOINs when NULLs are not present (Richard Guo) \u00a7
Allow more LEFT JOINs to be converted to ANTI JOINs (Tender Wang, Richard Guo) \u00a7
Allow use of Memoize for ANTI JOINs with unique inner sides (Richard Guo) \u00a7
Allow some aggregate processing to be performed before joins (Richard Guo, Antonin Houska) \u00a7 \u00a7 \u00a7
\nThis can reduce the number of rows needed to be processed.
", "text": "Allow some aggregate processing to be performed before joins (Richard Guo, Antonin Houska) \u00a7 \u00a7 \u00a7 This can reduce the number of rows needed to be processed.", "title": "Allow some aggregate processing to be performed before joins", "commits": ["3a08a2a8b", "8e1185910", "bd94845e8"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "7f74d6348893d4c4907c7fdba9651e0097c05a2f55b4edd383a1c9577534d377", "section_path": ["Server", "Optimizer"], "commit_groups": [["3a08a2a8b"], ["8e1185910"], ["bd94845e8"]], "identity_text": "Allow some aggregate processing to be performed before joins (Richard Guo, Antonin Houska) This can reduce the number of rows needed to be processed.", "commit_aliases": ["3a08a2a8b", "8e1185910", "bd94845e8"], "source_commits": ["3a08a2a8b", "8e1185910", "bd94845e8"], "source_entry_id": "19.0/changes/004", "db_id": "2c9e35c599775907c3b3bdda01894b08", "patch_ids": ["5913f214801aba0a67487defef3e5b0d", "8291b2a60abb0fe5a064be000be5f8fa", "cffcdfa6b2dc4400ca76dfa397fae5ef"], "statement_hash": "ebcf53889c9089799193d955b5499ed5608d3ed9bebbf5f510a69c50c88d2a6a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-7147c16b9c60db5f", "migration": false}, {"id": "19.0-409ecafc3fecde8d", "cves": [], "html": "Improve hash join's handling of tuples with NULL join keys (Tom Lane) \u00a7
Improve the planning of semijoins (Richard Guo) \u00a7
", "text": "Improve the planning of semijoins (Richard Guo) \u00a7", "title": "Improve the planning of semijoins", "commits": ["24225ad9a"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "75942474d30819e9e00598e0c7237ad5f11d5d761f5effe8cff1d0eeca807b75", "section_path": ["Server", "Optimizer"], "commit_groups": [["24225ad9a"]], "identity_text": "Improve the planning of semijoins (Richard Guo)", "commit_aliases": ["24225ad9a"], "source_commits": ["24225ad9a"], "source_entry_id": "19.0/changes/006", "db_id": "5e54b3a7512536e84f3ce0af31e9f570", "patch_ids": ["12f0b9df9adf791089766c7b6965b423"], "statement_hash": "3fd89272a005636d87d53bdef6753d0bc89ae0d9a98d441084003e15c79228f9", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-a14b289d84d3f204", "migration": false}, {"id": "19.0-58d3061275bdd469", "cves": [], "html": "Allow Append and MergeAppend to consider explicit incremental sorts (Richard Guo) \u00a7
", "text": "Allow Append and MergeAppend to consider explicit incremental sorts (Richard Guo) \u00a7", "title": "Allow Append and MergeAppend to consider explicit incremental sorts", "commits": ["55a780e94"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "168d85d328dd11f20f1143c8a296e6e58847c424d173b21a50778b8fd9926fc7", "section_path": ["Server", "Optimizer"], "commit_groups": [["55a780e94"]], "identity_text": "Allow Append and MergeAppend to consider explicit incremental sorts (Richard Guo)", "commit_aliases": ["55a780e94"], "source_commits": ["55a780e94"], "source_entry_id": "19.0/changes/007", "db_id": "6203b6154c3f44bfeba263b117e32150", "patch_ids": ["27e38922acefd323b2455933decbe319"], "statement_hash": "8157792aabe82a5852660e085153c9a6bf0beab886d8b8c2b2ede534649d2d3f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-58d3061275bdd469", "migration": false}, {"id": "19.0-c2ab03320b40a102", "cves": [], "html": "Convert IS [NOT] DISTINCT FROM NULL to IS [NOT] NULL during constant folding (Richard Guo) \u00a7
The latter form is more easily optimized.
", "text": "Convert IS [NOT] DISTINCT FROM NULL to IS [NOT] NULL during constant folding (Richard Guo) \u00a7 The latter form is more easily optimized.", "title": "Convert IS [NOT] DISTINCT FROM NULL to IS [NOT] NULL during constant folding", "commits": ["f41ab5157"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "f8cee679d25843f381baa6003d11f6160d2534997063e623fea3e5946afc7e7e", "section_path": ["Server", "Optimizer"], "commit_groups": [["f41ab5157"]], "identity_text": "Convert IS [NOT] DISTINCT FROM NULL to IS [NOT] NULL during constant folding (Richard Guo) The latter form is more easily optimized.", "commit_aliases": ["f41ab5157"], "source_commits": ["f41ab5157"], "source_entry_id": "19.0/changes/008", "db_id": "5338907e026429e992a5d52baa60153c", "patch_ids": ["a2fb1e20430f831c885b369e3405d403"], "statement_hash": "584ad92a9292ff29cd0d6cbda4cca44bf3e68f1d8d60a18c5eed98840068e80e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-c2ab03320b40a102", "migration": false}, {"id": "19.0-bb4485e8960db6ef", "cves": [], "html": "Simplify IS [NOT] DISTINCT FROM to equality/inequality operators when inputs are proven non-nullable (Richard Guo) \u00a7
Perform earlier constant folding of var IS [NOT] NULL in the optimizer (Richard Guo) \u00a7
This allows for later optimizations.
", "text": "Perform earlier constant folding of var IS [NOT] NULL in the optimizer (Richard Guo) \u00a7 This allows for later optimizations.", "title": "Perform earlier constant folding of var IS [NOT] NULL in the optimizer", "commits": ["e2debb643"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "207dee13849180dc9608920be0724e490b3efe178b8488272a97eae878b1ec8d", "section_path": ["Server", "Optimizer"], "commit_groups": [["e2debb643"]], "identity_text": "Perform earlier constant folding of var IS [NOT] NULL in the optimizer (Richard Guo) This allows for later optimizations.", "commit_aliases": ["e2debb643"], "source_commits": ["e2debb643"], "source_entry_id": "19.0/changes/010", "db_id": "be54aea280d26ed11021e92f08c48471", "patch_ids": ["4da26000bced26e6b5a890ab16d061f3"], "statement_hash": "2effe9bc40747a1dedba1a62ebceecfe10a353e6c2d7defc920764e73507eb25", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-a95eb1ef6edbf5ee", "migration": false}, {"id": "19.0-9f8d11c5b213d88b", "cves": [], "html": "Simplify COALESCE() and ROW(...) IS [NOT] NULL to avoid evaluating unnecessary arguments (Richard Guo) \u00a7 \u00a7
Simplify IS [NOT] TRUE/FALSE/UNKNOWN to plain boolean expressions when the input is proven non-nullable (Richard Guo) \u00a7
Speed up join selectivity computations for large optimizer statistics targets (Ilia Evdokimov, David Geier) \u00a7
", "text": "Speed up join selectivity computations for large optimizer statistics targets (Ilia Evdokimov, David Geier) \u00a7", "title": "Speed up join selectivity computations for large optimizer statistics targets", "commits": ["057012b20"], "section": "Server / Optimizer", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "cb5816282635fc4ea2cac9e1dada380cf14eabdd7423586d7e0ad26b80739f00", "section_path": ["Server", "Optimizer"], "commit_groups": [["057012b20"]], "identity_text": "Speed up join selectivity computations for large optimizer statistics targets (Ilia Evdokimov, David Geier)", "commit_aliases": ["057012b20"], "source_commits": ["057012b20"], "source_entry_id": "19.0/changes/013", "db_id": "731ee1882a965fff802edea15955fc65", "patch_ids": ["05810a8a82ed49e8d50c9a8d2307b017"], "statement_hash": "84bbb53ff5d48be13b424836a4e7afe094b25441ba268a7491cfa5b6fedd4a8d", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-ed34ada849bfd58f", "migration": false}, {"id": "19.0-16f503e76c291a93", "cves": [], "html": "Enable proper optimizer statistics for functions returning boolean values (Tom Lane) \u00a7
", "text": "Enable proper optimizer statistics for functions returning boolean values (Tom Lane) \u00a7", "title": "Enable proper optimizer statistics for functions returning boolean values", "commits": ["1eccb9315"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "d5709e222aeb794df1186d7bfc6866f6314cc7c5d808163a04d35452e7811b6d", "section_path": ["Server", "Optimizer"], "commit_groups": [["1eccb9315"]], "identity_text": "Enable proper optimizer statistics for functions returning boolean values (Tom Lane)", "commit_aliases": ["1eccb9315"], "source_commits": ["1eccb9315"], "source_entry_id": "19.0/changes/014", "db_id": "7f294ecac4e9a1916f488d72859c484d", "patch_ids": ["f46850b6c4c52bf1a7b94d806ec57249"], "statement_hash": "5d42b8b729544c58d41a4a5d300b78e9cab3bfc0edd1d32a68ff9e0627aa4d24", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-16f503e76c291a93", "migration": false}, {"id": "19.0-5d809f3670da37c8", "cves": [], "html": "Allow extended statistics on virtual generated columns (Yugo Nagata) \u00a7
", "text": "Allow extended statistics on virtual generated columns (Yugo Nagata) \u00a7", "title": "Allow extended statistics on virtual generated columns", "commits": ["f7f4052a4"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "5a074288a48869ff3a55a55fc43a11169ebfbd3cbd4eb589c0dcdf4fb7fb8318", "section_path": ["Server", "Optimizer"], "commit_groups": [["f7f4052a4"]], "identity_text": "Allow extended statistics on virtual generated columns (Yugo Nagata)", "commit_aliases": ["f7f4052a4"], "source_commits": ["f7f4052a4"], "source_entry_id": "19.0/changes/015", "db_id": "e521d4153b595d7b0a4bd84a7f2997b5", "patch_ids": ["5fd1f955452ebdb244af256249b84e03"], "statement_hash": "f08840b159de68e3dfb347da5a75c110c84bb48e47d4d2bfb5133dc5919c168f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-5d809f3670da37c8", "migration": false}, {"id": "19.0-fe033cc3fb21ca77", "cves": [], "html": "Allow function pg_restore_extended_stats() to restore optimizer extended statistics (Corey Huinker, Michael Paquier, Chao Li) \u00a7 \u00a7 \u00a7 \u00a7
Add function pg_clear_extended_stats() to remove extended statistics (Corey Huinker, Michael Paquier) \u00a7
Adjust the optimizer to consider startup costs of partial paths (Robert Haas, Tomas Vondra) \u00a7
", "text": "Adjust the optimizer to consider startup costs of partial paths (Robert Haas, Tomas Vondra) \u00a7", "title": "Adjust the optimizer to consider startup costs of partial paths", "commits": ["8300d3ad4"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "0979d34b0375be1003ebc03dfc24a3731e87f34dbd17f20d10a0e3cc2d409ab6", "section_path": ["Server", "Optimizer"], "commit_groups": [["8300d3ad4"]], "identity_text": "Adjust the optimizer to consider startup costs of partial paths (Robert Haas, Tomas Vondra)", "commit_aliases": ["8300d3ad4"], "source_commits": ["8300d3ad4"], "source_entry_id": "19.0/changes/018", "db_id": "4a027a3ab087d156be5cbf23dd9efa7b", "patch_ids": ["d2ad0209d8ff2c3963c69fa63df1925a"], "statement_hash": "a1a8105573366e0b72a29f2a7c0159bf1ad23b35b98c09a09132c8cc4a182cab", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-bbbfca88a12850b3", "migration": false}, {"id": "19.0-0aa6003a11abcb8c", "cves": [], "html": "Allow negative values of pg_aggregate.aggtransspace to indicate unbounded memory usage (Richard Guo) \u00a7
This information is used by the optimizer in planning memory usage.
", "text": "Allow negative values of pg_aggregate.aggtransspace to indicate unbounded memory usage (Richard Guo) \u00a7 This information is used by the optimizer in planning memory usage.", "title": "Allow negative values of pg_aggregate.aggtransspace to indicate unbounded memory usage", "commits": ["185e30426"], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-OPTIMIZER", "source_hash": "0c15dfb6a376f19e29ce81b360b538607797f23fa3726050cf2a9f1133f94697", "section_path": ["Server", "Optimizer"], "commit_groups": [["185e30426"]], "identity_text": "Allow negative values of pg_aggregate.aggtransspace to indicate unbounded memory usage (Richard Guo) This information is used by the optimizer in planning memory usage.", "commit_aliases": ["185e30426"], "source_commits": ["185e30426"], "source_entry_id": "19.0/changes/019", "db_id": "f3d3c220e6026e0eeda7bd6d56f665e5", "patch_ids": ["5492488c92f30a827563d46acd1c15ba"], "statement_hash": "46976883fce19440f738354918a608956e7c2ca5a90ad03c654003c69efbe7ab", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-0aa6003a11abcb8c", "migration": false}, {"id": "19.0-f4deb8e78867d7a2", "cves": [], "html": "Improve performance of foreign key constraint checks (Junwang Zhao, Amit Langote, Chao Li) \u00a7 \u00a7
", "text": "Improve performance of foreign key constraint checks (Junwang Zhao, Amit Langote, Chao Li) \u00a7 \u00a7", "title": "Improve performance of foreign key constraint checks", "commits": ["2da86c1ef", "e484b0eea"], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-PERFORMANCE", "source_hash": "4b1fa21f0dd9a6dc0c815850b02898286ac0f028cce3bf0a783f11095fbaf499", "section_path": ["Server", "General Performance"], "commit_groups": [["2da86c1ef"], ["e484b0eea"]], "identity_text": "Improve performance of foreign key constraint checks (Junwang Zhao, Amit Langote, Chao Li)", "commit_aliases": ["2da86c1ef", "e484b0eea"], "source_commits": ["2da86c1ef", "e484b0eea"], "source_entry_id": "19.0/changes/020", "db_id": "b1f9f55a512602ec9cd060bc2bc4371e", "patch_ids": ["00cf015ee47213a43181fb99b66a0771", "f4628d8586bd3ee7fa856a2b048ac468"], "statement_hash": "6721bd85527a6ca1358f80844fdc7e6fed859721c8241c12cec9e382035b32e7", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-f4deb8e78867d7a2", "migration": false}, {"id": "19.0-f5dcfc56f8dde08e", "cves": [], "html": "Improve asynchronous I/O read-ahead scheduling for large requests (Andres Freund) \u00a7 \u00a7 \u00a7
", "text": "Improve asynchronous I/O read-ahead scheduling for large requests (Andres Freund) \u00a7 \u00a7 \u00a7", "title": "Improve asynchronous I/O read-ahead scheduling for large requests", "commits": ["8ca147d58", "a9ee66881", "f63ca3379"], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-PERFORMANCE", "source_hash": "387f271f171b23c761d21c0ad07898142ffcb42364770d68d60cc9d395101b9a", "section_path": ["Server", "General Performance"], "commit_groups": [["8ca147d58"], ["a9ee66881"], ["f63ca3379"]], "identity_text": "Improve asynchronous I/O read-ahead scheduling for large requests (Andres Freund)", "commit_aliases": ["8ca147d58", "a9ee66881", "f63ca3379"], "source_commits": ["8ca147d58", "a9ee66881", "f63ca3379"], "source_entry_id": "19.0/changes/021", "db_id": "b4d4b57a7f99bc9f44ad1314afae429b", "patch_ids": ["2072501f14b820f1bfe35915d8b30158", "e087def6571d3f6e5a061dae62c2fd7c", "fe9957778679eb91b18205b9537edb64"], "statement_hash": "6cfcc165edbe911269bd81960b16bec9e8a30a5f6f44ec922baa64b01873c0ed", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-f5dcfc56f8dde08e", "migration": false}, {"id": "19.0-3daf73605bfdc665", "cves": [], "html": "Allow io_method method worker to automatically control needed background workers (Thomas Munro) \u00a7
The new server variables are io_min_workers, io_max_workers, io_worker_idle_timeout, and io_worker_launch_interval.
Allow query table scans to mark pages as all-visible in the visibility map (Melanie Plageman) \u00a7
\nPreviously only VACUUM and COPY ... FREEZE could do this.
Allow autovacuum to use parallel autovacuum workers (Daniil Davydov) \u00a7 \u00a7
The maximum number of workers is controlled by server variable autovacuum_max_parallel_workers and per-table storage parameter autovacuum_parallel_workers.
Allow TID Range Scans to be parallelized (Cary Huang, David Rowley) \u00a7
Improve COPY FROM performance for text and CSV input using SIMD CPU instructions (Nazir Bilal Yavuz, Shinya Kato) \u00a7
Improve NOTIFY to only wake up backends that are listening to specified notifications (Joel Jacobson) \u00a7
Previously most backends were woken by NOTIFY.
Change wal_compression equals on to use the best WAL compression method available (wenhui qiu) \u00a7
Previously this always used pglz.
Change the default TOAST compression method from pglz to the more efficient lz4 (Euler Taveira) \u00a7
This is done by changing the default for server variable default_toast_compression.
Improve performance of internal row deformation (David Rowley) \u00a7
", "text": "Improve performance of internal row deformation (David Rowley) \u00a7", "title": "Improve performance of internal row deformation", "commits": ["c456e3911"], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-PERFORMANCE", "source_hash": "e33ca61d27b34df73309428a3e161efa1d449ee1044142dba15d9d538241ec2b", "section_path": ["Server", "General Performance"], "commit_groups": [["c456e3911"]], "identity_text": "Improve performance of internal row deformation (David Rowley)", "commit_aliases": ["c456e3911"], "source_commits": ["c456e3911"], "source_entry_id": "19.0/changes/030", "db_id": "2f44033f40c98ee6a912c206532f6743", "patch_ids": ["2fb9e9b84098734ad1a8377076eb1c47"], "statement_hash": "1e8e65e0cb1dcba0aa0c3976cbd782de234996f92acb56d493eea9b3f4ad1817", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-8b5aec6ddca85fe5", "migration": false}, {"id": "19.0-a6c33a3e54232374", "cves": [], "html": "Improve performance of repeated UTF-8 case-folding operations (Andreas Karlsson) \u00a7
", "text": "Improve performance of repeated UTF-8 case-folding operations (Andreas Karlsson) \u00a7", "title": "Improve performance of repeated UTF-8 case-folding operations", "commits": ["c4ff35f10"], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-PERFORMANCE", "source_hash": "db8fbfa4cae3f4ce9ea41e2d7646f765107a8c90c00b50a26b5ab10d56937494", "section_path": ["Server", "General Performance"], "commit_groups": [["c4ff35f10"]], "identity_text": "Improve performance of repeated UTF-8 case-folding operations (Andreas Karlsson)", "commit_aliases": ["c4ff35f10"], "source_commits": ["c4ff35f10"], "source_entry_id": "19.0/changes/031", "db_id": "1910f331f0c069a5c4fed4524f4347c2", "patch_ids": ["ae87a7eb7068ebcf4d1d2b57fc639c7c"], "statement_hash": "9e3af8a44d0dedeb1741e935ea02b4dcc4de7cf406fe2bfb5e5b1435a115b5e0", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-a6c33a3e54232374", "migration": false}, {"id": "19.0-55e8599ec6e16a5d", "cves": [], "html": "Improve performance of hash index bulk-deletion and GIN index vacuuming using streaming reads (Xuneng Zhou) \u00a7 \u00a7
Improve sort performance using radix sort (John Naylor) \u00a7
", "text": "Improve sort performance using radix sort (John Naylor) \u00a7", "title": "Improve sort performance using radix sort", "commits": ["ef3c3cf6d"], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-PERFORMANCE", "source_hash": "053bf7d1a7a9e0349a991795e9476aaf1a1d59d2c0987e3bd5b973099c87cc5a", "section_path": ["Server", "General Performance"], "commit_groups": [["ef3c3cf6d"]], "identity_text": "Improve sort performance using radix sort (John Naylor)", "commit_aliases": ["ef3c3cf6d"], "source_commits": ["ef3c3cf6d"], "source_entry_id": "19.0/changes/033", "db_id": "e92f77f792175055754151b811c7e66f", "patch_ids": ["e549bc058c224184a36dddee5ed0274a"], "statement_hash": "1e58055dc676b28011576896b1a0c5617750d18c1bc9d507b6607e36ed2e726f", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-5906d443d6c17d19", "migration": false}, {"id": "19.0-9da3dd429f12c680", "cves": [], "html": "Improve timing performance measurements (Lukas Fittl, Andres Freund, David Geier) \u00a7 \u00a7
\nThis benefits EXPLAIN (ANALYZE, TIMING) and pg_test_timing, and is controlled via server variable timing_clock_source.
Optimize plpgsql syntax SELECT simple-expression INTO var (Tom Lane) \u00a7
Add system view pg_stat_lock and function pg_stat_get_lock() to report per-lock-type statistics (Bertrand Drouvot) \u00a7
Add system view pg_stat_recovery to report recovery status (Xuneng Zhou, Shinya Kato) \u00a7 \u00a7
Add system view pg_stat_autovacuum_scores to report per-table autovacuum details (Sami Imseih) \u00a7
Add system view pg_dsm_registry_allocations to report dynamic shared memory details (Florents Tselai, Nathan Bossart) \u00a7 \u00a7
Add vacuum initiation details to system view pg_stat_progress_vacuum (Shinya Kato) \u00a7
The new started_by column reports the initiator of the vacuum, and mode indicates its aggressiveness.
Add analyze initiation details to system view pg_stat_progress_analyze (Shinya Kato) \u00a7
The new started_by column reports the initiator of the analyze.
Add mem_exceeded_count column to system view pg_stat_replication_slots (Bertrand Drouvot) \u00a7
This reports the number of times that logical_decoding_work_mem was exceeded.
Add slot synchronization skip information to pg_stat_replication_slots and pg_replication_slots (Shlok Kyal) \u00a7 \u00a7 \u00a7
The new columns are slotsync_skip_count, slotsync_last_skip, and slotsync_skip_reason.
Add update_deleted column to system view pg_stat_subscription_stats (Zhijie Hou) \u00a7
This reports the number of rows where updates were ignored due to concurrent deletes. This requires the subscriber have retain_dead_tuples enabled.
Add sync_seq_error_count column to system view pg_stat_subscription_stats to report sequence synchronization errors (Vignesh C) \u00a7 \u00a7
Add stats_reset column to system views pg_stat_all_tables, pg_stat_all_indexes, and pg_statio_all_sequences (Bertrand Drouvot, Sami Imseih, Shihao Zhong) \u00a7
It also appears in the sys and user view variants.
Add stats_reset column to system views pg_stat_user_functions and pg_stat_database_conflicts (Bertrand Drouvot, Shihao Zhong) \u00a7 \u00a7
Add location column to system views pg_available_extensions and pg_available_extension_versions to report the file system directory of extensions (Matheus Alcantara) \u00a7
Add backup_type column to system view pg_stat_progress_basebackup to report the type of backup (Shinya Kato) \u00a7
Possible values are full or incremental.
Add connecting value to system view column pg_stat_wal_receiver.status (Xuneng Zhou) \u00a7
Add reporting of the bytes written to WAL for full page images (Shinya Kato) \u00a7
\nThis is accessible via system view pg_stat_wal and function pg_stat_get_backend_wal().
Add columns to system views pg_stats, pg_stats_ext, and pg_stats_ext_exprs (Corey Huinker) \u00a7
Adds table OID and attribute number columns to pg_stats, and table OID and statistics object OID columns to the other two.
Add information about range type extended statistics to system view pg_stats_ext_exprs (Corey Huinker, Michael Paquier) \u00a7
Allow log_min_messages log levels to be specified by process type (Euler Taveira) \u00a7
The new format is type:level. A value without a colon controls all process types, allowing backward compatibility.
Add server variable log_autoanalyze_min_duration to log long-running analyze operations by autovacuum operations (Shinya Kato) \u00a7
Server variable log_autovacuum_min_duration now only controls logging of vacuum operations by autovacuum.
Enable server variable log_lock_waits by default (Laurenz Albe) \u00a7
Add server variable debug_print_raw_parse to log raw parse trees (Chao Li) \u00a7
This is also enabled when the server is started with debug level three and higher.
", "text": "Add server variable debug_print_raw_parse to log raw parse trees (Chao Li) \u00a7 This is also enabled when the server is started with debug level three and higher.", "title": "Add server variable debug_print_raw_parse to log raw parse trees", "commits": ["06473f5a3"], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MONITORING", "source_hash": "cf2b08c6678a0a1a1b8123788c8c9b909cd72f7ab49aa1b35cd5d06be6b81989", "section_path": ["Server", "Monitoring"], "commit_groups": [["06473f5a3"]], "identity_text": "Add server variable debug_print_raw_parse to log raw parse trees (Chao Li) This is also enabled when the server is started with debug level three and higher.", "commit_aliases": ["06473f5a3"], "source_commits": ["06473f5a3"], "source_entry_id": "19.0/changes/057", "db_id": "5646c356710a0ff468e680767a12145f", "patch_ids": ["35275b87d078704b84093abdbb33b317"], "statement_hash": "888aed639a6c6d53026c2715f12cfbf15bb0732325722454f20900b5f470d25d", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-640782815f1992c6", "migration": false}, {"id": "19.0-fcff94c8e75b9a3e", "cves": [], "html": "Make messages coming from remote servers appear in the server logs in the same format as local server messages (Vignesh C) \u00a7
\nThese include replication, postgres_fdw, and dblink servers.
", "text": "Make messages coming from remote servers appear in the server logs in the same format as local server messages (Vignesh C) \u00a7 These include replication, postgres_fdw, and dblink servers.", "title": "Make messages coming from remote servers appear in the server logs in the same format as local server messages", "commits": ["112faf137"], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MONITORING", "source_hash": "4ae996182bc6ba341f5e82fada3ae225f941056fba9d335934e5a8ae1b3733fb", "section_path": ["Server", "Monitoring"], "commit_groups": [["112faf137"]], "identity_text": "Make messages coming from remote servers appear in the server logs in the same format as local server messages (Vignesh C) These include replication, postgres-fdw , and dblink servers.", "commit_aliases": ["112faf137"], "source_commits": ["112faf137"], "source_entry_id": "19.0/changes/058", "db_id": "2cd99aa5d193f608f0189a8061cb76f6", "patch_ids": ["ccf9c16787dca7d50e3a9153f9cfb579"], "statement_hash": "77ed52b035fe5f53546a51163df4617c0ab7ab64f9c6bced5a8bf49f6daca771", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-fcff94c8e75b9a3e", "migration": false}, {"id": "19.0-51905d1ba76fdedc", "cves": [], "html": "Add reporting of WAL full-page write bytes to VACUUM and ANALYZE logging (Shinya Kato) \u00a7
Add IO wait events for COPY FROM/TO on a pipe, file, or program (Nikolay Samokhvalov) \u00a7
Add wait events for commit_delay and for WAL write and flush LSNs (Xuneng Zhou) \u00a7 \u00a7
", "text": "Add wait events for commit_delay and for WAL write and flush LSNs (Xuneng Zhou) \u00a7 \u00a7", "title": "Add wait events for commit_delay and for WAL write and flush LSNs", "commits": ["3cb5808bd", "7a39f43d8"], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MONITORING", "source_hash": "b6cdd2c52e3d79b26d3f29232151d98d568bf6c9066cf95a0b816da2483f1c53", "section_path": ["Server", "Monitoring"], "commit_groups": [["3cb5808bd"], ["7a39f43d8"]], "identity_text": "Add wait events for guc-commit-delay and for WAL write and flush LSNs (Xuneng Zhou)", "commit_aliases": ["3cb5808bd", "7a39f43d8"], "source_commits": ["3cb5808bd", "7a39f43d8"], "source_entry_id": "19.0/changes/061", "db_id": "9ce16931b04b6b8074722b817754bc63", "patch_ids": ["1f0d51e7a5eb278056c49933b60ca129", "aa919e1de06d26365f9c5f03b3bcdf3a"], "statement_hash": "971e2da0d9f5c4e877063d950e28551c7a6d2239996851345a33279cfbe6c6c3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-575a583a5b3d25dc", "migration": false}, {"id": "19.0-68646ca8ac71b5bf", "cves": [], "html": "Have pg_get_sequence_data() return the sequence page LSN (Vignesh C) \u00a7
Add function pg_get_multixact_stats() to report multixact activity (Naga Appani) \u00a7
Issue warnings when the wraparound of xid and multi-xids is less than 100 million (Nathan Bossart) \u00a7
\nThe previous warning was 40 million. Warnings are issued to clients and in the server log.
", "text": "Issue warnings when the wraparound of xid and multi-xids is less than 100 million (Nathan Bossart) \u00a7 The previous warning was 40 million. Warnings are issued to clients and in the server log.", "title": "Issue warnings when the wraparound of xid and multi-xids is less than 100 million", "commits": ["48f11bfa0"], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MONITORING", "source_hash": "c5e174788f858c1ea39304f17b2f2e66d81fbe3a3b5cbce9ae18976d4b3b960b", "section_path": ["Server", "Monitoring"], "commit_groups": [["48f11bfa0"]], "identity_text": "Issue warnings when the wraparound of xid and multi-xids is less than 100 million (Nathan Bossart) The previous warning was 40 million. Warnings are issued to clients and in the server log.", "commit_aliases": ["48f11bfa0"], "source_commits": ["48f11bfa0"], "source_entry_id": "19.0/changes/064", "db_id": "c86b2dfd0978d65014a81a022bfc457e", "patch_ids": ["56cc61cb3c8c85c3391226a6d84b88b9"], "statement_hash": "fbeacdf215797907d57b49f52da6308db6ae4242af2333d2566670274680679c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-b8f9f0ccf4c3b14c", "migration": false}, {"id": "19.0-cb57c6cecaf356d3", "cves": [], "html": "Add scoring system to control the order that tables are processed by autovacuum (Nathan Bossart) \u00a7
\nThe new server variables are autovacuum_freeze_score_weight, autovacuum_multixact_freeze_score_weight, autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight, and autovacuum_analyze_score_weight.
Add server-side support for SNI (Server Name Indication) (Daniel Gustafsson, Jacob Champion) \u00a7
\nNew configuration file PGDATA/pg_hosts.conf specifies hostname/key pairs.
Allow OAuth validators to register custom pg_hba.conf authentication options (Jacob Champion, Zsolt Parragi) \u00a7
Allow roles pg_read_all_data and pg_write_all_data to read/write large objects (Nitin Motiani, Nathan Bossart) \u00a7
These roles are designed to allow non-super users to run pg_dump.
", "text": "Allow roles pg_read_all_data and pg_write_all_data to read/write large objects (Nitin Motiani, Nathan Bossart) \u00a7 These roles are designed to allow non-super users to run pg_dump.", "title": "Allow roles pg_read_all_data and pg_write_all_data to read/write large objects", "commits": ["d98197602"], "section": "Server / Server Configuration", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-CONFIG", "source_hash": "127199712cb45ed03c695d443c22da7886e43b5a3c861863e0938e4249869482", "section_path": ["Server", "Server Configuration"], "commit_groups": [["d98197602"]], "identity_text": "Allow roles pg_read_all_data and pg_write_all_data to read/write large objects (Nitin Motiani, Nathan Bossart) These roles are designed to allow non-super users to run pg_dump.", "commit_aliases": ["d98197602"], "source_commits": ["d98197602"], "source_entry_id": "19.0/changes/068", "db_id": "7546efde38c27c3ea4c44d31a764c942", "patch_ids": ["e8821ab803267cd9177e8f533e609ff5"], "statement_hash": "f78ec1c3d3366a20842cbbac9665c0542dda68d3cb6ea036006fe09bdf6d8e89", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-ead1db00a773cb6b", "migration": false}, {"id": "19.0-cd30210631923c00", "cves": [], "html": "Allow background workers to be configured to terminate before database-level operations (Aya Iwata) \u00a7
\nThis allows database-level operations to complete more quickly since blocking background workers can now be terminated.
", "text": "Allow background workers to be configured to terminate before database-level operations (Aya Iwata) \u00a7 This allows database-level operations to complete more quickly since blocking background workers can now be terminated.", "title": "Allow background workers to be configured to terminate before database-level operations", "commits": ["f1e251be8"], "section": "Server / Server Configuration", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-CONFIG", "source_hash": "3b253bfaa88968971752451a8075a5a5a8c7c5e429269c6607cc4ca273a01257", "section_path": ["Server", "Server Configuration"], "commit_groups": [["f1e251be8"]], "identity_text": "Allow background workers to be configured to terminate before database-level operations (Aya Iwata) This allows database-level operations to complete more quickly since blocking background workers can now be terminated.", "commit_aliases": ["f1e251be8"], "source_commits": ["f1e251be8"], "source_entry_id": "19.0/changes/069", "db_id": "94d0fbd1cd265761e78acc6492d37d07", "patch_ids": ["5a78770d7da2184228f0ab9685eafd9e"], "statement_hash": "828364cf1cc33ec4d8b84f8666275ef6a299eb947bab17da8e236dec761121c1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-cd30210631923c00", "migration": false}, {"id": "19.0-c4255bd8ab8c569f", "cves": [], "html": "Allow server variables that represent lists to be emptied by setting the value to NULL (Tom Lane) \u00a7
Update GB18030 encoding from version 2000 to 2022 (Chao Li, Zheng Tao) \u00a7
\nSee the commit message for compatibility details.
", "text": "Update GB18030 encoding from version 2000 to 2022 (Chao Li, Zheng Tao) \u00a7 See the commit message for compatibility details.", "title": "Update GB18030 encoding from version 2000 to 2022", "commits": ["5334620ee"], "section": "Server / Server Configuration", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-CONFIG", "source_hash": "ee2981026ec290bb348e89954c5b60c8d9c4483c6d0eaabe3b08b41689028924", "section_path": ["Server", "Server Configuration"], "commit_groups": [["5334620ee"]], "identity_text": "Update GB18030 encoding from version 2000 to 2022 (Chao Li, Zheng Tao) See the commit message for compatibility details.", "commit_aliases": ["5334620ee"], "source_commits": ["5334620ee"], "source_entry_id": "19.0/changes/071", "db_id": "3cb57e2d01a6cd251c7c76adc4b04cd3", "patch_ids": ["48b8aca46ccc0401e45a940f9c75b966"], "statement_hash": "594deded9e558041e87867a80a07ef79e230cbd6044de59b45a32f09dc48c45e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-6921b97081a5ff87", "migration": false}, {"id": "19.0-a5f671b391df23ae", "cves": [], "html": "Add WAIT command to allow standbys to wait for LSN values to be written, flushed, or replayed (Kartyshov Ivan, Alexander Korotkov, Xuneng Zhou) \u00a7 \u00a7
Improve function pg_sync_replication_slots() to wait for replication synchronization completion (Ajin Cherian, Zhijie Hou) \u00a7
Previously, certain synchronization failures would not be reported.
", "text": "Improve function pg_sync_replication_slots() to wait for replication synchronization completion (Ajin Cherian, Zhijie Hou) \u00a7 Previously, certain synchronization failures would not be reported.", "title": "Improve function pg_sync_replication_slots() to wait for replication synchronization completion", "commits": ["0d2d4a0ec"], "section": "Server / Streaming Replication and Recovery", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-REPLICATION", "source_hash": "d681defc763334271c6eabcffe2479e61a6f41208cdbe9de86a02faf459c7d7d", "section_path": ["Server", "Streaming Replication and Recovery"], "commit_groups": [["0d2d4a0ec"]], "identity_text": "Improve function pg_sync_replication_slots() to wait for replication synchronization completion (Ajin Cherian, Zhijie Hou) Previously, certain synchronization failures would not be reported.", "commit_aliases": ["0d2d4a0ec"], "source_commits": ["0d2d4a0ec"], "source_entry_id": "19.0/changes/073", "db_id": "45a31034a4672bd881e44cbe52066ccc", "patch_ids": ["338e3e19e235235f0275be20e543213b"], "statement_hash": "425b216f04b5fec1c9f6f6ba4f6eb2025d2d607e4b08e81c19bfc08de35595e5", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-c84bd47451b676b2", "migration": false}, {"id": "19.0-980bcbd4aad35502", "cves": [], "html": "Add server variable wal_sender_shutdown_timeout to limit replica synchronization waits during shutdown (Andrey Silitskiy, Hayato Kuroda) \u00a7
By default, senders still wait forever for synchronization.
", "text": "Add server variable wal_sender_shutdown_timeout to limit replica synchronization waits during shutdown (Andrey Silitskiy, Hayato Kuroda) \u00a7 By default, senders still wait forever for synchronization.", "title": "Add server variable wal_sender_shutdown_timeout to limit replica synchronization waits during shutdown", "commits": ["a8f45dee9"], "section": "Server / Streaming Replication and Recovery", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-REPLICATION", "source_hash": "f041fedc21d2d911223dcb4d84e0a674aa4569686f06d1f85deeea135f2a1bd5", "section_path": ["Server", "Streaming Replication and Recovery"], "commit_groups": [["a8f45dee9"]], "identity_text": "Add server variable wal_sender_shutdown_timeout to limit replica synchronization waits during shutdown (Andrey Silitskiy, Hayato Kuroda) By default, senders still wait forever for synchronization.", "commit_aliases": ["a8f45dee9"], "source_commits": ["a8f45dee9"], "source_entry_id": "19.0/changes/074", "db_id": "203a2adcedefdb3edd8d755c8e8d5ca4", "patch_ids": ["08ebe665d7e0f34213e1790cadf03a27"], "statement_hash": "9e31240cd0f7357f5add0456a9f2241263b7e5ee8e97793d13a6536581761a05", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-980bcbd4aad35502", "migration": false}, {"id": "19.0-e37b9a6a82bd3e8c", "cves": [], "html": "Allow sequence values stored in subscribers to match the publisher (Vignesh C) \u00a7 \u00a7 \u00a7
\nThis is enabled during CREATE SUBSCRIPTION, ALTER SUBSCRIPTION ... REFRESH PUBLICATION, and ALTER SUBSCRIPTION ... REFRESH SEQUENCES. The latter only updates values, not sequence existence. Function pg_get_sequence_data() allows inspection of sequence synchronization.
Allow CREATE/ALTER PUBLICATION to publish all sequences (Vignesh C, Tomas Vondra) \u00a7
This is enabled with the ALL SEQUENCES clause.
Allow ALTER SUBSCRIPTION on publications to synchronize the existence of sequences on subscribers to match the publisher (Vignesh C) \u00a7
This is enabled with the REFRESH SEQUENCES clause.
Allow CREATE/ALTER PUBLICATION to exclude some tables (Vignesh C, Shlok Kyal) \u00a7 \u00a7 \u00a7 \u00a7
This is controlled with the EXCEPT clause, and is useful when specifying ALL TABLES.
Add CREATE/ALTER SUBSCRIPTION setting retain_dead_tuples to retain information needed for conflict detection (Zhijie Hou) \u00a7 \u00a7 \u00a7
Also add setting max_retention_duration to limit retain_dead_tuples retention.
Allow CREATE SUBSCRIPTION to use postgres_fdw foreign data wrapper connection parameters (Jeff Davis) \u00a7
The connection parameters are referenced via CREATE SUBSCRIPTION ... SERVER.
When server variable wal_level is replica, allow automatic enablement of logical replication when needed (Masahiko Sawada) \u00a7
New server variable effective_wal_level, application pg_controldata, and function pg_control_checkpoint() report the effective WAL level.
Allow wal_receiver_timeout to be set per-subscription and user (Fujii Masao) \u00a7 \u00a7
This allows subscribers to use different wal_receiver_timeout values.
Add optional pid parameter to pg_replication_origin_session_setup() to allow parallelization of SQL-level replication solutions (Doruk Yilmaz, Hayato Kuroda) \u00a7
Allow GROUP BY to process target list subqueries that have expressions referencing non-subquery columns (Tom Lane) \u00a7
Also fix a bug in how GROUPING() handles target list subquery aliases.
Allow window functions to ignore NULLs with the IGNORE NULLS/RESPECT NULLS clause (Oliver Ford, Tatsuo Ishii) \u00a7
Supported window functions are lead(), lag(), first_value(), last_value(), and nth_value().
Add support for INSERT ... ON CONFLICT DO SELECT ... RETURNING (Andreas Karlsson, Marko Tiikkaja, Viktor Holmberg) \u00a7
This allows conflicting rows to be returned, and optionally locked with FOR UPDATE/SHARE.
Add REPACK command which replaces VACUUM FULL and CLUSTER (Antonin Houska) \u00a7
The two former commands did similar things, but with confusing names, so unify them as REPACK. The old commands have been retained for compatibility.
Allow REPACK to rebuild tables without access-exclusive locking (Antonin Houska, Mihail Nikalayeu, \u00c1lvaro Herrera) \u00a7 \u00a7 \u00a7
This is enabled via the CONCURRENTLY option. Server variable max_repack_replication_slots was also added.
Allow GRANT/REVOKE to specify the effective role performing the privileges adjustment (Nathan Bossart, Tom Lane) \u00a7
The GRANTED BY clause controls this.
Support forward references in FOREIGN KEY constraint clauses within CREATE SCHEMA (Jian He, Tom Lane) \u00a7
Allow CHECKPOINT to accept a list of options (Christoph Berg) \u00a7 \u00a7 \u00a7
Supported options are MODE and FLUSH_UNLOGGED.
Add CONNECTION clause to CREATE FOREIGN DATA WRAPPER to specify a function to be called for subscription connection parameters (Jeff Davis, Noriyoshi Shinoda) \u00a7 \u00a7
Add SUPPORT clause to CREATE AGGREGATE so extensions can specify support functions to optimize aggregate calls (Tom Lane) \u00a7
Add memory usage and parallelism reporting to VACUUM (VERBOSE) and autovacuum logs (Tatsuya Kawata, Daniil Davydov) \u00a7 \u00a7
Allow ALTER TABLE ALTER CONSTRAINT ... [NOT] ENFORCED for CHECK constraints (Jian He) \u00a7
Previously enforcement changes were only supported for foreign key constraints.
", "text": "Allow ALTER TABLE ALTER CONSTRAINT ... [NOT] ENFORCED for CHECK constraints (Jian He) \u00a7 Previously enforcement changes were only supported for foreign key constraints.", "title": "Allow ALTER TABLE ALTER CONSTRAINT ... [NOT] ENFORCED for CHECK constraints", "commits": ["342051d73"], "section": "Utility Commands / Constraints", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-CONSTRAINTS", "source_hash": "59987e86b56cfee4e8c516b2af161abe361b198473f75625fa488ce050eda323", "section_path": ["Utility Commands", "Constraints"], "commit_groups": [["342051d73"]], "identity_text": "Allow ALTER TABLE ALTER CONSTRAINT ... [NOT] ENFORCED for CHECK constraints (Jian He) Previously enforcement changes were only supported for foreign key constraints.", "commit_aliases": ["342051d73"], "source_commits": ["342051d73"], "source_entry_id": "19.0/changes/095", "db_id": "55915420081329c439adbcc41b75c155", "patch_ids": ["250565e38eddc1be4c0b9329b8d17ed9"], "statement_hash": "08ad7dcf1b13ccb659e6746561b917ccdb0988d6f6241b71489006dc339388cc", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-463f77e05b28a94e", "migration": false}, {"id": "19.0-567e60cb83ffaea3", "cves": [], "html": "Allow ALTER TABLE ... COLUMN SET EXPRESSION to succeed on virtual columns with CHECK constraints (Jian He) \u00a7
This was previously prohibited.
", "text": "Allow ALTER TABLE ... COLUMN SET EXPRESSION to succeed on virtual columns with CHECK constraints (Jian He) \u00a7 This was previously prohibited.", "title": "Allow ALTER TABLE ... COLUMN SET EXPRESSION to succeed on virtual columns with CHECK constraints", "commits": ["f80bedd52"], "section": "Utility Commands / Constraints", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-CONSTRAINTS", "source_hash": "14269a8de80a7ac83d0de53334935a73013e09e60261599a0695a77127c07d37", "section_path": ["Utility Commands", "Constraints"], "commit_groups": [["f80bedd52"]], "identity_text": "Allow ALTER TABLE ... COLUMN SET EXPRESSION to succeed on virtual columns with CHECK constraints (Jian He) This was previously prohibited.", "commit_aliases": ["f80bedd52"], "source_commits": ["f80bedd52"], "source_entry_id": "19.0/changes/096", "db_id": "719650dd55687b1d229757e6fc2b2d76", "patch_ids": ["638ada60613f5b5c1d2e3938cfc3c57d"], "statement_hash": "b7e3c7509d7d7a6f40c833dc8faf0c1b6189d02d88ec226ae4acae22ccc46dde", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-567e60cb83ffaea3", "migration": false}, {"id": "19.0-9ef3abbb86312705", "cves": [], "html": "Allow multiple headers lines to be skipped by COPY FROM (Shinya Kato, Fujii Masao) \u00a7
Previously only a single header line could be skipped.
", "text": "Allow multiple headers lines to be skipped by COPY FROM (Shinya Kato, Fujii Masao) \u00a7 Previously only a single header line could be skipped.", "title": "Allow multiple headers lines to be skipped by COPY FROM", "commits": ["bc2f348e8"], "section": "Utility Commands / COPY", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-COPY", "source_hash": "a5ea76193731276bde664acb67390f8ca66e4b28e5fe6f2356bd94e59c267a28", "section_path": ["Utility Commands", "COPY"], "commit_groups": [["bc2f348e8"]], "identity_text": "Allow multiple headers lines to be skipped by COPY FROM (Shinya Kato, Fujii Masao) Previously only a single header line could be skipped.", "commit_aliases": ["bc2f348e8"], "source_commits": ["bc2f348e8"], "source_entry_id": "19.0/changes/097", "db_id": "9e69371e828ab9188c2acff849734796", "patch_ids": ["05e2d08f24f6389cee7e47f4b967632f"], "statement_hash": "8b018f13b141716433f2b822df1fff84f0687b9057f813d40f36d04cf818f38c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-9ef3abbb86312705", "migration": false}, {"id": "19.0-34306d3cbc671e9f", "cves": [], "html": "Allow COPY FROM to set invalid input values to NULL (Jian He, Kirill Reshke) \u00a7
This is done using the COPY option ON_ERROR SET_NULL.
Allow COPY TO to output JSON format (Joe Conway, Jian He, Andrew Dunstan) \u00a7 \u00a7
JSON output can also be a single JSON array using the COPY option FORCE_ARRAY.
Allow COPY TO to process partitioned tables (Jian He, Ajin Cherian) \u00a7 \u00a7
Previously COPY (SELECT ...) had to be used to output partitioned tables. This also improves logical replication table synchronization.
Add EXPLAIN ANALYZE option IO to report asynchronous IO activity (Tomas Vondra) \u00a7 \u00a7 \u00a7
Add reporting of WAL full-page write bytes to EXPLAIN (ANALYZE, WAL) output (Shinya Kato) \u00a7
Add Memoize cache and lookup estimates to EXPLAIN output (Ilia Evdokimov, Lukas Fittl) \u00a7
This can show why Memoize was chosen.
", "text": "Add Memoize cache and lookup estimates to EXPLAIN output (Ilia Evdokimov, Lukas Fittl) \u00a7 This can show why Memoize was chosen.", "title": "Add Memoize cache and lookup estimates to EXPLAIN output", "commits": ["4bc62b868"], "section": "Utility Commands / EXPLAIN", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-EXPLAIN", "source_hash": "7ec0d59ce6bd88b207b85ec2706b87f29bdb673ed9807ee038c96b08f6907cb2", "section_path": ["Utility Commands", "EXPLAIN"], "commit_groups": [["4bc62b868"]], "identity_text": "Add Memoize cache and lookup estimates to EXPLAIN output (Ilia Evdokimov, Lukas Fittl) This can show why Memoize was chosen.", "commit_aliases": ["4bc62b868"], "source_commits": ["4bc62b868"], "source_entry_id": "19.0/changes/103", "db_id": "200882adc883b5bad6075b2ec5fa4eba", "patch_ids": ["362813dc72ebd4c49399fe5c80a3b8c0"], "statement_hash": "8f74f54c172bca3c1e922da2e18aae3836cd815d80f79316224dfd9b1c0d5ca4", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-c7aca9803b28ccfb", "migration": false}, {"id": "19.0-451f6de8e1fa93f7", "cves": [], "html": "Add the 64-bit unsigned data type oid8 (Michael Paquier) \u00a7
Add more jsonpath string methods (Florents Tselai, David E. Wheeler) \u00a7
They are ltrim(), rtrim(), btrim(), lower(), upper(), initcap(), replace(), and split_part(). These are immutable like their non-JSON string variants.
Allow casts between bytea and uuid data types (Dagfinn Ilmari Manns\u00e5ker, Aleksander Alekseev) \u00a7
Add ability to cast between database names and oids using regdatabase (Ian Lawrence Barwick) \u00a7
Add functions tid_block() and tid_offset() to extract block numbers and offsets from tid values (Ayush Tiwari) \u00a7
Add date, timestamp, and timestamptz versions of random(min, max) (Damien Clochard, Dean Rasheed) \u00a7 \u00a7
Allow encode() and decode() to process data in base64url and base32hex formats (Andrey Borodin, Aleksander Alekseev, Florents Tselai) \u00a7 \u00a7 \u00a7
This format retains ordering, unlike base32.
Add functions to return a set of ranges resulting from range subtraction (Paul A. Jungwirth) \u00a7
\nThe functions are range_minus_multi() and multirange_minus_multi(). This is useful to represent range subtraction results with gaps.
Add function error_on_null() to return the supplied parameter, or error on NULL input (Joel Jacobson) \u00a7
Allow IS JSON to work on domains defined over supported base types (Jian He) \u00a7
The supported base types are TEXT, JSON, JSONB, and BYTEA.
Add full text stemmers for Polish and Esperanto (Tom Lane) \u00a7
\nThe Dutch stemmer has also been updated. The old Dutch stemmer is available via dutch_porter.
Allow event triggers to be written using PL/Python (Euler Taveira, Dimitri Fontaine) \u00a7
", "text": "Allow event triggers to be written using PL/Python (Euler Taveira, Dimitri Fontaine) \u00a7", "title": "Allow event triggers to be written using PL/Python", "commits": ["53eff471c"], "section": "Functions", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-FUNCTIONS", "source_hash": "77962c064a273e05efd2b61ebac298cb405f217bf9ebefeda59aee0663fbce65", "section_path": ["Functions"], "commit_groups": [["53eff471c"]], "identity_text": "Allow event triggers to be written using PL/Python (Euler Taveira, Dimitri Fontaine)", "commit_aliases": ["53eff471c"], "source_commits": ["53eff471c"], "source_entry_id": "19.0/changes/115", "db_id": "dea4d618db8f59f9a6897cebf4fd37b3", "patch_ids": ["12561dc0cbadbe3c5683a8d9fc46a72b"], "statement_hash": "e86760cae912c2895e04b314848870434aba1cd233fb99049b68bad93b6ce9cc", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-19e83da9aed9bb4c", "migration": false}, {"id": "19.0-69aa41fdebdd77f0", "cves": [], "html": "Allow libpq connections to specify a service file via servicefile (Torsten F\u00f6rtsch, Ryo Kanbayashi) \u00a7
Add special libpq protocol parameters for compatibility testing (Jelte Fennema-Nio, Jacob Champion) \u00a7
\nOtherwise known as protocol grease, which was active during the 19 beta period. These will no longer be sent as of the PostgreSQL 19 official release, but the parameter reservations will remain for potential use in the future.
", "text": "Add special libpq protocol parameters for compatibility testing (Jelte Fennema-Nio, Jacob Champion) \u00a7 Otherwise known as protocol grease, which was active during the 19 beta period. These will no longer be sent as of the PostgreSQL 19 official release, but the parameter reservations will remain for potential use in the future.", "title": "Add special libpq protocol parameters for compatibility testing", "commits": ["d8d7c5dc8"], "section": "Libpq", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-LIBPQ", "source_hash": "c5fb4bfaa74cf3b3818ee61e8d4ac15edbca103da3729cd9c38e1a7e861adec5", "section_path": ["Libpq"], "commit_groups": [["d8d7c5dc8"]], "identity_text": "Add special libpq protocol parameters for compatibility testing (Jelte Fennema-Nio, Jacob Champion) Otherwise known as protocol grease, which was active during the 19 beta period. These will no longer be sent as of the PostgreSQL 19 official release, but the parameter reservations will remain for potential use in the future.", "commit_aliases": ["d8d7c5dc8"], "source_commits": ["d8d7c5dc8"], "source_entry_id": "19.0/changes/117", "db_id": "ff2b1dfe6067b31cf2bf934b7684cd23", "patch_ids": ["3632c83c1c1a91ef0ac583beea2de520"], "statement_hash": "650d3c1f8b2817bbf8a3398d8b09dc4b6cdd677149d6a52b52e8eba14e0d179b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-b5fec90b8d9cccee", "migration": false}, {"id": "19.0-1d98b3714cb11ecb", "cves": [], "html": "Add libpq connection parameter oauth_ca_file to specify an alternate certificate authority when communicating with OAuth providers (Jonathan Gonzalez V., Jacob Champion) \u00a7
This can also be set via the PGOAUTHCAFILE environment variable. The default is to use curl's built-in certificates.
Allow libpq environment variable PGOAUTHDEBUG to specify particular debug options (Zsolt Parragi, Jacob Champion) \u00a7
The UNSAFE option still generates all debugging output.
Improve custom OAuth client flows (Jacob Champion) \u00a7 \u00a7
\nPreviously, libpq reported only a generic error message during custom flow failures, and each flow implementation was required to calculate the issuer identifier independently. Add a new authdata hook type PQAUTHDATA_OAUTH_BEARER_TOKEN_V2 that precomputes the issuer ID and lets hooks provide error details.
Add libpq function PQgetThreadLock() to retrieve the current locking callback (Jacob Champion) \u00a7
Allow the search path to appear in the psql prompt via %S (Florents Tselai) \u00a7
This works when psql is connected to PostgreSQL 18 or later.
", "text": "Allow the search path to appear in the psql prompt via %S (Florents Tselai) \u00a7 This works when psql is connected to PostgreSQL 18 or later.", "title": "Allow the search path to appear in the psql prompt via %S", "commits": ["b3ce55f41"], "section": "psql", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-PSQL", "source_hash": "eb5f3532cbd779ff0f91ab011cc454508ae5f01ff43500a5d8dbdaead990a9aa", "section_path": ["psql"], "commit_groups": [["b3ce55f41"]], "identity_text": "Allow the search path to appear in the psql prompt via %S (Florents Tselai) This works when psql is connected to PostgreSQL 18 or later.", "commit_aliases": ["b3ce55f41"], "source_commits": ["b3ce55f41"], "source_entry_id": "19.0/changes/122", "db_id": "4466a740b06e239e2c620ecf5068da5c", "patch_ids": ["d4c541bb14197ec33826096426a28019"], "statement_hash": "29ab507d60b9104abb3f9325a7f1d1a4f509977ce16eaad9324ac80a3893381b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-798dbb9364a5d9c5", "migration": false}, {"id": "19.0-2460a91e44effe22", "cves": [], "html": "Allow the hot standby status to appear in the psql prompt via %i (Jim Jones) \u00a7
Modify psql backslash commands to show comments for publications, subscriptions, and extended statistics (Fujii Masao, Jim Jones) \u00a7
\nThe modified commands are \\dRp+, \\dRs+, and \\dX+.
Allow control over how booleans are displayed in psql (David G. Johnston) \u00a7
\nThe \\pset variables are display_true and display_false.
Add psql variable SERVICEFILE to reference the service file location (Ryo Kanbayashi) \u00a7
Allow psql to more accurately determine if the pager is needed (Erik Wienhold) \u00a7
", "text": "Allow psql to more accurately determine if the pager is needed (Erik Wienhold) \u00a7", "title": "Allow psql to more accurately determine if the pager is needed", "commits": ["27da1a796"], "section": "psql", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-PSQL", "source_hash": "6113bc7d5ac6ce6ca3017852451a83f7de3864887d5c08b7bf602891fe727aff", "section_path": ["psql"], "commit_groups": [["27da1a796"]], "identity_text": "Allow psql to more accurately determine if the pager is needed (Erik Wienhold)", "commit_aliases": ["27da1a796"], "source_commits": ["27da1a796"], "source_entry_id": "19.0/changes/127", "db_id": "43e3e5f1ede31bcf04563b5afcfc3a00", "patch_ids": ["d124a0f76abfa8b4a074a31702b32a98"], "statement_hash": "a13e94bf03e181e5e1b6f290cacb01a36ec07870dc5f606fcf6f13b4a604c26f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-c9aa3d8c8674408e", "migration": false}, {"id": "19.0-cc1e794ef5a081a8", "cves": [], "html": "Add or improve psql tab completion (Yamaguchi Atsuo, Yugo Nagata, Haruna Miwa, Xuneng Zhou, Dagfinn Ilmari Manns\u00e5ker, Fujii Masao, \u00c1lvaro Herrera, Jian He, Tatsuya Kawata, Ian Lawrence Barwick, Vasuki M) \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7
", "text": "Add or improve psql tab completion (Yamaguchi Atsuo, Yugo Nagata, Haruna Miwa, Xuneng Zhou, Dagfinn Ilmari Manns\u00e5ker, Fujii Masao, \u00c1lvaro Herrera, Jian He, Tatsuya Kawata, Ian Lawrence Barwick, Vasuki M) \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7 \u00a7", "title": "Add or improve psql tab completion", "commits": ["02fd47dbf", "0bf7d4ca9", "14ee8e640", "28c4b8a05", "344b572e3", "5fa7837d9", "6d2ff1de4", "81966c545", "86c539c5a", "a1f7f91be", "a4c10de92", "a604affad", "c6a7d3bab", "ff0bcb248"], "section": "psql", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-PSQL", "source_hash": "495b95f24035b18e959b7118e2b2bccc2eac97e31f678879bc2b7bd96b5a84b7", "section_path": ["psql"], "commit_groups": [["02fd47dbf"], ["0bf7d4ca9"], ["14ee8e640"], ["28c4b8a05"], ["344b572e3"], ["5fa7837d9"], ["6d2ff1de4"], ["81966c545"], ["86c539c5a"], ["a1f7f91be"], ["a4c10de92"], ["a604affad"], ["c6a7d3bab"], ["ff0bcb248"]], "identity_text": "Add or improve psql tab completion (Yamaguchi Atsuo, Yugo Nagata, Haruna Miwa, Xuneng Zhou, Dagfinn Ilmari Manns\u00e5ker, Fujii Masao, \u00c1lvaro Herrera, Jian He, Tatsuya Kawata, Ian Lawrence Barwick, Vasuki M)", "commit_aliases": ["02fd47dbf", "0bf7d4ca9", "14ee8e640", "28c4b8a05", "344b572e3", "5fa7837d9", "6d2ff1de4", "81966c545", "86c539c5a", "a1f7f91be", "a4c10de92", "a604affad", "c6a7d3bab", "ff0bcb248"], "source_commits": ["02fd47dbf", "0bf7d4ca9", "14ee8e640", "28c4b8a05", "344b572e3", "5fa7837d9", "6d2ff1de4", "81966c545", "86c539c5a", "a1f7f91be", "a4c10de92", "a604affad", "c6a7d3bab", "ff0bcb248"], "source_entry_id": "19.0/changes/128", "db_id": "97b6d1cb2b1c6f790e1ee0cc68c428f3", "patch_ids": ["0bc376509890d77647e587ceff1a09ea", "17bff6ec871538f49e658de435f132b7", "20909bee90f1612ca703976d25da4fe7", "5d94de103f4f8fbf41a27b4cf4c56f09", "5f74e7e5145fefdaedfb976ffce67bea", "83ce67d04ac574e86d5bea046edd389e", "aa13c523c0813d34b174efdf29f499ba", "b77a4036f7f23cf20f825245c8da3348", "d46cb2f27b79e74e5030f415873eafca", "d730e4d79557c79705494268a9a195de", "d780ef56bcb3d7ffef09b3cd3188438c", "dd8cde8962ab3420bca932e3d29ff31e", "dfa561fff55c8cf24ddb85664a222972", "fc29e1c27292cc71b84d0ad33579447a"], "statement_hash": "475b3b6334690493954256eb56aa5edf61bc1bf14ac662ca4097554f0d2af294", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-cc1e794ef5a081a8", "migration": false}, {"id": "19.0-667370a1d7ad11aa", "cves": [], "html": "Allow pg_dump to include restorable extended statistics (Corey Huinker) \u00a7
", "text": "Allow pg_dump to include restorable extended statistics (Corey Huinker) \u00a7", "title": "Allow pg_dump to include restorable extended statistics", "commits": ["c32fb29e9"], "section": "Server Applications", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-APPS", "source_hash": "6ca6a86204b38f89701c818931a87384b23bb50800f7e3a4dbbde81fa20ea8d1", "section_path": ["Server Applications"], "commit_groups": [["c32fb29e9"]], "identity_text": "Allow pg_dump to include restorable extended statistics (Corey Huinker)", "commit_aliases": ["c32fb29e9"], "source_commits": ["c32fb29e9"], "source_entry_id": "19.0/changes/129", "db_id": "78d7e5131c9e75e325718e7303eaa2ea", "patch_ids": ["0b859504d22f7cc1b13d7fa79360cc6a"], "statement_hash": "f3f31769f227a28a98d92dafef24df40353e3f436ee4ffc6e62a6288b14a61e4", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-667370a1d7ad11aa", "migration": false}, {"id": "19.0-576d256aedc6ad0f", "cves": [], "html": "Change vacuumdb's --analyze-only and --analyze-in-stages options to analyze partitioned tables when no targets are specified (Laurenz Albe, Mircea Cadariu, Chao Li) \u00a7 \u00a7
Previously it skipped partitioned tables. This now matches the behavior of ANALYZE.
Allow vacuumdb to report its commands without running them using option --dry-run (Corey Huinker) \u00a7
Allow pg_verifybackup to read WAL files stored in tar archives (Amul Sul) \u00a7
\nAdd option --wal-path as an alias for the existing and deprecated --wal-directory option.
Allow pg_waldump to read WAL files stored in tar archives (Amul Sul) \u00a7
", "text": "Allow pg_waldump to read WAL files stored in tar archives (Amul Sul) \u00a7", "title": "Allow pg_waldump to read WAL files stored in tar archives", "commits": ["b15c15139"], "section": "Server Applications", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-APPS", "source_hash": "b8cf5baef678a4e3da97aa8de3e112c0551aebbf2682769c06bdc73145af80db", "section_path": ["Server Applications"], "commit_groups": [["b15c15139"]], "identity_text": "Allow pg_waldump to read WAL files stored in tar archives (Amul Sul)", "commit_aliases": ["b15c15139"], "source_commits": ["b15c15139"], "source_entry_id": "19.0/changes/133", "db_id": "26b120f585dba2fb962357e8d46071d0", "patch_ids": ["92f9b79fdf9fb78ee70b0f2530d7a299"], "statement_hash": "01980c4fea242c3b9a2657c22f50ad9f2d747e98d8906b05f5f3afe7a3695dcf", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-d9bb89d33bfe0d6f", "migration": false}, {"id": "19.0-15a2d5ababf6313d", "cves": [], "html": "Improve performance of pg_upgrade copying large object metadata (Nathan Bossart) \u00a7 \u00a7 \u00a7 \u00a7
\nVarious methods are used, depending on the PostgreSQL version of the old cluster.
", "text": "Improve performance of pg_upgrade copying large object metadata (Nathan Bossart) \u00a7 \u00a7 \u00a7 \u00a7 Various methods are used, depending on the PostgreSQL version of the old cluster.", "title": "Improve performance of pg_upgrade copying large object metadata", "commits": ["158408fef", "161a3e8b6", "3bcfcd815", "b33f75361"], "section": "Server Applications", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-APPS", "source_hash": "af8eba51ecfd578bf49b397150547b6ceef9cc6f218b52642cecc6913fe6b668", "section_path": ["Server Applications"], "commit_groups": [["158408fef"], ["161a3e8b6"], ["3bcfcd815"], ["b33f75361"]], "identity_text": "Improve performance of pg_upgrade copying large object metadata (Nathan Bossart) Various methods are used, depending on the PostgreSQL version of the old cluster.", "commit_aliases": ["158408fef", "161a3e8b6", "3bcfcd815", "b33f75361"], "source_commits": ["158408fef", "161a3e8b6", "3bcfcd815", "b33f75361"], "source_entry_id": "19.0/changes/134", "db_id": "517bfb3f77fd3acc072ccfba83e23dc6", "patch_ids": ["12303ac15e78d39ab08e08ef243d950f", "6b265e25bb8e570015fb349cb57ed5a2", "af863f0d10fe9b397f2bad7e617549a6", "b59ae2604f73a158d4be254f1a275c5a"], "statement_hash": "06a2c858c3b814a3156920f43ab30f49a697eb76b8ddbc130b7c2979bd289b17", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-15a2d5ababf6313d", "migration": false}, {"id": "19.0-853f6a7a304647f2", "cves": [], "html": "Allow pg_upgrade to process non-default tablespaces stored in the PGDATA directory (Nathan Bossart) \u00a7
Previously such tablespaces generated an error.
", "text": "Allow pg_upgrade to process non-default tablespaces stored in the PGDATA directory (Nathan Bossart) \u00a7 Previously such tablespaces generated an error.", "title": "Allow pg_upgrade to process non-default tablespaces stored in the PGDATA directory", "commits": ["412036c22"], "section": "Server Applications", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SERVER-APPS", "source_hash": "592ff08a676cac43e7edd0ada529d5be76b35911fd8b8fb0c85ca8d3182e1149", "section_path": ["Server Applications"], "commit_groups": [["412036c22"]], "identity_text": "Allow pg_upgrade to process non-default tablespaces stored in the PGDATA directory (Nathan Bossart) Previously such tablespaces generated an error.", "commit_aliases": ["412036c22"], "source_commits": ["412036c22"], "source_entry_id": "19.0/changes/135", "db_id": "94dc0d22eae08afaf59f319b80e0628c", "patch_ids": ["1415dad8d3e913c3a3c2d8b913236a6f"], "statement_hash": "14415cbc76aeb007ed68c6488af8453f7d87555212a2eda42239a43446936837", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-853f6a7a304647f2", "migration": false}, {"id": "19.0-78502ebaee1d5b5a", "cves": [], "html": "Add pgbench option --continue-on-error to continue after SQL errors (Rintaro Ikeda, Yugo Nagata, Fujii Masao) \u00a7
Improve the usability of pg_test_timing (Hannu Krosing, Tom Lane) \u00a7 \u00a7
\nReport nanoseconds instead of microseconds. In addition to histogram output, output a second table that reports exact timings, with an optional cutoff set by --cutoff.
Allow pg_createsubscriber to ignore specified publications that already exist (Shubham Khanna) \u00a7
\nPreviously this generated an error.
", "text": "Allow pg_createsubscriber to ignore specified publications that already exist (Shubham Khanna) \u00a7 Previously this generated an error.", "title": "Allow pg_createsubscriber to ignore specified publications that already exist", "commits": ["85ddcc2f4"], "section": "Server Applications / pg_createsubscriber", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-PG-CREATESUBSCRIBER", "source_hash": "5c6984ff3a33e0bcf90232fd3ec4d124c2edc47adc816db34e2cd22cb8f47d6b", "section_path": ["Server Applications", "pg_createsubscriber"], "commit_groups": [["85ddcc2f4"]], "identity_text": "Allow pg_createsubscriber to ignore specified publications that already exist (Shubham Khanna) Previously this generated an error.", "commit_aliases": ["85ddcc2f4"], "source_commits": ["85ddcc2f4"], "source_entry_id": "19.0/changes/138", "db_id": "fe876660872e5113d1a8dfb5ab611340", "patch_ids": ["0b2cf2db89fc3d41057099f6d3df1807"], "statement_hash": "b3e8a144306f7c0989bbb4fe466e25d2600f15677c63a4ccb3f2ec43a0224d69", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-5c505665f70aefe3", "migration": false}, {"id": "19.0-2a4d169f25fc47c8", "cves": [], "html": "Change the way pg_createsubscriber stores recovery parameters (Alyona Vinter) \u00a7
\nChanges are stored in optionally-included pg_createsubscriber.conf rather than directly in postgresql.auto.conf.
Add pg_createsubscriber option -l/--logdir to redirect output to files (Gyan Sreejith, Hayato Kuroda) \u00a7
Restore support for AIX (Aditya Kamath, Srirama Kucherlapati, Peter Eisentraut) \u00a7 \u00a7
\nThis uses gcc and only supports 64-bit builds.
", "text": "Restore support for AIX (Aditya Kamath, Srirama Kucherlapati, Peter Eisentraut) \u00a7 \u00a7 This uses gcc and only supports 64-bit builds.", "title": "Restore support for AIX", "commits": ["4a1b05caa", "ecae09725"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "b4463b153233af21d597be4fcbdf031464bda673e5fabf9518a42aa5837ffc2e", "section_path": ["Source Code"], "commit_groups": [["4a1b05caa"], ["ecae09725"]], "identity_text": "Restore support for AIX (Aditya Kamath, Srirama Kucherlapati, Peter Eisentraut) This uses gcc and only supports 64-bit builds.", "commit_aliases": ["4a1b05caa", "ecae09725"], "source_commits": ["4a1b05caa", "ecae09725"], "source_entry_id": "19.0/changes/141", "db_id": "6a27ddc3375c6984764ecda039ece59e", "patch_ids": ["5857f41edf90defcc01e2ef6ba8c8efd", "61ed97ddf02ca838435046082ca86c9b"], "statement_hash": "687cd0fe635007846610174a75a0244c0e48839ae17a04ccd4342e88c0d06288", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-c688d7984908ee25", "migration": false}, {"id": "19.0-dadd6439474c27a1", "cves": [], "html": "Change Solaris to use unnamed POSIX semaphores (Tom Lane) \u00a7
\nPreviously it used System V semaphores.
", "text": "Change Solaris to use unnamed POSIX semaphores (Tom Lane) \u00a7 Previously it used System V semaphores.", "title": "Change Solaris to use unnamed POSIX semaphores", "commits": ["0123ce131"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "a1499b8a31c8a0cb25779d41b98189b0dd698dc9789a22791e3631ad3c609c53", "section_path": ["Source Code"], "commit_groups": [["0123ce131"]], "identity_text": "Change Solaris to use unnamed POSIX semaphores (Tom Lane) Previously it used System V semaphores.", "commit_aliases": ["0123ce131"], "source_commits": ["0123ce131"], "source_entry_id": "19.0/changes/142", "db_id": "5822454812a22c91153896d1170e12b8", "patch_ids": ["4f43e5ecb6f23020d60c39e4d56501b1"], "statement_hash": "8ec02317c271b59321e7294211e8e413e0fbc1ca6fbcc353ef9c10882bab95b0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-dadd6439474c27a1", "migration": false}, {"id": "19.0-5b6a8a514a0374a0", "cves": [], "html": "Require Visual Studio 2019 or later (Peter Eisentraut) \u00a7
", "text": "Require Visual Studio 2019 or later (Peter Eisentraut) \u00a7", "title": "Require Visual Studio 2019 or later", "commits": ["8fd9bb1d9"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "80c6a27889376fa7d9612c49327c9b27c38b186229a506936e0e6484010065af", "section_path": ["Source Code"], "commit_groups": [["8fd9bb1d9"]], "identity_text": "Require Visual Studio 2019 or later (Peter Eisentraut)", "commit_aliases": ["8fd9bb1d9"], "source_commits": ["8fd9bb1d9"], "source_entry_id": "19.0/changes/143", "db_id": "20208bf5986fd46d9b096ac8514bcd77", "patch_ids": ["eb1cb77c1a3dbaf28e4e4263775742ca"], "statement_hash": "54ed3353b823c253bb3788b37f3f5ab829631679cb77a1f673a26095d5dec794", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-5b6a8a514a0374a0", "migration": false}, {"id": "19.0-0938c090d15c6153", "cves": [], "html": "Allow MSVC to create PL/Python using the Python Limited API (Bryan Green) \u00a7
", "text": "Allow MSVC to create PL/Python using the Python Limited API (Bryan Green) \u00a7", "title": "Allow MSVC to create PL/Python using the Python Limited API", "commits": ["2bc60f862"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "9581b6a75f4b8620021738658ae9e910ab302a30da4752f4d5979f97b3f6a0d8", "section_path": ["Source Code"], "commit_groups": [["2bc60f862"]], "identity_text": "Allow MSVC to create PL/Python using the Python Limited API (Bryan Green)", "commit_aliases": ["2bc60f862"], "source_commits": ["2bc60f862"], "source_entry_id": "19.0/changes/144", "db_id": "3132aa5d06c1125f55b01f534f78d766", "patch_ids": ["418873dc1d7268f95f33dfe2b5e16c14"], "statement_hash": "b508d54b21604e4809a76017556486869554e4ef75e07613acbe6a703bccfb31", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-0938c090d15c6153", "migration": false}, {"id": "19.0-7e8736a39535b229", "cves": [], "html": "Allow building on AArch64 using MSVC (Niyas Sait, Greg Burd, Dave Cramer) \u00a7
", "text": "Allow building on AArch64 using MSVC (Niyas Sait, Greg Burd, Dave Cramer) \u00a7", "title": "Allow building on AArch64 using MSVC", "commits": ["a516b3f00"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "7485a82739a3d7f1133741c93e4926cb77848818b0431ab80fba090c5ece6e6d", "section_path": ["Source Code"], "commit_groups": [["a516b3f00"]], "identity_text": "Allow building on AArch64 using MSVC (Niyas Sait, Greg Burd, Dave Cramer)", "commit_aliases": ["a516b3f00"], "source_commits": ["a516b3f00"], "source_entry_id": "19.0/changes/145", "db_id": "d6325602478b636db3a5ec268cd93ecf", "patch_ids": ["16ee331f37ac78c9c891aded3cf696b3"], "statement_hash": "84047fa4d176146789f90f020396ed92c7727957e6ee704f3892da75d5c1c59b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-7e8736a39535b229", "migration": false}, {"id": "19.0-8ed89c7b8bb4f20c", "cves": [], "html": "Allow execution stack backtraces on Windows using DbgHelp (Bryan Green) \u00a7
Change the supported C language version to C11 (Peter Eisentraut) \u00a7 \u00a7
\nPreviously C99 was used.
", "text": "Change the supported C language version to C11 (Peter Eisentraut) \u00a7 \u00a7 Previously C99 was used.", "title": "Change the supported C language version to C11", "commits": ["4fbe01514", "f5e0186f8"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "6fa166bd21f29b3ae899571190b15cdf0d9d078a17d8a7109f463975d9e7e046", "section_path": ["Source Code"], "commit_groups": [["4fbe01514"], ["f5e0186f8"]], "identity_text": "Change the supported C language version to C11 (Peter Eisentraut) Previously C99 was used.", "commit_aliases": ["4fbe01514", "f5e0186f8"], "source_commits": ["4fbe01514", "f5e0186f8"], "source_entry_id": "19.0/changes/147", "db_id": "6e3da601f5fd206642c361c0c5b14440", "patch_ids": ["59f1a29dc10249292062069111b7b597", "67efc794132ce8bbd000864dd3ff37ab"], "statement_hash": "5192ce40a6b72f5a4ca925ca157226fb7f5355bd0720cb51674314bff694b09f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-09d850b430be5249", "migration": false}, {"id": "19.0-f7a91a34056f82c1", "cves": [], "html": "Use standard C23 and C++ attributes if available (Peter Eisentraut) \u00a7
", "text": "Use standard C23 and C++ attributes if available (Peter Eisentraut) \u00a7", "title": "Use standard C23 and C++ attributes if available", "commits": ["76f4b92ba"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "ba7a0225fc24aaecc9d6025a8c2ff34ce8c7b4284edfe41be8d97af6fd110343", "section_path": ["Source Code"], "commit_groups": [["76f4b92ba"]], "identity_text": "Use standard C23 and C++ attributes if available (Peter Eisentraut)", "commit_aliases": ["76f4b92ba"], "source_commits": ["76f4b92ba"], "source_entry_id": "19.0/changes/148", "db_id": "7f1a5c713dab5ac5bef306ef70947742", "patch_ids": ["7bad991024e595556f1c8e8c424a20ff"], "statement_hash": "1db1f95cb0bcf81dee57272ecc92a9719ae985b38083d8e3b8663020c192497c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-f7a91a34056f82c1", "migration": false}, {"id": "19.0-ac6449596fd7fab3", "cves": [], "html": "Use AVX2 CPU instructions for calculating page checksums (Matthew Sterrett, Andrew Kim) \u00a7
", "text": "Use AVX2 CPU instructions for calculating page checksums (Matthew Sterrett, Andrew Kim) \u00a7", "title": "Use AVX2 CPU instructions for calculating page checksums", "commits": ["5e13b0f24"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "841ead82af2b0d1e0f6e90fa65c905a6e0fb89a7b72285db017907f9a4ad24e8", "section_path": ["Source Code"], "commit_groups": [["5e13b0f24"]], "identity_text": "Use AVX2 CPU instructions for calculating page checksums (Matthew Sterrett, Andrew Kim)", "commit_aliases": ["5e13b0f24"], "source_commits": ["5e13b0f24"], "source_entry_id": "19.0/changes/149", "db_id": "b0e9a5bbb0226b3e4353c8b3a392d7c3", "patch_ids": ["60413bcbd7997e1f98531f60a705a9f8"], "statement_hash": "a02f1fbc49765e52cbf6fc57492c6231557d3c5764c44f7b7c5735ae5bf22eac", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-ac6449596fd7fab3", "migration": false}, {"id": "19.0-ce2cb80d5f3dbbb4", "cves": [], "html": "Use ARM Crypto Extension to Compute CRC32C (John Naylor) \u00a7
", "text": "Use ARM Crypto Extension to Compute CRC32C (John Naylor) \u00a7", "title": "Use ARM Crypto Extension to Compute CRC32C", "commits": ["fbc57f2bc"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "472ab2edd2029aa05418cf81ff56a97e72ab3da6bf9296568a818bae64d3ec2a", "section_path": ["Source Code"], "commit_groups": [["fbc57f2bc"]], "identity_text": "Use ARM Crypto Extension to Compute CRC32C (John Naylor)", "commit_aliases": ["fbc57f2bc"], "source_commits": ["fbc57f2bc"], "source_entry_id": "19.0/changes/150", "db_id": "ca3e3ffc4338eb1fadd9ee018569e34c", "patch_ids": ["1afa237ddb6466bb833bd77cf9ae7a9a"], "statement_hash": "4a8a7db7955a4301dbb9b2422d4732e9921698e2bb2a2ca27ca53c3dafa09ea3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-ce2cb80d5f3dbbb4", "migration": false}, {"id": "19.0-a28b99546298d516", "cves": [], "html": "Change hex_encode() and hex_decode() to use SIMD CPU instructions (Nathan Bossart, Chiranmoy Bhattacharya) \u00a7
Require Meson version 0.57.2 or later (Peter Eisentraut) \u00a7
", "text": "Require Meson version 0.57.2 or later (Peter Eisentraut) \u00a7", "title": "Require Meson version 0.57.2 or later", "commits": ["f039c2244"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "3cd9a49d741e0f67fe706a8766b89cfc20b09a4e02d0b837ab45fd98243392a0", "section_path": ["Source Code"], "commit_groups": [["f039c2244"]], "identity_text": "Require Meson version 0.57.2 or later (Peter Eisentraut)", "commit_aliases": ["f039c2244"], "source_commits": ["f039c2244"], "source_entry_id": "19.0/changes/152", "db_id": "dd79d2868c10a6351f8e573e735e76f5", "patch_ids": ["ec6352d779ee4bca9abdf1d381ffcd25"], "statement_hash": "090e6e109cb9a4eeb7cd4230829da972d7229ce411856f29f0e3d563ad71e20e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-4532677aa54568ee", "migration": false}, {"id": "19.0-2c7cc32ec00cfe7b", "cves": [], "html": "Add Meson option to build both shared and static libraries, or only shared (Peter Eisentraut) \u00a7
", "text": "Add Meson option to build both shared and static libraries, or only shared (Peter Eisentraut) \u00a7", "title": "Add Meson option to build both shared and static libraries, or only shared", "commits": ["78727dcba"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "46c3dea66afd3f6bdbe9c0f23cab3fc07f7c923b8a54cc68a1d0dec5d5a4b6ca", "section_path": ["Source Code"], "commit_groups": [["78727dcba"]], "identity_text": "Add Meson option to build both shared and static libraries, or only shared (Peter Eisentraut)", "commit_aliases": ["78727dcba"], "source_commits": ["78727dcba"], "source_entry_id": "19.0/changes/153", "db_id": "eb1383d7fd40f7f1c4dc0376067f3669", "patch_ids": ["e208dab0088868ff672bb9a88714796f"], "statement_hash": "05e4f24b484569d138bb3df3ce06e17134b1f4f827ed5f5579b85a398b9b9a4b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-2c7cc32ec00cfe7b", "migration": false}, {"id": "19.0-67d0062ccf19d152", "cves": [], "html": "Update Unicode data to version 17.0.0 (Peter Eisentraut) \u00a7
", "text": "Update Unicode data to version 17.0.0 (Peter Eisentraut) \u00a7", "title": "Update Unicode data to version 17.0.0", "commits": ["57ee39795"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "43664f1ed399ca43ebb2d6353c0ffd74946e74c4ce11f5c1fd3f1d2301438dbc", "section_path": ["Source Code"], "commit_groups": [["57ee39795"]], "identity_text": "Update Unicode data to version 17.0.0 (Peter Eisentraut)", "commit_aliases": ["57ee39795"], "source_commits": ["57ee39795"], "source_entry_id": "19.0/changes/154", "db_id": "d7e2c494563fe17c4ee00266fa53a520", "patch_ids": ["c59ccd505e5b66c373128a4ab143e4ce"], "statement_hash": "c94d52c3540a007227d0d2130851f8a92ba5cc5337ccb5c9d1d3728e6f706af6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-67d0062ccf19d152", "migration": false}, {"id": "19.0-0e94b3abdf93bcc7", "cves": [], "html": "Add hooks planner_setup_hook, planner_shutdown_hook, joinrel_setup_hook, and join_path_setup_hook (Robert Haas) \u00a7 \u00a7
Allow extensions to replace set-returning functions in the FROM clause with SQL queries (Paul A. Jungwirth) \u00a7
Make multixid members 64-bit (Maxim Orlov) \u00a7
", "text": "Make multixid members 64-bit (Maxim Orlov) \u00a7", "title": "Make multixid members 64-bit", "commits": ["bd8d9c9bd"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "3465fedcf0b82edf1b7bfbc2da01dd7c9ec73b07547f36dcb6b7cf816e3f91b2", "section_path": ["Source Code"], "commit_groups": [["bd8d9c9bd"]], "identity_text": "Make multixid members 64-bit (Maxim Orlov)", "commit_aliases": ["bd8d9c9bd"], "source_commits": ["bd8d9c9bd"], "source_entry_id": "19.0/changes/157", "db_id": "f94c0ae076ab514a80afc69faa028ea0", "patch_ids": ["192db2703f79d48c16fa25b3227ae71a"], "statement_hash": "b5eb89f3e7ec81151c1887651a26784eed70619fcc43136255213d78407aa72c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-b67c148ffb16bbcf", "migration": false}, {"id": "19.0-5650ebe4cfdffcf7", "cves": [], "html": "Change function prototypes to use uint* instead of bit* typedefs (Nathan Bossart) \u00a7
Allow logical decoding plugins to specify if they do not access shared catalogs (Antonin Houska) \u00a7
", "text": "Allow logical decoding plugins to specify if they do not access shared catalogs (Antonin Houska) \u00a7", "title": "Allow logical decoding plugins to specify if they do not access shared catalogs", "commits": ["0d3dba38c"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "72aecd4c45fa67483121399f05e3fba5e37d22a61fbc53317b3d25e399e58d94", "section_path": ["Source Code"], "commit_groups": [["0d3dba38c"]], "identity_text": "Allow logical decoding plugins to specify if they do not access shared catalogs (Antonin Houska)", "commit_aliases": ["0d3dba38c"], "source_commits": ["0d3dba38c"], "source_entry_id": "19.0/changes/159", "db_id": "b395b8b40db973ba1f42e8f3bc96ef65", "patch_ids": ["20a3361210f5c3f5967de899d879e2a4"], "statement_hash": "5e0711ae12acdadfaaabe4eddde6e6bdb9c618b67a4a9ef1b7a92987e17bffe1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-3a1ceba75f3157af", "migration": false}, {"id": "19.0-3f4066e65cf8a2d9", "cves": [], "html": "Allow OAuth validators to supply failure details (Jacob Champion) \u00a7
\nThis is done by setting the ValidatorModuleResult structure member error_detail.
Add simplified and improved shared memory registration function ShmemRequestStruct() (Heikki Linnakangas, Ashutosh Bapat) \u00a7
Functions ShmemInitStruct() and ShmemInitHash() remain for backward compatibility.
Add server variable debug_exec_backend to report how parameters are passed to new backends (Daniel Gustafsson) \u00a7
Add documentation section about temporal tables (Paul A. Jungwirth) \u00a7
", "text": "Add documentation section about temporal tables (Paul A. Jungwirth) \u00a7", "title": "Add documentation section about temporal tables", "commits": ["e4d8a2af0"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "cfa3938488ba5a382ebbf3ac30a262741cbc781d722187bf310f0b6d7a746f5f", "section_path": ["Source Code"], "commit_groups": [["e4d8a2af0"]], "identity_text": "Add documentation section about temporal tables (Paul A. Jungwirth)", "commit_aliases": ["e4d8a2af0"], "source_commits": ["e4d8a2af0"], "source_entry_id": "19.0/changes/163", "db_id": "ba840a11fad1344360a49032bc6c9bf0", "patch_ids": ["6199d082f1b7ffe83b1542803732c5b0"], "statement_hash": "7fce6be69bf094f60533b06c88d696d5fc0124240941764129ee15cf74310d38", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-2a1150b2757041ab", "migration": false}, {"id": "19.0-3892358a8de14030", "cves": [], "html": "Document the environment variables that control the regression tests (Michael Paquier) \u00a7
", "text": "Document the environment variables that control the regression tests (Michael Paquier) \u00a7", "title": "Document the environment variables that control the regression tests", "commits": ["02976b0a1"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "3c6d19ffa21c52c77bb6943f87c696d892441f56b6aa96541174e0ced30140b3", "section_path": ["Source Code"], "commit_groups": [["02976b0a1"]], "identity_text": "Document the environment variables that control the regression tests (Michael Paquier)", "commit_aliases": ["02976b0a1"], "source_commits": ["02976b0a1"], "source_entry_id": "19.0/changes/164", "db_id": "6e2a6dcc65b08df25684b4c976e8261f", "patch_ids": ["db371fbd69214646dc429f89122f5b44"], "statement_hash": "d64cc4af42817101fefe650bc306c67f8a5f2ed7253544890808aa96b29b6216", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-3892358a8de14030", "migration": false}, {"id": "19.0-ee879bd44886d9ad", "cves": [], "html": "Update documented systemd example to include a restart setting (Andrew Jackson) \u00a7
", "text": "Update documented systemd example to include a restart setting (Andrew Jackson) \u00a7", "title": "Update documented systemd example to include a restart setting", "commits": ["b30656ce0"], "section": "Source Code", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-SOURCE-CODE", "source_hash": "9e5278ec18324c26f53d4682b7cac16a25e724bdefb3a51af29c16622606160b", "section_path": ["Source Code"], "commit_groups": [["b30656ce0"]], "identity_text": "Update documented systemd example to include a restart setting (Andrew Jackson)", "commit_aliases": ["b30656ce0"], "source_commits": ["b30656ce0"], "source_entry_id": "19.0/changes/165", "db_id": "e0b8431931452801e2bf951c6fc029bf", "patch_ids": ["d5055a62c0b50ca7417a6aee5168d0cc"], "statement_hash": "5defbf603db0b450d9792692393d17b48cda3fae0f0d7e20de6bf6a5ab9fdeda", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-ee879bd44886d9ad", "migration": false}, {"id": "19.0-4835c6d957950079", "cves": [], "html": "Add pg_plan_advice module to stabilize and control planner decisions (Robert Haas) \u00a7 \u00a7
", "text": "Add pg_plan_advice module to stabilize and control planner decisions (Robert Haas) \u00a7 \u00a7", "title": "Add pg_plan_advice module to stabilize and control planner decisions", "commits": ["5883ff30b", "6455e55b0"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "97924ebded069e94b969b2483dadf89dfcd806dca8ed03452e99ded2ac8636ca", "section_path": ["Additional Modules"], "commit_groups": [["5883ff30b"], ["6455e55b0"]], "identity_text": "Add pgplanadvice module to stabilize and control planner decisions (Robert Haas)", "commit_aliases": ["5883ff30b", "6455e55b0"], "source_commits": ["5883ff30b", "6455e55b0"], "source_entry_id": "19.0/changes/166", "db_id": "4ac958c4dfcd715caf1af5422620f505", "patch_ids": ["56d63f5186ca503452a6223c6f729bc0", "b1613f7f0a064021e597c08a0f245a49"], "statement_hash": "31e3ff58f47fcca7b27455c485f5c16cf539a34db72635e763654a43b2f9850c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-4835c6d957950079", "migration": false}, {"id": "19.0-99f5eede3e770ccc", "cves": [], "html": "Add extension pg_stash_advice to allow per-query-id advice to be specified (Robert Haas, Lukas Fittl) \u00a7 \u00a7
", "text": "Add extension pg_stash_advice to allow per-query-id advice to be specified (Robert Haas, Lukas Fittl) \u00a7 \u00a7", "title": "Add extension pg_stash_advice to allow per-query-id advice to be specified", "commits": ["c10edb102", "e8ec19aa3"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "cd73a2b0c2b7e3e3ea5c580c529aed14af5174fcef7624106cfc364f9b712af8", "section_path": ["Additional Modules"], "commit_groups": [["c10edb102"], ["e8ec19aa3"]], "identity_text": "Add extension pgstashadvice to allow per-query-id advice to be specified (Robert Haas, Lukas Fittl)", "commit_aliases": ["c10edb102", "e8ec19aa3"], "source_commits": ["c10edb102", "e8ec19aa3"], "source_entry_id": "19.0/changes/167", "db_id": "45e851918f3743e4972a5ecf2ab78f59", "patch_ids": ["9da8a567937023cd2a129fdfde982f00", "f4a18a80b979077db607a9e188bc8ab2"], "statement_hash": "d9820baa158db7d0d39f696739da9f24dc384ddfeff94eb80a3383616be8699a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-99f5eede3e770ccc", "migration": false}, {"id": "19.0-763cd3481e3c7780", "cves": [], "html": "Show sizes of FETCH queries as constants in pg_stat_statements (Sami Imseih) \u00a7
Fetches of different sizes will now be grouped together in pg_stat_statements output.
", "text": "Show sizes of FETCH queries as constants in pg_stat_statements (Sami Imseih) \u00a7 Fetches of different sizes will now be grouped together in pg_stat_statements output.", "title": "Show sizes of FETCH queries as constants in pg_stat_statements", "commits": ["bee23ea4d"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "d85a64e309179f392fedcc0a28e405580913b93baeb95870909f8738d112e1c4", "section_path": ["Additional Modules"], "commit_groups": [["bee23ea4d"]], "identity_text": "Show sizes of FETCH queries as constants in pgstatstatements (Sami Imseih) Fetches of different sizes will now be grouped together in pgstatstatements output.", "commit_aliases": ["bee23ea4d"], "source_commits": ["bee23ea4d"], "source_entry_id": "19.0/changes/168", "db_id": "482299b237fbc46a6a50bdb47b208788", "patch_ids": ["d97e227d21ad315d6b87301eb67684d9"], "statement_hash": "56b6507c53757966822dc5b02b086499fcab94db3afe43cf0b16f70fd821aff5", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-763cd3481e3c7780", "migration": false}, {"id": "19.0-3e117bad67fe6211", "cves": [], "html": "Add generic and custom plan counts to pg_stat_statements (Sami Imseih) \u00a7
", "text": "Add generic and custom plan counts to pg_stat_statements (Sami Imseih) \u00a7", "title": "Add generic and custom plan counts to pg_stat_statements", "commits": ["3357471cf"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "db449b9cf7723032feb95c4a5892ceae6a4041ae1341f3885e0e2384a70acc9a", "section_path": ["Additional Modules"], "commit_groups": [["3357471cf"]], "identity_text": "Add generic and custom plan counts to pgstatstatements (Sami Imseih)", "commit_aliases": ["3357471cf"], "source_commits": ["3357471cf"], "source_entry_id": "19.0/changes/169", "db_id": "8b533dfc0cb31323a0af65fc5498095a", "patch_ids": ["a68aa4c27f58910e3aff221fa91fe3d1"], "statement_hash": "6572579d1d4bb8fcbd1defa3afe48fb510f4f443e55a8c0caa51da2f257f46f3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-3e117bad67fe6211", "migration": false}, {"id": "19.0-51474e742fd9aa52", "cves": [], "html": "Refactor pg_buffercache reporting of shared memory mapping (Bertrand Drouvot) \u00a7
\nNew function pg_buffercache_os_pages() and system view pg_buffercache_os_pages allow reporting of shared memory mapping; the function optionally includes NUMA details. Function pg_buffercache_numa_pages() remains for backward compatibility.
Add functions to pg_buffercache to mark buffers as dirty (Nazir Bilal Yavuz) \u00a7
\nThe functions are pg_buffercache_mark_dirty(), pg_buffercache_mark_dirty_relation(), and pg_buffercache_mark_dirty_all().
Allow pushdown of array comparisons in prepared statements to postgres_fdw foreign servers (Alexander Pyhalov) \u00a7
", "text": "Allow pushdown of array comparisons in prepared statements to postgres_fdw foreign servers (Alexander Pyhalov) \u00a7", "title": "Allow pushdown of array comparisons in prepared statements to postgres_fdw foreign servers", "commits": ["62c3b4cd9"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "bf6501c55945ab2cfc9cfe31aa3a3cb39698957c6cba992abf2bbd630f5ec772", "section_path": ["Additional Modules"], "commit_groups": [["62c3b4cd9"]], "identity_text": "Allow pushdown of array comparisons in prepared statements to postgres-fdw foreign servers (Alexander Pyhalov)", "commit_aliases": ["62c3b4cd9"], "source_commits": ["62c3b4cd9"], "source_entry_id": "19.0/changes/172", "db_id": "7c1a1048290344a4c12534360c09ece8", "patch_ids": ["f62f187297629adfd7fcf55390ff9b7f"], "statement_hash": "2fad95447b0442a3e310ff1b8fc810cccdbd60f2879adb6fdd18627a87ff3b4a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-d6327f06b92f9d9c", "migration": false}, {"id": "19.0-d428cbc5f59b7b81", "cves": [], "html": "Allow the retrieval of statistics from foreign data wrapper servers (Corey Huinker, Etsuro Fujita) \u00a7 \u00a7
\nThis is enabled for postgres_fdw by using the option import_stats. The default is for ANALYZE to retrieve rows from the remote server to locally generate statistics.
Allow file_fdw to read files or program output that uses multi-line headers (Shinya Kato) \u00a7
", "text": "Allow file_fdw to read files or program output that uses multi-line headers (Shinya Kato) \u00a7", "title": "Allow file_fdw to read files or program output that uses multi-line headers", "commits": ["26cb14aea"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "5711000ea7d7b32f82875c01a7d9125ecc2fd19b31a8bc9e4f83fa7d14d22f93", "section_path": ["Additional Modules"], "commit_groups": [["26cb14aea"]], "identity_text": "Allow file-fdw to read files or program output that uses multi-line headers (Shinya Kato)", "commit_aliases": ["26cb14aea"], "source_commits": ["26cb14aea"], "source_entry_id": "19.0/changes/174", "db_id": "f3aeae7bb3242d31771a456e66e4cb8f", "patch_ids": ["3ca3196d311c8cbda6df506d55e2219f"], "statement_hash": "8d83ef0b2f482eb9ecbf1ffdcd487f18316ca92d9d483dbf4dabd8a9711c20c8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-273e78d2da55ca39", "migration": false}, {"id": "19.0-d4c1bfe1ef53f180", "cves": [], "html": "Add server variable auto_explain.log_io to add IO reporting to auto_explain (Tomas Vondra) \u00a7
Allow auto_explain to add extension-specific EXPLAIN options via server variable auto_explain.log_extension_options (Robert Haas) \u00a7
Change btree_gin to support all btree-supported cross-type comparisons (Tom Lane) \u00a7 \u00a7
", "text": "Change btree_gin to support all btree-supported cross-type comparisons (Tom Lane) \u00a7 \u00a7", "title": "Change btree_gin to support all btree-supported cross-type comparisons", "commits": ["e2b64fcef", "fc896821c"], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "edbbbc7feb56b2d1a5299680352e405d62c795222ad63253dac5f142b6a819a4", "section_path": ["Additional Modules"], "commit_groups": [["e2b64fcef"], ["fc896821c"]], "identity_text": "Change btree-gin to support all btree-supported cross-type comparisons (Tom Lane)", "commit_aliases": ["e2b64fcef", "fc896821c"], "source_commits": ["e2b64fcef", "fc896821c"], "source_entry_id": "19.0/changes/177", "db_id": "6330392f29f43702451e3b94f5b40ee6", "patch_ids": ["465447a0b402e5edd236531603aa582e", "7a3130d69f709a301347e069b21a7e35"], "statement_hash": "d6132868a4bcffb9ab5280c1c4a08fb06978895a355b7dea4f1bad6174c4bb69", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=19.0#19.0-06a0a6beadfab22a", "migration": false}, {"id": "19.0-1036cac1a0aa4c90", "cves": [], "html": "Improve performance of bloom indexes by using streaming reads (Xuneng Zhou) \u00a7 \u00a7
", "text": "Improve performance of bloom indexes by using streaming reads (Xuneng Zhou) \u00a7 \u00a7", "title": "Improve performance of bloom indexes by using streaming reads", "commits": ["4c910f3bb", "d841ca2d1"], "section": "Additional Modules", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "aaa048beb10dd8b7c1c5a7624c84cf705067a690cea9ae8598847bbbc1208b91", "section_path": ["Additional Modules"], "commit_groups": [["4c910f3bb"], ["d841ca2d1"]], "identity_text": "Improve performance of bloom indexes by using streaming reads (Xuneng Zhou)", "commit_aliases": ["4c910f3bb", "d841ca2d1"], "source_commits": ["4c910f3bb", "d841ca2d1"], "source_entry_id": "19.0/changes/178", "db_id": "c1cae81ea4c701775cad29ff3f55752c", "patch_ids": ["686df171a67aee372faf0cb6692be924", "b7f9224c78446f20d7662ef68b714cce"], "statement_hash": "c18f530a0c78d3ed5bce4f12151346d68f3d1cc0202c7495ed6e256e0418d986", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-1036cac1a0aa4c90", "migration": false}, {"id": "19.0-c8e17e44f79160ac", "cves": [], "html": "Improve performance of pgstattuple by using streaming reads (Xuneng Zhou) \u00a7 \u00a7
", "text": "Improve performance of pgstattuple by using streaming reads (Xuneng Zhou) \u00a7 \u00a7", "title": "Improve performance of pgstattuple by using streaming reads", "commits": ["213f0079b", "ae58189a4"], "section": "Additional Modules", "category": "performance", "source_url": "/docs/release/19.0/#RELEASE-19-MODULES", "source_hash": "cc178c65f3173eb3e64fac7f6710652e29021bc1410e8a539e39ce0204887ee8", "section_path": ["Additional Modules"], "commit_groups": [["213f0079b"], ["ae58189a4"]], "identity_text": "Improve performance of pgstattuple by using streaming reads (Xuneng Zhou)", "commit_aliases": ["213f0079b", "ae58189a4"], "source_commits": ["213f0079b", "ae58189a4"], "source_entry_id": "19.0/changes/179", "db_id": "8a7e7de06c5684b8c541a0615c99b239", "patch_ids": ["960a7173fce3ace43c22feabf9818d26", "f88c740e4a92e5ef0efe0673eff46dbc"], "statement_hash": "6ce3c55548064e89eb5c7d1302ac0d2dc42f31f405d0d8d3277e6d4829f61f8b", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=19.0#19.0-c8e17e44f79160ac", "migration": false}, {"id": "19.0-4d24c099abc38ad0", "cves": [], "html": "Allow fuzzystrmatch's dmetaphone() to use single-byte encodings beyond ASCII (Peter Eisentraut) \u00a7
Modify oid2name --extended to report the relation file path (David Bidoc) \u00a7
A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section\u00a018.6 for general information on migrating to new major releases.
\nVersion 19 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:
\n