Архив рассылок [pgsql-hackers]

1 ноября

• 00:00   Re: display hot standby state in psql prompt Jim Jones
• 00:13   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Thomas Munro
• 00:17   Re: pg_plan_advice Alastair Turner
• 00:30   Re: Change initdb default to the builtin collation provider Jeff Davis
• 00:38   Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada
• 00:40   Re: Updating IPC::Run in CI? Jacob Champion
• 00:55   Re: Updating IPC::Run in CI? Andres Freund
• 00:56   Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio
• 01:29   Re: [PATCH] Add pg_get_type_ddl() to retrieve the CREATE TYPE statement Philip Alger
• 01:52   Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jacob Champion
• 01:54   Re: Updating IPC::Run in CI? Jacob Champion
• 02:09   Re: [PATCH] Add pg_get_type_ddl() to retrieve the CREATE TYPE statement Chao Li
• 04:18   Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) Corey Huinker
• 04:50   Re: another autovacuum scheduling thread David Rowley
• 06:29   Re: another autovacuum scheduling thread David Rowley
• 07:40   Re: [PATCH] Add Windows support for backtrace_functions (MSVC only) Bryan Green
• 08:15   Re: Logical Replication of sequences vignesh C
• 08:21   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Thomas Munro
• 11:00   Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin
• 14:18   postgres_fdw: Add more test coverage for EvalPlanQual testing Etsuro Fujita
• 14:25   Obsolete comment in ExecScanReScan() Etsuro Fujita
• 15:42   Re: Adding REPACK [concurrently] jian he
• 15:50   Re: contrib/sepgsql regression tests have been broken for months Joe Conway
• 15:53   Re: Adding REPACK [concurrently] Sergei Kornilov
• 16:43   Re: contrib/sepgsql regression tests have been broken for months Andrew Dunstan
• 16:51   Re: Missing parentheses Marcos Pegoraro
• 17:29   Re: Missing parentheses Bruce Momjian
• 17:33   Re: Missing parentheses Marcos Pegoraro
• 18:31   Re: [PATCH] Add Windows support for backtrace_functions (MSVC only) Euler Taveira
• 18:49   Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler
• 19:10   Re: pg_plan_advice Hannu Krosing
• 20:04   Re: [PATCH] Fix LTREE subpath with negative offset Tom Lane
• 20:44   Re: [PATCH] Add pg_get_type_ddl() to retrieve the CREATE TYPE statement Philip Alger
• 21:03   Re: Unused variable in perl test Tom Lane
• 21:16   Re: Adding REPACK [concurrently] Mihail Nikalayeu
• 23:11   Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Tom Lane
• 23:23   Fix typo in Vietnamese translation file Joshua Shanks
• 23:41   Re: Optimize LISTEN/NOTIFY Arseniy Mukhin

2 ноября

• 01:28   Re: Improving the names generated for indexes on expressions Tom Lane
• 02:49   [PATCH] Add error message for out-of-memory in passwordFromFile() Joshua Shanks
• 03:09   Re: [PATCH] Add error message for out-of-memory in passwordFromFile() Michael Paquier
• 03:30   Re: Channel binding for post-quantum cryptography Michael Paquier
• 03:55   Re: [PG19-3 PATCH] Don't ignore passfile Paul Ohlhauser
• 08:24   Re: [PATCH] Add Windows support for backtrace_functions (MSVC only) Bryan Green
• 09:24   Re: Implement waiting for wal lsn replay: reloaded Xuneng Zhou
• 13:00   Re: Improve LWLock tranche name visibility across backends Alexander Lakhin
• 13:03   Re: Should HashSetOp go away David Rowley
• 15:27   Re: Bug in amcheck? Mihail Nikalayeu
• 15:33   Re: test_json_parser/002_inline is kind of slow Mihail Nikalayeu
• 16:05   C nitpick about pgwin32_dispatch_queued_signals() Christian Ullrich
• 17:59   Avoid overflow (src/backend/utils/adt/formatting.c) Ranier Vilela
• 18:11   Re: Include extension path on pg_available_extensions Michael Banck
• 18:29   Re: C nitpick about pgwin32_dispatch_queued_signals() Bryan Green
• 19:09   Re: Avoid overflow (src/backend/utils/adt/formatting.c) Bryan Green
• 19:22   Re: Avoid overflow (src/backend/utils/adt/formatting.c) Bryan Green
• 19:26   Re: Should HashSetOp go away Tom Lane
• 19:47   Re: C nitpick about pgwin32_dispatch_queued_signals() Tom Lane
• 19:50   Re: C nitpick about pgwin32_dispatch_queued_signals() Laurenz Albe
• 19:52   Re: C nitpick about pgwin32_dispatch_queued_signals() Bryan Green
• 20:05   Re: Decouple C++ support in Meson's PGXS from LLVM enablement Josef Šimánek
• 20:28   [PATCH] Add a guc parameter to control limit clause adjust path cost. Haiyang Li
• 20:34   Re: Unnecessary delay in streaming replication due to replay lag Josef Šimánek
• 20:44   Re: [PATCH] Add a guc parameter to control limit clause adjust path cost. Tom Lane
• 20:45   Re: [PATCH] Add a guc parameter to control limit clause adjust path cost. Bryan Green
• 21:11   Re: [PATCH] Add a guc parameter to control limit clause adjust path cost. Tom Lane
• 22:05   Re: Logical Replication of sequences vignesh C
• 23:07   Re: Improve LWLock tranche name visibility across backends Sami Imseih
• 23:29   Re: Fully documenting the design of nbtree row comparison scan keys Peter Geoghegan
• 23:35   Re: Improve LWLock tranche name visibility across backends Sami Imseih
• 23:35   Re: List TAP test files in makefiles Nazir Bilal Yavuz
• 23:40   Re: proposal: schema variables Pavel Stehule
• 23:56   Re: Making jsonb_agg() faster Tom Lane

