Correctifs appliqués

Peter Eisentraut pushed:

Andrew Dunstan pushed:

Simon Riggs pushed:

  • Ability to advance replication slots. Ability to advance both physical and logical replication slots using a new user function pg_replication_slot_advance(). For logical advance that means records are consumed as fast as possible and changes are not given to output plugin for sending. Makes 2nd phase (after we reached SNAPBUILD_FULL_SNAPSHOT) of replication slot creation faster, especially when there are big transactions as the reorder buffer does not have to deal with data changes and does not have to spill to disk. Author: Petr Jelinek Reviewed-by: Simon Riggs https://git.postgresql.org/pg/commitdiff/9c7d06d60680c7f00d931233873dee81fdb311c6
  • Fix typo in recent commit. Typo in 9c7d06d60680c7f00d931233873dee81fdb311c6 Reported-by: Masahiko Sawada https://git.postgresql.org/pg/commitdiff/4e54dd2e0a750352ce2a5c45d1cc9183e887eec3

Tom Lane pushed:

Robert Haas pushed:

Bruce Momjian pushed:

Álvaro Herrera pushed:

Magnus Hagander pushed:

Correctifs en attente

Ildus Kurbangaliev sent in another revision of a patch to create custom compression methods.

Masahiko Sawada sent in a patch to fix a README in nbtree to reflect current realities.

Michaël Paquier sent in a patch to remove WITH clause support in CREATE FUNCTION for isCachable and isStrict.

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

Joe Wildish sent in another revision of a patch to implement SQL ASSERTIONs.

Haribabu Kommi sent in another revision of a patch to enhance pg_stat_wal_receiver view to display connected host.

Robert Haas sent in another revision of a patch to make "quit" and "exit" Do The Right Thing™ in psql.

Marco Nenciarini sent in two more revisions of a patch to implement logical decoding of TRUNCATE.

Shubham Barai sent in another revision of a patch to predicate Locking in hash index.

Marina Polyakova sent in another revision of a patch to add the infrastructure for pre-calculating STABLE functions.

Alexander Korotkov sent in another revision of a patch to count tuples correctly during GiST VACUUM of partial indexes.

Andrew Dunstan sent in another revision of a patch to speed up adding a column with a DEFAULT to a table.

Amit Langote sent in a patch to ensure that partitioned tables do not have TOAST tables created for them.

Geoff Winkless sent in a patch to psql to handle EOF correctly when readline is enabled.

Ildar Musin sent in two more revisions of a patch to create general purpose hashing functions in pgbench.

Peter Eisentraut sent in another revision of a patch to implement GENERATED columns per the SQL standard.

Yuto Hayamizu sent in another revision of a patch to mitigate filter cost overestimation.

Amit Langote and David Rowley traded patches to speed up partition pruning.

Peter Eisentraut sent in another revision of a patch to implement transaction control in procedures.

Yoshimi Ichiyanagi sent in a patch to apply PMDK to WAL operations for persistent memory.

Peter Geoghegan sent in two more revisions of a patch to add parallel B-tree index build sorting.

Andrey Borodin sent in two more revisions of a patch to implement a GiST vacuum.

Anastasia Lubennikova sent in two more revisions of a patch to implement covering + unique indexes.

Claudio Freire sent in another revision of a patch to vacuum which makes it update the FSM more frequently.

Claudio Freire sent in another revision of a patch to enable VACUUM to use more than 1GB of work_mem.

Nikolay Shaplov sent in another revision of a patch to skip setting toast.* reloptions when a TOAST table does not exist.

Konstantin Knizhnik sent in three revisions of a patch to implement built-in connection pooling.

Robert Haas sent in another revision of a patch to sort epq path if needed.

Robert Haas sent in a patch to propagate REINDEX state.

David Gould sent in a patch to fix a bug where ANALYZE can cause pg_class.reltuples to be wildly exaggerated.

Etsuro Fujita sent in another revision of a patch to fix WCO handling in the PostgreSQL FDW.

Fabien COELHO sent in another revision of a patch to add a pgbench progress test.

Jeevan Chalke sent in another revision of a patch to implement partition-wise aggregation/grouping.

Antonin Houska sent in a patch to fix possible gaps/garbage in the output of the XLOG reader.

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

Fabien COELHO sent in another revision of a patch to add --random-seed to pgbench.

Kyotaro HORIGUCHI sent in two more revisions of a patch to fix an issue where an index-only scan would return incorrect results when using a composite GIST index with a gist_trgm_ops column.

Peter Eisentraut sent in a patch to create constraint triggers to fire ALWAYS, which ensures that all constraints are also enforced on logical replicas.

Álvaro Herrera sent in a patch to add tests for pg_dump for local indexes on partitoned tables.

Robert Haas sent in another revision of a patch to handle parallel worker fork failures better.

Amit Langote sent in two revisions of a patch to add assorted partition reporting functions.

Haribabu Kommi sent in another revision of a patch to refactor handling of database attributes between pg_dump and pg_dumpall.

Marco Nenciarini sent in another revision of a patch to TRUNCATE to make it ignore foreign keys in ROLE_REPLICA.

Liudmila Mantrova sent in another revision of a patch to fix some documentation inconsistencies in pg_trgm word_similarity.

Jörg Westheide sent in a patch to make "make check" work on MacOS when SIP is enabled.

Konstantin Knizhnik sent in another revision of a patch to optimize secondary index access.

Amit Langote sent in another revision of a patch to teach CopyFrom to use ModifyTableState for tuple-routing, refactor ExecFindPartition and ExecSetupPartitionTupleRouting, and ensure that during tuple-routing, per-partition objects are initialized lazily.

Tomas Vondra sent in two more revisions of a patch to add logical_work_mem and use same to constrain memory usage for logical replication.

Peter Eisentraut sent in another revision of a patch to implement GNU TLS support.

Etsuro Fujita sent in a patch to update some regression tests for the PostgreSQL FDW.

David Steele sent in another revision of a patch to make a configurable file mode mask for the PostgreSQL directories.

Jing Wang sent in another revision of a patch to support COMMENT ON DATABASE CURRENT_DATABASE.

Tom Lane sent in a patch to pg_dump to make TOC tags reliably distinguishable and dump comments in a more uniform order.

Tom Lane sent in another revision of a patch to refactor handling of database attributes between pg_dump and pg_dumpall.