Movatterモバイル変換

E.20. Release 16#

• Allowlogical decoding on standbys (Bertrand Drouvot, Andres Freund, Amit Khandekar)§§§

  SnapshotWAL records are required for logical slot creation but cannot be created on standbys. To avoid delays, the new functionpg_log_standby_snapshot() allows creation of such records.

• Add server variable to control how logical decoding publishers transfer changes and how subscribers apply them (Shi Yu)§§§

  The variable isdebug_logical_replication_streaming.

• Allow logical replication initial table synchronization to copy rows in binary format (Melih Mutlu)§

  This is only possible for subscriptions marked as binary.

• Allow parallel application of logical replication (Hou Zhijie, Wang Wei, Amit Kapila)§§§

  TheCREATE SUBSCRIPTIONSTREAMING option now supportsparallel to enable application of large transactions by parallel workers. The number of parallel workers is controlled by the new server variablemax_parallel_apply_workers_per_subscription. Wait eventsLogicalParallelApplyMain,LogicalParallelApplyStateChange, andLogicalApplySendData were also added. Columnleader_pid was added to system viewpg_stat_subscription to track parallel activity.

• Improve performance forlogical replication apply without a primary key (Onder Kalaci, Amit Kapila)§

  Specifically,REPLICA IDENTITY FULL can now use btree indexes rather than sequentially scanning the table to find matches.

• Allow logical replication subscribers to process only changes that have no origin (Vignesh C, Amit Kapila)§§

  This can be used to avoid replication loops. This is controlled by the newCREATE SUBSCRIPTION ... ORIGIN option.

• Perform logical replicationSELECT andDML actions as the table owner (Robert Haas)§§

  This improves security and now requires subscription owners to be either superusers or to haveSET ROLE permission on all roles owning tables in the replication set. The previous behavior of performing all operations as the subscription owner can be enabled with the subscriptionrun_as_owner option.

• Havewal_retrieve_retry_interval operate on a per-subscription basis (Nathan Bossart)§

  Previously the retry time was applied globally. This also adds wait events>LogicalRepLauncherDSA andLogicalRepLauncherHash.

• AddEXPLAIN optionGENERIC_PLAN to display the generic plan for a parameterized query (Laurenz Albe)§

• Allow aCOPY FROM value to map to a column'sDEFAULT (Israel Barth Rubio)§

• AllowCOPY into foreign tables to add rows in batches (Andrey Lepikhov, Etsuro Fujita)§

  This is controlled by thepostgres_fdw optionbatch_size.

• Allow theSTORAGE type to be specified byCREATE TABLE (Teodor Sigaev, Aleksander Alekseev)§§

  Previously onlyALTER TABLE could control this.

• Allowtruncate triggers on foreign tables (Yugo Nagata)§

• AllowVACUUM andvacuumdb to only processTOAST tables (Nathan Bossart)§

  This is accomplished by havingVACUUM turn offPROCESS_MAIN or byvacuumdb using the--no-process-main option.

• AddVACUUM options to skip or update allfrozen statistics (Tom Lane, Nathan Bossart)§

  The options areSKIP_DATABASE_STATS andONLY_DATABASE_STATS.

• ChangeREINDEX DATABASE andREINDEX SYSTEM to no longer require an argument (Simon Riggs)§§

  Previously the database name had to be specified.

• AllowCREATE STATISTICS to generate a statistics name if none is specified (Simon Riggs)§

• Allow non-decimalinteger literals (Peter Eisentraut)§

  For example,0x42F,0o273, and0b100101.

• AllowNUMERIC to process hexadecimal, octal, and binary integers of any size (Dean Rasheed)§

  Previously only unquoted eight-byte integers were supported with these non-decimal bases.

• Allow underscores in integer and numericconstants (Peter Eisentraut, Dean Rasheed)§

  This can improve readability for long strings of digits.

• Accept the spelling+infinity in datetime input (Vik Fearing)§

• Prevent the specification ofepoch andinfinity together with other fields in datetime strings (Joseph Koshakow)§

• Remove undocumented support for date input in the formYyearMmonthDday (Joseph Koshakow)§

• Add functionspg_input_is_valid() andpg_input_error_info() to check for type conversion errors (Tom Lane)§§

• Allow subqueries in theFROM clause to omit aliases (Dean Rasheed)§

• Add support for enhanced numeric literals inSQL/JSON paths (Peter Eisentraut)§

  For example, allow hexadecimal, octal, and binary integers and underscores between digits.

• AddSQL/JSON constructors (Nikita Glukhov, Teodor Sigaev, Oleg Bartunov, Alexander Korotkov, Amit Langote)§

  The new functionsJSON_ARRAY(),JSON_ARRAYAGG(),JSON_OBJECT(), andJSON_OBJECTAGG() are part of theSQL standard.