3 ноября

• 00:12   Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Josef Šimánek
• 00:15   Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Josef Šimánek
• 00:29   Re: Should HashSetOp go away David Rowley
• 00:30   Re: Should HashSetOp go away Tom Lane
• 00:30   Y2038 BUG Bryan Green
• 01:33   Re: Fix typo in Vietnamese translation file Chao Li
• 01:48   Re: Y2038 BUG Tom Lane
• 01:52   Re: Fix typo in Vietnamese translation file Tom Lane
• 02:21   Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Noah Misch
• 02:30   Re: Fix typo in Vietnamese translation file Joshua Shanks
• 02:49   Re: index prefetching Peter Geoghegan
• 02:52   Re: ci: Improve OpenBSD core dump backtrace handling Thomas Munro
• 02:53   Re: Y2038 BUG Bryan Green
• 03:06   Re: index prefetching Tomas Vondra
• 03:31   Re: Avoid overflow (src/backend/utils/adt/formatting.c) Ranier Vilela
• 03:34   Re: Avoid overflow (src/backend/utils/adt/formatting.c) Ranier Vilela
• 04:18   Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Philip Alger
• 04:22   Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Philip Alger
• 04:30   Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Josef Šimánek
• 04:31   Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Josef Šimánek
• 05:09   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Thomas Munro
• 05:15   Add CHECK_FOR_INTERRUPTS in Evict{Rel,All}UnpinnedBuffers 邱宇航
• 05:20   Re: Implement waiting for wal lsn replay: reloaded Xuneng Zhou
• 07:40   Re: Add support for specifying tables in pg_createsubscriber. Shubham Khanna
• 08:26   Re: Import Statistics in postgres_fdw before resorting to sampling. Corey Huinker
• 08:43   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Tristan Partin
• 09:14   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Tom Lane
• 09:35   Re: Non-text mode for pg_dumpall Vaibhav Dalvi
• 09:37   Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Peter Smith
• 09:53   Re: Report bytes and transactions actually sent downtream Ashutosh Bapat
• 10:24   Re: Add support for specifying tables in pg_createsubscriber. Peter Smith
• 10:27   Use stack-allocated StringInfoData Mats Kindahl
• 10:47   Re: Consistently use the XLogRecPtrIsInvalid() macro Bertrand Drouvot
• 10:51   Re: Issue with logical replication slot during switchover Alexander Kukushkin
• 10:56   Re: Adding REPACK [concurrently] Antonin Houska
• 11:41   Re: [PoC] XMLCast (SQL/XML X025) Jim Jones
• 12:44   Re: How can end users know the cause of LR slot sync delays? shveta malik
• 12:49   Re: [PATCH] Add a guc parameter to control limit clause adjust path cost. ocean_li_996
• 12:54   Re: Report bytes and transactions actually sent downtream shveta malik
• 12:55   Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py Bertrand Drouvot
• 13:27   Re: Use stack-allocated StringInfoData David Rowley
• 13:33   Re: Improve pg_sync_replication_slots() to wait for primary to advance Ajin Cherian
• 13:35   Re: [PATCH] Add error message for out-of-memory in passwordFromFile() Michael Paquier
• 13:45   Re: Avoid overflow (src/backend/utils/adt/formatting.c) Bryan Green
• 13:50   Re: Add wal_fpi_bytes_[un]compressed to pg_stat_wal Michael Paquier
• 14:02   Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Heikki Linnakangas
• 14:14   Re: Logical Replication of sequences Amit Kapila
• 14:16   Re: Reorganize GUC structs Peter Eisentraut
• 14:21   Re: Docs and tests for RLS policies applied by command type Dean Rasheed
• 14:21   BRIN autosummarization lacking a snapshot Álvaro Herrera
• 14:36   Re: Avoid overflow (src/backend/utils/adt/formatting.c) Ranier Vilela
• 14:46   Re: Implement waiting for wal lsn replay: reloaded Alexander Korotkov
• 14:47   Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement Akshay Joshi
• 14:54   Re: 64 bit numbers vs format strings Thomas Munro
• 14:54   Re: Non-text mode for pg_dumpall Mahendra Singh Thalor
• 14:59   Re: Non-text mode for pg_dumpall Vaibhav Dalvi
• 15:14   Re: Fix comments for ChangeVarNodes() and related functions Peter Eisentraut
• 15:34   Re: 64 bit numbers vs format strings Wolfgang Walther
• 15:56   Re: Fix typo in Vietnamese translation file Álvaro Herrera
• 16:00   Re: Asynchronous MergeAppend Matheus Alcantara
• 16:24   Re: tuple radix sort John Naylor
• 16:33   Re: fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY Álvaro Herrera
• 16:38   Re: Making jsonb_agg() faster Chao Li
• 17:09   contrib/pg_stat_tcpinfo Jakub Wartak
• 17:13   Fix outdated comment of CopyStmt in gram.y cca5507
• 17:23   Re: Report bytes and transactions actually sent downtream Ashutosh Bapat
• 17:24   Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode Daniel Gustafsson
• 17:46   Re: AIX support AIX PG user
• 17:46   Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio
• 17:59   Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Andres Freund
• 17:59   Re: fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY Álvaro Herrera
• 18:06   Re: Implement waiting for wal lsn replay: reloaded Álvaro Herrera
• 18:12   [PATCH] Fix orphaned backend processes on Windows using Job Objects Bryan Green
• 18:13   Re: Implement waiting for wal lsn replay: reloaded Andres Freund
• 18:16   Re: Logical Replication of sequences vignesh C
• 18:19   Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects Andres Freund
• 18:20   Re: Report bytes and transactions actually sent downtream Andres Freund
• 18:25   Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects Bryan Green
• 18:29   Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects Andres Freund
• 18:41   Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio
• 18:59   Re: Confine vacuum skip logic to lazy_scan_skip Melanie Plageman
• 19:18   Re: pg_plan_advice Robert Haas
• 19:24   Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode Jacob Champion
• 19:34   Re: Intention to start an [oauth] "working group" Melanie Plageman
• 19:41   Re: pg_plan_advice Robert Haas
• 19:44   Re: Add \pset options for boolean value display Álvaro Herrera
• 19:53   Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode Zsolt Parragi
• 20:04   Re: Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup Jelte Fennema-Nio
• 20:16   Re: Add \pset options for boolean value display David G. Johnston
• 20:44   psql --help=variables missing csv_fieldsep Álvaro Herrera
• 20:50   Re: Improve LWLock tranche name visibility across backends Sami Imseih
• 20:57   Re: test_json_parser/002_inline is kind of slow Jacob Champion
• 20:59   Re: psql --help=variables missing csv_fieldsep Tom Lane
• 21:03   Re: psql --help=variables missing csv_fieldsep Tom Lane
• 21:36   Re: Fix outdated comment of CopyStmt in gram.y Masahiko Sawada
• 21:40   Re: Making jsonb_agg() faster Tom Lane
• 21:55   [PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation Pickett, Eshe N
• 21:56   Re: MSVC: Improve warning options set Peter Eisentraut
• 22:14   Re: Remaining dependency on setlocale() Daniel Verite
• 22:15   Re: MSVC: Improve warning options set Andres Freund
• 22:19   Re: [PG19-3 PATCH] Don't ignore passfile Jacob Champion
• 22:26   Re: MSVC: Improve warning options set Andres Freund
• 22:48   Re: Support getrandom() for pg_strong_random() source Masahiko Sawada
• 22:59   Re: Remaining dependency on setlocale() Jeff Davis
• 23:06   Re: Add CHECK_FOR_INTERRUPTS in Evict{Rel,All}UnpinnedBuffers Masahiko Sawada
• 23:06   Re: Eagerly evict bulkwrite strategy ring Melanie Plageman
• 23:20   Re: psql --help=variables missing csv_fieldsep Álvaro Herrera
• 23:20   Re: Use stack-allocated StringInfoData Mats Kindahl
• 23:38   Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) Matheus Alcantara
• 23:41   Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Mihail Nikalayeu
• 23:53   Re: psql --help=variables missing csv_fieldsep Tom Lane

