pgsql: Add PostgreSQL::Test::Cluster::config_data()

2022-02-07 Thread Michael Paquier
Add PostgreSQL::Test::Cluster::config_data()

This is useful to grab some configuration information from a node
already set up, and I personally found two cases for it: pg_upgrade and
a test to emulate check_guc.

Author: Michael Paquier
Discussion: https://postgr.es/m/20211129030833.gj17...@telsasoft.com
Discussion: https://postgr.es/m/yj8xtmlqkotvl...@paquier.xyz

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/ba15f16107bea8a93edc505f3013cd7df4ac90fc

Modified Files
--
src/test/perl/PostgreSQL/Test/Cluster.pm | 25 +
1 file changed, 25 insertions(+)



pgsql: Stamp 10.20.

2022-02-07 Thread Tom Lane
Stamp 10.20.

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/fa362d2b3bde0f99ba8a22486205de11b2e00e14

Modified Files
--
configure| 18 +-
configure.in |  2 +-
doc/bug.template |  2 +-
src/include/pg_config.h.win32|  8 
src/interfaces/libpq/libpq.rc.in |  8 
src/port/win32ver.rc |  4 ++--
6 files changed, 21 insertions(+), 21 deletions(-)



pgsql: Stamp 11.15.

2022-02-07 Thread Tom Lane
Stamp 11.15.

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/ff2a6d2621439d3d3f6e340c363d3b5e71749919

Modified Files
--
configure| 18 +-
configure.in |  2 +-
doc/bug.template |  2 +-
src/include/pg_config.h.win32|  8 
src/interfaces/libpq/libpq.rc.in |  8 
src/port/win32ver.rc |  4 ++--
6 files changed, 21 insertions(+), 21 deletions(-)



pgsql: Stamp 12.10.

2022-02-07 Thread Tom Lane
Stamp 12.10.

Branch
--
REL_12_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/ec24521950fb055488e3ab2c652ffbf7fe0180b9

Modified Files
--
configure| 18 +-
configure.in |  2 +-
src/include/pg_config.h.win32|  8 
src/interfaces/libpq/libpq.rc.in |  8 
src/port/win32ver.rc |  4 ++--
5 files changed, 20 insertions(+), 20 deletions(-)



pgsql: Stamp 13.6.

2022-02-07 Thread Tom Lane
Stamp 13.6.

Branch
--
REL_13_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/d7db9572070a627bae9919fd1b4e16c8208d4fca

Modified Files
--
configure| 18 +-
configure.in |  2 +-
2 files changed, 10 insertions(+), 10 deletions(-)



pgsql: Stamp 14.2.

2022-02-07 Thread Tom Lane
Stamp 14.2.

Branch
--
REL_14_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/78b1ddc753b3e5e3f3e9eb0e7519b48146018394

Modified Files
--
configure| 18 +-
configure.ac |  2 +-
2 files changed, 10 insertions(+), 10 deletions(-)



pgsql: Reduce non-leaf keys overlap in GiST indexes produced by a sorte

2022-02-07 Thread Alexander Korotkov
Reduce non-leaf keys overlap in GiST indexes produced by a sorted build

The GiST sorted build currently chooses split points according to the only page
space utilization.  That may lead to higher non-leaf keys overlap and, in turn,
slower search query answers.

This commit makes the sorted build use the opclass's picksplit method.  Once
four pages at the level are accumulated, the picksplit method is applied until
each split partition fits the page.  Some of our split algorithms could show
significant performance degradation while processing 4-times more data at once.
But those opclasses haven't received the sorted build support and shouldn't
receive it before their split algorithms are improved.

Discussion: 
https://postgr.es/m/CAHqSB9jqtS94e9%3D0vxqQX5dxQA89N95UKyz-%3DA7Y%2B_YJt%2BVW5A%40mail.gmail.com
Author: Aliaksandr Kalenik, Sergei Shoulbakov, Andrey Borodin
Reviewed-by: Björn Harrtell, Darafei Praliaskouski, Andres Freund
Reviewed-by: Alexander Korotkov

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/f1ea98a7975e15cefdb446385880a2f55224ee7d

Modified Files
--
contrib/pageinspect/expected/gist.out |  18 +--
src/backend/access/gist/README|  16 ++
src/backend/access/gist/gistbuild.c   | 271 +-
src/tools/pgindent/typedefs.list  |   2 +-
4 files changed, 197 insertions(+), 110 deletions(-)



pgsql: Translation updates

2022-02-07 Thread Peter Eisentraut
Translation updates

Source-Git-URL: git://git.postgresql.org/git/pgtranslation/messages.git
Source-Git-Hash: b63dc3c71c81bdfad2481ea7ae011d5d22cfb7bd