• AddSQL/JSON object checks (Nikita Glukhov, Teodor Sigaev, Oleg Bartunov, Alexander Korotkov, Amit Langote, Andrew Dunstan)§

  TheIS JSON checks include checks for values, arrays, objects, scalars, and unique keys.

• AllowJSON string parsing to use vector operations (John Naylor)§

• Improve the handling of full text highlighting functionts_headline() forOR andNOT expressions (Tom Lane)§

• Add functions to add, subtract, and generatetimestamptz values in a specified time zone (Przemyslaw Sztoch, Gurjeet Singh)§

  The functions aredate_add(),date_subtract(), andgenerate_series().

• Changedate_trunc(unit, timestamptz, time_zone) to be an immutable function (Przemyslaw Sztoch)§

  This allows the creation of expression indexes using this function.

• Add server variableSYSTEM_USER (Bertrand Drouvot)§

  This reports the authentication method and its authenticated user.

• Add functionsarray_sample() andarray_shuffle() (Martin Kalcher)§

• Add aggregate functionANY_VALUE() which returns any value from a set (Vik Fearing)§

• Add functionrandom_normal() to supply normally-distributed random numbers (Paul Ramsey)§

• Add error functionerf() and its complementerfc() (Dean Rasheed)§

• Improve the accuracy of numericpower() for integer exponents (Dean Rasheed)§

• AddXMLSERIALIZE() optionINDENT to pretty-print its output (Jim Jones)§

• Changepg_collation_actual_version() to return a reasonable value for the default collation (Jeff Davis)§

  Previously it returnedNULL.

• Allowpg_read_file() andpg_read_binary_file() to ignore missing files (Kyotaro Horiguchi)§

• Add byte specification (B) topg_size_bytes() (Peter Eisentraut)§

• Allowto_reg* functions to accept numericOIDs as input (Tom Lane)§

• Add the ability to get the current function'sOID inPL/pgSQL (Pavel Stehule)§

  This is accomplished withGET DIAGNOSTICS variable = PG_ROUTINE_OID.

• Addlibpq connection optionrequire_auth to specify a list of acceptable authentication methods (Jacob Champion)§

  This can also be used to disallow certain authentication methods.

• Allow multiplelibpq-specified hosts to be randomly selected (Jelte Fennema)§§

  This is enabled withload_balance_hosts=random and can be used for load balancing.

• Addlibpq optionsslcertmode to control transmission of the client certificate (Jacob Champion)§

  The option values aredisable,allow, andrequire.

• Allowlibpq to use the system certificate pool for certificate verification (Jacob Champion, Thomas Habets)§

  This is enabled withsslrootcert=system, which also enablessslmode=verify-full.

• AllowECPG variable declarations to use typedef names that match unreservedSQL keywords (Tom Lane)§

  This change does prevent keywords which match C typedef names from being processed as keywords in laterEXEC SQL blocks.

• Addinitdb option to set server variables for the duration ofinitdb and all future server starts (Tom Lane)§

  The option is-c name=value.

• Add options tocreateuser to control more user options (Shinya Kato)§§

  Specifically, the new options control the valid-until date, bypassing of row-level security, and role membership.

• Deprecatecreateuser option--role (Nathan Bossart)§§

  This option could be easily confused with newcreateuser role membership options, so option--member-of has been added with the same functionality. The--role option can still be used.

• Allow control ofvacuumdb schema processing (Gilles Darold)§

  These are controlled by options--schema and--exclude-schema.

• Use newVACUUM options to improve the performance ofvacuumdb (Tom Lane, Nathan Bossart)§

• Havepg_upgrade set the new cluster's locale and encoding (Jeff Davis)§

  This removes the requirement that the new cluster be created with the same locale and encoding settings.

• Addpg_upgrade option to specify the default transfer mode (Peter Eisentraut)§

  The option is--copy.

• Improvepg_basebackup to accept numeric compression options (Georgios Kokolatos, Michael Paquier)§

  Options like--compress=server-5 are now supported.

• Fixpg_basebackup to handle tablespaces stored in thePGDATA directory (Robert Haas)§

• Addpg_waldump option--save-fullpage to dump full page images (David Christensen)§

• Allowpg_waldump options-t/--timeline to accept hexadecimal values (Peter Eisentraut)§

• Add support for progress reporting topg_verifybackup (Masahiko Sawada)§

• Allowpg_rewind to properly track timeline changes (Heikki Linnakangas)§§

  Previously ifpg_rewind was run after a timeline switch but before a checkpoint was issued, it might incorrectly determine that a rewind was unnecessary.

• Havepg_receivewal andpg_recvlogical cleanly exit onSIGTERM (Christoph Berg)§

  This signal is often used bysystemd.

• BuildICU support by default (Jeff Davis)§

  This removes build flag--with-icu and adds flag--without-icu.

• Add support for SSE2 (StreamingSIMD Extensions 2) vector operations on x86-64 architectures (John Naylor)§

