Hash indexes must be rebuilt after pg_upgrade-ing from any previous major PostgreSQL version (Mithun Cy, Robert Haas, Amit Kapila)
\nMajor hash index improvements necessitated this requirement. pg_upgrade will create a script to assist with this.
", "text": "Hash indexes must be rebuilt after pg_upgrade-ing from any previous major PostgreSQL version (Mithun Cy, Robert Haas, Amit Kapila) Major hash index improvements necessitated this requirement. pg_upgrade will create a script to assist with this.", "title": "Hash indexes must be rebuilt after pg_upgrade-ing from any previous major PostgreSQL version", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "979cd752f8f4fc06fd9ae5eb92d7adcfbf373ba63388989ff024eea414a78f2c", "section_path": ["Compatibility"], "commit_groups": [["620b49a16"], ["a95410e2e"], ["ea69a0dea"]], "identity_text": "Hash indexes must be rebuilt after pg_upgrade-ing from any previous major PostgreSQL version (Mithun Cy, Robert Haas, Amit Kapila) Major hash index improvements necessitated this requirement. pg_upgrade will create a script to assist with this.", "commit_aliases": ["620b49a16", "a95410e2e", "ea69a0dea"], "source_commits": ["620b49a16", "a95410e2e", "ea69a0dea"], "source_entry_id": "10.0/migration/001", "db_id": "a160d4c3b43ec4e671044c3176ac1458", "patch_ids": ["075f3ebb20a2eda8014f73811801ac39", "a97771610174f839f70cdb13dca22ba7", "cf52f7bc92da3e9c0404fc6b0887717c"], "statement_hash": "969273d87717dca7d30875343075baf2c6bcef69cb275fc4242620f76180075e", "relations": [{"rule": 2, "type": "related", "target": "1b1b0c796b5562126f6326ed5ed1fffe", "evidence": {"same_day": true, "patch_ids": ["075f3ebb20a2eda8014f73811801ac39", "cf52f7bc92da3e9c0404fc6b0887717c"]}}], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-cc0b29ddadc754be", "migration": true}, {"id": "10.0-1ca98bd2081e18f2", "cves": [], "html": "Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier)
Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.
", "text": "Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier) Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.", "title": "Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "af9ee2b3d2278d7550a9621f7841769259578e44d733b4d47f29de86fb08e522", "section_path": ["Compatibility"], "commit_groups": [["88e66d193"], ["f82ec32ac"]], "identity_text": "Rename write-ahead log directory pg_xlog to pg_wal, and rename transaction status directory pg_clog to pg_xact (Michael Paquier) Users have occasionally thought that these directories contained only inessential log files, and proceeded to remove write-ahead log files or transaction status files manually, causing irrecoverable data loss. These name changes are intended to discourage such errors in future.", "commit_aliases": ["88e66d193", "f82ec32ac"], "source_commits": ["88e66d193", "f82ec32ac"], "source_entry_id": "10.0/migration/002", "db_id": "80285bd02246ccce799ef0363b672bcc", "patch_ids": ["d84e8e8f606e3e51f78f2181a479d742", "f93606131cb1e0a019c5b3f5c7532feb"], "statement_hash": "ec76b024b34c1e50ceda2ce53bad68b37a0edfeed2ef948cf3e48222bc181b3f", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-1ca98bd2081e18f2", "migration": true}, {"id": "10.0-0328fcadd496f23f", "cves": [], "html": "Rename SQL functions, tools, and options that reference \u201cxlog\u201d to \u201cwal\u201d (Robert Haas)
\nFor example, pg_switch_xlog() becomes pg_switch_wal(), pg_receivexlog becomes pg_receivewal, and --xlogdir becomes --waldir. This is for consistency with the change of the pg_xlog directory name; in general, the \u201cxlog\u201d terminology is no longer used in any user-facing places.
Rename WAL-related functions and views to use lsn instead of location (David Rowley)
There was previously an inconsistent mixture of the two terminologies.
", "text": "Rename WAL-related functions and views to use lsn instead of location (David Rowley) There was previously an inconsistent mixture of the two terminologies.", "title": "Rename WAL-related functions and views to use lsn instead of location", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "17daf2d5977844d28ed5fe857912f3fa1b77b45529e16795c9affd1449833d42", "section_path": ["Compatibility"], "commit_groups": [["d10c626de"]], "identity_text": "Rename WAL-related functions and views to use lsn instead of location (David Rowley) There was previously an inconsistent mixture of the two terminologies.", "commit_aliases": ["d10c626de"], "source_commits": ["d10c626de"], "source_entry_id": "10.0/migration/004", "db_id": "68e45165420d584126ae831afc42c08f", "patch_ids": ["1aeece2c2dce8568ac68eb8a4d85586d"], "statement_hash": "005c8de951edcc16c5d18e1b4b864979fe39b0b3e6d8a6465eedb1f1c575886e", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-05e7976c1ebb8f46", "migration": true}, {"id": "10.0-bcbf067a5df4f0c6", "cves": [], "html": "Change the implementation of set-returning functions appearing in a query's SELECT list (Andres Freund)
Set-returning functions are now evaluated before evaluation of scalar expressions in the SELECT list, much as though they had been placed in a LATERAL FROM-clause item. This allows saner semantics for cases where multiple set-returning functions are present. If they return different numbers of rows, the shorter results are extended to match the longest result by adding nulls. Previously the results were cycled until they all terminated at the same time, producing a number of rows equal to the least common multiple of the functions' periods. In addition, set-returning functions are now disallowed within CASE and COALESCE constructs. For more information see Section\u00a037.4.8.
Use standard row constructor syntax in UPDATE ... SET ( (Tom Lane)column_list) = row_constructor
The row_constructor can now begin with the keyword ROW; previously that had to be omitted. If just one column name appears in the column_list, then the row_constructor now must use the ROW keyword, since otherwise it is not a valid row constructor but just a parenthesized expression. Also, an occurrence of table_name.*row_constructor is now expanded into multiple columns, as occurs in other uses of row_constructors.
When ALTER TABLE ... ADD PRIMARY KEY marks columns NOT NULL, that change now propagates to inheritance child tables as well (Michael Paquier)
Prevent statement-level triggers from firing more than once per statement (Tom Lane)
\nCases involving writable CTEs updating the same table updated by the containing statement, or by another writable CTE, fired BEFORE STATEMENT or AFTER STATEMENT triggers more than once. Also, if there were statement-level triggers on a table affected by a foreign key enforcement action (such as ON DELETE CASCADE), they could fire more than once per outer SQL statement. This is contrary to the SQL standard, so change it.
Move sequences' metadata fields into a new pg_sequence system catalog (Peter Eisentraut)
A sequence relation now stores only the fields that can be modified by nextval(), that is last_value, log_cnt, and is_called. Other sequence properties, such as the starting value and increment, are kept in a corresponding row of the pg_sequence catalog. ALTER SEQUENCE updates are now fully transactional, implying that the sequence is locked until commit. The nextval() and setval() functions remain nontransactional.
The main incompatibility introduced by this change is that selecting from a sequence relation now returns only the three fields named above. To obtain the sequence's other properties, applications must look into pg_sequence. The new system view pg_sequences can also be used for this purpose; it provides column names that are more compatible with existing code.
Also, sequences created for SERIAL columns now generate positive 32-bit wide values, whereas previous versions generated 64-bit wide values. This has no visible effect if the values are only stored in a column.
The output of psql's \\d command for a sequence has been redesigned, too.
Make pg_basebackup stream the WAL needed to restore the backup by default (Magnus Hagander)
\nThis changes pg_basebackup's -X/--wal-method default to stream. An option value none has been added to reproduce the old behavior. The pg_basebackup option -x has been removed (instead, use -X fetch).
Change how logical replication uses pg_hba.conf (Peter Eisentraut)
In previous releases, a logical replication connection required the replication keyword in the database column. As of this release, logical replication matches a normal entry with a database name or keywords such as all. Physical replication continues to use the replication keyword. Since built-in logical replication is new in this release, this change only affects users of third-party logical replication plugins.
Make all pg_ctl actions wait for completion by default (Peter Eisentraut)
\nPreviously some pg_ctl actions didn't wait for completion, and required the use of -w to do so.
Change the default value of the log_directory server parameter from pg_log to log (Andreas Karlsson)
Add configuration option ssl_dh_params_file to specify file name for custom OpenSSL DH parameters (Heikki Linnakangas)
\nThis replaces the hardcoded, undocumented file name dh1024.pem. Note that dh1024.pem is no longer examined by default; you must set this option if you want to use custom DH parameters.
Increase the size of the default DH parameters used for OpenSSL ephemeral DH ciphers to 2048 bits (Heikki Linnakangas)
\nThe size of the compiled-in DH parameters has been increased from 1024 to 2048 bits, making DH key exchange more resistant to brute-force attacks. However, some old SSL implementations, notably some revisions of Java Runtime Environment version 6, will not accept DH parameters longer than 1024 bits, and hence will not be able to connect over SSL. If it's necessary to support such old clients, you can use custom 1024-bit DH parameters instead of the compiled-in defaults. See ssl_dh_params_file.
", "text": "Increase the size of the default DH parameters used for OpenSSL ephemeral DH ciphers to 2048 bits (Heikki Linnakangas) The size of the compiled-in DH parameters has been increased from 1024 to 2048 bits, making DH key exchange more resistant to brute-force attacks. However, some old SSL implementations, notably some revisions of Java Runtime Environment version 6, will not accept DH parameters longer than 1024 bits, and hence will not be able to connect over SSL. If it's necessary to support such old clients, you can use custom 1024-bit DH parameters instead of the compiled-in defaults. See ssl_dh_params_file.", "title": "Increase the size of the default DH parameters used for OpenSSL ephemeral DH ciphers to 2048 bits", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "58b5c87af94ac7222fc7115d44e0e36e58185075862627c50c5bf96e795b335d", "section_path": ["Compatibility"], "commit_groups": [["c0a15e07c"]], "identity_text": "Increase the size of the default DH parameters used for OpenSSL ephemeral DH ciphers to 2048 bits (Heikki Linnakangas) The size of the compiled-in DH parameters has been increased from 1024 to 2048 bits, making DH key exchange more resistant to brute-force attacks. However, some old SSL implementations, notably some revisions of Java Runtime Environment version 6, will not accept DH parameters longer than 1024 bits, and hence will not be able to connect over SSL. If it's necessary to support such old clients, you can use custom 1024-bit DH parameters instead of the compiled-in defaults. See guc-ssl-dh-params-file .", "commit_aliases": ["c0a15e07c"], "source_commits": ["c0a15e07c"], "source_entry_id": "10.0/migration/015", "db_id": "cb4b77c0c00d68dc5c60c6499749f9e6", "patch_ids": ["0e4248c819efa4e25c3ab0380d5253fb"], "statement_hash": "5f7b7806962b7d912b887a0b2bc336d92d63dd637eef011338ae618a2652c257", "relations": [{"rule": 2, "type": "related", "target": "92da656075bacfc60d42e80c9be765ad", "evidence": {"same_day": true, "patch_ids": ["0e4248c819efa4e25c3ab0380d5253fb"], "ambiguous_patch_ids": ["0e4248c819efa4e25c3ab0380d5253fb"]}}], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-aa33faf98496afab", "migration": true}, {"id": "10.0-e5d08a9bd1cfd284", "cves": [], "html": "Remove the ability to store unencrypted passwords on the server (Heikki Linnakangas)
\nThe password_encryption server parameter no longer supports off or plain. The UNENCRYPTED option is no longer supported in CREATE/ALTER USER ... PASSWORD. Similarly, the --unencrypted option has been removed from createuser. Unencrypted passwords migrated from older versions will be stored encrypted in this release. The default setting for password_encryption is still md5.
Add min_parallel_table_scan_size and min_parallel_index_scan_size server parameters to control parallel queries (Amit Kapila, Robert Haas)
\nThese replace min_parallel_relation_size, which was found to be too generic.
Don't downcase unquoted text within shared_preload_libraries and related server parameters (QL Zhuo)
\nThese settings are really lists of file names, but they were previously treated as lists of SQL identifiers, which have different parsing rules.
", "text": "Don't downcase unquoted text within shared_preload_libraries and related server parameters (QL Zhuo) These settings are really lists of file names, but they were previously treated as lists of SQL identifiers, which have different parsing rules.", "title": "Don't downcase unquoted text within shared_preload_libraries and related server parameters", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "2d305be34bd817d98860e4181f751d1f25a848098fc1bc46d03a1117bc8c5590", "section_path": ["Compatibility"], "commit_groups": [["a69dfe5f4"]], "identity_text": "Don't downcase unquoted text within guc-shared-preload-libraries and related server parameters (QL Zhuo) These settings are really lists of file names, but they were previously treated as lists of SQL identifiers, which have different parsing rules.", "commit_aliases": ["a69dfe5f4"], "source_commits": ["a69dfe5f4"], "source_entry_id": "10.0/migration/018", "db_id": "1495fd1294e2eaf1c7d96962eb161685", "patch_ids": ["c80615a1a8fcd843532f029ed9d71948"], "statement_hash": "8b0039defc13dc8f300ae0c59b029326a2bbdeee25aa5a6a3662140c7a467204", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-6209356329823c78", "migration": true}, {"id": "10.0-b3bc05e613a8b809", "cves": [], "html": "Remove sql_inheritance server parameter (Robert Haas)
Changing this setting from the default value caused queries referencing parent tables to not include child tables. The SQL standard requires them to be included, however, and this has been the default since PostgreSQL 7.1.
", "text": "Remove sql_inheritance server parameter (Robert Haas) Changing this setting from the default value caused queries referencing parent tables to not include child tables. The SQL standard requires them to be included, however, and this has been the default since PostgreSQL 7.1.", "title": "Remove sql_inheritance server parameter", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "01afcd02f477b1cb68e0705fcd92caf61289634b4b01674a58480e2610628dee", "section_path": ["Compatibility"], "commit_groups": [["e13486eba"]], "identity_text": "Remove sql_inheritance server parameter (Robert Haas) Changing this setting from the default value caused queries referencing parent tables to not include child tables. The SQL standard requires them to be included, however, and this has been the default since PostgreSQL 7.1.", "commit_aliases": ["e13486eba"], "source_commits": ["e13486eba"], "source_entry_id": "10.0/migration/019", "db_id": "fb3d9e8678d88063b0a5aa96665191df", "patch_ids": ["9173ac91ac70cc43d9154f66d12a0b8a"], "statement_hash": "9faabd6f20e000bcc67bfd37dd505760ad8828c8bbf602d41dd574c06c400427", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-b3bc05e613a8b809", "migration": true}, {"id": "10.0-786009920087400b", "cves": [], "html": "Allow multi-dimensional arrays to be passed into PL/Python functions, and returned as nested Python lists (Alexey Grishchenko, Dave Cramer, Heikki Linnakangas)
\nThis feature requires a backwards-incompatible change to the handling of arrays of composite types in PL/Python. Previously, you could return an array of composite values by writing, e.g., [[col1, col2], [col1, col2]]; but now that is interpreted as a two-dimensional array. Composite types in arrays must now be written as Python tuples, not lists, to resolve the ambiguity; that is, write [(col1, col2), (col1, col2)] instead.
Remove PL/Tcl's \u201cmodule\u201d auto-loading facility (Tom Lane)
\nThis functionality has been replaced by new server parameters pltcl.start_proc and pltclu.start_proc, which are easier to use and more similar to features available in other PLs.
", "text": "Remove PL/Tcl's \u201cmodule\u201d auto-loading facility (Tom Lane) This functionality has been replaced by new server parameters pltcl.start_proc and pltclu.start_proc, which are easier to use and more similar to features available in other PLs.", "title": "Remove PL/Tcl's \u201cmodule\u201d auto-loading facility", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "e13cd151c725d5b868b83caa789349df9a1efd06c4ab7d5069306ec19bb72a82", "section_path": ["Compatibility"], "commit_groups": [["817f2a586"]], "identity_text": "Remove PL/Tcl's module auto-loading facility (Tom Lane) This functionality has been replaced by new server parameters guc-pltcl-start-proc and guc-pltclu-start-proc , which are easier to use and more similar to features available in other PLs.", "commit_aliases": ["817f2a586"], "source_commits": ["817f2a586"], "source_entry_id": "10.0/migration/021", "db_id": "c03c95ce7eeffbec000f259934fb41cb", "patch_ids": ["88c13146b3a3fed017d68203071cfd78"], "statement_hash": "d81330d7d891ef5d0c6f2120e954c4995909f20d4246a53270cf088c2ef10028", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-d2ab6383a4b470a6", "migration": true}, {"id": "10.0-9d192b743e3955d3", "cves": [], "html": "Remove pg_dump/pg_dumpall support for dumping from pre-8.0 servers (Tom Lane)
\nUsers needing to dump from pre-8.0 servers will need to use dump programs from PostgreSQL 9.6 or earlier. The resulting output should still load successfully into newer servers.
", "text": "Remove pg_dump/pg_dumpall support for dumping from pre-8.0 servers (Tom Lane) Users needing to dump from pre-8.0 servers will need to use dump programs from PostgreSQL 9.6 or earlier. The resulting output should still load successfully into newer servers.", "title": "Remove pg_dump/pg_dumpall support for dumping from pre-8.0 servers", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "f44eac09b3da8b09d769aea99964e1fa5cf562f620ad44579ebd31f4d9c10b43", "section_path": ["Compatibility"], "commit_groups": [["64f3524e2"]], "identity_text": "Remove pg_dump/pg_dumpall support for dumping from pre-8.0 servers (Tom Lane) Users needing to dump from pre-8.0 servers will need to use dump programs from PostgreSQL 9.6 or earlier. The resulting output should still load successfully into newer servers.", "commit_aliases": ["64f3524e2"], "source_commits": ["64f3524e2"], "source_entry_id": "10.0/migration/022", "db_id": "e708375dd11b40d794cf3d160c742442", "patch_ids": ["4bf913a8c9b3b7dccf9a8b26fe84716a"], "statement_hash": "b5e18ae8f8be6a536856eb0587d270b4488d734ad26ab96d62c076dcbaa38f5d", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-9d192b743e3955d3", "migration": true}, {"id": "10.0-298991efe65f8e25", "cves": [], "html": "Remove support for floating-point timestamps and intervals (Tom Lane)
\nThis removes configure's --disable-integer-datetimes option. Floating-point timestamps have few advantages and have not been the default since PostgreSQL 8.3.
Remove server support for client/server protocol version 1.0 (Tom Lane)
\nThis protocol hasn't had client support since PostgreSQL 6.3.
", "text": "Remove server support for client/server protocol version 1.0 (Tom Lane) This protocol hasn't had client support since PostgreSQL 6.3.", "title": "Remove server support for client/server protocol version 1.0", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "e3f4ada2e62c24e2dd443018f1c17663677dcbcd2eced79cc79dd028555ef2ae", "section_path": ["Compatibility"], "commit_groups": [["2f1eaf87e"]], "identity_text": "Remove server support for client/server protocol version 1.0 (Tom Lane) This protocol hasn't had client support since PostgreSQL 6.3.", "commit_aliases": ["2f1eaf87e"], "source_commits": ["2f1eaf87e"], "source_entry_id": "10.0/migration/024", "db_id": "81eef6f0aba869c9a7f8a5e9ee8dc63c", "patch_ids": ["d1cceb8cddc1ba06b7c79817163dcb8b"], "statement_hash": "7f5f76e19023fd7318e02469fc450323c7edc092d17b9e126962d6042aaaf562", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-e48d9c66129f472d", "migration": true}, {"id": "10.0-7e653adcc77c5117", "cves": [], "html": "Remove contrib/tsearch2 module (Robert Haas)
This module provided compatibility with the version of full text search that shipped in pre-8.3 PostgreSQL releases.
", "text": "Remove contrib/tsearch2 module (Robert Haas) This module provided compatibility with the version of full text search that shipped in pre-8.3 PostgreSQL releases.", "title": "Remove contrib/tsearch2 module", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "5b293fe710a47e88f1d1b6b86f6b0cf588303e6d141a12e0c0cd07d53719ac28", "section_path": ["Compatibility"], "commit_groups": [["7ada2d31f"]], "identity_text": "Remove contrib/tsearch2 module (Robert Haas) This module provided compatibility with the version of full text search that shipped in pre-8.3 PostgreSQL releases.", "commit_aliases": ["7ada2d31f"], "source_commits": ["7ada2d31f"], "source_entry_id": "10.0/migration/025", "db_id": "1a05147655c1210ec375bd2f9c02d1c9", "patch_ids": ["932b2c5e290267a22f18b1876e10ed18"], "statement_hash": "210ffe3563bf7de960c87e330df5a3634dd53e7cb340cb8172394e93657df03e", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-7e653adcc77c5117", "migration": true}, {"id": "10.0-1c87a86e7ad0e818", "cves": [], "html": "Remove createlang and droplang command-line applications (Peter Eisentraut)
\nThese had been deprecated since PostgreSQL 9.1. Instead, use CREATE EXTENSION and DROP EXTENSION directly.
Remove support for version-0 function calling conventions (Andres Freund)
\nExtensions providing C-coded functions must now conform to version 1 calling conventions. Version 0 has been deprecated since 2001.
", "text": "Remove support for version-0 function calling conventions (Andres Freund) Extensions providing C-coded functions must now conform to version 1 calling conventions. Version 0 has been deprecated since 2001.", "title": "Remove support for version-0 function calling conventions", "commits": [], "section": "Compatibility", "category": "compatibility", "source_url": "/docs/release/10.0/#id-1.11.6.28.4", "source_hash": "46b749c3477f25c73996e92b83370336f8e2d3bde60f30f3613ec4a4f77f049a", "section_path": ["Compatibility"], "commit_groups": [["5ded4bd21"]], "identity_text": "Remove support for version-0 function calling conventions (Andres Freund) Extensions providing C-coded functions must now conform to version 1 calling conventions. Version 0 has been deprecated since 2001.", "commit_aliases": ["5ded4bd21"], "source_commits": ["5ded4bd21"], "source_entry_id": "10.0/migration/027", "db_id": "b5f209d771b4c1a1723ede502a54fd8d", "patch_ids": ["5babd72dcf17ae40b9fb5270462511a0"], "statement_hash": "d639fe62b1f2a136d0870bb65a945f583a53c42e9df3d4ee34f6d6e43bf59417", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=10.0#10.0-babf5538c113801d", "migration": true}, {"id": "10.0-60159dedcdbd4078", "cves": [], "html": "Support parallel B-tree index scans (Rahila Syed, Amit Kapila, Robert Haas, Rafia Sabih)
\nThis change allows B-tree index pages to be searched by separate parallel workers.
", "text": "Support parallel B-tree index scans (Rahila Syed, Amit Kapila, Robert Haas, Rafia Sabih) This change allows B-tree index pages to be searched by separate parallel workers.", "title": "Support parallel B-tree index scans", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "aca557d3d1e58e26007b2b527cdaf5ecf6e6e800ce4f5b47d9cdc23aaaa405c5", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["0414b26ba"], ["5262f7a4f"], ["569174f1b"]], "identity_text": "Support parallel B-tree index scans (Rahila Syed, Amit Kapila, Robert Haas, Rafia Sabih) This change allows B-tree index pages to be searched by separate parallel workers.", "commit_aliases": ["0414b26ba", "5262f7a4f", "569174f1b"], "source_commits": ["0414b26ba", "5262f7a4f", "569174f1b"], "source_entry_id": "10.0/changes/001", "db_id": "682a5f9ecb4d0cdec4897c75626bfea3", "patch_ids": ["91fa2069512023818d14b0b319798fe9", "e3a26acf4fde7eee6bc7b5bc4d248fd9", "f7a7da66874b982f8eb549f21d6baf90"], "statement_hash": "22b451f44222b3a7f7d792a96897b8e0770d6221cd7c2d99dae5704d355247f4", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-60159dedcdbd4078", "migration": false}, {"id": "10.0-25a4c253b5aeb899", "cves": [], "html": "Support parallel bitmap heap scans (Dilip Kumar)
\nThis allows a single index scan to dispatch parallel workers to process different areas of the heap.
", "text": "Support parallel bitmap heap scans (Dilip Kumar) This allows a single index scan to dispatch parallel workers to process different areas of the heap.", "title": "Support parallel bitmap heap scans", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "55b2bcad1979307015f5253a26c37c34039b21595d33597ebadfadbec1a60f8e", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["98e6e8904"], ["f35742ccb"]], "identity_text": "Support parallel bitmap heap scans (Dilip Kumar) This allows a single index scan to dispatch parallel workers to process different areas of the heap.", "commit_aliases": ["98e6e8904", "f35742ccb"], "source_commits": ["98e6e8904", "f35742ccb"], "source_entry_id": "10.0/changes/002", "db_id": "24fc5d0e51366f41e7f5e9922b8b5161", "patch_ids": ["629cf981d25684e5b147651f28b4c8e1", "6d957af0268dd9dfa2017b2d1c50e309"], "statement_hash": "eaa8b0fa7bd3eef5069cc71123c2ec79f39a5fc91838e44755055c5fac9e4250", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-25a4c253b5aeb899", "migration": false}, {"id": "10.0-bcea463862a7eff7", "cves": [], "html": "Allow merge joins to be performed in parallel (Dilip Kumar)
", "text": "Allow merge joins to be performed in parallel (Dilip Kumar)", "title": "Allow merge joins to be performed in parallel", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "9cdd92a093863975baaa75e4068354ceafac2fdedb9c1258afe5c58a0ba0da1e", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["3bc7dafa9"]], "identity_text": "Allow merge joins to be performed in parallel (Dilip Kumar)", "commit_aliases": ["3bc7dafa9"], "source_commits": ["3bc7dafa9"], "source_entry_id": "10.0/changes/003", "db_id": "c784e80ec5ff24465e15248f04a333c9", "patch_ids": ["7e68bf93dfa9618dc3fab75d8c1a3f07"], "statement_hash": "2d6e4b80ed0db4d3069c57fddab64c5616f6b89e25ca82c337515b66054a0a7f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-bcea463862a7eff7", "migration": false}, {"id": "10.0-9499d3ef357ca0ac", "cves": [], "html": "Allow non-correlated subqueries to be run in parallel (Amit Kapila)
", "text": "Allow non-correlated subqueries to be run in parallel (Amit Kapila)", "title": "Allow non-correlated subqueries to be run in parallel", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "a610d55a792b25a3ffbd43a7ac84828eac5f4e02a0c4d85f5a3d8ba7eaa03b3c", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["5e6d8d2bb"]], "identity_text": "Allow non-correlated subqueries to be run in parallel (Amit Kapila)", "commit_aliases": ["5e6d8d2bb"], "source_commits": ["5e6d8d2bb"], "source_entry_id": "10.0/changes/004", "db_id": "e9d1c67ac3574d856f78446e579303c2", "patch_ids": ["849a1f5fd1b872e61dc71e18e4f9740b"], "statement_hash": "429f823fa1d5f284d176d32c6deed87d5301d11020e9f3e296e7fa23149d317a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-9499d3ef357ca0ac", "migration": false}, {"id": "10.0-5e7440ea94d39726", "cves": [], "html": "Improve ability of parallel workers to return pre-sorted data (Rushabh Lathia)
", "text": "Improve ability of parallel workers to return pre-sorted data (Rushabh Lathia)", "title": "Improve ability of parallel workers to return pre-sorted data", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "d09bfe1793536fd49f50aba5cb1149a2eaaff0c86f0bff40d45b8ae96a818242", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["355d3993c"]], "identity_text": "Improve ability of parallel workers to return pre-sorted data (Rushabh Lathia)", "commit_aliases": ["355d3993c"], "source_commits": ["355d3993c"], "source_entry_id": "10.0/changes/005", "db_id": "4c208a7743c924b79735347e1d426e8e", "patch_ids": ["509ec37077cec958eb5520e625d52052"], "statement_hash": "ffe5e05bbd6a0c40c4044d2b982561389a3d3bd8b1d7f3ea1d1ce0e74d0dcd9f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-5e7440ea94d39726", "migration": false}, {"id": "10.0-1a33a009bd0fc61c", "cves": [], "html": "Increase parallel query usage in procedural language functions (Robert Haas, Rafia Sabih)
", "text": "Increase parallel query usage in procedural language functions (Robert Haas, Rafia Sabih)", "title": "Increase parallel query usage in procedural language functions", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "cf90018ade9f526b1660ab80f9829a58aab33ccd717b3bff1bff289f4df76e12", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["61c2e1a95"]], "identity_text": "Increase parallel query usage in procedural language functions (Robert Haas, Rafia Sabih)", "commit_aliases": ["61c2e1a95"], "source_commits": ["61c2e1a95"], "source_entry_id": "10.0/changes/006", "db_id": "c1ec4c90e1a33730fb117f91889e5d56", "patch_ids": ["78de1520fd1f32695c2ac39a44a45312"], "statement_hash": "331ac2a0ce4746c37ac7d206c3c29b1dd129805a494751cb961f8fde3fd6c611", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-1a33a009bd0fc61c", "migration": false}, {"id": "10.0-21624eb7b901e3d1", "cves": [], "html": "Add max_parallel_workers server parameter to limit the number of worker processes that can be used for query parallelism (Julien Rouhaud)
\nThis parameter can be set lower than max_worker_processes to reserve worker processes for purposes other than parallel queries.
", "text": "Add max_parallel_workers server parameter to limit the number of worker processes that can be used for query parallelism (Julien Rouhaud) This parameter can be set lower than max_worker_processes to reserve worker processes for purposes other than parallel queries.", "title": "Add max_parallel_workers server parameter to limit the number of worker processes that can be used for query parallelism", "commits": [], "section": "Server / Parallel Queries", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.2", "source_hash": "7ae2c509b0d6dd29c37593531f0060e57681dd5167df8a3c5e48260c95f38fde", "section_path": ["Server", "Parallel Queries"], "commit_groups": [["2b959d495"], ["b460f5d66"]], "identity_text": "Add guc-max-parallel-workers server parameter to limit the number of worker processes that can be used for query parallelism (Julien Rouhaud) This parameter can be set lower than guc-max-worker-processes to reserve worker processes for purposes other than parallel queries.", "commit_aliases": ["2b959d495", "b460f5d66"], "source_commits": ["2b959d495", "b460f5d66"], "source_entry_id": "10.0/changes/007", "db_id": "abbd9ebe7d3a67e869eeee738c83311d", "patch_ids": ["36f84726e5753a84dfb5a09853b0630a", "df4cbddc4deffc229b293ac854537194"], "statement_hash": "e2f8f1f1dafe2a68f02fbb049caa9c1c255ba54f3deda2f6c1182bc172751dfb", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-21624eb7b901e3d1", "migration": false}, {"id": "10.0-2446c53feceab308", "cves": [], "html": "Enable parallelism by default by changing the default setting of max_parallel_workers_per_gather to 2.
Add write-ahead logging support to hash indexes (Amit Kapila)
\nThis makes hash indexes crash-safe and replicatable. The former warning message about their use is removed.
", "text": "Add write-ahead logging support to hash indexes (Amit Kapila) This makes hash indexes crash-safe and replicatable. The former warning message about their use is removed.", "title": "Add write-ahead logging support to hash indexes", "commits": [], "section": "Server / Indexes", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.3", "source_hash": "fa617020316b9a307c6fde153beb850621e2c84a30491f530bca45ce2af31e58", "section_path": ["Server", "Indexes"], "commit_groups": [["30df93f69"], ["b0f18cb77"], ["c11453ce0"]], "identity_text": "Add write-ahead logging support to hash indexes (Amit Kapila) This makes hash indexes crash-safe and replicatable. The former warning message about their use is removed.", "commit_aliases": ["30df93f69", "b0f18cb77", "c11453ce0"], "source_commits": ["30df93f69", "b0f18cb77", "c11453ce0"], "source_entry_id": "10.0/changes/009", "db_id": "f6dd7d3a8bef90162e03c2d3e4e1e3a6", "patch_ids": ["1d965afca76234dfc985f8724bc6bcd5", "361abac0f8366db26c3ede435bd5e0ae", "c20c623ba1ad76fa2063d54dc3106115"], "statement_hash": "560804e59867b934dd1cafe40d85040a057e6e042d033f8cd36612ab37d2b026", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-fd42d81c8249193d", "migration": false}, {"id": "10.0-1a3e2d76909da0ed", "cves": [], "html": "Improve hash index performance (Amit Kapila, Mithun Cy, Ashutosh Sharma)
", "text": "Improve hash index performance (Amit Kapila, Mithun Cy, Ashutosh Sharma)", "title": "Improve hash index performance", "commits": [], "section": "Server / Indexes", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.3", "source_hash": "646efed697bd84978d9f2442b234aa264931974436a5ab5faac8a4fbfa3a4baa", "section_path": ["Server", "Indexes"], "commit_groups": [["293e24e50"], ["620b49a16"], ["6977b8b7f"], ["6d46f4783"], ["ea69a0dea"]], "identity_text": "Improve hash index performance (Amit Kapila, Mithun Cy, Ashutosh Sharma)", "commit_aliases": ["293e24e50", "620b49a16", "6977b8b7f", "6d46f4783", "ea69a0dea"], "source_commits": ["293e24e50", "620b49a16", "6977b8b7f", "6d46f4783", "ea69a0dea"], "source_entry_id": "10.0/changes/010", "db_id": "1b1b0c796b5562126f6326ed5ed1fffe", "patch_ids": ["075f3ebb20a2eda8014f73811801ac39", "160ea01bcb9075d2469e9e7ffd94ff3f", "6759c40a077528852e7807d924b9b54b", "a9f874a6334070b7da10b1c5f7984550", "cf52f7bc92da3e9c0404fc6b0887717c"], "statement_hash": "4a873900b374f5c1632882dfe33ca1d3db459e6daf6be3e5862bf0f171c4007a", "relations": [{"rule": 2, "type": "related", "target": "a160d4c3b43ec4e671044c3176ac1458", "evidence": {"same_day": true, "patch_ids": ["075f3ebb20a2eda8014f73811801ac39", "cf52f7bc92da3e9c0404fc6b0887717c"]}}], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-1a3e2d76909da0ed", "migration": false}, {"id": "10.0-43dc0b6294ff0455", "cves": [], "html": "Add SP-GiST index support for INET and CIDR data types (Emre Hasegeli)
Add option to allow BRIN index summarization to happen more aggressively (\u00c1lvaro Herrera)
\nA new CREATE INDEX option enables auto-summarization of the previous BRIN page range when a new page range is created.
Add functions to remove and re-add BRIN summarization for BRIN index ranges (\u00c1lvaro Herrera)
\nThe new SQL function brin_summarize_range() updates BRIN index summarization for a specified range and brin_desummarize_range() removes it. This is helpful to update summarization of a range that is now smaller due to UPDATEs and DELETEs.
Improve accuracy in determining if a BRIN index scan is beneficial (David Rowley, Emre Hasegeli)
", "text": "Improve accuracy in determining if a BRIN index scan is beneficial (David Rowley, Emre Hasegeli)", "title": "Improve accuracy in determining if a BRIN index scan is beneficial", "commits": [], "section": "Server / Indexes", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.3", "source_hash": "38623bd18943c31c88e3c0644817754ba52fa4a0eaa49ba07862adfa48fd7a13", "section_path": ["Server", "Indexes"], "commit_groups": [["7e534adcd"]], "identity_text": "Improve accuracy in determining if a BRIN index scan is beneficial (David Rowley, Emre Hasegeli)", "commit_aliases": ["7e534adcd"], "source_commits": ["7e534adcd"], "source_entry_id": "10.0/changes/014", "db_id": "4a3a9681e4de32eff50a6844b84d1f3d", "patch_ids": ["38c076e6a2a1c68b83549d69fdfe6046"], "statement_hash": "4697ce18a739f6b66fbe3ea4e30d5845b230be125772b75978c9fb392932e4eb", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-2e4e9ec1c730bfb0", "migration": false}, {"id": "10.0-e9cfd24a83317b36", "cves": [], "html": "Allow faster GiST inserts and updates by reusing index space more efficiently (Andrey Borodin)
", "text": "Allow faster GiST inserts and updates by reusing index space more efficiently (Andrey Borodin)", "title": "Allow faster GiST inserts and updates by reusing index space more efficiently", "commits": [], "section": "Server / Indexes", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.3", "source_hash": "873e1fae304b71cdaa7d7d3133f08f9f5f71bfb6d37ebee9338a92519b7a46d1", "section_path": ["Server", "Indexes"], "commit_groups": [["b1328d78f"]], "identity_text": "Allow faster GiST inserts and updates by reusing index space more efficiently (Andrey Borodin)", "commit_aliases": ["b1328d78f"], "source_commits": ["b1328d78f"], "source_entry_id": "10.0/changes/015", "db_id": "72c2c504d2cad357bfa42c1a57aeec03", "patch_ids": ["958af0fa41b150f1937d368cd9bd5dd7"], "statement_hash": "1efd64b4e1c6f919ab916c249d45b239626c584700a628bb3360ea4c3cef3199", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-e9cfd24a83317b36", "migration": false}, {"id": "10.0-ad454f00596efce2", "cves": [], "html": "Reduce page locking during vacuuming of GIN indexes (Andrey Borodin)
", "text": "Reduce page locking during vacuuming of GIN indexes (Andrey Borodin)", "title": "Reduce page locking during vacuuming of GIN indexes", "commits": [], "section": "Server / Indexes", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.3", "source_hash": "54234c0421590e825056630e0e51e79bec4f242af70ee5144c1452e68be025fd", "section_path": ["Server", "Indexes"], "commit_groups": [["218f51584"]], "identity_text": "Reduce page locking during vacuuming of GIN indexes (Andrey Borodin)", "commit_aliases": ["218f51584"], "source_commits": ["218f51584"], "source_entry_id": "10.0/changes/016", "db_id": "cf69d56def03ed14755fd31def0e340e", "patch_ids": ["af5a4f84bd504729b8d5553c5738666c"], "statement_hash": "feb3878a230e43b5012884158962e33eb28eb30945219a110608f2b9bce84e2c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-ad454f00596efce2", "migration": false}, {"id": "10.0-11075688181f8142", "cves": [], "html": "Reduce locking required to change table parameters (Simon Riggs, Fabr\u00edzio Mello)
\nFor example, changing a table's effective_io_concurrency setting can now be done with a more lightweight lock.
", "text": "Reduce locking required to change table parameters (Simon Riggs, Fabr\u00edzio Mello) For example, changing a table's effective_io_concurrency setting can now be done with a more lightweight lock.", "title": "Reduce locking required to change table parameters", "commits": [], "section": "Server / Locking", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.4", "source_hash": "91ab7a497fc5770163a3a945e5773e800c8e7a32ffd2da0041ec494a3ebf0559", "section_path": ["Server", "Locking"], "commit_groups": [["21d4e2e20"], ["68ea2b7f9"]], "identity_text": "Reduce locking required to change table parameters (Simon Riggs, Fabr\u00edzio Mello) For example, changing a table's guc-effective-io-concurrency setting can now be done with a more lightweight lock.", "commit_aliases": ["21d4e2e20", "68ea2b7f9"], "source_commits": ["21d4e2e20", "68ea2b7f9"], "source_entry_id": "10.0/changes/017", "db_id": "03e8ed29f7925f4b75f852de9ecac106", "patch_ids": ["0362c70ef060a8323099d6f91c42b444", "d778ac864ec469991b691e09935a25b0"], "statement_hash": "a88b00fc4ab215877dfbc9078872b452a425181d9a8469401118815d6103ef15", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-11075688181f8142", "migration": false}, {"id": "10.0-52bc09ede78cd89a", "cves": [], "html": "Allow tuning of predicate lock promotion thresholds (Dagfinn Ilmari Manns\u00e5ker)
\nLock promotion can now be controlled through two new server parameters, max_pred_locks_per_relation and max_pred_locks_per_page.
", "text": "Allow tuning of predicate lock promotion thresholds (Dagfinn Ilmari Manns\u00e5ker) Lock promotion can now be controlled through two new server parameters, max_pred_locks_per_relation and max_pred_locks_per_page.", "title": "Allow tuning of predicate lock promotion thresholds", "commits": [], "section": "Server / Locking", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.4", "source_hash": "1b164abf1c1c1a7263268b6d9468c9258294c14fbf95f8399d6c1d96d153912e", "section_path": ["Server", "Locking"], "commit_groups": [["c63172d60"]], "identity_text": "Allow tuning of predicate lock promotion thresholds (Dagfinn Ilmari Manns\u00e5ker) Lock promotion can now be controlled through two new server parameters, guc-max-pred-locks-per-relation and guc-max-pred-locks-per-page .", "commit_aliases": ["c63172d60"], "source_commits": ["c63172d60"], "source_entry_id": "10.0/changes/018", "db_id": "f2a62da54906e93a244338a9f1df3037", "patch_ids": ["55bcf78b0fa537d7fd1325d7279409cd"], "statement_hash": "5f4f7e007595f1d08973f2b118f76f5beefc7d6474e826547b45b274c5b2d5e7", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-52bc09ede78cd89a", "migration": false}, {"id": "10.0-7c6256ab3e65397c", "cves": [], "html": "Add multi-column optimizer statistics to compute the correlation ratio and number of distinct values (Tomas Vondra, David Rowley, \u00c1lvaro Herrera)
\nNew commands are CREATE STATISTICS, ALTER STATISTICS, and DROP STATISTICS. This feature is helpful in estimating query memory usage and when combining the statistics from individual columns.
Improve performance of queries affected by row-level security restrictions (Tom Lane)
\nThe optimizer now has more knowledge about where it can place RLS filter conditions, allowing better plans to be generated while still enforcing the RLS conditions safely.
", "text": "Improve performance of queries affected by row-level security restrictions (Tom Lane) The optimizer now has more knowledge about where it can place RLS filter conditions, allowing better plans to be generated while still enforcing the RLS conditions safely.", "title": "Improve performance of queries affected by row-level security restrictions", "commits": [], "section": "Server / Optimizer", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.5", "source_hash": "63087745028303bed5708851010959a235822d06b5b2ad1a44b30dd43ceb4d3a", "section_path": ["Server", "Optimizer"], "commit_groups": [["215b43cdc"]], "identity_text": "Improve performance of queries affected by row-level security restrictions (Tom Lane) The optimizer now has more knowledge about where it can place RLS filter conditions, allowing better plans to be generated while still enforcing the RLS conditions safely.", "commit_aliases": ["215b43cdc"], "source_commits": ["215b43cdc"], "source_entry_id": "10.0/changes/020", "db_id": "aedc755a19871b47cb5166ba00e27e27", "patch_ids": ["46a4422734002802265df47eeea0d0fb"], "statement_hash": "314e46d8b05aeb6c02502a43a7d599456722fdc05f1f4eb1eea50e573bb25bb8", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-863d5bbb77c09e95", "migration": false}, {"id": "10.0-19854209648bc7a7", "cves": [], "html": "Speed up aggregate functions that calculate a running sum using numeric-type arithmetic, including some variants of SUM(), AVG(), and STDDEV() (Heikki Linnakangas)
Improve performance of character encoding conversions by using radix trees (Kyotaro Horiguchi, Heikki Linnakangas)
", "text": "Improve performance of character encoding conversions by using radix trees (Kyotaro Horiguchi, Heikki Linnakangas)", "title": "Improve performance of character encoding conversions by using radix trees", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.6", "source_hash": "d5ab19d5e750c79efa4a97073df0229f0c4de02cfb0bedec8302b4c3e11dee67", "section_path": ["Server", "General Performance"], "commit_groups": [["aeed17d00"]], "identity_text": "Improve performance of character encoding conversions by using radix trees (Kyotaro Horiguchi, Heikki Linnakangas)", "commit_aliases": ["aeed17d00"], "source_commits": ["aeed17d00"], "source_entry_id": "10.0/changes/022", "db_id": "c645b71861ca967a72c8abf674da258d", "patch_ids": ["185e9a021cca9226f2cf50bfc0ac993f"], "statement_hash": "6b98766abfd66058dc51b50da6f729ec3719981f995060188b50a283a9dd29f4", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-02a3228ca5afec5a", "migration": false}, {"id": "10.0-e670ee097e91e602", "cves": [], "html": "Reduce expression evaluation overhead during query execution, as well as plan node calling overhead (Andres Freund)
\nThis is particularly helpful for queries that process many rows.
", "text": "Reduce expression evaluation overhead during query execution, as well as plan node calling overhead (Andres Freund) This is particularly helpful for queries that process many rows.", "title": "Reduce expression evaluation overhead during query execution, as well as plan node calling overhead", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.6", "source_hash": "5aded6e9fe95f159d390c23cf60f5939626bb4f3e8ed4d9d846b18abbef08336", "section_path": ["Server", "General Performance"], "commit_groups": [["b8d7f053c"], ["cc9f08b6b"]], "identity_text": "Reduce expression evaluation overhead during query execution, as well as plan node calling overhead (Andres Freund) This is particularly helpful for queries that process many rows.", "commit_aliases": ["b8d7f053c", "cc9f08b6b"], "source_commits": ["b8d7f053c", "cc9f08b6b"], "source_entry_id": "10.0/changes/023", "db_id": "37ec3e16410b3679e8ec302bf54ec3f9", "patch_ids": ["6972bf8f12429a286990b6d6b79b6d05", "c583553efe8cc6ed3441f8448744f770"], "statement_hash": "31f4b0068b97a365bf20839668498a509e0df7b6c4082f5c07f7ca0a3ad772a8", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-e670ee097e91e602", "migration": false}, {"id": "10.0-05c7ca7b41df473d", "cves": [], "html": "Allow hashed aggregation to be used with grouping sets (Andrew Gierth)
", "text": "Allow hashed aggregation to be used with grouping sets (Andrew Gierth)", "title": "Allow hashed aggregation to be used with grouping sets", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.6", "source_hash": "c2b08341f19ef757cad75fdfa47ea562a2ff62339aab26d6c6080de43ab946bb", "section_path": ["Server", "General Performance"], "commit_groups": [["b5635948a"]], "identity_text": "Allow hashed aggregation to be used with grouping sets (Andrew Gierth)", "commit_aliases": ["b5635948a"], "source_commits": ["b5635948a"], "source_entry_id": "10.0/changes/024", "db_id": "462fa1732b982d6224435709bbab7cd8", "patch_ids": ["5df792cd132af1166945ad18f97760c8"], "statement_hash": "2bb7751c8e9e4ebcca9a50fb1dca0205f9b5808245d9bac5b19be88907614ec8", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-05c7ca7b41df473d", "migration": false}, {"id": "10.0-eedea64b37384288", "cves": [], "html": "Use uniqueness guarantees to optimize certain join types (David Rowley)
", "text": "Use uniqueness guarantees to optimize certain join types (David Rowley)", "title": "Use uniqueness guarantees to optimize certain join types", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.6", "source_hash": "4c74193b31f377f1f61a3c8c2175236a6d1ef1e4b7bfe77f7261592576a0a96a", "section_path": ["Server", "General Performance"], "commit_groups": [["23886581b"], ["9c7f5229a"]], "identity_text": "Use uniqueness guarantees to optimize certain join types (David Rowley)", "commit_aliases": ["23886581b", "9c7f5229a"], "source_commits": ["23886581b", "9c7f5229a"], "source_entry_id": "10.0/changes/025", "db_id": "a497fd0779d1413d9e58d39c3a4efda8", "patch_ids": ["3a88d4439de16075a5e21a2ec2734b4b", "cb899a40b67185d81457c2b38164d79e"], "statement_hash": "6654469be140987fa0bacdc94b993b4dff5f1de14d2fc2834502dfdfc09121a3", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-eedea64b37384288", "migration": false}, {"id": "10.0-cff847b06df06a54", "cves": [], "html": "Improve sort performance of the macaddr data type (Brandur Leach)
Reduce statistics tracking overhead in sessions that reference many thousands of relations (Aleksander Alekseev)
", "text": "Reduce statistics tracking overhead in sessions that reference many thousands of relations (Aleksander Alekseev)", "title": "Reduce statistics tracking overhead in sessions that reference many thousands of relations", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.6", "source_hash": "8f42cb8829b0375e0aaad5cda279df5896c09c29558121d70e61921e24385492", "section_path": ["Server", "General Performance"], "commit_groups": [["090010f2e"]], "identity_text": "Reduce statistics tracking overhead in sessions that reference many thousands of relations (Aleksander Alekseev)", "commit_aliases": ["090010f2e"], "source_commits": ["090010f2e"], "source_entry_id": "10.0/changes/027", "db_id": "1c8079c8d371eb57ce2f3d1d6cc62bb6", "patch_ids": ["6cab17a8be470f60e10b85a56008788b"], "statement_hash": "93f5fffd6c920bbffef5a853de79b95d24f970f71db7e006be9b73a29028e7e2", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-3e5a5a5f2c18a3ab", "migration": false}, {"id": "10.0-de0bdd2d280cb626", "cves": [], "html": "Allow explicit control over EXPLAIN's display of planning and execution time (Ashutosh Bapat)
By default planning and execution time are displayed by EXPLAIN ANALYZE and are not displayed in other cases. The new EXPLAIN option SUMMARY allows explicit control of this.
Add default monitoring roles (Dave Page)
\nNew roles pg_monitor, pg_read_all_settings, pg_read_all_stats, and pg_stat_scan_tables allow simplified permission configuration.
Properly update the statistics collector during REFRESH MATERIALIZED VIEW (Jim Mlodgenski)
Change the default value of log_line_prefix to include current timestamp (with milliseconds) and the process ID in each line of postmaster log output (Christoph Berg)
\nThe previous default was an empty prefix.
", "text": "Change the default value of log_line_prefix to include current timestamp (with milliseconds) and the process ID in each line of postmaster log output (Christoph Berg) The previous default was an empty prefix.", "title": "Change the default value of log_line_prefix to include current timestamp (with milliseconds) and the process ID in each line of postmaster log output", "commits": [], "section": "Server / Monitoring / Logging", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.7.3", "source_hash": "430530b779b749f39d390dc37eee0a6f2c90912e97fab5109eac4390988c03a7", "section_path": ["Server", "Monitoring", "Logging"], "commit_groups": [["7d3235ba4"]], "identity_text": "Change the default value of guc-log-line-prefix to include current timestamp (with milliseconds) and the process ID in each line of postmaster log output (Christoph Berg) The previous default was an empty prefix.", "commit_aliases": ["7d3235ba4"], "source_commits": ["7d3235ba4"], "source_entry_id": "10.0/changes/031", "db_id": "4ba3f50ad7bca656896e9b0bf0e9b1e1", "patch_ids": ["cc34968670c26fa85eb9f19b550a7fea"], "statement_hash": "10ce51fdd7c68cd9b2a6f256ec140ba623bcca630a8ed9696bc59e6b34ff9f35", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-65e11fe095d39b48", "migration": false}, {"id": "10.0-46a30348a26d357a", "cves": [], "html": "Add functions to return the log and WAL directory contents (Dave Page)
\nThe new functions are pg_ls_logdir() and pg_ls_waldir() and can be executed by non-superusers with the proper permissions.
Add function pg_current_logfile() to read logging collector's current stderr and csvlog output file names (Gilles Darold)
Report the address and port number of each listening socket in the server log during postmaster startup (Tom Lane)
\nAlso, when logging failure to bind a listening socket, include the specific address we attempted to bind to.
", "text": "Report the address and port number of each listening socket in the server log during postmaster startup (Tom Lane) Also, when logging failure to bind a listening socket, include the specific address we attempted to bind to.", "title": "Report the address and port number of each listening socket in the server log during postmaster startup", "commits": [], "section": "Server / Monitoring / Logging", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.7.3", "source_hash": "d9c6f9c9dedb546ff579dbaeabf9516157b0b8d5f301d0a994ae1b67e50517cd", "section_path": ["Server", "Monitoring", "Logging"], "commit_groups": [["2b32ac2a5"], ["f9dfa5c97"]], "identity_text": "Report the address and port number of each listening socket in the server log during postmaster startup (Tom Lane) Also, when logging failure to bind a listening socket, include the specific address we attempted to bind to.", "commit_aliases": ["2b32ac2a5", "f9dfa5c97"], "source_commits": ["2b32ac2a5", "f9dfa5c97"], "source_entry_id": "10.0/changes/034", "db_id": "271e0aed53552f19193ecc8e7e8bf126", "patch_ids": ["463233a146b24b5e51cf7e4a2ce16960", "d37ecd73caa8793d2ba533432e8910de"], "statement_hash": "992ddb3eb6b0cfbd74f88dabb38811adc178df61a93bd16814a3961270354d57", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-a290540d481180c2", "migration": false}, {"id": "10.0-e72f17cdf819d3af", "cves": [], "html": "Reduce log chatter about the starting and stopping of launcher subprocesses (Tom Lane)
\nThese are now DEBUG1-level messages.
Reduce message verbosity of lower-numbered debug levels controlled by log_min_messages (Robert Haas)
\nThis also changes the verbosity of client_min_messages debug levels.
", "text": "Reduce message verbosity of lower-numbered debug levels controlled by log_min_messages (Robert Haas) This also changes the verbosity of client_min_messages debug levels.", "title": "Reduce message verbosity of lower-numbered debug levels controlled by log_min_messages", "commits": [], "section": "Server / Monitoring / Logging", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.7.3", "source_hash": "df4e904359840948cf53906f5168fa3005017c1ae2572d893a949793650a7569", "section_path": ["Server", "Monitoring", "Logging"], "commit_groups": [["a43f1939d"]], "identity_text": "Reduce message verbosity of lower-numbered debug levels controlled by guc-log-min-messages (Robert Haas) This also changes the verbosity of guc-client-min-messages debug levels.", "commit_aliases": ["a43f1939d"], "source_commits": ["a43f1939d"], "source_entry_id": "10.0/changes/036", "db_id": "c4d01ad319a06db439ae0411c31e7c7b", "patch_ids": ["5867378bd43df64dd898d6670e3791aa"], "statement_hash": "ef8d0ea82aae09f3f1f4871c1b664d7896086ccb80d4c22711d94a8af3a7a588", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-46aa08699796fa7a", "migration": false}, {"id": "10.0-fcd4ffb064fb98d2", "cves": [], "html": "Add pg_stat_activity reporting of low-level wait states (Michael Paquier, Robert Haas, Rushabh Lathia)
This change enables reporting of numerous low-level wait conditions, including latch waits, file reads/writes/fsyncs, client reads/writes, and synchronous replication.
", "text": "Add pg_stat_activity reporting of low-level wait states (Michael Paquier, Robert Haas, Rushabh Lathia) This change enables reporting of numerous low-level wait conditions, including latch waits, file reads/writes/fsyncs, client reads/writes, and synchronous replication.", "title": "Add pg_stat_activity reporting of low-level wait states", "commits": [], "section": "Server / Monitoring / pg_stat_activity", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.7.4", "source_hash": "5ff4e17d8556018318958e0e0683c0e505afedeb5025d70cca75945b04e39374", "section_path": ["Server", "Monitoring", "pg_stat_activity"], "commit_groups": [["249cf070e"], ["6f3bd98eb"]], "identity_text": "Add pg_stat_activity reporting of low-level wait states (Michael Paquier, Robert Haas, Rushabh Lathia) This change enables reporting of numerous low-level wait conditions, including latch waits, file reads/writes/fsyncs, client reads/writes, and synchronous replication.", "commit_aliases": ["249cf070e", "6f3bd98eb"], "source_commits": ["249cf070e", "6f3bd98eb"], "source_entry_id": "10.0/changes/037", "db_id": "548d61363ef43e9e7d3300b8c0a296aa", "patch_ids": ["95c8a1fef2d53841fc467b6975fcd271", "e2fcec9826192788006bf9c5069eccdc"], "statement_hash": "f9ad28b2e7fe93e93ccbd6fae1e42e388478d76063c504772673ceda2f95ca01", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-fcd4ffb064fb98d2", "migration": false}, {"id": "10.0-d4094b029d62267a", "cves": [], "html": "Show auxiliary processes, background workers, and walsender processes in pg_stat_activity (Kuntal Ghosh, Michael Paquier)
This simplifies monitoring. A new column backend_type identifies the process type.
Allow pg_stat_activity to show the SQL query being executed by parallel workers (Rafia Sabih)
Rename pg_stat_activity.wait_event_type values LWLockTranche and LWLockNamed to LWLock (Robert Haas)
This makes the output more consistent.
", "text": "Rename pg_stat_activity.wait_event_type values LWLockTranche and LWLockNamed to LWLock (Robert Haas) This makes the output more consistent.", "title": "Rename pg_stat_activity.wait_event_type values LWLockTranche and LWLockNamed to LWLock", "commits": [], "section": "Server / Monitoring / pg_stat_activity", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.7.4", "source_hash": "b4aa3fd82344e64b9f92bd4d7e700f520be7a8351d13375ec0c232776da6dddd", "section_path": ["Server", "Monitoring", "pg_stat_activity"], "commit_groups": [["3761fe3c2"]], "identity_text": "Rename pg_stat_activity.wait_event_type values LWLockTranche and LWLockNamed to LWLock (Robert Haas) This makes the output more consistent.", "commit_aliases": ["3761fe3c2"], "source_commits": ["3761fe3c2"], "source_entry_id": "10.0/changes/040", "db_id": "f59ec4da0ca69e48f492dc00cf6f1d9e", "patch_ids": ["ec668b12c66ff7f67c918dd7fb4c6a77"], "statement_hash": "fdcf1edb08069f73db9f25970f7a5931255b6bcb898d10573b8028e18742f65a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-8d7abd70d2803c4f", "migration": false}, {"id": "10.0-97c58c4eb5d81a89", "cves": [], "html": "Add SCRAM-SHA-256 support for password negotiation and storage (Michael Paquier, Heikki Linnakangas)
\nThis provides better security than the existing md5 negotiation and storage method.
Change the password_encryption server parameter from boolean to enum (Michael Paquier)
This was necessary to support additional password hashing options.
", "text": "Change the password_encryption server parameter from boolean to enum (Michael Paquier) This was necessary to support additional password hashing options.", "title": "Change the password_encryption server parameter from boolean to enum", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.8", "source_hash": "b996f7f4b951b2199d49b484d7cb76c3630253bdd52981c2cb034a05b43f6dcf", "section_path": ["Server", "Authentication"], "commit_groups": [["babe05bc2"]], "identity_text": "Change the guc-password-encryption server parameter from boolean to enum (Michael Paquier) This was necessary to support additional password hashing options.", "commit_aliases": ["babe05bc2"], "source_commits": ["babe05bc2"], "source_entry_id": "10.0/changes/042", "db_id": "afa263671dbc0306e1d8e88bc4015fc2", "patch_ids": ["abb74703914df8bd8d9e5393b60bc3d9"], "statement_hash": "7f1ce92d72b66ecfad551ff7220b5c6f1ca42cddc103609a5b53b0cf75b4189f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-122f6d236a25e718", "migration": false}, {"id": "10.0-a3599e7b9a367475", "cves": [], "html": "Add view pg_hba_file_rules to display the contents of pg_hba.conf (Haribabu Kommi)
This shows the file contents, not the currently active settings.
", "text": "Add view pg_hba_file_rules to display the contents of pg_hba.conf (Haribabu Kommi) This shows the file contents, not the currently active settings.", "title": "Add view pg_hba_file_rules to display the contents of pg_hba.conf", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.8", "source_hash": "f005ec6553290cabb809a2b288a7583908c42eb587889f913c6c59c529e1e3df", "section_path": ["Server", "Authentication"], "commit_groups": [["de16ab723"]], "identity_text": "Add view pg_hba_file_rules to display the contents of pg_hba.conf (Haribabu Kommi) This shows the file contents, not the currently active settings.", "commit_aliases": ["de16ab723"], "source_commits": ["de16ab723"], "source_entry_id": "10.0/changes/043", "db_id": "a133c968c922bc702ba42065038ca89f", "patch_ids": ["44e5d255d321296cbde553fb62d692b9"], "statement_hash": "493c791e8e96266151f710342beff6199a2fffd0f3aba7a309a34462e6866cf8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-a3599e7b9a367475", "migration": false}, {"id": "10.0-c34de25417090c4f", "cves": [], "html": "Support multiple RADIUS servers (Magnus Hagander)
\nAll the RADIUS related parameters are now plural and support a comma-separated list of servers.
", "text": "Support multiple RADIUS servers (Magnus Hagander) All the RADIUS related parameters are now plural and support a comma-separated list of servers.", "title": "Support multiple RADIUS servers", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.8", "source_hash": "0c03f11738b6648834426e56eed507bc21189c7ec16c3b5ba9a0e151d15d47cd", "section_path": ["Server", "Authentication"], "commit_groups": [["6b76f1bb5"]], "identity_text": "Support multiple RADIUS servers (Magnus Hagander) All the RADIUS related parameters are now plural and support a comma-separated list of servers.", "commit_aliases": ["6b76f1bb5"], "source_commits": ["6b76f1bb5"], "source_entry_id": "10.0/changes/044", "db_id": "ef402842881f2e52be7128c86e6153b8", "patch_ids": ["398995d71c255838efc9a3f83849d48e"], "statement_hash": "a877a2a65bc61475f09aaac8cc1e5fe999dcb07fe1478d61897e6106787f3518", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-c34de25417090c4f", "migration": false}, {"id": "10.0-710c341de5948c44", "cves": [], "html": "Allow SSL configuration to be updated during configuration reload (Andreas Karlsson, Tom Lane)
\nThis allows SSL to be reconfigured without a server restart, by using pg_ctl reload, SELECT pg_reload_conf(), or sending a SIGHUP signal. However, reloading the SSL configuration does not work if the server's SSL key requires a passphrase, as there is no way to re-prompt for the passphrase. The original configuration will apply for the life of the postmaster in that case.
Make the maximum value of bgwriter_lru_maxpages effectively unlimited (Jim Nasby)
", "text": "Make the maximum value of bgwriter_lru_maxpages effectively unlimited (Jim Nasby)", "title": "Make the maximum value of bgwriter_lru_maxpages effectively unlimited", "commits": [], "section": "Server / Server Configuration", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.9", "source_hash": "6c426f9c83e8a983b71116d32bb416dbd8026fd8e76e61bc459410fb79be3471", "section_path": ["Server", "Server Configuration"], "commit_groups": [["14ca9abfb"]], "identity_text": "Make the maximum value of guc-bgwriter-lru-maxpages effectively unlimited (Jim Nasby)", "commit_aliases": ["14ca9abfb"], "source_commits": ["14ca9abfb"], "source_entry_id": "10.0/changes/046", "db_id": "d0181024ec9a4f1edad33804ec164b30", "patch_ids": ["0cfacdeb65fad0038089c8dc0a3cf879"], "statement_hash": "7fd162546a7727735abb8008b372b7f5df3170f5d5b3ffabd9f1db8aea3edc64", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-0a92e60994db576d", "migration": false}, {"id": "10.0-db5a638e7919c3f9", "cves": [], "html": "After creating or unlinking files, perform an fsync on their parent directory (Michael Paquier)
\nThis reduces the risk of data loss after a power failure.
", "text": "After creating or unlinking files, perform an fsync on their parent directory (Michael Paquier) This reduces the risk of data loss after a power failure.", "title": "After creating or unlinking files, perform an fsync on their parent directory", "commits": [], "section": "Server / Reliability", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.10", "source_hash": "7de32df7489edd361c1eecd079afe7243172fd9cb25fd7f8b92ecb5b326f65ba", "section_path": ["Server", "Reliability"], "commit_groups": [["1b02be21f"]], "identity_text": "After creating or unlinking files, perform an fsync on their parent directory (Michael Paquier) This reduces the risk of data loss after a power failure.", "commit_aliases": ["1b02be21f"], "source_commits": ["1b02be21f"], "source_entry_id": "10.0/changes/047", "db_id": "8fed6acbfe05ef12435a27b0ab7c8ded", "patch_ids": ["89bb2ac8b09908cfe5eec222d8b8cfcf"], "statement_hash": "5c404d40efb7231cc67fc2a2249db5c257a0132b3becca6d799f8b47ebcab782", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-db5a638e7919c3f9", "migration": false}, {"id": "10.0-0baabb492b1978f0", "cves": [], "html": "Prevent unnecessary checkpoints and WAL archiving on otherwise-idle systems (Michael Paquier)
", "text": "Prevent unnecessary checkpoints and WAL archiving on otherwise-idle systems (Michael Paquier)", "title": "Prevent unnecessary checkpoints and WAL archiving on otherwise-idle systems", "commits": [], "section": "Server / Reliability / Write-Ahead Log (WAL)", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.10.3", "source_hash": "8f66f95c00cf87924a004fe24299c5a84715e5544a795512373727485e1a32a7", "section_path": ["Server", "Reliability", "Write-Ahead Log (WAL)"], "commit_groups": [["6ef2eba3f"]], "identity_text": "Prevent unnecessary checkpoints and WAL archiving on otherwise-idle systems (Michael Paquier)", "commit_aliases": ["6ef2eba3f"], "source_commits": ["6ef2eba3f"], "source_entry_id": "10.0/changes/048", "db_id": "c1edf67502edb4aede9d2b3347b0ec95", "patch_ids": ["f48c31ad65a7f11a438c2974a0536592"], "statement_hash": "d9bdd702fdc51105f7373d18ffb8bdcf4b53ec0b0cc71485e0f5a1912a1cbdf4", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-0baabb492b1978f0", "migration": false}, {"id": "10.0-924e8c325fd7351d", "cves": [], "html": "Add wal_consistency_checking server parameter to add details to WAL that can be sanity-checked on the standby (Kuntal Ghosh, Robert Haas)
\nAny sanity-check failure generates a fatal error on the standby.
", "text": "Add wal_consistency_checking server parameter to add details to WAL that can be sanity-checked on the standby (Kuntal Ghosh, Robert Haas) Any sanity-check failure generates a fatal error on the standby.", "title": "Add wal_consistency_checking server parameter to add details to WAL that can be sanity-checked on the standby", "commits": [], "section": "Server / Reliability / Write-Ahead Log (WAL)", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.10.3", "source_hash": "d01988da1ae8d1e138d03262c003b98f92865cbedf946fed29870ab3a82d00c4", "section_path": ["Server", "Reliability", "Write-Ahead Log (WAL)"], "commit_groups": [["a507b8690"], ["bb4a39637"]], "identity_text": "Add guc-wal-consistency-checking server parameter to add details to WAL that can be sanity-checked on the standby (Kuntal Ghosh, Robert Haas) Any sanity-check failure generates a fatal error on the standby.", "commit_aliases": ["a507b8690", "bb4a39637"], "source_commits": ["a507b8690", "bb4a39637"], "source_entry_id": "10.0/changes/049", "db_id": "4bd9e1fe8f926b6fc20518c6dc3080b1", "patch_ids": ["0bd78eb8733a86695381e9a5b1b24957", "537ad465a78225b3d14bc9986ad98a52"], "statement_hash": "b2b57a7f4c75e4e522b3517745ffb0932ec4eef1ec7a363a81859171387ffcc1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-924e8c325fd7351d", "migration": false}, {"id": "10.0-e4ddde7b6ed853a2", "cves": [], "html": "Increase the maximum configurable WAL segment size to one gigabyte (Beena Emerson)
\nA larger WAL segment size allows for fewer archive_command invocations and fewer WAL files to manage.
", "text": "Increase the maximum configurable WAL segment size to one gigabyte (Beena Emerson) A larger WAL segment size allows for fewer archive_command invocations and fewer WAL files to manage.", "title": "Increase the maximum configurable WAL segment size to one gigabyte", "commits": [], "section": "Server / Reliability / Write-Ahead Log (WAL)", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.3.10.3", "source_hash": "ffaff3176ba6966287b903cf06f54b13599e82bdbd1061a038f7e4cb92638a96", "section_path": ["Server", "Reliability", "Write-Ahead Log (WAL)"], "commit_groups": [["00b6b6feb"]], "identity_text": "Increase the maximum configurable WAL segment size to one gigabyte (Beena Emerson) A larger WAL segment size allows for fewer guc-archive-command invocations and fewer WAL files to manage.", "commit_aliases": ["00b6b6feb"], "source_commits": ["00b6b6feb"], "source_entry_id": "10.0/changes/050", "db_id": "9fd24a9439f4f6d2094f14222d345f3b", "patch_ids": ["f5a2f823013247b008b9bdd7a231b654"], "statement_hash": "cec98edf71c2e5c03ae4f899f9c87357bda6939b413a19f1c42c38e2ee3d8536", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-e4ddde7b6ed853a2", "migration": false}, {"id": "10.0-a26b890a92034444", "cves": [], "html": "Add the ability to logically replicate tables to standby servers (Petr Jelinek)
\nLogical replication allows more flexibility than physical replication does, including replication between different major versions of PostgreSQL and selective replication.
", "text": "Add the ability to logically replicate tables to standby servers (Petr Jelinek) Logical replication allows more flexibility than physical replication does, including replication between different major versions of PostgreSQL and selective replication.", "title": "Add the ability to logically replicate tables to standby servers", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.4", "source_hash": "1bdb86037bc318143094d15587265e1e9fcf4380b1084c3613e527d1bd9f03b9", "section_path": ["Replication and Recovery"], "commit_groups": [["665d1fad9"], ["7c4f52409"], ["ff7bce174"]], "identity_text": "Add the ability to logically replicate tables to standby servers (Petr Jelinek) Logical replication allows more flexibility than physical replication does, including replication between different major versions of PostgreSQL and selective replication.", "commit_aliases": ["665d1fad9", "7c4f52409", "ff7bce174"], "source_commits": ["665d1fad9", "7c4f52409", "ff7bce174"], "source_entry_id": "10.0/changes/051", "db_id": "8d5c9b1007a1e351a1af663db823583c", "patch_ids": ["4eca6a9f36394470a86009ce54223f8d", "8113e89894f6095931263bf7098c1110", "949507c79af3f30c367f628ab83d5fdd"], "statement_hash": "7cd538c62bc7e58a29dc48b42cd9e002ff58a17d00cf43f5f9e04c6cf1ce1fd3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-a26b890a92034444", "migration": false}, {"id": "10.0-c80fb88003487911", "cves": [], "html": "Allow waiting for commit acknowledgment from standby servers irrespective of the order they appear in synchronous_standby_names (Masahiko Sawada)
\nPreviously the server always waited for the active standbys that appeared first in synchronous_standby_names. The new synchronous_standby_names keyword ANY allows waiting for any number of standbys irrespective of their ordering. This is known as quorum commit.
Reduce configuration changes necessary to perform streaming backup and replication (Magnus Hagander, Dang Minh Huong)
\nSpecifically, the defaults were changed for wal_level, max_wal_senders, max_replication_slots, and hot_standby to make them suitable for these usages out-of-the-box.
", "text": "Reduce configuration changes necessary to perform streaming backup and replication (Magnus Hagander, Dang Minh Huong) Specifically, the defaults were changed for wal_level, max_wal_senders, max_replication_slots, and hot_standby to make them suitable for these usages out-of-the-box.", "title": "Reduce configuration changes necessary to perform streaming backup and replication", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.4", "source_hash": "d3634dccf2785ef8a802bc41559cea4f4769a6deb07d6e9790b829d4bf4238cc", "section_path": ["Replication and Recovery"], "commit_groups": [["34fc61673"], ["f6d6d2920"]], "identity_text": "Reduce configuration changes necessary to perform streaming backup and replication (Magnus Hagander, Dang Minh Huong) Specifically, the defaults were changed for guc-wal-level , guc-max-wal-senders , guc-max-replication-slots , and guc-hot-standby to make them suitable for these usages out-of-the-box.", "commit_aliases": ["34fc61673", "f6d6d2920"], "source_commits": ["34fc61673", "f6d6d2920"], "source_entry_id": "10.0/changes/053", "db_id": "67d90388012baa145d263d45eb7790f2", "patch_ids": ["b83866010e871eb381fcdcf31e89ba20", "e62eb5fbd5fad22e130cb6c120efcf4d"], "statement_hash": "23d398d442a929d5ee5da45afd1d9af0cc976ce5f54bbe9e8eeb239f373dbf65", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-cc4d2f3185c03b27", "migration": false}, {"id": "10.0-22f234c1c5fbd57c", "cves": [], "html": "Enable replication from localhost connections by default in pg_hba.conf (Michael Paquier)
Previously pg_hba.conf's replication connection lines were commented out by default. This is particularly useful for pg_basebackup.
Add columns to pg_stat_replication to report replication delay times (Thomas Munro)
The new columns are write_lag, flush_lag, and replay_lag.
Allow specification of the recovery stopping point by Log Sequence Number (LSN) in recovery.conf (Michael Paquier)
Previously the stopping point could only be selected by timestamp or XID.
", "text": "Allow specification of the recovery stopping point by Log Sequence Number (LSN) in recovery.conf (Michael Paquier) Previously the stopping point could only be selected by timestamp or XID.", "title": "Allow specification of the recovery stopping point by Log Sequence Number (LSN) in recovery.conf", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.4", "source_hash": "2815edcf421ed51fb957d4d3d6ee6f275c011b004376b6a6d76ab5f0d7f1b9c3", "section_path": ["Replication and Recovery"], "commit_groups": [["35250b6ad"]], "identity_text": "Allow specification of the recovery stopping point by Log Sequence Number (LSN) in recovery.conf (Michael Paquier) Previously the stopping point could only be selected by timestamp or XID.", "commit_aliases": ["35250b6ad"], "source_commits": ["35250b6ad"], "source_entry_id": "10.0/changes/056", "db_id": "d6aad2f763b159e65a7887cd2c4b49c9", "patch_ids": ["7d0400fa87e53e4484c0f9d39f4d9988"], "statement_hash": "f248486f70b3f3fa457fddcd45bbc3b43a12f70c723ee0a82aec4b66748989ac", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-30fc50864161c2db", "migration": false}, {"id": "10.0-ef1ec0153826b5ce", "cves": [], "html": "Allow users to disable pg_stop_backup()'s waiting for all WAL to be archived (David Steele)
An optional second argument to pg_stop_backup() controls that behavior.
Allow creation of temporary replication slots (Petr Jelinek)
\nTemporary slots are automatically removed on session exit or error.
", "text": "Allow creation of temporary replication slots (Petr Jelinek) Temporary slots are automatically removed on session exit or error.", "title": "Allow creation of temporary replication slots", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.4", "source_hash": "a67867bae863ed84d21ca94229f1b08fce3661ab3cb1c8ba3d786e27d408fc61", "section_path": ["Replication and Recovery"], "commit_groups": [["a924c327e"]], "identity_text": "Allow creation of temporary replication slots (Petr Jelinek) Temporary slots are automatically removed on session exit or error.", "commit_aliases": ["a924c327e"], "source_commits": ["a924c327e"], "source_entry_id": "10.0/changes/058", "db_id": "94d63f267644c5550a4fb34179113407", "patch_ids": ["d5ca53ea829b0433d245a027c96795bd"], "statement_hash": "8d8d325f39d1180484d4b07bf2b8183c820cb51efd0886380d75e0a970f34803", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-1d112aac6922df0a", "migration": false}, {"id": "10.0-c8e64341d9546006", "cves": [], "html": "Improve performance of hot standby replay with better tracking of Access Exclusive locks (Simon Riggs, David Rowley)
", "text": "Improve performance of hot standby replay with better tracking of Access Exclusive locks (Simon Riggs, David Rowley)", "title": "Improve performance of hot standby replay with better tracking of Access Exclusive locks", "commits": [], "section": "Replication and Recovery", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.4", "source_hash": "2fac1f6616f3b9e3ab4661e2db7fd219e7500c215606370cb552f6a97818671a", "section_path": ["Replication and Recovery"], "commit_groups": [["9b013dc23"]], "identity_text": "Improve performance of hot standby replay with better tracking of Access Exclusive locks (Simon Riggs, David Rowley)", "commit_aliases": ["9b013dc23"], "source_commits": ["9b013dc23"], "source_entry_id": "10.0/changes/059", "db_id": "88bbe6e6e6d7a54a9f119813e0196fe1", "patch_ids": ["4d856039f05b57199360f11dcdc4ebf6"], "statement_hash": "5cac060c135c7ee57dbdf57f581799d1dca505c84afa9d86823f5219753397b2", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-c8e64341d9546006", "migration": false}, {"id": "10.0-16b760a47355914b", "cves": [], "html": "Speed up two-phase commit recovery performance (Stas Kelvich, Nikhil Sontakke, Michael Paquier)
", "text": "Speed up two-phase commit recovery performance (Stas Kelvich, Nikhil Sontakke, Michael Paquier)", "title": "Speed up two-phase commit recovery performance", "commits": [], "section": "Replication and Recovery", "category": "performance", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.4", "source_hash": "094a02cfffc6c75f2bb0f6d2f8fff998eaf5119ae119dfe739f0dafd869a5cdb", "section_path": ["Replication and Recovery"], "commit_groups": [["728bd991c"]], "identity_text": "Speed up two-phase commit recovery performance (Stas Kelvich, Nikhil Sontakke, Michael Paquier)", "commit_aliases": ["728bd991c"], "source_commits": ["728bd991c"], "source_entry_id": "10.0/changes/060", "db_id": "e62db3557fadcb3ee908fa7de4be4572", "patch_ids": ["855c0c93dc38e0e721302335a849e5ea"], "statement_hash": "02d70c318ea3c974e16da864d95ccb7491e8fe1508c8eaf85575f5ca6adf9f06", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=10.0#10.0-16b760a47355914b", "migration": false}, {"id": "10.0-a4da245a86440913", "cves": [], "html": "Add XMLTABLE function that converts XML-formatted data into a row set (Pavel Stehule, \u00c1lvaro Herrera)
Fix regular expressions' character class handling for large character codes, particularly Unicode characters above U+7FF (Tom Lane)
Previously, such characters were never recognized as belonging to locale-dependent character classes such as [[:alpha:]].
Add table partitioning syntax that automatically creates partition constraints and handles routing of tuple insertions and updates (Amit Langote)
\nThe syntax supports range and list partitioning.
", "text": "Add table partitioning syntax that automatically creates partition constraints and handles routing of tuple insertions and updates (Amit Langote) The syntax supports range and list partitioning.", "title": "Add table partitioning syntax that automatically creates partition constraints and handles routing of tuple insertions and updates", "commits": [], "section": "Utility Commands", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.6", "source_hash": "94d8858175f00905c9d3674000e0ab563d7df4de6468d33020421e857c482b9c", "section_path": ["Utility Commands"], "commit_groups": [["f0e44751d"]], "identity_text": "Add table partitioning syntax that automatically creates partition constraints and handles routing of tuple insertions and updates (Amit Langote) The syntax supports range and list partitioning.", "commit_aliases": ["f0e44751d"], "source_commits": ["f0e44751d"], "source_entry_id": "10.0/changes/063", "db_id": "000057305b6d8458507f09c26fffd339", "patch_ids": ["2bf171efca6b83c614abb12f5bd60e5b"], "statement_hash": "e6f014871affdecd51e5f21cf376222be26826e3fc03e3b464de957394eb3724", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-3d3f6ef09fffdb07", "migration": false}, {"id": "10.0-0f94816707fb6197", "cves": [], "html": "Add AFTER trigger transition tables to record changed rows (Kevin Grittner, Thomas Munro)
Transition tables are accessible from triggers written in server-side languages.
", "text": "Add AFTER trigger transition tables to record changed rows (Kevin Grittner, Thomas Munro) Transition tables are accessible from triggers written in server-side languages.", "title": "Add AFTER trigger transition tables to record changed rows", "commits": [], "section": "Utility Commands", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.6", "source_hash": "834dedfaacca547b9c5623065cdd74918520d15a6eecb0697bb7156e7a039f9e", "section_path": ["Utility Commands"], "commit_groups": [["597027163"], ["5ebeb579b"], ["8c48375e5"]], "identity_text": "Add AFTER trigger transition tables to record changed rows (Kevin Grittner, Thomas Munro) Transition tables are accessible from triggers written in server-side languages.", "commit_aliases": ["597027163", "5ebeb579b", "8c48375e5"], "source_commits": ["597027163", "5ebeb579b", "8c48375e5"], "source_entry_id": "10.0/changes/064", "db_id": "de0d9af502d9e1e6d87e711d28a2f042", "patch_ids": ["09466e2798704d0757aecf9fb54b94a2", "bd09118edd8189fcb8d416683119d3f9", "d984a09ea62a00b46e43afe97c645165"], "statement_hash": "38e9e2985f53a4c167d53ae0073e13f157f08a37e2051da83812a01d3d18e94c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-0f94816707fb6197", "migration": false}, {"id": "10.0-593e22c1ab72dd4c", "cves": [], "html": "Allow restrictive row-level security policies (Stephen Frost)
\nPreviously all security policies were permissive, meaning that any matching policy allowed access. A restrictive policy must match for access to be granted. These policy types can be combined.
", "text": "Allow restrictive row-level security policies (Stephen Frost) Previously all security policies were permissive, meaning that any matching policy allowed access. A restrictive policy must match for access to be granted. These policy types can be combined.", "title": "Allow restrictive row-level security policies", "commits": [], "section": "Utility Commands", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.6", "source_hash": "20ad2dc5b93616be835c2ebc1e74e3a483caf830be97c14ed18e764c8393df66", "section_path": ["Utility Commands"], "commit_groups": [["093129c9d"]], "identity_text": "Allow restrictive row-level security policies (Stephen Frost) Previously all security policies were permissive, meaning that any matching policy allowed access. A restrictive policy must match for access to be granted. These policy types can be combined.", "commit_aliases": ["093129c9d"], "source_commits": ["093129c9d"], "source_entry_id": "10.0/changes/065", "db_id": "11b96674a66e357c060e1dcc5e253b7b", "patch_ids": ["f8296a929e01c4303a2ddef9913af095"], "statement_hash": "190ca66f06b4064549fe003257b36cb1c8f60d7a632f550709198255cc4d7a36", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-593e22c1ab72dd4c", "migration": false}, {"id": "10.0-30393191cd6d3fc5", "cves": [], "html": "When creating a foreign-key constraint, check for REFERENCES permission on only the referenced table (Tom Lane)
Previously REFERENCES permission on the referencing table was also required. This appears to have stemmed from a misreading of the SQL standard. Since creating a foreign key (or any other type of) constraint requires ownership privilege on the constrained table, additionally requiring REFERENCES permission seems rather pointless.
Allow default permissions on schemas (Matheus Oliveira)
\nThis is done using the ALTER DEFAULT PRIVILEGES command.
Add CREATE SEQUENCE AS command to create a sequence matching an integer data type (Peter Eisentraut)
This simplifies the creation of sequences matching the range of base columns.
", "text": "Add CREATE SEQUENCE AS command to create a sequence matching an integer data type (Peter Eisentraut) This simplifies the creation of sequences matching the range of base columns.", "title": "Add CREATE SEQUENCE AS command to create a sequence matching an integer data type", "commits": [], "section": "Utility Commands", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.6", "source_hash": "dbb699bf2f589350eb074b3c495e11b3a59e7e9001bd1d4b3a618bd053608abf", "section_path": ["Utility Commands"], "commit_groups": [["2ea5b06c7"]], "identity_text": "Add CREATE SEQUENCE AS command to create a sequence matching an integer data type (Peter Eisentraut) This simplifies the creation of sequences matching the range of base columns.", "commit_aliases": ["2ea5b06c7"], "source_commits": ["2ea5b06c7"], "source_entry_id": "10.0/changes/068", "db_id": "7d19b7716e47e8fa920af0dae46ddb4d", "patch_ids": ["cacf93b55aeda4f5f523fbc43dbd30cf"], "statement_hash": "23c49e912e34ad5a64b6aefdb1a356a6b2589f2cbe9779f3e75b515e383e16ec", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-973c057063aefc25", "migration": false}, {"id": "10.0-7313bfe81114e077", "cves": [], "html": "Allow COPY on views with view FROM sourceINSTEAD INSERT triggers (Haribabu Kommi)
The triggers are fed the data rows read by COPY.
Allow the specification of a function name without arguments in DDL commands, if it is unique (Peter Eisentraut)
\nFor example, allow DROP FUNCTION on a function name without arguments if there is only one function with that name. This behavior is required by the SQL standard.
Allow multiple functions, operators, and aggregates to be dropped with a single DROP command (Peter Eisentraut)
Support IF NOT EXISTS in CREATE SERVER, CREATE USER MAPPING, and CREATE COLLATION (Anastasia Lubennikova, Peter Eisentraut)
Make VACUUM VERBOSE report the number of skipped frozen pages and oldest xmin (Masahiko Sawada, Simon Riggs)
This information is also included in log_autovacuum_min_duration output.
", "text": "Make VACUUM VERBOSE report the number of skipped frozen pages and oldest xmin (Masahiko Sawada, Simon Riggs) This information is also included in log_autovacuum_min_duration output.", "title": "Make VACUUM VERBOSE report the number of skipped frozen pages and oldest xmin", "commits": [], "section": "Utility Commands", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.6", "source_hash": "b1ea7471c96e5f6232bc2311eb4db75d35067a3b942d2d84ba5b63c5681e7761", "section_path": ["Utility Commands"], "commit_groups": [["70adf2fbe"], ["9eb344faf"]], "identity_text": "Make VACUUM VERBOSE report the number of skipped frozen pages and oldest xmin (Masahiko Sawada, Simon Riggs) This information is also included in guc-log-autovacuum-min-duration output.", "commit_aliases": ["70adf2fbe", "9eb344faf"], "source_commits": ["70adf2fbe", "9eb344faf"], "source_entry_id": "10.0/changes/073", "db_id": "06bb1e20aacbb6d818a007b2e238284d", "patch_ids": ["4e6dc85dbe847037690024614bd18f5e", "fa12b6ce3cc4b131c8e5aa5d58041af3"], "statement_hash": "4d280537989bc498a717ed8629cac7b69a66f09cb2f874d2d554cc2b12edd270", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-7e9df1e2e4173796", "migration": false}, {"id": "10.0-3b2c870d73f1b073", "cves": [], "html": "Improve speed of VACUUM's removal of trailing empty heap pages (Claudio Freire, \u00c1lvaro Herrera)
Add full text search support for JSON and JSONB (Dmitry Dolgov)
The functions ts_headline() and to_tsvector() can now be used on these data types.
Add support for EUI-64 MAC addresses, as a new data type macaddr8 (Haribabu Kommi)
This complements the existing support for EUI-48 MAC addresses (type macaddr).
Add identity columns for assigning a numeric value to columns on insert (Peter Eisentraut)
\nThese are similar to SERIAL columns, but are SQL standard compliant.
Allow ENUM values to be renamed (Dagfinn Ilmari Manns\u00e5ker)
This uses the syntax ALTER TYPE ... RENAME VALUE.
Properly treat array pseudotypes (anyarray) as arrays in to_json() and to_jsonb() (Andrew Dunstan)
Previously columns declared as anyarray (particularly those in the pg_stats view) were converted to JSON strings rather than arrays.
Add operators for multiplication and division of money values with int8 values (Peter Eisentraut)
Previously such cases would result in converting the int8 values to float8 and then using the money-and-float8 operators. The new behavior avoids possible precision loss. But note that division of money by int8 now truncates the quotient, like other integer-division cases, while the previous behavior would have rounded.
Check for overflow in the money type's input function (Peter Eisentraut)
Add simplified regexp_match() function (Emre Hasegeli)
This is similar to regexp_matches(), but it only returns results from the first match so it does not need to return a set, making it easier to use for simple cases.
Add a version of jsonb's delete operator that takes an array of keys to delete (Magnus Hagander)
Make json_populate_record() and related functions process JSON arrays and objects recursively (Nikita Glukhov)
With this change, array-type fields in the destination SQL type are properly converted from JSON arrays, and composite-type fields are properly converted from JSON objects. Previously, such cases would fail because the text representation of the JSON value would be fed to array_in() or record_in(), and its syntax would not match what those input functions expect.
Add function txid_current_if_assigned() to return the current transaction ID or NULL if no transaction ID has been assigned (Craig Ringer)
This is different from txid_current(), which always returns a transaction ID, assigning one if necessary. Unlike that function, this function can be run on standby servers.
Add function txid_status() to check if a transaction was committed (Craig Ringer)
This is useful for checking after an abrupt disconnection whether your previous transaction committed and you just didn't receive the acknowledgment.
", "text": "Add function txid_status() to check if a transaction was committed (Craig Ringer) This is useful for checking after an abrupt disconnection whether your previous transaction committed and you just didn't receive the acknowledgment.", "title": "Add function txid_status() to check if a transaction was committed", "commits": [], "section": "Functions", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.8", "source_hash": "808f998fe4439e6fc32b2b1fa19efcae2ffa123bffd20035ddef84fe57f8cd50", "section_path": ["Functions"], "commit_groups": [["857ee8e39"]], "identity_text": "Add function txid_status() to check if a transaction was committed (Craig Ringer) This is useful for checking after an abrupt disconnection whether your previous transaction committed and you just didn't receive the acknowledgment.", "commit_aliases": ["857ee8e39"], "source_commits": ["857ee8e39"], "source_entry_id": "10.0/changes/086", "db_id": "477a94a6ca175b6c16700bc1804783e1", "patch_ids": ["b374ac2d878c2e229f57bc7657b64258"], "statement_hash": "1de8d31170590b09d6c56d048b4c21a1fae194759cab51553207593bf1581a8e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-fc6bd6094fc66a70", "migration": false}, {"id": "10.0-fc99974e624faff0", "cves": [], "html": "Allow make_date() to interpret negative years as BC years (\u00c1lvaro Herrera)
Make to_timestamp() and to_date() reject out-of-range input fields (Artur Zakirov)
For example, previously to_date('2009-06-40','YYYY-MM-DD') was accepted and returned 2009-07-10. It will now generate an error.
Allow PL/Python's cursor() and execute() functions to be called as methods of their plan-object arguments (Peter Eisentraut)
This allows a more object-oriented programming style.
", "text": "Allow PL/Python's cursor() and execute() functions to be called as methods of their plan-object arguments (Peter Eisentraut) This allows a more object-oriented programming style.", "title": "Allow PL/Python's cursor() and execute() functions to be called as methods of their plan-object arguments", "commits": [], "section": "Server-Side Languages", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.9", "source_hash": "96a10bcd6aef76eac1cc8b13e97ecf16a3b383559b0de01661700bf79043f524", "section_path": ["Server-Side Languages"], "commit_groups": [["70ec3f1f8"]], "identity_text": "Allow PL/Python's cursor() and execute() functions to be called as methods of their plan-object arguments (Peter Eisentraut) This allows a more object-oriented programming style.", "commit_aliases": ["70ec3f1f8"], "source_commits": ["70ec3f1f8"], "source_entry_id": "10.0/changes/089", "db_id": "58135d084852fb0c1dd15cd4aa09a548", "patch_ids": ["3e37e02ee1881d68673b87de2ce427b8"], "statement_hash": "b39c999ba70888c567dc2b3b8d9bd3fbd67b399ab9cf1a942d5f2de4fd788db0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-a2fca2b3171de451", "migration": false}, {"id": "10.0-8666bc4286dd8bd5", "cves": [], "html": "Allow PL/pgSQL's GET DIAGNOSTICS statement to retrieve values into array elements (Tom Lane)
Previously, a syntactic restriction prevented the target variable from being an array element.
", "text": "Allow PL/pgSQL's GET DIAGNOSTICS statement to retrieve values into array elements (Tom Lane) Previously, a syntactic restriction prevented the target variable from being an array element.", "title": "Allow PL/pgSQL's GET DIAGNOSTICS statement to retrieve values into array elements", "commits": [], "section": "Server-Side Languages", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.9", "source_hash": "12fbad3faeed716f5cd3c74564ef7ef262e43a3954fab844c8ad2e162e2ab04f", "section_path": ["Server-Side Languages"], "commit_groups": [["55caaaeba"]], "identity_text": "Allow PL/pgSQL's GET DIAGNOSTICS statement to retrieve values into array elements (Tom Lane) Previously, a syntactic restriction prevented the target variable from being an array element.", "commit_aliases": ["55caaaeba"], "source_commits": ["55caaaeba"], "source_entry_id": "10.0/changes/090", "db_id": "35fbe50c90084828d661bb4f787217b1", "patch_ids": ["44cd5b157d83444a0c7850640102fae5"], "statement_hash": "4a0ab6b13e2b35baaf9fdd740ad1effc58d177841e3eaf46510686cc09935be5", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-8666bc4286dd8bd5", "migration": false}, {"id": "10.0-0a1a154ca5643fd4", "cves": [], "html": "Allow PL/Tcl functions to return composite types and sets (Karl Lehenbauer)
", "text": "Allow PL/Tcl functions to return composite types and sets (Karl Lehenbauer)", "title": "Allow PL/Tcl functions to return composite types and sets", "commits": [], "section": "Server-Side Languages / PL/Tcl", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.9.3", "source_hash": "ad4dfdeeb70840259b5a093c797a83fa31673ab7b1e46f94dca7a579d16b770c", "section_path": ["Server-Side Languages", "PL/Tcl"], "commit_groups": [["26abb50c4"]], "identity_text": "Allow PL/Tcl functions to return composite types and sets (Karl Lehenbauer)", "commit_aliases": ["26abb50c4"], "source_commits": ["26abb50c4"], "source_entry_id": "10.0/changes/091", "db_id": "280edeefb0ba5757df7c827a62e02b0d", "patch_ids": ["674705dc636a83f2d35f9918ef3024e1"], "statement_hash": "53fc4d1f0453d79899465c25beeaa25ce59a61e6401c2cc67aeac24a71684c2f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-0a1a154ca5643fd4", "migration": false}, {"id": "10.0-d88b581a97e309eb", "cves": [], "html": "Add a subtransaction command to PL/Tcl (Victor Wagner)
\nThis allows PL/Tcl queries to fail without aborting the entire function.
", "text": "Add a subtransaction command to PL/Tcl (Victor Wagner) This allows PL/Tcl queries to fail without aborting the entire function.", "title": "Add a subtransaction command to PL/Tcl", "commits": [], "section": "Server-Side Languages / PL/Tcl", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.9.3", "source_hash": "fbd09adbfb3e50dc5e5a26af640dccebb10c00b34d1ee94700271fe3a0f3c317", "section_path": ["Server-Side Languages", "PL/Tcl"], "commit_groups": [["b58fd4a9c"]], "identity_text": "Add a subtransaction command to PL/Tcl (Victor Wagner) This allows PL/Tcl queries to fail without aborting the entire function.", "commit_aliases": ["b58fd4a9c"], "source_commits": ["b58fd4a9c"], "source_entry_id": "10.0/changes/092", "db_id": "76177936ef580652b687b5d63c73e420", "patch_ids": ["6dab0696fe279870ec6917f2900a44cc"], "statement_hash": "2b5ef0e903620c1830bc0e6fde6682e8c4aca8ab00fe6f204d0b0cffa4d5c003", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-d88b581a97e309eb", "migration": false}, {"id": "10.0-761c78646c6b9450", "cves": [], "html": "Add server parameters pltcl.start_proc and pltclu.start_proc, to allow initialization functions to be called on PL/Tcl startup (Tom Lane)
", "text": "Add server parameters pltcl.start_proc and pltclu.start_proc, to allow initialization functions to be called on PL/Tcl startup (Tom Lane)", "title": "Add server parameters pltcl.start_proc and pltclu.start_proc, to allow initialization functions to be called on PL/Tcl startup", "commits": [], "section": "Server-Side Languages / PL/Tcl", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.9.3", "source_hash": "001a5dfb792657346cae3b04c7793fc76149191c790d61f21cbfd2e3dc46cd23", "section_path": ["Server-Side Languages", "PL/Tcl"], "commit_groups": [["0d2b1f305"]], "identity_text": "Add server parameters guc-pltcl-start-proc and guc-pltclu-start-proc , to allow initialization functions to be called on PL/Tcl startup (Tom Lane)", "commit_aliases": ["0d2b1f305"], "source_commits": ["0d2b1f305"], "source_entry_id": "10.0/changes/093", "db_id": "7592546b9103c51fc56c17a96b5180a7", "patch_ids": ["2d0740e72abce0d9c5e27e820a4bf62f"], "statement_hash": "5376a9ae21cbabef4de5bf36a0003df048a47e7d8a63956912da672803bd3812", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-761c78646c6b9450", "migration": false}, {"id": "10.0-872ca094f594bc28", "cves": [], "html": "Allow specification of multiple host names or addresses in libpq connection strings and URIs (Robert Haas, Heikki Linnakangas)
\nlibpq will connect to the first responsive server in the list.
", "text": "Allow specification of multiple host names or addresses in libpq connection strings and URIs (Robert Haas, Heikki Linnakangas) libpq will connect to the first responsive server in the list.", "title": "Allow specification of multiple host names or addresses in libpq connection strings and URIs", "commits": [], "section": "Client Interfaces", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.10", "source_hash": "5381b6d8ae9cf33b033a3cc4709ad301fa44503e8ff313f9e200a0c5286462cc", "section_path": ["Client Interfaces"], "commit_groups": [["274bb2b38"], ["5f374fe7a"], ["7b02ba62e"]], "identity_text": "Allow specification of multiple host names or addresses in libpq connection strings and URIs (Robert Haas, Heikki Linnakangas) libpq will connect to the first responsive server in the list.", "commit_aliases": ["274bb2b38", "5f374fe7a", "7b02ba62e"], "source_commits": ["274bb2b38", "5f374fe7a", "7b02ba62e"], "source_entry_id": "10.0/changes/094", "db_id": "f0cfad9d6b023b56828152e6109e0dfd", "patch_ids": ["0f39c00541ebdba307e86fad1a0f103a", "22146dfce814af6cc4d29a4190b0311b", "2e1b2710142b284aca3f28eb56aae6fa"], "statement_hash": "92fbd2d150695af766463a146560cdcf1a54a898cc3ab38ea8d06d0310fe538a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-872ca094f594bc28", "migration": false}, {"id": "10.0-25d62c4e4b901ac4", "cves": [], "html": "Allow libpq connection strings and URIs to request a read/write host, that is a master server rather than a standby server (Victor Wagner, Mithun Cy)
\nThis is useful when multiple host names are specified. It is controlled by libpq connection parameter target_session_attrs.
Allow the password file name to be specified as a libpq connection parameter (Julian Markwort)
\nPreviously this could only be specified via an environment variable.
", "text": "Allow the password file name to be specified as a libpq connection parameter (Julian Markwort) Previously this could only be specified via an environment variable.", "title": "Allow the password file name to be specified as a libpq connection parameter", "commits": [], "section": "Client Interfaces", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.10", "source_hash": "2fb112dd9630466f24cbf72356b9ade0ab45f928f10261ef39de800fb012d65a", "section_path": ["Client Interfaces"], "commit_groups": [["ba005f193"]], "identity_text": "Allow the password file name to be specified as a libpq connection parameter (Julian Markwort) Previously this could only be specified via an environment variable.", "commit_aliases": ["ba005f193"], "source_commits": ["ba005f193"], "source_entry_id": "10.0/changes/096", "db_id": "82843dc8b5df5fd130a110b5f1f8c298", "patch_ids": ["f598f751a925a0636860bc484bc212c0"], "statement_hash": "2039978c7d1eceba2c08e5e1806af97fdad24475fa574f7df4d0248883cf80eb", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-5cf39a38ec9ad0aa", "migration": false}, {"id": "10.0-3aace77b2c08feb9", "cves": [], "html": "Add function PQencryptPasswordConn() to allow creation of more types of encrypted passwords on the client side (Michael Paquier, Heikki Linnakangas)
Previously only MD5-encrypted passwords could be created using PQencryptPassword(). This new function can also create SCRAM-SHA-256-encrypted passwords.
Change ecpg preprocessor version from 4.12 to 10 (Tom Lane)
\nHenceforth the ecpg version will match the PostgreSQL distribution version number.
", "text": "Change ecpg preprocessor version from 4.12 to 10 (Tom Lane) Henceforth the ecpg version will match the PostgreSQL distribution version number.", "title": "Change ecpg preprocessor version from 4.12 to 10", "commits": [], "section": "Client Interfaces", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.10", "source_hash": "1ffb82f2a04117c851785e6a96ed07f928ec5a2405172025126b61b6673e4ed2", "section_path": ["Client Interfaces"], "commit_groups": [["a7b5573d6"]], "identity_text": "Change ecpg preprocessor version from 4.12 to 10 (Tom Lane) Henceforth the ecpg version will match the PostgreSQL distribution version number.", "commit_aliases": ["a7b5573d6"], "source_commits": ["a7b5573d6"], "source_entry_id": "10.0/changes/098", "db_id": "22520ddb4a408a84ee50d183e1ed848c", "patch_ids": ["ffc13000a97a46ed8d71e8b79ce8c740"], "statement_hash": "4edb4d32c8ac4364b9ee4ff53c8716db23e51bec715763571aa61690b60992fa", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-ece1185bfce9e4f4", "migration": false}, {"id": "10.0-67647d3e4454a2e0", "cves": [], "html": "Add conditional branch support to psql (Corey Huinker)
\nThis feature adds psql meta-commands \\if, \\elif, \\else, and \\endif. This is primarily helpful for scripting.
Add psql \\gx meta-command to execute (\\g) a query in expanded mode (\\x) (Christoph Berg)
Expand psql variable references in backtick-executed strings (Tom Lane)
\nThis is particularly useful in the new psql conditional branch commands.
", "text": "Expand psql variable references in backtick-executed strings (Tom Lane) This is particularly useful in the new psql conditional branch commands.", "title": "Expand psql variable references in backtick-executed strings", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.11.2", "source_hash": "75f7f4b584ba3c32e351ba63630ab7ceed89ea9f32a32fc37f3f5508cce18571", "section_path": ["Client Applications", "psql"], "commit_groups": [["f833c847b"]], "identity_text": "Expand psql variable references in backtick-executed strings (Tom Lane) This is particularly useful in the new psql conditional branch commands.", "commit_aliases": ["f833c847b"], "source_commits": ["f833c847b"], "source_entry_id": "10.0/changes/101", "db_id": "7050da050390a40bdc76a2afd09beeda", "patch_ids": ["e96c3f12571ff11ca27635abed9db715"], "statement_hash": "fd7115a0bd0231e0499c77c0c3fee045860f9c5e5bc3dec57704029b466df3c9", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-9accc8431c866bd8", "migration": false}, {"id": "10.0-ef188cc04c8daaa4", "cves": [], "html": "Prevent psql's special variables from being set to invalid values (Daniel V\u00e9rit\u00e9, Tom Lane)
\nPreviously, setting one of psql's special variables to an invalid value silently resulted in the default behavior. \\set on a special variable now fails if the proposed new value is invalid. As a special exception, \\set with an empty or omitted new value, on a boolean-valued special variable, still has the effect of setting the variable to on; but now it actually acquires that value rather than an empty string. \\unset on a special variable now explicitly sets the variable to its default value, which is also the value it acquires at startup. In sum, a control variable now always has a displayable value that reflects what psql is actually doing.
Add variables showing server version and psql version (Fabien Coelho)
", "text": "Add variables showing server version and psql version (Fabien Coelho)", "title": "Add variables showing server version and psql version", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.11.2", "source_hash": "2819d63589fa4050b132635666a596f8a2e8739675aca4cdde86ac40f1a78ed9", "section_path": ["Client Applications", "psql"], "commit_groups": [["a6c678f01"]], "identity_text": "Add variables showing server version and psql version (Fabien Coelho)", "commit_aliases": ["a6c678f01"], "source_commits": ["a6c678f01"], "source_entry_id": "10.0/changes/103", "db_id": "c3cf73e37f3d8075709692908af98688", "patch_ids": ["4294581f372156f6a262adf5b4f303e2"], "statement_hash": "a05df29bf988b1704fc197f6aa6865518c29a6c7beb5a8e30a4ab3089d4260b3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-7eb11b51f27da188", "migration": false}, {"id": "10.0-ef743c515dbcb5c7", "cves": [], "html": "Improve psql's \\d (display relation) and \\dD (display domain) commands to show collation, nullable, and default properties in separate columns (Peter Eisentraut)
Previously they were shown in a single \u201cModifiers\u201d column.
", "text": "Improve psql's \\d (display relation) and \\dD (display domain) commands to show collation, nullable, and default properties in separate columns (Peter Eisentraut) Previously they were shown in a single \u201cModifiers\u201d column.", "title": "Improve psql's \\d (display relation) and \\dD (display domain) commands to show collation, nullable, and default properties in separate columns", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.11.2", "source_hash": "df52cbe887ae119ce898ca7470bed1b932bb23125e69a23703a54ce0d95fc27c", "section_path": ["Client Applications", "psql"], "commit_groups": [["a0f357e57"]], "identity_text": "Improve psql's \\d (display relation) and \\dD (display domain) commands to show collation, nullable, and default properties in separate columns (Peter Eisentraut) Previously they were shown in a single Modifiers column.", "commit_aliases": ["a0f357e57"], "source_commits": ["a0f357e57"], "source_entry_id": "10.0/changes/104", "db_id": "ca24a2f0cdfcfe7e05fa4094aa35d793", "patch_ids": ["206b86af913465c441e60b876f549638"], "statement_hash": "be2707582114fd1966dd9867510ef3dc52e7a015eb3b3497a8d00cf50162e65a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-ef743c515dbcb5c7", "migration": false}, {"id": "10.0-1689514b2e685cca", "cves": [], "html": "Make the various \\d commands handle no-matching-object cases more consistently (Daniel Gustafsson)
They now all print the message about that to stderr, not stdout, and the message wording is more consistent.
", "text": "Make the various \\d commands handle no-matching-object cases more consistently (Daniel Gustafsson) They now all print the message about that to stderr, not stdout, and the message wording is more consistent.", "title": "Make the various \\d commands handle no-matching-object cases more consistently", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.11.2", "source_hash": "cc94b1642b766ce9100bae8788bf9503ef904f883283ea435d6703240580b86e", "section_path": ["Client Applications", "psql"], "commit_groups": [["77cb4a1d6"]], "identity_text": "Make the various \\d commands handle no-matching-object cases more consistently (Daniel Gustafsson) They now all print the message about that to stderr, not stdout, and the message wording is more consistent.", "commit_aliases": ["77cb4a1d6"], "source_commits": ["77cb4a1d6"], "source_entry_id": "10.0/changes/105", "db_id": "6f6d96bb204d9b1e7c71de7f57faf67b", "patch_ids": ["21c70b2ca49b56329414a3fe6b4e25e6"], "statement_hash": "74f2bf56241d594bd95a4ddc7844c1d35ac19df89f6074bd012627196a9af8ab", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-1689514b2e685cca", "migration": false}, {"id": "10.0-23aba107d83f0874", "cves": [], "html": "Improve psql's tab completion (Jeff Janes, Ian Barwick, Andreas Karlsson, Sehrope Sarkuni, Thomas Munro, Kevin Grittner, Dagfinn Ilmari Manns\u00e5ker)
", "text": "Improve psql's tab completion (Jeff Janes, Ian Barwick, Andreas Karlsson, Sehrope Sarkuni, Thomas Munro, Kevin Grittner, Dagfinn Ilmari Manns\u00e5ker)", "title": "Improve psql's tab completion", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.11.2", "source_hash": "525aa0b58c6d1695d5cc433f1cb384447be4f252a383a1d01e5709eeb920497d", "section_path": ["Client Applications", "psql"], "commit_groups": [["1d15d0db5"], ["49917dbd7"], ["52803098a"], ["577f0bdd2"], ["63c1a8719"], ["76f9dd4fa"], ["8019b5a89"], ["927d7bb6b"], ["b5a388392"], ["d7d77f382"]], "identity_text": "Improve psql's tab completion (Jeff Janes, Ian Barwick, Andreas Karlsson, Sehrope Sarkuni, Thomas Munro, Kevin Grittner, Dagfinn Ilmari Manns\u00e5ker)", "commit_aliases": ["1d15d0db5", "49917dbd7", "52803098a", "577f0bdd2", "63c1a8719", "76f9dd4fa", "8019b5a89", "927d7bb6b", "b5a388392", "d7d77f382"], "source_commits": ["1d15d0db5", "49917dbd7", "52803098a", "577f0bdd2", "63c1a8719", "76f9dd4fa", "8019b5a89", "927d7bb6b", "b5a388392", "d7d77f382"], "source_entry_id": "10.0/changes/106", "db_id": "6ee37d397eabc368ebb0b09e8cb1f166", "patch_ids": ["0e121b8d81a535d14529070e6b41b177", "0e5f7f76a152e44c779cb7036f04f020", "331162ed3fe570da7f0808eb580a58a6", "340380993c3fcf96ebaa6ae992318a1e", "34ac2b5548e9e9c428564e3e3b0b272d", "4762323bc309231370bcbdbd09e68fde", "6232a07d514568cfb66cbb32c580056e", "a5706b65b7045c60565bec2d44b0a49f", "b6456e2dfd436086a0d350ef46af9190", "e51c1d96dbc630df624bdfa3bc731247"], "statement_hash": "791d1939e7986db4cb1357958ef4b62acb6416b859733cdf37ddae5763ab7e3e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-23aba107d83f0874", "migration": false}, {"id": "10.0-2dfdb64887b0b33e", "cves": [], "html": "Add pgbench option --log-prefix to control the log file prefix (Masahiko Sawada)
Allow pgbench's meta-commands to span multiple lines (Fabien Coelho)
\nA meta-command can now be continued onto the next line by writing backslash-return.
", "text": "Allow pgbench's meta-commands to span multiple lines (Fabien Coelho) A meta-command can now be continued onto the next line by writing backslash-return.", "title": "Allow pgbench's meta-commands to span multiple lines", "commits": [], "section": "Client Applications / pgbench", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.11.3", "source_hash": "d473edbbbc0e7e6831bd2d14ed4bcf4aae9f4b2ef398a8b29d27743aedffc9c0", "section_path": ["Client Applications", "pgbench"], "commit_groups": [["cdc2a7047"]], "identity_text": "Allow pgbench's meta-commands to span multiple lines (Fabien Coelho) A meta-command can now be continued onto the next line by writing backslash-return.", "commit_aliases": ["cdc2a7047"], "source_commits": ["cdc2a7047"], "source_entry_id": "10.0/changes/108", "db_id": "bf86efefbb208dcd720be1e49901ff2c", "patch_ids": ["7a2354b184227d94432b106e218dcc71"], "statement_hash": "2c4503907695aa4e64c87ff5646b95aa58ed79dc0b2dbf6bf8f3bb46f50cda34", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-4300da736bff67a1", "migration": false}, {"id": "10.0-c6535f0620e2ffd7", "cves": [], "html": "Remove restriction on placement of -M option relative to other command line options (Tom Lane)
Add pg_receivewal option -Z/--compress to specify compression (Michael Paquier)
Add pg_recvlogical option --endpos to specify the ending position (Craig Ringer)
This complements the existing --startpos option.
Rename initdb options --noclean and --nosync to be spelled --no-clean and --no-sync (Vik Fearing, Peter Eisentraut)
The old spellings are still supported.
", "text": "Rename initdb options --noclean and --nosync to be spelled --no-clean and --no-sync (Vik Fearing, Peter Eisentraut) The old spellings are still supported.", "title": "Rename initdb options --noclean and --nosync to be spelled --no-clean and --no-sync", "commits": [], "section": "Server Applications", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12", "source_hash": "bde3ed95c8705f9af0b30c806bbe3496958c91f814480880cc50230d16b314db", "section_path": ["Server Applications"], "commit_groups": [["5d58c07a4"]], "identity_text": "Rename initdb options --noclean and --nosync to be spelled --no-clean and --no-sync (Vik Fearing, Peter Eisentraut) The old spellings are still supported.", "commit_aliases": ["5d58c07a4"], "source_commits": ["5d58c07a4"], "source_entry_id": "10.0/changes/112", "db_id": "868a55e2f443f6af9edc06e059ca9690", "patch_ids": ["a2c1574f5af340dc2a70ae4549f08323"], "statement_hash": "794083b2dfac37eeff644171487cdcadbcc4682331e4cfaf4ca31a208c62fd4d", "relations": [{"rule": 2, "type": "related", "target": "4ad69074dd464ac52c051302ebdd3c2b", "evidence": {"same_day": true, "patch_ids": ["a2c1574f5af340dc2a70ae4549f08323"], "ambiguous_patch_ids": ["a2c1574f5af340dc2a70ae4549f08323"]}}], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-569bbb0893652a8c", "migration": false}, {"id": "10.0-9131cbfbe6bf6de6", "cves": [], "html": "Allow pg_restore to exclude schemas (Michael Banck)
\nThis adds a new -N/--exclude-schema option.
Add --no-blobs option to pg_dump (Guillaume Lelarge)
This suppresses dumping of large objects.
", "text": "Add --no-blobs option to pg_dump (Guillaume Lelarge) This suppresses dumping of large objects.", "title": "Add --no-blobs option to pg_dump", "commits": [], "section": "Server Applications / pg_dump, pg_dumpall, pg_restore", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.3", "source_hash": "62c8fe97098fc78802f7eb91c6fb9bfdf1c06ba1f2133fbd4f24761790df3f40", "section_path": ["Server Applications", "pg_dump, pg_dumpall, pg_restore"], "commit_groups": [["4fafa579b"]], "identity_text": "Add --no-blobs option to pg_dump (Guillaume Lelarge) This suppresses dumping of large objects.", "commit_aliases": ["4fafa579b"], "source_commits": ["4fafa579b"], "source_entry_id": "10.0/changes/114", "db_id": "8ffbf5d17d9e708010692004eeffdacf", "patch_ids": ["45862d068c4f8c27a6e040aeee8cf23a"], "statement_hash": "89b3ada14a986418d540edf452d7df1589aae4c3d3bb2110d117fa9d5dbe754d", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-d87a6d9ccffe9e5e", "migration": false}, {"id": "10.0-b3b3297e1b804590", "cves": [], "html": "Add pg_dumpall option --no-role-passwords to omit role passwords (Robins Tharakan, Simon Riggs)
This allows use of pg_dumpall by non-superusers; without this option, it fails due to inability to read passwords.
", "text": "Add pg_dumpall option --no-role-passwords to omit role passwords (Robins Tharakan, Simon Riggs) This allows use of pg_dumpall by non-superusers; without this option, it fails due to inability to read passwords.", "title": "Add pg_dumpall option --no-role-passwords to omit role passwords", "commits": [], "section": "Server Applications / pg_dump, pg_dumpall, pg_restore", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.3", "source_hash": "48353c876263d5a70815ecd9d5b826deeb30cd601cebe4806d795a696a989b6f", "section_path": ["Server Applications", "pg_dump, pg_dumpall, pg_restore"], "commit_groups": [["9a83d56b3"]], "identity_text": "Add pg_dumpall option --no-role-passwords to omit role passwords (Robins Tharakan, Simon Riggs) This allows use of pg_dumpall by non-superusers; without this option, it fails due to inability to read passwords.", "commit_aliases": ["9a83d56b3"], "source_commits": ["9a83d56b3"], "source_entry_id": "10.0/changes/115", "db_id": "5f16d6a4d62a5daf2ce9aef3cadc6f59", "patch_ids": ["080004d594782aa2bdf8e79b7c08485f"], "statement_hash": "94ae41a59c110bf7dae0dd152745a9a8a4ea0192fb98270d14de669c6f85e732", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-b3b3297e1b804590", "migration": false}, {"id": "10.0-09930da97562b51c", "cves": [], "html": "Support using synchronized snapshots when dumping from a standby server (Petr Jelinek)
", "text": "Support using synchronized snapshots when dumping from a standby server (Petr Jelinek)", "title": "Support using synchronized snapshots when dumping from a standby server", "commits": [], "section": "Server Applications / pg_dump, pg_dumpall, pg_restore", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.3", "source_hash": "66b841e732920a2657794d5c30b7d048de63d7b656ba957f0cf4c5858de2d103", "section_path": ["Server Applications", "pg_dump, pg_dumpall, pg_restore"], "commit_groups": [["e4892c681"]], "identity_text": "Support using synchronized snapshots when dumping from a standby server (Petr Jelinek)", "commit_aliases": ["e4892c681"], "source_commits": ["e4892c681"], "source_entry_id": "10.0/changes/116", "db_id": "415aaada42162af3fa1d324ef5086ea2", "patch_ids": ["11fb20f40bd006618bf7fe1cc60587f3"], "statement_hash": "e4481306e5454b76c5fbe3577967267d338abfdb6e5b29fd3a588dfc105b40d8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-09930da97562b51c", "migration": false}, {"id": "10.0-539f5f53e23ff5f0", "cves": [], "html": "Issue fsync() on the output files generated by pg_dump and pg_dumpall (Michael Paquier)
This provides more security that the output is safely stored on disk before the program exits. This can be disabled with the new --no-sync option.
Allow pg_basebackup to stream write-ahead log in tar mode (Magnus Hagander)
\nThe WAL will be stored in a separate tar file from the base backup.
", "text": "Allow pg_basebackup to stream write-ahead log in tar mode (Magnus Hagander) The WAL will be stored in a separate tar file from the base backup.", "title": "Allow pg_basebackup to stream write-ahead log in tar mode", "commits": [], "section": "Server Applications / pg_basebackup", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.4", "source_hash": "08f311cc73876b36b37922880dab333b8e2a5ba0a31854a9a46ee676c2fcba06", "section_path": ["Server Applications", "pg_basebackup"], "commit_groups": [["56c7d8d45"], ["ecbdc4c55"]], "identity_text": "Allow pg_basebackup to stream write-ahead log in tar mode (Magnus Hagander) The WAL will be stored in a separate tar file from the base backup.", "commit_aliases": ["56c7d8d45", "ecbdc4c55"], "source_commits": ["56c7d8d45", "ecbdc4c55"], "source_entry_id": "10.0/changes/118", "db_id": "068ce7d3e14ee47277e98ba3c8bca1bd", "patch_ids": ["09128c9bb92b3811b528991cfb739340", "be16d4967abf16ae65411ee4b8e4235f"], "statement_hash": "0389786c4106a88a62885cdbdb84649abc1f4723072dfe2a98a2d908b42aca65", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-69d3ff2152986c7c", "migration": false}, {"id": "10.0-00a927653cabdc9e", "cves": [], "html": "Make pg_basebackup use temporary replication slots (Magnus Hagander)
\nTemporary replication slots will be used by default when pg_basebackup uses WAL streaming with default options.
", "text": "Make pg_basebackup use temporary replication slots (Magnus Hagander) Temporary replication slots will be used by default when pg_basebackup uses WAL streaming with default options.", "title": "Make pg_basebackup use temporary replication slots", "commits": [], "section": "Server Applications / pg_basebackup", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.4", "source_hash": "7665a26f237404b63ae8632a3727d2a819745f60ff506319195f6ad760797258", "section_path": ["Server Applications", "pg_basebackup"], "commit_groups": [["e7b020f78"]], "identity_text": "Make pg_basebackup use temporary replication slots (Magnus Hagander) Temporary replication slots will be used by default when pg_basebackup uses WAL streaming with default options.", "commit_aliases": ["e7b020f78"], "source_commits": ["e7b020f78"], "source_entry_id": "10.0/changes/119", "db_id": "096f05b90d00b9e6a118543b233314dd", "patch_ids": ["7952ff6ebb7748dac3db57278d343e04"], "statement_hash": "ffe4a665ed964b018e716037b7eadb5f854b261164a832d4d8dd22eca3e9b7e8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-00a927653cabdc9e", "migration": false}, {"id": "10.0-5191c75bed2b802f", "cves": [], "html": "Be more careful about fsync'ing in all required places in pg_basebackup and pg_receivewal (Michael Paquier)
", "text": "Be more careful about fsync'ing in all required places in pg_basebackup and pg_receivewal (Michael Paquier)", "title": "Be more careful about fsync'ing in all required places in pg_basebackup and pg_receivewal", "commits": [], "section": "Server Applications / pg_basebackup", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.4", "source_hash": "5285949aef2d37906d9c16c92f8c0b0b847acf45ec61fe86ff0ea20ca2a6eda9", "section_path": ["Server Applications", "pg_basebackup"], "commit_groups": [["bc34223bc"]], "identity_text": "Be more careful about fsync'ing in all required places in pg_basebackup and pg_receivewal (Michael Paquier)", "commit_aliases": ["bc34223bc"], "source_commits": ["bc34223bc"], "source_entry_id": "10.0/changes/120", "db_id": "d4dabba52a8865453f7ffc5c7f1029c8", "patch_ids": ["a9a2e9d96d5ab087630c3a7028c10677"], "statement_hash": "10b2e565743dbed23502fac010fa66f56c0a204a6bcaea593c7f5e756156ff8a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-5191c75bed2b802f", "migration": false}, {"id": "10.0-d56d2255111972dc", "cves": [], "html": "Add pg_basebackup option --no-sync to disable fsync (Michael Paquier)
Improve pg_basebackup's handling of which directories to skip (David Steele)
", "text": "Improve pg_basebackup's handling of which directories to skip (David Steele)", "title": "Improve pg_basebackup's handling of which directories to skip", "commits": [], "section": "Server Applications / pg_basebackup", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.4", "source_hash": "3744c5d89754bf98c108a7ef2c8ba97c658d9ce198307c89c0a23245a9c0e82b", "section_path": ["Server Applications", "pg_basebackup"], "commit_groups": [["6ad8ac602"]], "identity_text": "Improve pg_basebackup's handling of which directories to skip (David Steele)", "commit_aliases": ["6ad8ac602"], "source_commits": ["6ad8ac602"], "source_entry_id": "10.0/changes/122", "db_id": "fed8b500772af072be5e155f25b8850e", "patch_ids": ["dd8ac1636099e837ba76fdde10904929"], "statement_hash": "b1cbcaee39c8da9c292cc411f63e5922da52c3fabe8fbc64037881b57246fb57", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-88bb68fc0ea74648", "migration": false}, {"id": "10.0-1874f9198e97ccc6", "cves": [], "html": "Add wait option for pg_ctl's promote operation (Peter Eisentraut)
", "text": "Add wait option for pg_ctl's promote operation (Peter Eisentraut)", "title": "Add wait option for pg_ctl's promote operation", "commits": [], "section": "Server Applications / pg_ctl", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.5", "source_hash": "027072e0029bbb130abc07a9b075e3bcd2ba2ec377b29efad265f6e5a35c6696", "section_path": ["Server Applications", "pg_ctl"], "commit_groups": [["e7010ce47"]], "identity_text": "Add wait option for app-pg-ctl 's promote operation (Peter Eisentraut)", "commit_aliases": ["e7010ce47"], "source_commits": ["e7010ce47"], "source_entry_id": "10.0/changes/123", "db_id": "99bc3c69e5dcc6b3a96a9080fa9b8d54", "patch_ids": ["f6f84a22680a103513d861cf101e98fb"], "statement_hash": "ddad51c4ecd7649eaf652ff02aa4abbce203ee38f025f3575243b145a03d2b1d", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-1874f9198e97ccc6", "migration": false}, {"id": "10.0-8b3e6b8330910c71", "cves": [], "html": "Add long options for pg_ctl wait (--wait) and no-wait (--no-wait) (Vik Fearing)
Add long option for pg_ctl server options (--options) (Peter Eisentraut)
Make pg_ctl start --wait detect server-ready by watching postmaster.pid, not by attempting connections (Tom Lane)
The postmaster has been changed to report its ready-for-connections status in postmaster.pid, and pg_ctl now examines that file to detect whether startup is complete. This is more efficient and reliable than the old method, and it eliminates postmaster log entries about rejected connection attempts during startup.
Reduce pg_ctl's reaction time when waiting for postmaster start/stop (Tom Lane)
\npg_ctl now probes ten times per second when waiting for a postmaster state change, rather than once per second.
", "text": "Reduce pg_ctl's reaction time when waiting for postmaster start/stop (Tom Lane) pg_ctl now probes ten times per second when waiting for a postmaster state change, rather than once per second.", "title": "Reduce pg_ctl's reaction time when waiting for postmaster start/stop", "commits": [], "section": "Server Applications / pg_ctl", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.12.5", "source_hash": "4a452c1a2150dc8bda52a718a910c0595218b2b5c1e5211cfbb0e1bfd208b7ff", "section_path": ["Server Applications", "pg_ctl"], "commit_groups": [["c61559ec3"]], "identity_text": "Reduce pg_ctl's reaction time when waiting for postmaster start/stop (Tom Lane) pg_ctl now probes ten times per second when waiting for a postmaster state change, rather than once per second.", "commit_aliases": ["c61559ec3"], "source_commits": ["c61559ec3"], "source_entry_id": "10.0/changes/127", "db_id": "38c8aa92014a6d8ebb19c6668d68f4bf", "patch_ids": ["bb1c248c14114377a8c6225ae9b51c24"], "statement_hash": "f6ef2435472e7cdf8a55aae893b27ce65726ebf22b15551a55e0b5cc35958e2f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-86ee150eb5a208f9", "migration": false}, {"id": "10.0-ae75dec2a1aefd0c", "cves": [], "html": "Ensure that pg_ctl exits with nonzero status if an operation being waited for does not complete within the timeout (Peter Eisentraut)
\nThe start and promote operations now return exit status 1, not 0, in such cases. The stop operation has always done that.
Change to two-part release version numbering (Peter Eisentraut, Tom Lane)
\nRelease numbers will now have two parts (e.g., 10.1) rather than three (e.g., 9.6.3). Major versions will now increase just the first number, and minor releases will increase just the second number. Release branches will be referred to by single numbers (e.g., 10 rather than 9.6). This change is intended to reduce user confusion about what is a major or minor release of PostgreSQL.
Improve behavior of pgindent (Piotr Stefaniak, Tom Lane)
\nWe have switched to a new version of pg_bsd_indent based on recent improvements made by the FreeBSD project. This fixes numerous small bugs that led to odd C code formatting decisions. Most notably, lines within parentheses (such as in a multi-line function call) are now uniformly indented to match the opening paren, even if that would result in code extending past the right margin.
", "text": "Improve behavior of pgindent (Piotr Stefaniak, Tom Lane) We have switched to a new version of pg_bsd_indent based on recent improvements made by the FreeBSD project. This fixes numerous small bugs that led to odd C code formatting decisions. Most notably, lines within parentheses (such as in a multi-line function call) are now uniformly indented to match the opening paren, even if that would result in code extending past the right margin.", "title": "Improve behavior of pgindent", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "40627313a88d5ed5b95f09a082467c9ca0fee81ab33df6729ff6f45ecc4101bb", "section_path": ["Source Code"], "commit_groups": [["382ceffdf"], ["81f056c72"], ["8ff6d4ec7"], ["c7b8998eb"], ["cea258b63"], ["e3860ffa4"]], "identity_text": "Improve behavior of pgindent (Piotr Stefaniak, Tom Lane) We have switched to a new version of pg_bsd_indent based on recent improvements made by the FreeBSD project. This fixes numerous small bugs that led to odd C code formatting decisions. Most notably, lines within parentheses (such as in a multi-line function call) are now uniformly indented to match the opening paren, even if that would result in code extending past the right margin.", "commit_aliases": ["382ceffdf", "81f056c72", "8ff6d4ec7", "c7b8998eb", "cea258b63", "e3860ffa4"], "source_commits": ["382ceffdf", "81f056c72", "8ff6d4ec7", "c7b8998eb", "cea258b63", "e3860ffa4"], "source_entry_id": "10.0/changes/130", "db_id": "10fe19946356161a27bd03dc15ffd7e9", "patch_ids": ["2100606ce8fbac772f0eafeb188fde5b", "7950068523801c6e32ac24e8df4bc369", "9410b07d903a833d0e1f168555108266", "a8b7b250a6cb7515596de23ce1052812", "aae3693b5aa518b67b8d4c393607c3b5", "b5fe90ec88e01f9ca9c6b60cc558d7ab"], "statement_hash": "bc18a95d0763bb980b3202488b0040051aec1f3d2a94deccc75d4d2bda69423a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-305d50d4cd3e7b50", "migration": false}, {"id": "10.0-70266bf9f9dc1b7a", "cves": [], "html": "Allow the ICU library to optionally be used for collation support (Peter Eisentraut)
\nThe ICU library has versioning that allows detection of collation changes between versions. It is enabled via configure option --with-icu. The default still uses the operating system's native collation library.
Automatically mark all PG_FUNCTION_INFO_V1 functions as DLLEXPORT-ed on Windows (Laurenz Albe)
If third-party code is using extern function declarations, they should also add DLLEXPORT markers to those declarations.
Remove SPI functions SPI_push(), SPI_pop(), SPI_push_conditional(), SPI_pop_conditional(), and SPI_restore_connection() as unnecessary (Tom Lane)
Their functionality now happens automatically. There are now no-op macros by these names so that external modules don't need to be updated immediately, but eventually such calls should be removed.
\nA side effect of this change is that SPI_palloc() and allied functions now require an active SPI connection; they do not degenerate to simple palloc() if there is none. That previous behavior was not very useful and posed risks of unexpected memory leaks.
Allow shared memory to be dynamically allocated (Thomas Munro, Robert Haas)
", "text": "Allow shared memory to be dynamically allocated (Thomas Munro, Robert Haas)", "title": "Allow shared memory to be dynamically allocated", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "37292afe6ed3e499a9b7a659c505aeb66d3ab4b31d387204861e1b15a82bfcde", "section_path": ["Source Code"], "commit_groups": [["13df76a53"], ["13e14a78e"], ["e13029a5c"]], "identity_text": "Allow shared memory to be dynamically allocated (Thomas Munro, Robert Haas)", "commit_aliases": ["13df76a53", "13e14a78e", "e13029a5c"], "source_commits": ["13df76a53", "13e14a78e", "e13029a5c"], "source_entry_id": "10.0/changes/134", "db_id": "f1093432d52d470a69d6c0184595db8e", "patch_ids": ["2867c74a4fa5d04d48f0c4eeb23ad648", "4af035a182d046ee68ba3a54f58ee482", "a1538b1c7a0355a25388cd16011c7cc0"], "statement_hash": "c04f5f366d884f0dea17f559a7bfdda940d9e0e39dd0ed76015977eb059734cc", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-f645387aab703faf", "migration": false}, {"id": "10.0-99108b99884fd3b1", "cves": [], "html": "Add slab-like memory allocator for efficient fixed-size allocations (Tomas Vondra)
", "text": "Add slab-like memory allocator for efficient fixed-size allocations (Tomas Vondra)", "title": "Add slab-like memory allocator for efficient fixed-size allocations", "commits": [], "section": "Source Code", "category": "bugfix", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "bb0499f8ae416fb592ce3fdf92dcd2eab2ddc67cdc0937d8be326a6af9c5a574", "section_path": ["Source Code"], "commit_groups": [["58b25e981"]], "identity_text": "Add slab-like memory allocator for efficient fixed-size allocations (Tomas Vondra)", "commit_aliases": ["58b25e981"], "source_commits": ["58b25e981"], "source_entry_id": "10.0/changes/135", "db_id": "561b204bb681ade504e9679abb0868c7", "patch_ids": ["bcdbd738bf1aa07396379a70dd520cf1"], "statement_hash": "0cb8cdd20f35334707b1e570af3cf5e3ed21e2d27ee5018c3763f85c22c27fd0", "relations": [], "category_label": "Bug fixes", "url": "/docs/compare/?release=10.0#10.0-99108b99884fd3b1", "migration": false}, {"id": "10.0-f46ff384ace4fd96", "cves": [], "html": "Use POSIX semaphores rather than SysV semaphores on Linux and FreeBSD (Tom Lane)
\nThis avoids platform-specific limits on SysV semaphore usage.
", "text": "Use POSIX semaphores rather than SysV semaphores on Linux and FreeBSD (Tom Lane) This avoids platform-specific limits on SysV semaphore usage.", "title": "Use POSIX semaphores rather than SysV semaphores on Linux and FreeBSD", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "e34c8e0a8a69ccc49e2e60df049b7ed66bb220f3406109efc90a638a0628c3d8", "section_path": ["Source Code"], "commit_groups": [["ecb0d20a9"]], "identity_text": "Use POSIX semaphores rather than SysV semaphores on Linux and FreeBSD (Tom Lane) This avoids platform-specific limits on SysV semaphore usage.", "commit_aliases": ["ecb0d20a9"], "source_commits": ["ecb0d20a9"], "source_entry_id": "10.0/changes/136", "db_id": "67fd4c492be6e737138108d89e9cba10", "patch_ids": ["084bfaee3b45fabfcf3fb0abaf6cb0e4"], "statement_hash": "b53df938ff467af421c9300e5da3d647a23a201e7cc1ac9dd83c40715297ec7d", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-f46ff384ace4fd96", "migration": false}, {"id": "10.0-8fe301f206036912", "cves": [], "html": "Improve support for 64-bit atomics (Andres Freund)
", "text": "Improve support for 64-bit atomics (Andres Freund)", "title": "Improve support for 64-bit atomics", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "3240ae2ea8533db8bf6f77b07edb4b747cb5bbb51342da7a9ae343b6f9f7e9d2", "section_path": ["Source Code"], "commit_groups": [["e8fdbd58f"]], "identity_text": "Improve support for 64-bit atomics (Andres Freund)", "commit_aliases": ["e8fdbd58f"], "source_commits": ["e8fdbd58f"], "source_entry_id": "10.0/changes/137", "db_id": "7c1b4cb45ea942a84122ba9550fbe64d", "patch_ids": ["1548b9df0487121e828e40bbda43a7df"], "statement_hash": "aaca75bf86bdf362e87feb59eaade633c1d091a8237a78b1a4c32da1fbece78c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-8fe301f206036912", "migration": false}, {"id": "10.0-8d32b3e80638fe0f", "cves": [], "html": "Enable 64-bit atomic operations on ARM64 (Roman Shaposhnik)
", "text": "Enable 64-bit atomic operations on ARM64 (Roman Shaposhnik)", "title": "Enable 64-bit atomic operations on ARM64", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "d82ef6613f9e6ef56696cc891f89d1b92334ced12da17e7a27649aec0def32c3", "section_path": ["Source Code"], "commit_groups": [["f8f1430ae"]], "identity_text": "Enable 64-bit atomic operations on ARM64 (Roman Shaposhnik)", "commit_aliases": ["f8f1430ae"], "source_commits": ["f8f1430ae"], "source_entry_id": "10.0/changes/138", "db_id": "39abd24526ba3d7fd3bbeffff1f3a35a", "patch_ids": ["87daa13e597655a77010780d812d1fb0"], "statement_hash": "b010b645b43e9cbb3a35ee98baa37ccfefb67aa72e3b76c12a1ae36b1bbb2c9c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-8d32b3e80638fe0f", "migration": false}, {"id": "10.0-9024cb6f1c30fe70", "cves": [], "html": "Switch to using clock_gettime(), if available, for duration measurements (Tom Lane)
gettimeofday() is still used if clock_gettime() is not available.
Add more robust random number generators to be used for cryptographically secure uses (Magnus Hagander, Michael Paquier, Heikki Linnakangas)
\nIf no strong random number generator can be found, configure will fail unless the --disable-strong-random option is used. However, with this option, pgcrypto functions requiring a strong random number generator will be disabled.
Allow WaitLatchOrSocket() to wait for socket connection on Windows (Andres Freund)
tupconvert.c functions no longer convert tuples just to embed a different composite-type OID in them (Ashutosh Bapat, Tom Lane)
The majority of callers don't care about the composite-type OID; but if the result tuple is to be used as a composite Datum, steps should be taken to make sure the correct OID is inserted in it.
", "text": "tupconvert.c functions no longer convert tuples just to embed a different composite-type OID in them (Ashutosh Bapat, Tom Lane) The majority of callers don't care about the composite-type OID; but if the result tuple is to be used as a composite Datum, steps should be taken to make sure the correct OID is inserted in it.", "title": "tupconvert.c functions no longer convert tuples just to embed a different composite-type OID in them", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "46851bae694966ab8c64b9854def6e46d6319c192c0289347da566dd3fb55401", "section_path": ["Source Code"], "commit_groups": [["3f902354b"]], "identity_text": "tupconvert.c functions no longer convert tuples just to embed a different composite-type OID in them (Ashutosh Bapat, Tom Lane) The majority of callers don't care about the composite-type OID; but if the result tuple is to be used as a composite Datum, steps should be taken to make sure the correct OID is inserted in it.", "commit_aliases": ["3f902354b"], "source_commits": ["3f902354b"], "source_entry_id": "10.0/changes/142", "db_id": "c9ee644935bd1464b6c4973c22fe5c6c", "patch_ids": ["4c11e8b1f650a039dbd1c16000158818"], "statement_hash": "d3a71f777e28aa98349a8349f7d2d901289e5bffaa30421cbba4ee807cb00286", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-da7ef65f8669ab75", "migration": false}, {"id": "10.0-6b5ee5f03aeff306", "cves": [], "html": "Remove SCO and Unixware ports (Tom Lane)
", "text": "Remove SCO and Unixware ports (Tom Lane)", "title": "Remove SCO and Unixware ports", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "de7f509d9d384822b70664639559d361836281d9296afeeaefd255285cbf6ce6", "section_path": ["Source Code"], "commit_groups": [["2b860f52e"]], "identity_text": "Remove SCO and Unixware ports (Tom Lane)", "commit_aliases": ["2b860f52e"], "source_commits": ["2b860f52e"], "source_entry_id": "10.0/changes/143", "db_id": "8ad0076f205b24c51796e5c92c35e05d", "patch_ids": ["49a683eac2eba8fd00ddd7523db71532"], "statement_hash": "5e31a79465f3cfddd710fbba88532425f4606ab9bfd9157806eea0f7529b5ddb", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-6b5ee5f03aeff306", "migration": false}, {"id": "10.0-afd7931ee345d72c", "cves": [], "html": "Overhaul documentation build process (Alexander Lakhin)
", "text": "Overhaul documentation build process (Alexander Lakhin)", "title": "Overhaul documentation build process", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "57725a71ef861d0e76430bce113e09cbd3d9fdb516997a83969599146d0399e6", "section_path": ["Source Code"], "commit_groups": [["0e4cc1fc5"], ["e8306745e"]], "identity_text": "Overhaul documentation build process (Alexander Lakhin)", "commit_aliases": ["0e4cc1fc5", "e8306745e"], "source_commits": ["0e4cc1fc5", "e8306745e"], "source_entry_id": "10.0/changes/144", "db_id": "bb11ece57c7964a6737dbe2822911d61", "patch_ids": ["57208305002469e2c54b3577a205dd32", "92bf289c2140166aa84092becb21b71a"], "statement_hash": "d1353f9fc3a27b80f038964572801d35ec41740dca2d9b1b861193a97cb16064", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-afd7931ee345d72c", "migration": false}, {"id": "10.0-315549a099c1f82e", "cves": [], "html": "Use XSLT to build the PostgreSQL documentation (Peter Eisentraut)
\nPreviously Jade, DSSSL, and JadeTex were used.
", "text": "Use XSLT to build the PostgreSQL documentation (Peter Eisentraut) Previously Jade, DSSSL, and JadeTex were used.", "title": "Use XSLT to build the PostgreSQL documentation", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "9b3923cb02ce04cdbdbef8238fefd79a2fa4b5642dafc6e83d8ea82bbc1382de", "section_path": ["Source Code"], "commit_groups": [["510074f9f"]], "identity_text": "Use XSLT to build the PostgreSQL documentation (Peter Eisentraut) Previously Jade, DSSSL, and JadeTex were used.", "commit_aliases": ["510074f9f"], "source_commits": ["510074f9f"], "source_entry_id": "10.0/changes/145", "db_id": "cfdb2a0ed737fbc3af05dce9249de39c", "patch_ids": ["d059a2cbf581790dfe6072df82c3a8ce"], "statement_hash": "4301cc4736c1b61c1ef6718a14cc95a976041903c30e3cf4cec7029d1407f2d0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-315549a099c1f82e", "migration": false}, {"id": "10.0-a6b45f157efe5332", "cves": [], "html": "Build HTML documentation using XSLT stylesheets by default (Peter Eisentraut)
", "text": "Build HTML documentation using XSLT stylesheets by default (Peter Eisentraut)", "title": "Build HTML documentation using XSLT stylesheets by default", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.13", "source_hash": "5db4e6d685bd4098231626900fcbd6bc442857be18700a7638ddd7e810230ca5", "section_path": ["Source Code"], "commit_groups": [["e36ddab11"]], "identity_text": "Build HTML documentation using XSLT stylesheets by default (Peter Eisentraut)", "commit_aliases": ["e36ddab11"], "source_commits": ["e36ddab11"], "source_entry_id": "10.0/changes/146", "db_id": "c48548e792e12c508f7c69e1151b5050", "patch_ids": ["e05797f86eeb201a5debde062b28fd66"], "statement_hash": "365046a831659dfc8ac03174346fa56a10499a03666e57bda12bdbd703d19176", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-a6b45f157efe5332", "migration": false}, {"id": "10.0-5cb4ca4ccea075b4", "cves": [], "html": "Allow file_fdw to read from program output as well as files (Corey Huinker, Adam Gomaa)
", "text": "Allow file_fdw to read from program output as well as files (Corey Huinker, Adam Gomaa)", "title": "Allow file_fdw to read from program output as well as files", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "1905cd86ce88ef40eae0a2661e191ea570c4d2791bfb9b67ce2041a6a17f4e7a", "section_path": ["Additional Modules"], "commit_groups": [["8e91e12bc"]], "identity_text": "Allow file_fdw to read from program output as well as files (Corey Huinker, Adam Gomaa)", "commit_aliases": ["8e91e12bc"], "source_commits": ["8e91e12bc"], "source_entry_id": "10.0/changes/147", "db_id": "15d18069ea633b397d4df770f4532e00", "patch_ids": ["52e44c8bcf6c6bc442e93a3cf4d716d3"], "statement_hash": "bd6502caea4c6328e14909aa97158a944b7e4b2c5f0e01f60fced6ded4e38c8e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-5cb4ca4ccea075b4", "migration": false}, {"id": "10.0-099c17751c54ab28", "cves": [], "html": "In postgres_fdw, push aggregate functions to the remote server, when possible (Jeevan Chalke, Ashutosh Bapat)
\nThis reduces the amount of data that must be passed from the remote server, and offloads aggregate computation from the requesting server.
", "text": "In postgres_fdw, push aggregate functions to the remote server, when possible (Jeevan Chalke, Ashutosh Bapat) This reduces the amount of data that must be passed from the remote server, and offloads aggregate computation from the requesting server.", "title": "In postgres_fdw, push aggregate functions to the remote server, when possible", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "1624bfd6730ef0844987ce6ea96233017480c47dc58d8548848736334f3c865f", "section_path": ["Additional Modules"], "commit_groups": [["7012b132d"]], "identity_text": "In postgres_fdw, push aggregate functions to the remote server, when possible (Jeevan Chalke, Ashutosh Bapat) This reduces the amount of data that must be passed from the remote server, and offloads aggregate computation from the requesting server.", "commit_aliases": ["7012b132d"], "source_commits": ["7012b132d"], "source_entry_id": "10.0/changes/148", "db_id": "c7445fdf368503e63d5735c24970e6ca", "patch_ids": ["78d1e323d4a11dcac96aa3de56fdc16b"], "statement_hash": "f5c8125e67109d418b0abfe977124bafffb121be4691f9e89e5b7dd4c4d99734", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-099c17751c54ab28", "migration": false}, {"id": "10.0-48030a082bfac19f", "cves": [], "html": "In postgres_fdw, push joins to the remote server in more cases (David Rowley, Ashutosh Bapat, Etsuro Fujita)
", "text": "In postgres_fdw, push joins to the remote server in more cases (David Rowley, Ashutosh Bapat, Etsuro Fujita)", "title": "In postgres_fdw, push joins to the remote server in more cases", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "7dab5c745436fb0745c9b880536efb10a2a3283fb07fe7bd25c5dbb7cf7685d3", "section_path": ["Additional Modules"], "commit_groups": [["332bec1e6", "86e640a69"], ["b30fb56b0"]], "identity_text": "In postgres_fdw, push joins to the remote server in more cases (David Rowley, Ashutosh Bapat, Etsuro Fujita)", "commit_aliases": ["332bec1e6", "86e640a69", "b30fb56b0"], "source_commits": ["332bec1e6", "b30fb56b0"], "source_entry_id": "10.0/changes/149", "db_id": "1d7034dc922b3a8fd90e30724c91151d", "patch_ids": ["23a98917619479129e61580372563863", "5fcdc899bd07d93e4195463e31689714"], "statement_hash": "ffcae5e7f6503e4cfb49bcb1add8a4fb3a3605b362a5b8eff859479926a04340", "relations": [{"rule": 2, "type": "related", "target": "a43973256957179239a0c08258d4eebd", "evidence": {"same_day": false, "patch_ids": ["23a98917619479129e61580372563863"]}}], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-48030a082bfac19f", "migration": false}, {"id": "10.0-5ffaa8df03d25f0a", "cves": [], "html": "Properly support OID columns in postgres_fdw tables (Etsuro Fujita)
Previously OID columns always returned zeros.
Allow btree_gist and btree_gin to index enum types (Andrew Dunstan)
\nThis allows enums to be used in exclusion constraints.
", "text": "Allow btree_gist and btree_gin to index enum types (Andrew Dunstan) This allows enums to be used in exclusion constraints.", "title": "Allow btree_gist and btree_gin to index enum types", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "531faee6748551214152051a2923a84389ea84e88de15ae1c498245b0e0e9495", "section_path": ["Additional Modules"], "commit_groups": [["f7946a92b"]], "identity_text": "Allow btree_gist and btree_gin to index enum types (Andrew Dunstan) This allows enums to be used in exclusion constraints.", "commit_aliases": ["f7946a92b"], "source_commits": ["f7946a92b"], "source_entry_id": "10.0/changes/151", "db_id": "a89b74fcdf31b1e59c99ea89ccd55c9b", "patch_ids": ["cd6b6d01da41d48612f8236424ce72f8"], "statement_hash": "d95978f3bdc857784360087f3c6960ff46fb3fd08caab20ae4dcf4e072f58d5a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-0dce72c1dc0ec9c4", "migration": false}, {"id": "10.0-c177794ead002c56", "cves": [], "html": "Add indexing support to btree_gist for the UUID data type (Paul Jungwirth)
Add amcheck which can check the validity of B-tree indexes (Peter Geoghegan)
", "text": "Add amcheck which can check the validity of B-tree indexes (Peter Geoghegan)", "title": "Add amcheck which can check the validity of B-tree indexes", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "7d922f8e1e290d16f22b1f297775b957d56e755ac219ad6891ebf17f16470755", "section_path": ["Additional Modules"], "commit_groups": [["3717dc149"]], "identity_text": "Add amcheck which can check the validity of B-tree indexes (Peter Geoghegan)", "commit_aliases": ["3717dc149"], "source_commits": ["3717dc149"], "source_entry_id": "10.0/changes/153", "db_id": "bd7217b53f67466a2680eb0f548b96ee", "patch_ids": ["754b9fc6d5a9b6c809ac06d84dd4da8a"], "statement_hash": "97989afc640ed19f4ee16a16f5f04ca86eddf2a7d75ccfc81d35aaf3cbef1300", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-1c232e344759a75d", "migration": false}, {"id": "10.0-226d1daa16f85c27", "cves": [], "html": "Show ignored constants as $N rather than ? in pg_stat_statements (Lukas Fittl)
Improve cube's handling of zero-dimensional cubes (Tom Lane)
\nThis also improves handling of infinite and NaN values.
Allow pg_buffercache to run with fewer locks (Ivan Kartyshov)
\nThis makes it less disruptive when run on production systems.
", "text": "Allow pg_buffercache to run with fewer locks (Ivan Kartyshov) This makes it less disruptive when run on production systems.", "title": "Allow pg_buffercache to run with fewer locks", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "add8df49b44b7fd981200e9472a36de2eebebbb0a10fb05ef392f833ba4c55de", "section_path": ["Additional Modules"], "commit_groups": [["6e654546f"]], "identity_text": "Allow pg_buffercache to run with fewer locks (Ivan Kartyshov) This makes it less disruptive when run on production systems.", "commit_aliases": ["6e654546f"], "source_commits": ["6e654546f"], "source_entry_id": "10.0/changes/156", "db_id": "0c07a3cbd638c9c4281b7b7348ae5534", "patch_ids": ["9ec97e8e42df4414d3f7a5c92cf8ec53"], "statement_hash": "fbafdd00feb69a7abdb5a55431d95cdc3253f5b705ef7e04396098cfd642a59a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-afd5b965e389c57e", "migration": false}, {"id": "10.0-80e732230a638f6f", "cves": [], "html": "Add pgstattuple function pgstathashindex() to view hash index statistics (Ashutosh Sharma)
Use GRANT permissions to control pgstattuple function usage (Stephen Frost)
This allows DBAs to allow non-superusers to run these functions.
", "text": "Use GRANT permissions to control pgstattuple function usage (Stephen Frost) This allows DBAs to allow non-superusers to run these functions.", "title": "Use GRANT permissions to control pgstattuple function usage", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "d64902d100b96a92d5b21822dfb6a56f5da620a05fe4ce8218d88b2a15e4edd9", "section_path": ["Additional Modules"], "commit_groups": [["fd321a1df"]], "identity_text": "Use GRANT permissions to control pgstattuple function usage (Stephen Frost) This allows DBAs to allow non-superusers to run these functions.", "commit_aliases": ["fd321a1df"], "source_commits": ["fd321a1df"], "source_entry_id": "10.0/changes/158", "db_id": "2edcd91253fdfd04ccb721550c277b73", "patch_ids": ["6f2ae2dd3f2a287b747d9fd29f995027"], "statement_hash": "951d719fc5a3244266e6e9054aa307589b135834a3e717154b0f9a448f34486e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-ce3e6e8b2d4720de", "migration": false}, {"id": "10.0-dea79bb40365764d", "cves": [], "html": "Reduce locking when pgstattuple examines hash indexes (Amit Kapila)
", "text": "Reduce locking when pgstattuple examines hash indexes (Amit Kapila)", "title": "Reduce locking when pgstattuple examines hash indexes", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "5a89d638220af9035bcd935b243b73cc58dfe4c2c9edf45585b0e57ceeed0479", "section_path": ["Additional Modules"], "commit_groups": [["d4b5d4cad"]], "identity_text": "Reduce locking when pgstattuple examines hash indexes (Amit Kapila)", "commit_aliases": ["d4b5d4cad"], "source_commits": ["d4b5d4cad"], "source_entry_id": "10.0/changes/159", "db_id": "5d3634a71d0e54c5e9069db5393823ed", "patch_ids": ["3fcf0bb3ceb8c33cbd70f8a2bf55fef4"], "statement_hash": "06dee103047dea1949c905ca3e94252c1eba991f237cecf30347a735e1bcfdd5", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-dea79bb40365764d", "migration": false}, {"id": "10.0-6213764c06400daa", "cves": [], "html": "Add pageinspect function page_checksum() to show a page's checksum (Tomas Vondra)
Add pageinspect function bt_page_items() to print page items from a page image (Tomas Vondra)
Add hash index support to pageinspect (Jesper Pedersen, Ashutosh Sharma)
", "text": "Add hash index support to pageinspect (Jesper Pedersen, Ashutosh Sharma)", "title": "Add hash index support to pageinspect", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/10.0/#id-1.11.6.28.5.14", "source_hash": "cb604adce61e7a9f7001a955d792cc2f28963a845bc0673b97340ee254fead48", "section_path": ["Additional Modules"], "commit_groups": [["08bf6e529"]], "identity_text": "Add hash index support to pageinspect (Jesper Pedersen, Ashutosh Sharma)", "commit_aliases": ["08bf6e529"], "source_commits": ["08bf6e529"], "source_entry_id": "10.0/changes/162", "db_id": "611cef2b7d8bec1b875682973bd05e30", "patch_ids": ["c7d91586ebb3c024d0dc7d127b67db8f"], "statement_hash": "ef3e9a94765efe03a56a050b35e68b866a74a57988b72e11bc3288131b4f6c20", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=10.0#10.0-473aab0c8acb3871", "migration": false}], "initial_entry_count": 189, "migration_html": "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 10 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:
\n