pgsql: Enhance pg_stat_reset_single_table_counters function.

2021-09-01 Thread Fujii Masao
Enhance pg_stat_reset_single_table_counters function. This commit allows pg_stat_reset_single_table_counters() to reset statistics for a single relation shared across all databases in the cluster to zero. Bump catalog version. Author: B Sadhu Prasad Patro Reviewed-by: Mahendra Singh Thalor, Hima

pgsql: Optimize fileset usage in apply worker.

2021-09-01 Thread Amit Kapila
Optimize fileset usage in apply worker. Use one fileset for the entire worker lifetime instead of using separate filesets for each streaming transaction. Now, the changes/subxacts files for every streaming transaction will be created under the same fileset and the files will be deleted after the t

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- REL_12_STABLE Details --

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- master Details --- https

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- REL_14_STABLE Details --

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- REL_11_STABLE Details --

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- REL_10_STABLE Details --

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- REL_13_STABLE Details --

pgsql: doc: Replace some uses of "which" by "that" in parallel.sgml

2021-09-01 Thread Michael Paquier
doc: Replace some uses of "which" by "that" in parallel.sgml This makes the documentation more accurate grammatically. Author: Elena Indrupskaya Discussion: https://postgr.es/m/[email protected] Backpatch-through: 9.6 Branch -- REL9_6_STABLE Details --

pgsql: Use COPY FREEZE in pgbench for faster benchmark table population

2021-09-01 Thread Tatsuo Ishii
Use COPY FREEZE in pgbench for faster benchmark table population. While populating the pgbench_accounts table, plain COPY was unconditionally used. By changing it to COPY FREEZE, the time for VACUUM is significantly reduced, thus the total time of "pgbench -i" is also reduced. This only happens if

pgsql: Doc: clarify how triggers relate to transactions.

2021-09-01 Thread Tom Lane
Doc: clarify how triggers relate to transactions. Laurenz Albe, per gripe from Nathan Long. Discussion: https://postgr.es/m/[email protected] Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/95bc40f880a68dc092ca34c

pgsql: Doc: clarify how triggers relate to transactions.

2021-09-01 Thread Tom Lane
Doc: clarify how triggers relate to transactions. Laurenz Albe, per gripe from Nathan Long. Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/469150a240dd79acbe7d86cb5df869

pgsql: Refactor postgresImportForeignSchema to avoid code duplication.

2021-09-01 Thread Tom Lane
Refactor postgresImportForeignSchema to avoid code duplication. Avoid repeating fragments of the query we're building, along the same lines as recent cleanup in pg_dump. I got annoyed about this because aa769f80e broke my pending patch to change postgres_fdw's collation handling, due to each of u

pgsql: Identify simple column references in extended statistics

2021-09-01 Thread Tomas Vondra
Identify simple column references in extended statistics Until now, when defining extended statistics, everything except a plain column reference was treated as complex expression. So for example "a" was a column reference, but "(a)" would be an expression. In most cases this does not matter much,

pgsql: Identify simple column references in extended statistics

2021-09-01 Thread Tomas Vondra
Identify simple column references in extended statistics Until now, when defining extended statistics, everything except a plain column reference was treated as complex expression. So for example "a" was a column reference, but "(a)" would be an expression. In most cases this does not matter much,

Re: pgsql: Improve defaults shown in postgresql.conf.sample and pg_settings

2021-09-01 Thread Andrew Dunstan
On 8/23/21 12:34 PM, Bruce Momjian wrote: > > Backpatch-through: master > > This seems like an oxymoron. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com

pgsql: Improve tab-completion for CREATE PUBLICATION.

2021-09-01 Thread Fujii Masao
Improve tab-completion for CREATE PUBLICATION. Author: Peter Smith Reviewed-by: Vignesh C Discussion: https://postgr.es/m/CAHut+Ps-vkmnWAShWSRVCB3gx8aM=bfodqwgbntzofk0q1l...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b0c066297bdac901a13a5a900a19

pgsql: Fix incorrect format placeholders

2021-09-01 Thread Peter Eisentraut
Fix incorrect format placeholders Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/590ecd982304dec8599d6ca339903982d39a9a1a Modified Files -- src/backend/access/brin/brin_minmax_multi.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: pgbench: Fix bug in measurement of disconnection delays.

2021-09-01 Thread Fujii Masao
pgbench: Fix bug in measurement of disconnection delays. When -C/--connect option is specified, pgbench establishes and closes the connection for each transaction. In this case pgbench needs to measure the times taken for all those connections and disconnections, to include the average connection

pgsql: pgbench: Fix bug in measurement of disconnection delays.

2021-09-01 Thread Fujii Masao
pgbench: Fix bug in measurement of disconnection delays. When -C/--connect option is specified, pgbench establishes and closes the connection for each transaction. In this case pgbench needs to measure the times taken for all those connections and disconnections, to include the average connection