pgsql: Suppress useless wakeups in walreceiver.

Suppress useless wakeups in walreceiver. Instead of waking up 10 times per second to check for various timeout conditions, keep track of when we next have periodic work to do. Author: Thomas Munro Author: Nathan Bossart Reviewed-by: Kyotaro Horiguchi Reviewed-by: Bharath Rupireddy Reviewed-by

pgsql: psql: Add information in \d+ about foreign partitions and child

psql: Add information in \d+ about foreign partitions and child tables \d+ is already able to show if a partition or a child table is "PARTITIONED" via its relkind, hence the addition of a keyword for "FOREIGN" in the relation description is basically free. Author: Ian Lawrence Barwick Reviewed-b

pgsql: Use pg_pwrite_zeros() in walmethods.c

Use pg_pwrite_zeros() in walmethods.c This change impacts pg_receivewal and pg_basebackup, for the pre-padding with zeros of all the new non-compressed WAL segments, so as the code is more robust on partial writes. This makes the code consistent with the backend (XLogFileInitInternal) when wal_in

pgsql: Introduce pg_pwrite_zeros() in fileutils.c

Introduce pg_pwrite_zeros() in fileutils.c This routine is designed to write zeros to a file using vectored I/O, for a size given by its caller, being useful when it comes to initializing a file with a final size already known. XLogFileInitInternal() in xlog.c is changed to use this new routine w

pgsql: Fix initialization of pg_stat_get_lastscan()

Fix initialization of pg_stat_get_lastscan() A NULL result should be reported when a stats timestamp is set to 0, but c037471 missed that, leading to a confusing timestamp value after for example a DML on a freshly-created relation with no scans done on it yet. This impacted the following attribu

Re: pgsql: Resolve partition strategy during early parsing

On Sat, 5 Nov 2022 at 05:19, Justin Pryzby wrote: > [16:10:46.225] c:\cirrus\src\backend\parser\gram.y(18435) : warning C4715: > 'parsePartitionStrategy': not all control paths return a value I noticed this too. I've just pushed a patch to fix it. David

pgsql: Fix compiler warning on MSVC

Fix compiler warning on MSVC MSVC does not understand that ereport(ERROR) does not return, so just return the first enum PartitionStrategy value to keep the compiler from complaining about the missing return. Discussion: https://postgr.es/m/20221104161934.gb16...@telsasoft.com Branch -- mast

pgsql: Stamp 10.23.

Stamp 10.23. Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4 Modified Files -- configure| 18 +- configure.in | 2 +- doc/bug.template

pgsql: Stamp 11.18.

Stamp 11.18. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/eb3ff8600bd313071838ab376dd5c35524937242 Modified Files -- configure| 18 +- configure.in | 2 +- doc/bug.template

pgsql: Stamp 12.13.

Stamp 12.13. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/26b9b5dddfa21ce73d9b99e79e2336c5584745bd Modified Files -- configure| 18 +- configure.in | 2 +- src/include/pg_config.h.win32

pgsql: Stamp 13.9.

Stamp 13.9. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b664e3552b800b480e2b4fadd847f8b312e00642 Modified Files -- configure| 18 +- configure.in | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 14.6.

Stamp 14.6. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6dde6ed3efb4baaa0955f78ba5c93e9490aaa490 Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 15.1.

Stamp 15.1. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/c5dc80c1bc216f0e21a2f79f5e0415c2d4cfb35d Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Translation updates

Translation updates Source-Git-URL: ssh://g...@git.postgresql.org/pgtranslation/messages.git Source-Git-Hash: 0a578288026cfaae6b3d120b3ecf719aaa94dfdc Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/0bc9872b1106fa5cdd488bc0ddafb270b2e7540a Modified Files ---

pgsql: Last-minute updates for release notes.

Last-minute updates for release notes. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b7f9c762a8e10a64866309b64b785a4496bcd194 Modified Files -- doc/src/sgml/release-15.sgml | 42 ++ 1 file changed, 42 inser

pgsql: Fix failure to remove non-first segments of temporary tables.

Fix failure to remove non-first segments of temporary tables. Commit 4ab5dae94 broke mdunlinkfork's logic for removing additional segments of a multi-gigabyte table, because it neglected to advance "segno" after unlinking the first segment, in the code path where it chooses to unlink that one imme

pgsql: Fix failure to remove non-first segments of temporary tables.

Fix failure to remove non-first segments of temporary tables. Commit 4ab5dae94 broke mdunlinkfork's logic for removing additional segments of a multi-gigabyte table, because it neglected to advance "segno" after unlinking the first segment, in the code path where it chooses to unlink that one imme

pgsql: Translation updates

Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: e10eebf472d24554d5f1a3a854f8c47508225b2d Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/953a0346f43cbd69bef85513765d7cc621ac81e7 Modified Files --

pgsql: Translation updates

Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: f491e594cbaa7be0f786199e48f44bf0d55c9c8b Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/7134af1149247d956d32c994fa00a844f2bdc796 Modified Files --

pgsql: Translation updates

Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: 93ab2efcf9d6fb34739c57e61d57ae37e1fb03d3 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5680c5de322de1d7c0a7c657231bc252e5c471ef Modified Files --

pgsql: Translation updates

Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: cb81d65ab5de3d0a84d73bdf72d3c97bf5ea596b Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d26829e3f76ac58872bd57374cce6bd41d1e40cf Modified Files --

pgsql: Translation updates

Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: a2d024d57415123f7c9c6e7a71796c7cee8cabc6 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9c5cbed95e3761d36c1b8cdf89cb1e1f1a8aca9a Modified Files --

pgsql: Translation updates

Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: ff92e39b5698b83b8f5290094153a59df3056a1a Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/81b2ffdb32385366aa45b13e669b7d1291770af0 Modified Files --