pgsql: Re-update Unicode data to CLDR 39

2022-03-10 Thread Peter Eisentraut
Re-update Unicode data to CLDR 39 Apparently, the previous update (2e0e0666790e48cec716d4947f89d067ef53490c) must have used a stale input file and missed a few additions that were added shortly before the CLDR release. Update this now so that the next update really only changes things new in that

pgsql: dshash: Add sequential scan support.

2022-03-10 Thread Andres Freund
dshash: Add sequential scan support. Add ability to scan all entries sequentially to dshash. The interface is similar but a bit different both from that of dynahash and simple dshash search functions. The most significant differences is that dshash's interfac always needs a call to dshash_seq_term

Re: pgsql: dshash: Add sequential scan support.

2022-03-10 Thread Tom Lane
Andres Freund writes: > dshash: Add sequential scan support. > Add ability to scan all entries sequentially to dshash. The interface is > similar but a bit different both from that of dynahash and simple dshash > search functions. The most significant differences is that dshash's interfac > always

Re: pgsql: dshash: Add sequential scan support.

2022-03-10 Thread Andres Freund
Hi, On 2022-03-10 20:09:56 -0500, Tom Lane wrote: > Andres Freund writes: > > dshash: Add sequential scan support. > > Add ability to scan all entries sequentially to dshash. The interface is > > similar but a bit different both from that of dynahash and simple dshash > > search functions. The mo

pgsql: Fix header inclusion order in xloginsert.c with lz4.h

2022-03-10 Thread Michael Paquier
Fix header inclusion order in xloginsert.c with lz4.h Per project policy, all system and library headers need to be declared in the backend code after "postgres.h" and before the internal headers, but 4035cd5 broke this policy when adding support for LZ4 in wal_compression. Noticed while reviewin

pgsql: Add support for zstd with compression of full-page writes in WAL

2022-03-10 Thread Michael Paquier
Add support for zstd with compression of full-page writes in WAL wal_compression gains a new value, "zstd", to allow the compression of full-page images using the compression method of the same name. Compression is done using the default level recommended by the library, as of ZSTD_CLEVEL_DEFAULT

pgsql: doc: Standardize capitalization of term "hot standby"/"Hot Stand

2022-03-10 Thread Michael Paquier
doc: Standardize capitalization of term "hot standby"/"Hot Standby" "Hot Standby" was capitalized in a couple of places in the docs, as the style primarily used when it was introduced, but this has not been much respected across the years. Per discussion, it is more natural for the reader to use

pgsql: DefineCollation() code cleanup

2022-03-10 Thread Peter Eisentraut
DefineCollation() code cleanup Reorganize the code in DefineCollation() so that the parts using the FROM clause and the parts not doing so are more cleanly separated. No functionality change intended. Reviewed-by: Julien Rouhaud Discussion: https://www.postgresql.org/message-id/29ae752f-80e9-8