pgsql: New header varatt.h split off from postgres.h

2023-01-09 Thread Peter Eisentraut
New header varatt.h split off from postgres.h This new header contains all the variable-length data types support (TOAST support) from postgres.h, which isn't needed by large parts of the backend code. Reviewed-by: Tom Lane Discussion:

pgsql: Document the newly added wait events added by commit 216a784829.

2023-01-09 Thread Amit Kapila
Document the newly added wait events added by commit 216a784829. Author: Shinoda, Noriyoshi Reviewed-by: Hou Zhijie Discussion: https://postgr.es/m/dm4pr84mb173460530245f56364e1daf7ee...@dm4pr84mb1734.namprd84.prod.outlook.com Branch -- master Details ---

pgsql: Round off random_normal() test results one more decimal place.

2023-01-09 Thread Tom Lane
Round off random_normal() test results one more decimal place. As I suspected, some machines have even more low-order-bit inaccuracy than the ones I tested. Tweak new test so that (hopefully) it will pass everywhere. Per buildfarm. Discussion:

pgsql: Fix the display of lock information for specktoken.

2023-01-09 Thread Amit Kapila
Fix the display of lock information for specktoken. A transaction id is now displayed in the transactionid field and speculative insertion token is displayed in the objid field. Author: Sawada Masahiko Reviewed-by: Amit Kapila Discussion:

pgsql: Remove pg_regress' never-documented "ignore" feature.

2023-01-09 Thread Tom Lane
Remove pg_regress' never-documented "ignore" feature. We aren't using this anymore in the wake of commit 09d517773, so delete it. We can always revert this if some future use emerges, but I think our standards for test quality are now high enough that that will never happen. Discussion:

pgsql: Upgrade the random.sql regression test.

2023-01-09 Thread Tom Lane
Upgrade the random.sql regression test. We had some pretty ad-hoc and inefficient code here. To make matters worse, it didn't test the properties of the random() function very thoroughly, and it had a test failure rate of one in every few tens of thousands of runs. Replace the script altogether

pgsql: Doc: add XML ID attributes to and tags.

2023-01-09 Thread Tom Lane
Doc: add XML ID attributes to and tags. This doesn't have any external effect at the moment, but it will allow adding useful link-discoverability features later. Brar Piening, reviewed by Karl Pinc. Discussion:

pgsql: Invent random_normal() to provide normally-distributed random nu

2023-01-09 Thread Tom Lane
Invent random_normal() to provide normally-distributed random numbers. There is already a version of this in contrib/tablefunc, but it seems sufficiently widely useful to justify having it in core. Paul Ramsey Discussion:

pgsql: Remove redundant setting of tuplesort status

2023-01-09 Thread John Naylor
Remove redundant setting of tuplesort status Also add an explanatory comment to match other similar coding within tuplesort_performsort(). Xing Guo Reviewed by Richard Guo and Cary Huang Discussion:

pgsql: Fix the file mode of worker.c changed by the commit 216a784829.

2023-01-09 Thread Amit Kapila
Fix the file mode of worker.c changed by the commit 216a784829. Reported-by: Japin Li Discussion: https://postgr.es/m/meyp282mb166970d1559b7cc74d3e339bb6...@meyp282mb1669.ausp282.prod.outlook.com Branch -- master Details ---