• Add support for AdvancedSIMD (Single Instruction Multiple Data) (NEON) instructions onARM architectures (Nathan Bossart)§

• HaveWindows binaries built withMSVC useRandomizedBaseAddress (ASLR) (Michael Paquier)§

  This was already enabled onMinGW builds.

• Prevent extension libraries from exporting their symbols by default (Andres Freund, Tom Lane)§§

  Functions that need to be called from the core backend or other extensions must now be explicitly markedPGDLLEXPORT.

• RequireWindows 10 or newer versions (Michael Paquier, Juan José Santamaría Flecha)§

  PreviouslyWindows Vista andWindows XP were supported.

• RequirePerl version 5.14 or later (John Naylor)§

• RequireBison version 2.3 or later (John Naylor)§

• RequireFlex version 2.5.35 or later (John Naylor)§

• RequireMIT Kerberos forGSSAPI support (Stephen Frost)§

• Remove support forVisual Studio 2013 (Michael Paquier)§

• Remove support forHP-UX (Thomas Munro)§

• Remove support forHP/Intel Itanium (Thomas Munro)§

• Remove support forM68K,M88K,M32R, andSuperHCPU architectures (Thomas Munro)§§

• Removelibpq support forSCM credential authentication (Michael Paquier)§

  Backend support for this authentication method was removed inPostgresSQL 9.1.

• Addmeson build system (Andres Freund, Nazir Bilal Yavuz, Peter Eisentraut)§

  This eventually will replace theAutoconf andWindows-basedMSVC build systems.

• Allow control of the location of theopenssl binary used by the build system (Peter Eisentraut)§

  Make findingopenssl program aconfigure ormeson option

• Add build option to allow testing of small table segment sizes (Andres Freund)§

  The build options are--with-segsize-blocks and-Dsegsize_blocks.

• Addpgindent options (Andrew Dunstan)§§§§§§§

  The new options are--show-diff,--silent-diff,--commit, and--help, and allow multiple--exclude options. Also require the typedef file to be explicitly specified. Options--code-base and--build were also removed.

• Addpg_bsd_indent source code to the main tree (Tom Lane)§

• Improvemake_ctags andmake_etags (Yugo Nagata)§

• Adjustpg_attribute columns for efficiency (Peter Eisentraut)§

• Improve use of extension-based indexes on boolean columns (Zongliang Quan, Tom Lane)§

• Add support for Daitch-Mokotoff Soundex tofuzzystrmatch (Dag Lem)§

• Allowauto_explain to log values passed to parameterized statements (Dagfinn Ilmari Mannsåker)§

  This affects queries using server-sidePREPARE/EXECUTE and client-side parse/bind. Logging is controlled byauto_explain.log_parameter_max_length; by default query parameters will be logged with no length restriction.

• Haveauto_explain'slog_verbose mode honor the value ofcompute_query_id (Atsushi Torikoshi)§

  Previously even ifcompute_query_id was enabled,log_verbose was not showing the query identifier.

• Change the maximum length ofltree labels from 256 to 1000 and allow hyphens (Garen Torikian)§

• Havepg_stat_statements normalize constants used in utility commands (Michael Paquier)§

  Previously constants appeared instead of placeholders, e.g.,$1.

• Addpg_walinspect functionpg_get_wal_block_info() to reportWAL block information (Michael Paquier, Melanie Plageman, Bharath Rupireddy)§§§§

• Change howpg_walinspect functionspg_get_wal_records_info() andpg_get_wal_stats() interpret endingLSNs (Bharath Rupireddy)§

  Previously endingLSNs which represent nonexistentWAL locations would generate an error, while they will now be interpreted as the end of theWAL.

• Add detailed descriptions ofWAL records inpg_walinspect andpg_waldump (Melanie Plageman, Peter Geoghegan)§§§§

• Addpageinspect functionbt_multi_page_stats() to report statistics on multiple pages (Hamid Akhtar)§

  This is similar tobt_page_stats() except it can report on a range of pages.

• Add empty range output column topageinspect functionbrin_page_items() (Tomas Vondra)§

• Redesign archive modules to be more flexible (Nathan Bossart)§

  Initialization changes will require modules written for older versions of Postgres to be updated.

• Correct inaccuratepg_stat_statements row tracking extended query protocol statements (Sami Imseih)§

• Addpg_buffercache functionpg_buffercache_usage_counts() to report usage totals (Nathan Bossart)§

• Addpg_buffercache functionpg_buffercache_summary() to report summarized buffer statistics (Melih Mutlu)§

• Allow the schemas of required extensions to be referenced in extension scripts using the new syntax@extschema:referenced_extension_name@ (Regina Obe)§

• Allow required extensions to be marked as non-relocatable usingno_relocate (Regina Obe)§

  This allows@extschema:referenced_extension_name@ to be treated as a constant for the lifetime of the extension.