pgsql: doc: Improve description of min_dynamic_shared_memory

2020-12-29 Thread Michael Paquier
doc: Improve description of min_dynamic_shared_memory While on it, fix one oversight in 90fbf7c, that introduced a reference to an incorrect value for the compression level of pg_dump. Author: Justin Pryzby Reviewed-by: Thomas Munro, Michael Paquier Discussion: https://postgr.es/m/ca+hukgjrtlwwp

pgsql: doc: Improve some grammar and sentences

2020-12-29 Thread Michael Paquier
doc: Improve some grammar and sentences 90fbf7c has taken care of that for HEAD. This includes the portion of the fixes that applies to the documentation, where needed depending on the branch. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-th

pgsql: doc: Improve some grammar and sentences

2020-12-29 Thread Michael Paquier
doc: Improve some grammar and sentences 90fbf7c has taken care of that for HEAD. This includes the portion of the fixes that applies to the documentation, where needed depending on the branch. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-th

pgsql: doc: Improve some grammar and sentences

2020-12-29 Thread Michael Paquier
doc: Improve some grammar and sentences 90fbf7c has taken care of that for HEAD. This includes the portion of the fixes that applies to the documentation, where needed depending on the branch. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-th

pgsql: doc: Improve some grammar and sentences

2020-12-29 Thread Michael Paquier
doc: Improve some grammar and sentences 90fbf7c has taken care of that for HEAD. This includes the portion of the fixes that applies to the documentation, where needed depending on the branch. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-th

pgsql: doc: Improve some grammar and sentences

2020-12-29 Thread Michael Paquier
doc: Improve some grammar and sentences 90fbf7c has taken care of that for HEAD. This includes the portion of the fixes that applies to the documentation, where needed depending on the branch. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-th

pgsql: doc: Improve some grammar and sentences

2020-12-29 Thread Michael Paquier
doc: Improve some grammar and sentences 90fbf7c has taken care of that for HEAD. This includes the portion of the fixes that applies to the documentation, where needed depending on the branch. Author: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-th

pgsql: Implement operators for checking if the range contains a multira

2020-12-29 Thread Alexander Korotkov
Implement operators for checking if the range contains a multirange We have operators for checking if the multirange contains a range but don't have the opposite. This commit improves completeness of the operator set by adding two new operators: @> (anyrange,anymultirange) and <@(anymultirange,an

pgsql: Add support of multirange matching to the existing range GiST in

2020-12-29 Thread Alexander Korotkov
Add support of multirange matching to the existing range GiST indexes 6df7a9698b has introduced a set of operators between ranges and multiranges. Existing GiST indexes for ranges could easily support majority of them. This commit adds support for new operators to the existing range GiST indexes.

pgsql: Fix bugs in comparison functions for multirange_bsearch_match()

2020-12-29 Thread Alexander Korotkov
Fix bugs in comparison functions for multirange_bsearch_match() Two functions multirange_range_overlaps_bsearch_comparison() and multirange_range_contains_bsearch_comparison() contain bugs of returning -1 instead of 1. This commit fixes these bugs and adds corresponding regression tests. Branch

pgsql: Improve the signature of internal multirange functions

2020-12-29 Thread Alexander Korotkov
Improve the signature of internal multirange functions There is a set of *_internal() functions exposed in include/utils/multirangetypes.h. This commit improves the signatures of these functions in two ways. * Add const qualifies where applicable. * Replace multirange typecache argument with ra

Re: pgsql: Add support of multirange matching to the existing range GiST in

2020-12-29 Thread Alexander Korotkov
On Tue, Dec 29, 2020 at 11:45 PM Alexander Korotkov wrote: > Add support of multirange matching to the existing range GiST indexes I accidentally squash here a commit which implements GiST multirange indexes. That commit was intended to go separately with its own commit message below. Sorry for

pgsql: Suppress log spam from multiple reports of SIGQUIT shutdown.

2020-12-29 Thread Tom Lane
Suppress log spam from multiple reports of SIGQUIT shutdown. When the postmaster sends SIGQUIT to its children, there's no real need for all the children to log that fact; the postmaster already made a log entry about it, so adding perhaps dozens or hundreds of child-process log entries adds nothi

Re: pgsql: Multirange datatypes

2020-12-29 Thread Tom Lane
Alexander Korotkov writes: > Multirange datatypes Multiple buildfarm members are issuing similar warnings about multirangetypes.c: calliphoridae | 2020-12-29 23:10:11 | /home/andres/build/buildfarm-calliphoridae/HEAD/pgsql.build/../pgsql/src/backend/utils/adt/multirangetypes.c:218:37: warning

pgsql: Doc: fix up PDF build warnings from over-width table columns.

2020-12-29 Thread Tom Lane
Doc: fix up PDF build warnings from over-width table columns. Addition of multirange info to tables 8.27 and 65.1 made them start throwing "exceed the available area" warnings in PDF docs builds. For 8.27, twiddling the existing column width hints was enough to fix this. For 65.1, I twiddled the

pgsql: Remove references to libpq_srcdir in adminpack and old_snapshot

2020-12-29 Thread Michael Paquier
Remove references to libpq_srcdir in adminpack and old_snapshot Those two modules included references to libpq's source path, without using anything from libpq. Some copy-pastos done when each module was created are likely at the origin of those useless references (aecf5ee for old_snapshot, fe59e

Re: pgsql: Add support of multirange matching to the existing range GiST in

2020-12-29 Thread Michael Paquier
On Tue, Dec 29, 2020 at 11:53:14PM +0300, Alexander Korotkov wrote: > On Tue, Dec 29, 2020 at 11:45 PM Alexander Korotkov > wrote: >> Add support of multirange matching to the existing range GiST indexes > > I accidentally squash here a commit which implements GiST multirange > indexes. That co