Branch
--
REL_10_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/217257fac07426cf4c0c2def14f1cb19c330d36a

Modified Files
--
src/backend/po/de.po |  814 +++
src/backend/po/fr.po | 4198 +-
src/backend/po/ru.po |  822 +++
src/backend/po/sv.po |  387 ++--
src/bin/initdb/po/sv.po  |   12 +-
src/bin/pg_archivecleanup/po/sv.po   |2 +-
src/bin/pg_basebackup/po/ru.po   |   96 +-
src/bin/pg_basebackup/po/sv.po   |2 +-
src/bin/pg_config/po/sv.po   |2 +-
src/bin/pg_controldata/po/sv.po  |2 +-
src/bin/pg_ctl/po/sv.po  |2 +-
src/bin/pg_dump/po/ru.po |   20 +-
src/bin/pg_dump/po/sv.po |   10 +-
src/bin/pg_resetwal/po/sv.po |4 +-
src/bin/pg_rewind/po/sv.po   |6 +-
src/bin/pg_test_fsync/po/sv.po   |2 +-
src/bin/pg_test_timing/po/sv.po  |2 +-
src/bin/pg_upgrade/po/ru.po  |8 +-
src/bin/pg_upgrade/po/sv.po  |   14 +-
src/bin/pg_waldump/po/sv.po  |2 +-
src/bin/psql/po/de.po|  179 +-
src/bin/psql/po/fr.po| 3553 ++--
src/bin/psql/po/ru.po|  186 +-
src/bin/psql/po/sv.po|  181 +-
src/bin/scripts/po/ru.po |   38 +-
src/bin/scripts/po/sv.po |   10 +-
src/interfaces/ecpg/ecpglib/po/sv.po |2 +-
src/interfaces/ecpg/preproc/po/sv.po |2 +-
src/interfaces/libpq/po/de.po|  212 +-
src/interfaces/libpq/po/fr.po|  296 +--
src/interfaces/libpq/po/ru.po|   92 +-
src/interfaces/libpq/po/sv.po|   92 +-
src/pl/plperl/po/ru.po   |   88 +-
src/pl/plperl/po/sv.po   |2 +-
src/pl/plpgsql/src/po/sv.po  |2 +-
src/pl/plpython/po/sv.po |2 +-
src/pl/tcl/po/sv.po  |2 +-
37 files changed, 5720 insertions(+), 5626 deletions(-)



pgsql: Translation updates

2022-02-07 Thread Peter Eisentraut
Translation updates

Source-Git-URL: git://git.postgresql.org/git/pgtranslation/messages.git
Source-Git-Hash: 063c497a909612d444c7c7188482db9aef86200f

Branch
--
REL_14_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/3c879e61d9ad5968e88e12620e270808b6cb76f5

Modified Files
--
src/backend/po/de.po | 1272 +++
src/backend/po/es.po | 2939 
src/backend/po/fr.po | 6151 +-
src/backend/po/ru.po | 1251 +++
src/backend/po/sv.po | 1914 +--
src/bin/initdb/po/el.po  |   19 +-
src/bin/initdb/po/sv.po  |   12 +-
src/bin/pg_amcheck/po/el.po  |  247 +-
src/bin/pg_amcheck/po/ru.po  |6 +-
src/bin/pg_basebackup/nls.mk |2 +-
src/bin/pg_basebackup/po/de.po   |  294 +-
src/bin/pg_basebackup/po/el.po   | 1476 
src/bin/pg_basebackup/po/es.po   |  310 +-
src/bin/pg_basebackup/po/fr.po   |  635 ++--
src/bin/pg_basebackup/po/ru.po   |  295 +-
src/bin/pg_dump/po/de.po |  436 +--
src/bin/pg_dump/po/el.po |  195 +-
src/bin/pg_dump/po/es.po |  478 +--
src/bin/pg_dump/po/fr.po | 1192 +++
src/bin/pg_dump/po/ru.po |  436 +--
src/bin/pg_dump/po/sv.po |   10 +-
src/bin/pg_resetwal/po/el.po |  304 +-
src/bin/pg_resetwal/po/sv.po |4 +-
src/bin/pg_rewind/po/sv.po   |4 +-
src/bin/pg_upgrade/po/ru.po  |8 +-
src/bin/pg_upgrade/po/sv.po  |   12 +-
src/bin/psql/po/de.po|  663 ++--
src/bin/psql/po/el.po| 1192 +++
src/bin/psql/po/es.po|  208 +-
src/bin/psql/po/fr.po|  652 ++--
src/bin/psql/po/ru.po|  666 ++--
src/bin/psql/po/sv.po|  221 +-
src/bin/scripts/po/el.po |   12 +-
src/bin/scripts/po/es.po |   86 +-
src/bin/scripts/po/ru.po |6 +-
src/bin/scripts/po/sv.po |8 +-
src/interfaces/ecpg/preproc/po/el.po |   92 +-
src/interfaces/libpq/po/de.po|  217 +-
src/interfaces/libpq/po/es.po|  470 +--
src/interfaces/libpq/po/fr.po|  588 ++--
src/interfaces/libpq/po/ru.po|  107 +-
src/interfaces/libpq/po/sv.po|  106 +-
src/pl/plperl/po/ru.po   |   88 +-
src/pl/plpgsql/src/po/el.po  |  180 +-
44 files changed, 13406 insertions(+), 12058 deletions(-)