4 ноября

• 00:27   Re: Resetting recovery target parameters in pg_createsubscriber Alexander Korotkov
• 00:32   Re: Use stack-allocated StringInfoData David Rowley
• 00:36   Re: [PATCH] Write Notifications Through WAL Rishu Bagga
• 00:36   ago(interval) → timestamptz Florents Tselai
• 00:45   Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Joel Jacobson
• 00:54   Re: Remaining dependency on setlocale() Jeff Davis
• 00:55   Re: Use merge-based matching for MCVs in eqjoinsel Tom Lane
• 01:12   Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects Bryan Green
• 01:47   Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) David Rowley
• 01:49   Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) David Rowley
• 01:52   Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Noah Misch
• 02:03   Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Mihail Nikalayeu
• 02:34   Re: Checkpointer write combining Melanie Plageman
• 02:49   Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement Manni Wood
• 03:27   Re: COPY WHERE clause generated/system column reference Masahiko Sawada
• 04:16   Re: pg_createsubscriber --dry-run logging concerns Peter Smith
• 04:29   Re: Report oldest xmin source when autovacuum cannot remove tuples Shinya Kato
• 04:43   Re: Should we say "wal_level = logical" instead of "wal_level >= logical" Peter Smith
• 05:44   Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis Peter Smith
• 06:35   Re: DOCS: What SGML markup to use for user objects like tables, columns, etc? Peter Smith
• 06:36   [PATCH] Add pretty formatting to pg_get_triggerdef Philip Alger
• 08:15   Re: [PATCH] Add error message for out-of-memory in passwordFromFile() Joshua Shanks
• 08:30   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Thomas Munro
• 08:38   Re: BRIN autosummarization lacking a snapshot Michael Paquier
• 08:55   Re: ago(interval) → timestamptz Laurenz Albe
• 09:02   Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions jian he
• 09:17   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Tristan Partin
• 09:23   Re: Improve pg_sync_replication_slots() to wait for primary to advance shveta malik
• 09:25   Re: meson's in-tree libpq header search order vs -Dextra_include_dirs Tristan Partin
• 09:50   Re: Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions Sadhuprasad Patro
• 10:03   Re: Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions Michael Paquier
• 10:13   Re: Extended Statistics set/restore/clear functions.[ Michael Paquier
• 10:19   Re: [PATCH] Add pretty formatting to pg_get_triggerdef Steven Niu
• 11:00   Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs Alexander Lakhin
• 11:25   Re: Use stack-allocated StringInfoData Mats Kindahl
• 11:27   Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement Jim Jones
• 11:47   Re: Extend injection_points_attach() to accept a user-defined function Rahila Syed
• 11:53   Re: ago(interval) → timestamptz Quan Zongliang
• 11:57   Extra blank line in StrategyGetBuffer Ashutosh Bapat
• 12:05   Fix redundant memset after palloc0 in heap_form_minimal_tuple() Chao Li
• 12:19   Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs Richard Guo
• 12:27   Re: Confine vacuum skip logic to lazy_scan_skip John Naylor
• 12:31   Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py Mats Kindahl
• 12:35   Re: [PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation John Naylor
• 12:40   Re: [PATCH] Add pretty formatting to pg_get_triggerdef Chao Li
• 12:47   Re: How can end users know the cause of LR slot sync delays? shveta malik
• 12:54   Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs David Rowley
• 12:59   Re: pg_createsubscriber --dry-run logging concerns Álvaro Herrera
• 13:00   Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs David Rowley
• 13:02   Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs Richard Guo
• 13:37   Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement Nishant Sharma