pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Revert "Avoid creating archive status ".ready" files too early"

2021-09-04 Thread Alvaro Herrera
Revert "Avoid creating archive status ".ready" files too early" This reverts commit 515e3d84a0b5 and equivalent commits in back branches. This solution to the problem has a number of problems, so we'll try again with a different approach. Per note from Andres Freund Discussion: https://postgr.

pgsql: Minor improvements for psql help output.

2021-09-04 Thread Tom Lane
Minor improvements for psql help output. Fix alphabetization of the output of "\?", and improve one description. Update PageOutput counts where needed, fixing breakage from previous patches. Haiying Tang (PageOutput fixes by me) Discussion: https://postgr.es/m/os0pr01mb61136018064660f095cb57a8

pgsql: Minor improvements for psql help output.

2021-09-04 Thread Tom Lane
Minor improvements for psql help output. Fix alphabetization of the output of "\?", and improve one description. Update PageOutput counts where needed, fixing breakage from previous patches. Haiying Tang (PageOutput fixes by me) Discussion: https://postgr.es/m/os0pr01mb61136018064660f095cb57a8

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t

pgsql: Further portability tweaks for float4/float8 hash functions.

2021-09-04 Thread Tom Lane
Further portability tweaks for float4/float8 hash functions. Attempting to make hashfloat4() look as much as possible like hashfloat8(), I'd figured I could replace NaNs with get_float4_nan() before widening to float8. However, results from protosciurus and topminnow show that on some platforms t