pgsql: Translation updates

2022-02-07 Thread Peter Eisentraut
Translation updates

Source-Git-URL: git://git.postgresql.org/git/pgtranslation/messages.git
Source-Git-Hash: cc8ba6a1bf30f4ee65149c1596513abcffa2e521

Branch
--
REL_12_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/3b00428f1f453dd1beba64385c57efd4cb67d57f

Modified Files
--
src/backend/po/de.po |  993 +++
src/backend/po/fr.po | 4961 +-
src/backend/po/ru.po | 1001 +++
src/backend/po/sv.po |  414 +--
src/bin/initdb/po/sv.po  |   12 +-
src/bin/pg_archivecleanup/po/sv.po   |2 +-
src/bin/pg_basebackup/po/de.po   |  467 ++--
src/bin/pg_basebackup/po/fr.po   |  796 +++---
src/bin/pg_basebackup/po/ru.po   |  293 +-
src/bin/pg_basebackup/po/sv.po   |2 +-
src/bin/pg_checksums/po/sv.po|2 +-
src/bin/pg_config/po/sv.po   |2 +-
src/bin/pg_controldata/po/sv.po  |2 +-
src/bin/pg_ctl/po/sv.po  |2 +-
src/bin/pg_dump/po/de.po |  424 +--
src/bin/pg_dump/po/fr.po | 1100 
src/bin/pg_dump/po/ru.po |  428 +--
src/bin/pg_dump/po/sv.po |   12 +-
src/bin/pg_resetwal/po/sv.po |6 +-
src/bin/pg_rewind/po/sv.po   |6 +-
src/bin/pg_test_fsync/po/sv.po   |2 +-
src/bin/pg_test_timing/po/sv.po  |2 +-
src/bin/pg_upgrade/po/ru.po  |8 +-
src/bin/pg_upgrade/po/sv.po  |   14 +-
src/bin/pg_waldump/po/sv.po  |2 +-
src/bin/psql/po/de.po|  193 +-
src/bin/psql/po/fr.po|  632 ++---
src/bin/psql/po/ru.po|  200 +-
src/bin/psql/po/sv.po|  195 +-
src/bin/scripts/po/ru.po |   38 +-
src/bin/scripts/po/sv.po |   10 +-
src/interfaces/ecpg/ecpglib/po/sv.po |2 +-
src/interfaces/ecpg/preproc/po/sv.po |2 +-
src/interfaces/libpq/po/de.po|  170 +-
src/interfaces/libpq/po/fr.po|  258 +-
src/interfaces/libpq/po/ru.po|  103 +-
src/interfaces/libpq/po/sv.po|  102 +-
src/pl/plperl/po/ru.po   |   88 +-
src/pl/plperl/po/sv.po   |2 +-
src/pl/plpgsql/src/po/sv.po  |2 +-
src/pl/plpython/po/sv.po |2 +-
src/pl/tcl/po/sv.po  |2 +-
42 files changed, 6573 insertions(+), 6381 deletions(-)



pgsql: Translation updates

2022-02-07 Thread Peter Eisentraut
Translation updates

Source-Git-URL: git://git.postgresql.org/git/pgtranslation/messages.git
Source-Git-Hash: 250dd3558ab52b3b5f7c9b6d0cfe9ff81d726de2

Branch
--
REL_11_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/d793dcf28b5dc6da4a76cbf3c059b36c2c8763f4

