pgsql: Raise a WARNING for max_slot_wal_keep_size in pg_createsubscribe

Raise a WARNING for max_slot_wal_keep_size in pg_createsubscriber. During the pg_createsubscriber execution, it is possible that the required WAL is removed from the primary/publisher node due to 'max_slot_wal_keep_size'. This patch raises a WARNING during the '--dry-run' mode if the 'max_slot_wa

pgsql: Specialize intarray sorting

Specialize intarray sorting There is at least one report in the field of storing millions of integers in arrays, so it seems like a good time to specialize intarray's qsort function. In doing so, streamline the comparators: Previously there were three, two for each direction for sorting and one pa

pgsql: Doc: Improve pg_replication_slots.inactive_since description.

Doc: Improve pg_replication_slots.inactive_since description. Author: Peter Smith Reviewed-by: Amit Kapila Discussion: https://postgr.es/m/cahut+pssvvmtwvtupto6hbpo8pgvsvtzndt_fdboma_oq4z...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/164bac92f

pgsql: Fix typo in 2a8a0067.

Fix typo in 2a8a0067. Builds configured with Valgrind but without assertions would fail due to a typo in the recent change. This should be included when back-patching 2a8a0067 into v17. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2509b857cc1067be628291864289f27

pgsql: Stamp 17.4.

Stamp 17.4. Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f8554dee417ffc4540c94cf357f7bf7d4b6e5d80 Modified Files -- configure| 18 +- configure.ac | 2 +- meson.build | 2 +- 3 files changed, 11 insertions(+), 11 deletions(-

pgsql: Stamp 13.20.

Stamp 13.20. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/c8f198c3acb59ed858b5b9b88b4fbc55cece544e Modified Files -- configure| 18 +- configure.in | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 14.17.

Stamp 14.17. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e5cabe28006995d90cc9ebc613dad072c44c7f4a Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 15.12.

Stamp 15.12. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/50d3d22baba63613d1f1406b2ed460dc9b03c3fc Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 16.8.

Stamp 16.8. Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/71eb35c0b18de96537bd3876ec9bf8075bfd484f Modified Files -- configure| 18 +- configure.ac | 2 +- meson.build | 2 +- 3 files changed, 11 insertions(+), 11 deletions(-

pgsql: Fix translator notes in comments

Fix translator notes in comments The translator comments detailing what a %s inclusion refers to were accidentally including too many address types. In practice this is not a problem since it's not a translated string, but to minimize any risk of confusion let's fix them anwyays. Even though thi

pgsql: Add tab completion for ALTER USER/ROLE RESET

Add tab completion for ALTER USER/ROLE RESET Currently tab completion for ALTER USER RESET shows a list of all configuration parameters that may be set on a role, irrespectively of which parameters are actually set. This patch improves tab completion to offer only parameters that are set. Author:

pgsql: Add tab completion for ALTER DATABASE RESET

Add tab completion for ALTER DATABASE RESET Currently tab completion for ALTER DATABASE RESET shows a list of all configuration parameters that may be set on a database, irrespectively of which parameters are actually set. This patch improves tab completion to offer only parameters that are set.

pgsql: Translation updates

Translation updates Source-Git-URL: ssh://g...@git.postgresql.org/pgtranslation/messages.git Source-Git-Hash: 4b3f97f98ced3e9b03a6b24a16ac06eec2eab330 Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d0ed7d2a5aeb858e814147b42f8681870340909b Modified Files ---

pgsql: Translation updates

Translation updates Source-Git-URL: ssh://g...@git.postgresql.org/pgtranslation/messages.git Source-Git-Hash: af39eb1d27d7701ff7240457c2c9e49e9531eaa7 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/f815362abecde1aebcd9ddb334fe271edc759eaa Modified Files ---

pgsql: Translation updates

Translation updates Source-Git-URL: ssh://g...@git.postgresql.org/pgtranslation/messages.git Source-Git-Hash: 1e8728e015ca86554fa7a4e4153c8fd414657a02 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3b5b99f6f14567396555b6c24a14111f81161e60 Modified Files ---

pgsql: Translation updates

Translation updates Source-Git-URL: ssh://g...@git.postgresql.org/pgtranslation/messages.git Source-Git-Hash: 8fbdbed3216a3cdbb9ca74f3d9d990b4e96100e3 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/50fabe48e39858eacf8a56e0da1ba7610ae537ae Modified Files ---

pgsql: Translation updates

Translation updates Source-Git-URL: ssh://g...@git.postgresql.org/pgtranslation/messages.git Source-Git-Hash: 2bcd19355a18178dfe82bde9e98b9486fcd3143f Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a282099583039633a8aa83953a0c4e72fca95423 Modified Files ---

pgsql: Implement Self-Join Elimination

Implement Self-Join Elimination The Self-Join Elimination (SJE) feature removes an inner join of a plain table to itself in the query tree if it is proven that the join can be replaced with a scan without impacting the query result. Self-join and inner relation get replaced with the outer in quer

pgsql: Revert: Get rid of WALBufMappingLock

Revert: Get rid of WALBufMappingLock This commit reverts 6a2275b895. Buildfarm failure on batta spots some concurrency issue, which requires further investigation. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3fb58625d18fd226cb929c9700d0db72ac92c075 Modified Fi