Correctifs appliqués

Teodor Sigaev pushed:

Peter Eisentraut pushed:

Robert Haas pushed:

�lvaro Herrera pushed:

Andres Freund pushed:

Andrew Dunstan pushed:

Simon Riggs pushed:

Magnus Hagander pushed:

  • Properly set base backup backends to active in pg_stat_activity. When walsenders were included in pg_stat_activity, only the ones actually streaming WAL were listed as active when they were active. In particular, the connections sending base backups were listed as being idle. Which means that a regular pg_basebackup would show up with one active and one idle connection, when both were active. This patch updates to set all walsenders to active when they are (including those doing very fast things like IDENTIFY_SYSTEM), and then back to idle. Details about exactly what they are doing is available in pg_stat_replication. Patch by me, review by Michael Paquier and David Steele. https://git.postgresql.org/pg/commitdiff/d02974e32e028fc078d8f5eca1d6a4516efb0aa6

Correctifs en attente

Aleksandr Parfenov sent in another revision of a patch to make a more flexible configuration for full-text search.

Tomas Vondra sent in another revision of a patch to add some controls over the resources logical replication consumes.

Amit Langote sent in another revision of a patch to teach the executor to handle ON CONFLICT (key) on partitioned tables.

Masahiko Sawada sent in another revision of a patch to determine whether logical replication has caught up.

Nikhil Sontakke sent in a patch to fix the now-incorrect assumption by HeapTupleSatisfiesVacuum that rows belonging to an aborted transaction are not visible to anyone else.

Micha�l Paquier sent in a patch to improve the concurrent behavior of ALTER ROLE.

Peter Eisentraut sent in two more revisions of a patch to add infrastructure needed in order to use stdbool.h.

David Rowley sent in another revision of a patch to better prune partitions at runtime.

Vaishnavi Prabakaran sent in a patch to add TAP test support for backup with tablespace mapping.

Etsuro Fujita sent in another revision of a patch to improve predicate pushdown for UPDATEs in the PostgreSQL FDW.

Haribabu Kommi sent in another revision of a patch to implement pluggable storage.

Dmitry Dolgov sent in another revision of a patch to implement generic type subscripting and use same for arrays and JSONB.

Ra�l Mar�n Rodr�guez sent in another revision of a patch to add pow() support to pgbench.

Masahiko Sawada sent in another revision of a patch to handle 2PC and similar across multiple servers.

Konstantin Knizhnik sent in three more revisions of a patch to implement AS OF queries.

Yugo Nagata sent in three more revisions of a patch to implement lockable views.

Peter Eisentraut sent in another revision of a patch to implement generated columns.

David Rowley sent in another revision of a patch to remove [Merge]Append nodes which contain a single subpath.

Micha�l Paquier sent in a patch to improve the current behavior of a flock of DDLs.

Micha�l Paquier sent in a patch to refactor channel binding code to fetch cbind_data only when necessary and implement channel binding tls-server-end-point for SCRAM.

John Naylor sent in another revision of a patch to make bootstrap data simpler to read and use.

Fabien COELHO sent in two more revisions of a patch to add more functions and operators to pgbench.

Nathan Bossart sent in another revision of a patch to fix the unparenthesized VACUUM grammar, add a parenthesized ANALYZE syntax, and add a NOWAIT vacuum option.

Andrey Borodin sent in another revision of a patch to delete pages during GiST VACUUM and implement a physical GiST scan.

Kyotaro HORIGUCHI sent in a patch to add a simple perl client module for testing and add a sample prove_check based on same.

Jeff Janes sent in a patch to fix MCV lists for highly skewed distributions.

Yugo Nagata sent in a patch to implement GET DIAGNOSTICS FUNCTION_NAME in PL/pgsql.

David Steele sent in another revision of a patch to allow group read for $PGDATA.

Jeff Davis sent in another revision of a patch to implement RANGE MERGE JOIN.

Thomas Munro sent in another revision of a patch to fix a condition variable live lock.

Marco Nenciarini sent in a patch to support TRUNCATE statements in logical replication.

�lvaro Herrera sent in another revision of a patch to implement local indexes for partitioned tables.

Fabien COELHO sent in another revision of a patch to add \if to pgbench.

�lvaro Herrera sent in a patch to add FOR EACH ROW triggers to partitioned tables.

Marco Nenciarini sent in a patch to make TRUNCATE match the behavior of DELETE for session_replication_role = replica.

Yugo Nagata sent in a patch to fix an Oracle incompatibility in error condition for the Oracle-compatibility function instr() documented for PL/pgsql.

�lvaro Herrera sent in a patch to allow UNIQUE indexes on partitioned tables.

Andrey Borodin sent in a patch to count tuples correctly during GiST VACUUM of partial index.

Simon Riggs sent in a patch to change the WAL header to reduce contention during ReserveXLogInsertLocation().

Simon Riggs sent in another revision of a patch to implement MERGE.

Petr Jel�nek sent in a patch to add dd pg_replication_slot_advance() function which advances a replication slot to the specified position. It works both with logical and physical slots.

Vik Fearing sent in a patch to add some sample values for the parameters of pg_stat_statements.

Marina Polyakova sent in another revision of a patch to precalculate stable and immutable functions.

Pavan Deolasee sent in a patch to speed up inserts with mostly-monotonically increasing values.

Artur Zakirov sent in another revision of a patch to enable shared Ispell dictionaries.

Remi Colinet sent in a patch to make block and file size for WAL and relations defined at cluster creation.

Ivan Kartyshov sent in a patch to implement checksums for SLRU files.

Stephen Frost sent in a patch to add a default role 'pg_access_server_files'.

�lvaro Herrera sent in a patch to allow foreign key triggers on partitioned tables.