pgsql: Reintroduce dead tuple counter in pg_stat_progress_vacuum.

2024-06-13 Thread Masahiko Sawada
Reintroduce dead tuple counter in pg_stat_progress_vacuum. Commit 667e65aac3 changed both num_dead_tuples and max_dead_tuples columns to dead_tuple_bytes and max_dead_tuple_bytes columns, respectively. But as per discussion, the number of dead tuples collected still provides meaningful insights fo

pgsql: Fix parsing of ignored operators in websearch_to_tsquery().

2024-06-13 Thread Tom Lane
Fix parsing of ignored operators in websearch_to_tsquery(). The manual says clearly that punctuation in the input of websearch_to_tsquery() is ignored, except for the special cases of dashes and quotes. However, this failed for cases like "(foo bar) or something", or in general an ISOPERATOR char

pgsql: Fix parsing of ignored operators in websearch_to_tsquery().

2024-06-13 Thread Tom Lane
Fix parsing of ignored operators in websearch_to_tsquery(). The manual says clearly that punctuation in the input of websearch_to_tsquery() is ignored, except for the special cases of dashes and quotes. However, this failed for cases like "(foo bar) or something", or in general an ISOPERATOR char

pgsql: Fix parsing of ignored operators in websearch_to_tsquery().

2024-06-13 Thread Tom Lane
Fix parsing of ignored operators in websearch_to_tsquery(). The manual says clearly that punctuation in the input of websearch_to_tsquery() is ignored, except for the special cases of dashes and quotes. However, this failed for cases like "(foo bar) or something", or in general an ISOPERATOR char

pgsql: Fix parsing of ignored operators in websearch_to_tsquery().

2024-06-13 Thread Tom Lane
Fix parsing of ignored operators in websearch_to_tsquery(). The manual says clearly that punctuation in the input of websearch_to_tsquery() is ignored, except for the special cases of dashes and quotes. However, this failed for cases like "(foo bar) or something", or in general an ISOPERATOR char

pgsql: Fix parsing of ignored operators in websearch_to_tsquery().

2024-06-13 Thread Tom Lane
Fix parsing of ignored operators in websearch_to_tsquery(). The manual says clearly that punctuation in the input of websearch_to_tsquery() is ignored, except for the special cases of dashes and quotes. However, this failed for cases like "(foo bar) or something", or in general an ISOPERATOR char

pgsql: Fix parsing of ignored operators in websearch_to_tsquery().

2024-06-13 Thread Tom Lane
Fix parsing of ignored operators in websearch_to_tsquery(). The manual says clearly that punctuation in the input of websearch_to_tsquery() is ignored, except for the special cases of dashes and quotes. However, this failed for cases like "(foo bar) or something", or in general an ISOPERATOR char

pgsql: doc: Fix description WAL summarizer in glossary

2024-06-13 Thread Michael Paquier
doc: Fix description WAL summarizer in glossary The WAL summarizer is an auxiliary process. Oversight in 7b1dbf0a8d1d. Author: Masahiro Ikeda Discussion: https://postgr.es/m/d3a5a4278fd8d9e7a47c6aa4db9e9...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org/pg/comm

pgsql: doc: Fix description WAL writer in glossary

2024-06-13 Thread Michael Paquier
doc: Fix description WAL writer in glossary The WAL writer is an auxiliary process, but its description in the glossary did not match that. This is inexact since d3014fff4cd4. Author: Masahiro Ikeda Discussion: https://postgr.es/m/d3a5a4278fd8d9e7a47c6aa4db9e9...@oss.nttdata.com Backpatch-throug

pgsql: doc: Fix description WAL writer in glossary

2024-06-13 Thread Michael Paquier
doc: Fix description WAL writer in glossary The WAL writer is an auxiliary process, but its description in the glossary did not match that. This is inexact since d3014fff4cd4. Author: Masahiro Ikeda Discussion: https://postgr.es/m/d3a5a4278fd8d9e7a47c6aa4db9e9...@oss.nttdata.com Backpatch-throug

pgsql: doc: Fix description WAL writer in glossary

2024-06-13 Thread Michael Paquier
doc: Fix description WAL writer in glossary The WAL writer is an auxiliary process, but its description in the glossary did not match that. This is inexact since d3014fff4cd4. Author: Masahiro Ikeda Discussion: https://postgr.es/m/d3a5a4278fd8d9e7a47c6aa4db9e9...@oss.nttdata.com Backpatch-throug

pgsql: When replanning a plpgsql "simple expression", check it's still

2024-06-13 Thread Tom Lane
When replanning a plpgsql "simple expression", check it's still simple. The previous coding here assumed that we didn't need to recheck any of the querytree tests made in exec_simple_check_plan(). I think we supposed that those properties were fully determined by the syntax of the source text and

pgsql: When replanning a plpgsql "simple expression", check it's still

2024-06-13 Thread Tom Lane
When replanning a plpgsql "simple expression", check it's still simple. The previous coding here assumed that we didn't need to recheck any of the querytree tests made in exec_simple_check_plan(). I think we supposed that those properties were fully determined by the syntax of the source text and

pgsql: Improve the granularity of PQsocketPoll's timeout parameter.

2024-06-13 Thread Tom Lane
Improve the granularity of PQsocketPoll's timeout parameter. Commit f5e4dedfa exposed libpq's internal function PQsocketPoll without a lot of thought about whether that was an API we really wanted to chisel in stone. The main problem with it is the use of time_t to specify the timeout. While we

pgsql: When replanning a plpgsql "simple expression", check it's still

2024-06-13 Thread Tom Lane
When replanning a plpgsql "simple expression", check it's still simple. The previous coding here assumed that we didn't need to recheck any of the querytree tests made in exec_simple_check_plan(). I think we supposed that those properties were fully determined by the syntax of the source text and