Modified Files
--
src/backend/po/de.po |  896 +++
src/backend/po/fr.po | 4480 +-
src/backend/po/ru.po |  904 +++
src/backend/po/sv.po |  397 +--
src/bin/initdb/po/sv.po  |   12 +-
src/bin/pg_archivecleanup/po/sv.po   |2 +-
src/bin/pg_basebackup/po/ru.po   |   96 +-
src/bin/pg_basebackup/po/sv.po   |2 +-
src/bin/pg_config/po/sv.po   |2 +-
src/bin/pg_controldata/po/sv.po  |2 +-
src/bin/pg_ctl/po/sv.po  |2 +-
src/bin/pg_dump/po/ru.po |   20 +-
src/bin/pg_dump/po/sv.po |   10 +-
src/bin/pg_resetwal/po/sv.po |4 +-
src/bin/pg_rewind/po/sv.po   |6 +-
src/bin/pg_test_fsync/po/sv.po   |2 +-
src/bin/pg_test_timing/po/sv.po  |2 +-
src/bin/pg_upgrade/po/ru.po  |8 +-
src/bin/pg_upgrade/po/sv.po  |   14 +-
src/bin/pg_verify_checksums/po/sv.po |2 +-
src/bin/pg_waldump/po/sv.po  |2 +-
src/bin/psql/po/de.po|  179 +-
src/bin/psql/po/fr.po|  567 +++--
src/bin/psql/po/ru.po|  186 +-
src/bin/psql/po/sv.po|  181 +-
src/bin/scripts/po/ru.po |   38 +-
src/bin/scripts/po/sv.po |   10 +-
src/interfaces/ecpg/ecpglib/po/sv.po |2 +-
src/interfaces/ecpg/preproc/po/sv.po |2 +-
src/interfaces/libpq/po/de.po|  218 +-
src/interfaces/libpq/po/fr.po|  310 +--
src/interfaces/libpq/po/ru.po|   94 +-
src/interfaces/libpq/po/sv.po|   94 +-
src/pl/plperl/po/ru.po   |   86 +-
src/pl/plperl/po/sv.po   |2 +-
src/pl/plpgsql/src/po/sv.po  |2 +-
src/pl/plpython/po/sv.po |2 +-
src/pl/tcl/po/sv.po  |2 +-
38 files changed, 4467 insertions(+), 4373 deletions(-)



pgsql: Translation updates

2022-02-07 Thread Peter Eisentraut
Translation updates

Source-Git-URL: git://git.postgresql.org/git/pgtranslation/messages.git
Source-Git-Hash: 9aa8bc576f9af5c61de4a6fc8119abfa36493d01

Branch
--
REL_13_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/7f7148b72e2b63274d93da6ea43f1493f4e92aa8

Modified Files
--
src/backend/po/de.po | 1110 +++
src/backend/po/fr.po | 5422 +-
src/backend/po/ru.po | 1119 +++
src/backend/po/sv.po |  414 +--
src/bin/initdb/po/sv.po  |   45 +-
src/bin/pg_archivecleanup/po/sv.po   |6 +-
src/bin/pg_basebackup/po/de.po   |  511 ++--
src/bin/pg_basebackup/po/fr.po   |  829 +++---
src/bin/pg_basebackup/po/ru.po   |  299 +-
src/bin/pg_basebackup/po/sv.po   |  498 ++--
src/bin/pg_checksums/po/sv.po|4 +-
src/bin/pg_config/po/sv.po   |6 +-
src/bin/pg_controldata/po/sv.po  |6 +-
src/bin/pg_ctl/po/sv.po  |  262 +-
src/bin/pg_dump/po/de.po |  422 +--
src/bin/pg_dump/po/fr.po | 1137 +++
src/bin/pg_dump/po/ru.po |  426 +--
src/bin/pg_dump/po/sv.po |   12 +-
src/bin/pg_resetwal/po/sv.po |6 +-
src/bin/pg_rewind/po/sv.po   |6 +-
src/bin/pg_test_fsync/po/sv.po   |6 +-
src/bin/pg_test_timing/po/sv.po  |6 +-
src/bin/pg_upgrade/po/ru.po  |8 +-
src/bin/pg_upgrade/po/sv.po  |   14 +-
src/bin/pg_verifybackup/po/sv.po |  108 +-
src/bin/pg_waldump/po/sv.po  |   90 +-
src/bin/psql/po/de.po|  635 ++--
src/bin/psql/po/fr.po|  666 +++--
src/bin/psql/po/ru.po|  642 ++--
src/bin/psql/po/sv.po|  195 +-
src/bin/scripts/po/ru.po |6 +-
src/bin/scripts/po/sv.po |   12 +-
src/interfaces/ecpg/ecpglib/po/sv.po |8 +-
src/interfaces/ecpg/preproc/po/sv.po |4 +-
src/interfaces/libpq/po/de.po|  172 +-
src/interfaces/libpq/po/fr.po|  280 +-
src/interfaces/libpq/po/ru.po|  103 +-
src/interfaces/libpq/po/sv.po|  116 +-
src/pl/plperl/po/ru.po   |   88 +-
src/pl/plperl/po/sv.po   |6 +-
src/pl/plpgsql/src/po/sv.po  |  290 +-
src/pl/plpython/po/sv.po |   34 +-
src/pl/tcl/po/sv.po  |   32 +-
43 files changed, 8120 insertions(+), 7941 deletions(-)