pgsql: PDF docs build: avoid spurious "warn" in build logs.

2025-02-07 Thread Tom Lane
PDF docs build: avoid spurious "warn" in build logs. Improve on e4c886519 so that the string "warn" appears in the output when there's a problem, and not when there isn't. This should silence noise I've been seeing in my buildfarm warning scraper. Branch -- master Details --- https://git

pgsql: Fix pgbench performance issue induced by commit af35fe501.

2025-02-07 Thread Tom Lane
Fix pgbench performance issue induced by commit af35fe501. Commit af35fe501 caused "pgbench -i" to emit a '\r' character for each data row loaded (when stderr is a terminal). That's effectively invisible on-screen, but it causes the connected terminal program to consume a lot of cycles. It's even

pgsql: Fix pgbench performance issue induced by commit af35fe501.

2025-02-07 Thread Tom Lane
Fix pgbench performance issue induced by commit af35fe501. Commit af35fe501 caused "pgbench -i" to emit a '\r' character for each data row loaded (when stderr is a terminal). That's effectively invisible on-screen, but it causes the connected terminal program to consume a lot of cycles. It's even

pgsql: Fix pgbench performance issue induced by commit af35fe501.

2025-02-07 Thread Tom Lane
Fix pgbench performance issue induced by commit af35fe501. Commit af35fe501 caused "pgbench -i" to emit a '\r' character for each data row loaded (when stderr is a terminal). That's effectively invisible on-screen, but it causes the connected terminal program to consume a lot of cycles. It's even

pgsql: Fix pgbench performance issue induced by commit af35fe501.

2025-02-07 Thread Tom Lane
Fix pgbench performance issue induced by commit af35fe501. Commit af35fe501 caused "pgbench -i" to emit a '\r' character for each data row loaded (when stderr is a terminal). That's effectively invisible on-screen, but it causes the connected terminal program to consume a lot of cycles. It's even

pgsql: Fix pgbench performance issue induced by commit af35fe501.

2025-02-07 Thread Tom Lane
Fix pgbench performance issue induced by commit af35fe501. Commit af35fe501 caused "pgbench -i" to emit a '\r' character for each data row loaded (when stderr is a terminal). That's effectively invisible on-screen, but it causes the connected terminal program to consume a lot of cycles. It's even

pgsql: Fix pgbench performance issue induced by commit af35fe501.

2025-02-07 Thread Tom Lane
Fix pgbench performance issue induced by commit af35fe501. Commit af35fe501 caused "pgbench -i" to emit a '\r' character for each data row loaded (when stderr is a terminal). That's effectively invisible on-screen, but it causes the connected terminal program to consume a lot of cycles. It's even

pgsql: Doc: clarify behavior of timestamptz input some more.

2025-02-07 Thread Tom Lane
Doc: clarify behavior of timestamptz input some more. Try to make it absolutely plain that we don't retain the originally specified time zone, only the UTC timestamp. While at it, make glossary entries for "UTC" and "GMT". Author: Robert Treat Co-authored-by: Tom Lane Discussion: https://post

pgsql: Doc: clarify behavior of timestamptz input some more.

2025-02-07 Thread Tom Lane
Doc: clarify behavior of timestamptz input some more. Try to make it absolutely plain that we don't retain the originally specified time zone, only the UTC timestamp. While at it, make glossary entries for "UTC" and "GMT". Author: Robert Treat Co-authored-by: Tom Lane Discussion: https://post

pgsql: Doc: clarify behavior of timestamptz input some more.

2025-02-07 Thread Tom Lane
Doc: clarify behavior of timestamptz input some more. Try to make it absolutely plain that we don't retain the originally specified time zone, only the UTC timestamp. While at it, make glossary entries for "UTC" and "GMT". Author: Robert Treat Co-authored-by: Tom Lane Discussion: https://post

pgsql: Doc: clarify behavior of timestamptz input some more.

2025-02-07 Thread Tom Lane
Doc: clarify behavior of timestamptz input some more. Try to make it absolutely plain that we don't retain the originally specified time zone, only the UTC timestamp. While at it, make glossary entries for "UTC" and "GMT". Author: Robert Treat Co-authored-by: Tom Lane Discussion: https://post

pgsql: Doc: clarify behavior of timestamptz input some more.

2025-02-07 Thread Tom Lane
Doc: clarify behavior of timestamptz input some more. Try to make it absolutely plain that we don't retain the originally specified time zone, only the UTC timestamp. While at it, make glossary entries for "UTC" and "GMT". Author: Robert Treat Co-authored-by: Tom Lane Discussion: https://post

pgsql: Doc: clarify behavior of timestamptz input some more.

2025-02-07 Thread Tom Lane
Doc: clarify behavior of timestamptz input some more. Try to make it absolutely plain that we don't retain the originally specified time zone, only the UTC timestamp. While at it, make glossary entries for "UTC" and "GMT". Author: Robert Treat Co-authored-by: Tom Lane Discussion: https://post

pgsql: First-draft release notes for 17.3.

2025-02-07 Thread Tom Lane
First-draft release notes for 17.3. As usual, the release notes for other branches will be made by cutting these down, but put them up for community review first. Branch -- REL_17_STABLE Details --- https://git.postgresql.org/pg/commitdiff/572ec03cbec4690eeb5c1047b378626fe475d218 Modifi

pgsql: meson: Fix linking using old OpenSSL lib names

2025-02-07 Thread Daniel Gustafsson
meson: Fix linking using old OpenSSL lib names Before OpenSSL 1.1.0 the legacy names ssleay32 and libeay32 were still used on Windows, and while we have support for this auto- conf the meson buildsystem only used the new names on all plat- forms. This adds support for the old name scheme when bui

pgsql: meson: Fix linking using old OpenSSL lib names

2025-02-07 Thread Daniel Gustafsson
meson: Fix linking using old OpenSSL lib names Before OpenSSL 1.1.0 the legacy names ssleay32 and libeay32 were still used on Windows, and while we have support for this auto- conf the meson buildsystem only used the new names on all plat- forms. This adds support for the old name scheme when bui

pgsql: Support non-btree indexes for foreign keys

2025-02-07 Thread Peter Eisentraut
Support non-btree indexes for foreign keys Previously, only btrees were supported as the referenced unique index for foreign keys because there was no way to get the equality strategy number for other index methods. We have this now (commit c09e5a6a016), so we can support this. In fact, this is

pgsql: Allow non-btree speculative insertion indexes

2025-02-07 Thread Peter Eisentraut
Allow non-btree speculative insertion indexes Previously, only btrees were supported as the arbiter index for speculative insertion because there was no way to get the equality strategy number for other index methods. We have this now (commit c09e5a6a016), so we can support this. At the moment,

pgsql: Virtual generated columns

2025-02-07 Thread Peter Eisentraut
Virtual generated columns This adds a new variant of generated columns that are computed on read (like a view, unlike the existing stored generated columns, which are computed on write, like a materialized view). The syntax for the column definition is ... GENERATED ALWAYS AS (...) VIRTUAL

pgsql: Track unpruned relids to avoid processing pruned relations

2025-02-07 Thread Amit Langote
Track unpruned relids to avoid processing pruned relations This commit introduces changes to track unpruned relations explicitly, making it possible for top-level plan nodes, such as ModifyTable and LockRows, to avoid processing partitions pruned during initial pruning. Scan-level nodes, such as