pgsql: Clamp result of MultiXactMemberFreezeThreshold

2024-06-13 Thread Heikki Linnakangas
Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than pl

pgsql: Clamp result of MultiXactMemberFreezeThreshold

2024-06-13 Thread Heikki Linnakangas
Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than pl

pgsql: When replanning a plpgsql "simple expression", check it's still

2024-06-13 Thread Tom Lane
When replanning a plpgsql "simple expression", check it's still simple. The previous coding here assumed that we didn't need to recheck any of the querytree tests made in exec_simple_check_plan(). I think we supposed that those properties were fully determined by the syntax of the source text and

pgsql: When replanning a plpgsql "simple expression", check it's still

2024-06-13 Thread Tom Lane
When replanning a plpgsql "simple expression", check it's still simple. The previous coding here assumed that we didn't need to recheck any of the querytree tests made in exec_simple_check_plan(). I think we supposed that those properties were fully determined by the syntax of the source text and

pgsql: When replanning a plpgsql "simple expression", check it's still

2024-06-13 Thread Tom Lane
When replanning a plpgsql "simple expression", check it's still simple. The previous coding here assumed that we didn't need to recheck any of the querytree tests made in exec_simple_check_plan(). I think we supposed that those properties were fully determined by the syntax of the source text and

pgsql: Clamp result of MultiXactMemberFreezeThreshold

2024-06-13 Thread Heikki Linnakangas
Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than pl

pgsql: Clamp result of MultiXactMemberFreezeThreshold

2024-06-13 Thread Heikki Linnakangas
Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than pl

pgsql: Clamp result of MultiXactMemberFreezeThreshold

2024-06-13 Thread Heikki Linnakangas
Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than pl

pgsql: Clamp result of MultiXactMemberFreezeThreshold

2024-06-13 Thread Heikki Linnakangas
Clamp result of MultiXactMemberFreezeThreshold The purpose of the function is to reduce the effective autovacuum_multixact_freeze_max_age if the multixact members SLRU is approaching wraparound, to make multixid freezing more aggressive. The returned value should therefore never be greater than pl

pgsql: Skip some permissions checks on Cygwin

2024-06-13 Thread Andrew Dunstan
Skip some permissions checks on Cygwin These are checks that are already skipped on other Windows systems. Backpatch to all live branches, as appropriate. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/0e51485392c0c457de0709181a3d2bfdba6f3fb6 Modified File

pgsql: Skip some permissions checks on Cygwin

2024-06-13 Thread Andrew Dunstan
Skip some permissions checks on Cygwin These are checks that are already skipped on other Windows systems. Backpatch to all live branches, as appropriate. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f83908798f78c4cafda217ca875602c88ea2ae28 Modified Files -

pgsql: Skip some permissions checks on Cygwin

2024-06-13 Thread Andrew Dunstan
Skip some permissions checks on Cygwin These are checks that are already skipped on other Windows systems. Backpatch to all live branches, as appropriate. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/c38518fa978075d08d64a34e1b4504da13a81e02 Modified File

pgsql: Skip some permissions checks on Cygwin

2024-06-13 Thread Andrew Dunstan
Skip some permissions checks on Cygwin These are checks that are already skipped on other Windows systems. Backpatch to all live branches, as appropriate. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/ca947649208ce7343c54c8f92e67ea9274be812c Modified File

pgsql: Skip some permissions checks on Cygwin

2024-06-13 Thread Andrew Dunstan
Skip some permissions checks on Cygwin These are checks that are already skipped on other Windows systems. Backpatch to all live branches, as appropriate. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/57625308f62da2d4f875478a39158a23e41a3dbe Modified File

pgsql: Skip some permissions checks on Cygwin

2024-06-13 Thread Andrew Dunstan
Skip some permissions checks on Cygwin These are checks that are already skipped on other Windows systems. Backpatch to all live branches, as appropriate. Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/32c5dc0ebe83e927c953c42ad79148a03933c6ba Modified File

pgsql: Add postgres_inc to meson check for Python.h

2024-06-13 Thread Andrew Dunstan
Add postgres_inc to meson check for Python.h Required for Cygwin. Backpatch to release 16. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/11b9b8ce44a8cc80cbef6ade2b5ae7438227da79 Modified Files -- meson.build | 2 +- 1 file changed, 1 insertion(+), 1 d

pgsql: Add postgres_inc to meson check for Python.h

2024-06-13 Thread Andrew Dunstan
Add postgres_inc to meson check for Python.h Required for Cygwin. Backpatch to release 16. Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a13c7ee87b0ab31ecbf1a9e9302ee48b52d1cf9a Modified Files -- meson.build | 2 +- 1 file changed, 1 insertion(

pgsql: Fix documentation of initdb --show option

2024-06-13 Thread Peter Eisentraut
Fix documentation of initdb --show option It wasn't in the documentation at all (even though we document all the other debugging-like options). Also, change the --help output to show that it exits after showing, similar to other options. Branch -- master Details --- https://git.postgres

pgsql: Add missing source files to nls.mk

2024-06-13 Thread Peter Eisentraut
Add missing source files to nls.mk Files in common/ and fe_utils/ that contain translatable strings need to be listed in the nls.mk files of the programs that use them. (Not great, but that's the way it works for now.) This usually requires some manual analysis which is done about once during ea

Re: pgsql: Add missing source files to nls.mk

2024-06-13 Thread Peter Eisentraut
On 13.06.24 10:25, Peter Eisentraut wrote: Add missing source files to nls.mk Files in common/ and fe_utils/ that contain translatable strings need to be listed in the nls.mk files of the programs that use them. (Not great, but that's the way it works for now.) This usually requires some manua