pgsql: Refactor and cleanup runtime partition prune code a little

2022-04-05 Thread Alvaro Herrera
Refactor and cleanup runtime partition prune code a little * Move the execution pruning initialization steps that are common between both ExecInitAppend() and ExecInitMergeAppend() into a new function ExecInitPartitionPruning() defined in execPartition.c. Those steps include creation of a Partitio

pgsql: Extend TAP tests of pg_dump to test for compression with gzip

2022-04-05 Thread Michael Paquier
Extend TAP tests of pg_dump to test for compression with gzip The test logic is extended with two new concepts: - Addition of a compression command called compress_cmd, executed between restore_cmd and dump_cmd to control the contents of the dumps. In the case of this commit, this is used to compr

Re: [COMMITTERS] pgsql: Allow time delayed standbys and recovery

2022-04-05 Thread Thom Brown
On Wed, 26 Feb 2014 at 13:55, Thom Brown wrote: > > On 26 February 2014 13:32, Simon Riggs wrote: >> >> On 26 February 2014 13:07, Thom Brown wrote: >> > On 19 December 2013 19:33, Simon Riggs wrote: >> >> >> >> On 19 December 2013 19:19, Thom Brown wrote: >> >> > On 12 December 2013 10:56, Si

pgsql: pg_rewind: Fetch small files according to new size.

2022-04-05 Thread Daniel Gustafsson
pg_rewind: Fetch small files according to new size. There's a race condition if a file changes in the source system after we have collected the file list. If the file becomes larger, we only fetched up to its original size. That can easily result in a truncated file. That's not a problem for rela

Re: pgsql: pg_rewind: Fetch small files according to new size.

2022-04-05 Thread Daniel Gustafsson
> On 5 Apr 2022, at 15:02, Daniel Gustafsson wrote: > > pg_rewind: Fetch small files according to new size. The buildfarm is less impressed than CI was, I’m collecting more feedback and will then fix. / daniel

pgsql: Have VACUUM warn on relfrozenxid "in the future".

2022-04-05 Thread Peter Geoghegan
Have VACUUM warn on relfrozenxid "in the future". Commits 74cf7d46 and a61daa14 fixed pg_upgrade bugs involving oversights in how relfrozenxid or relminmxid are carried forward or initialized. Corruption caused by bugs of this nature was ameliorated by commit 78db307bb2, which taught VACUUM to alw

pgsql: PLAN clauses for JSON_TABLE

2022-04-05 Thread Andrew Dunstan
PLAN clauses for JSON_TABLE These clauses allow the user to specify how data from nested paths are joined, allowing considerable freedom in shaping the tabular output of JSON_TABLE. PLAN DEFAULT allows the user to specify the global strategies when dealing with sibling or child nested paths. The

Re: pgsql: JSON_TABLE

2022-04-05 Thread Oleg Bartunov
On Tue, Apr 5, 2022 at 1:17 AM Erik Rijkers wrote: > > Op 04-04-2022 om 22:23 schreef Andrew Dunstan: > > JSON_TABLE > > Great that this is now committed! > > I notice one changed item: the NESTED-PATH-phrase does not accept an > alias anymore. The JSON_PATH v59 patches still had: > > | NESTED PA

Re: pgsql: JSON_TABLE

2022-04-05 Thread Oleg Bartunov
On Tue, Apr 5, 2022 at 1:31 AM Andrew Dunstan wrote: > > > On 4/4/22 18:16, Erik Rijkers wrote: > > Op 04-04-2022 om 22:23 schreef Andrew Dunstan: > >> JSON_TABLE > > > > Great that this is now committed! > > > > I notice one changed item: the NESTED-PATH-phrase does not accept an > > alias anymor

Re: pgsql: JSON_TABLE

2022-04-05 Thread Andrew Dunstan
On 4/5/22 15:05, Oleg Bartunov wrote: > On Tue, Apr 5, 2022 at 1:31 AM Andrew Dunstan wrote: >> >> On 4/4/22 18:16, Erik Rijkers wrote: >>> Op 04-04-2022 om 22:23 schreef Andrew Dunstan: JSON_TABLE >>> Great that this is now committed! >>> >>> I notice one changed item: the NESTED-PATH-phra

Re: pgsql: pg_rewind: Fetch small files according to new size.

2022-04-05 Thread Daniel Gustafsson
> On 5 Apr 2022, at 15:36, Daniel Gustafsson wrote: > >> On 5 Apr 2022, at 15:02, Daniel Gustafsson >> wrote: >> >> pg_rewind: Fetch small files according to new size. > > The buildfarm is less impressed than CI was, I’m collecting more feedback and > will then fix. Sorry for being slow, l

pgsql: Fix compilerwarning in logging size_t

2022-04-05 Thread Daniel Gustafsson
Fix compilerwarning in logging size_t The pg_fatal log which included filesizes were using UINT64_FORMAT for the size_t variables, which failed on 32 bit buildfarm animals. Change to using plain int instead, which is in line with how digestControlFile is doing it already. Per buildfarm animals fl

pgsql: Remove race condition in 022_crash_temp_files.pl test.

2022-04-05 Thread Tom Lane
Remove race condition in 022_crash_temp_files.pl test. It's possible for the query that "waits for restart" to complete a successful iteration before the postmaster has noticed its SIGKILL'd child and begun the restart cycle. (This is a bit hard to believe perhaps, but it's been seen at least twi

pgsql: Remove race condition in 022_crash_temp_files.pl test.

2022-04-05 Thread Tom Lane
Remove race condition in 022_crash_temp_files.pl test. It's possible for the query that "waits for restart" to complete a successful iteration before the postmaster has noticed its SIGKILL'd child and begun the restart cycle. (This is a bit hard to believe perhaps, but it's been seen at least twi

pgsql: Change aggregated log format of pgbench.

2022-04-05 Thread Tatsuo Ishii
Change aggregated log format of pgbench. Commit 4a39f87acd changed the aggregated log format. Problem is, now the explanatory paragraph for the log line in the document is too long. Also the log format included more optional columns, and it's harder to parse the log lines. This commit tries to so

pgsql: Improve comments for row filtering and toast interaction in logi

2022-04-05 Thread Amit Kapila
Improve comments for row filtering and toast interaction in logical replication. Reported-by: Antonin Houska Author: Amit Kapila Reviewed-by: Antonin Houska, Ajin Cherian Discussion: https://postgr.es/m/84638.1649152255@antos Branch -- master Details --- https://git.postgresql.org/pg/com

pgsql: Update Unicode data to CLDR 41

2022-04-05 Thread Peter Eisentraut
Update Unicode data to CLDR 41 No actual changes result. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/376dc437de40bd17e99a37f72f88627a16d7f200 Modified Files -- src/Makefile.global.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Allow asynchronous execution in more cases.

2022-04-05 Thread Etsuro Fujita
Allow asynchronous execution in more cases. In commit 27e1f1456, create_append_plan() only allowed the subplan created from a given subpath to be executed asynchronously when it was an async-capable ForeignPath. To extend coverage, this patch handles cases when the given subpath includes some oth