pgsql-hackers since 2025-03-03 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

March 3, 2025

Thread Author Time
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 00:19
Re: Extend postgres_fdw_get_connections to return remote backend pid Fujii Masao 00:21
Fixing various typos in comments and docs 📎 Jacob Brazeal 00:39
Re: per backend WAL statistics Michael Paquier 01:48
Re: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier 01:51
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 01:53
Re: [PATCH] Add regression tests of ecpg command notice (error / warning) 📎 Fujii Masao 03:23
Re: [Patch] add new parameter to pg_replication_origin_session_setup Amit Kapila 03:38
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot Fujii Masao 04:10
Re: Add assertion for failed alloc to palloc0() and palloc_extended() Michael Paquier 04:13
Accidental assignment instead of compare in GetOperatorFromCompareType? 📎 Jacob Brazeal 05:05
Re: Accidental assignment instead of compare in GetOperatorFromCompareType? 📎 Jacob Brazeal 05:06
Re: [PATCH] Add regression tests of ecpg command notice (error / warning) Ryo Kanbayashi 05:09
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible 📎 Michael Paquier 05:23
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback Amit Kapila 05:26
Re: Accidental assignment instead of compare in GetOperatorFromCompareType? Michael Paquier 05:26
Re: Anti join confusion Richard Guo 07:34
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback 📎 Jakub Wartak 07:35
RE: long-standing data loss bug in initial sync of logical replication Zhijie Hou (Fujitsu) 07:41
Re: Anti join confusion Tender Wang 07:57
Selectively invalidate caches in pgoutput module 📎 Hayato Kuroda (Fujitsu) 07:57
Re: Allow io_combine_limit up to 1MB 📎 Thomas Munro 08:11
Re: MergeJoin beats HashJoin in the case of multiple hash clauses 📎 Andrei Lepikhov 08:24
Re: making EXPLAIN extensible Alena Rybakina 08:25
Re: bug when apply fast default mechanism for adding new column over domain with default value jian he 08:45
Re: Add an option to skip loading missing publication to avoid logical replication failure 📎 vignesh C 09:00
Re: long-standing data loss bug in initial sync of logical replication Benoit Lobréau 09:03
Re: tests for pg_stat_progress_copy.tuples_skipped 📎 Fujii Masao 09:05
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints 📎 Suraj Kharage 09:13
Re: per backend WAL statistics Bertrand Drouvot 09:17
Re: Selectively invalidate caches in pgoutput module Amit Kapila 09:23
Re: Parallel heap vacuum 📎 Masahiko Sawada 09:28
Re: Commit fest 2025-03 vignesh C 09:32
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback Fujii Masao 09:48
Re: SQL:2011 application time Peter Eisentraut 10:05
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎 Ajin Cherian 10:10
Re: Use Python "Limited API" in PL/Python Peter Eisentraut 10:17
Re: Introduce "log_connection_stages" setting. Sergey Dudoladov 10:43
Re: per backend WAL statistics 📎 Bertrand Drouvot 10:47
Re: SIMD optimization for list_sort John Naylor 10:48
Re: vacuumdb changes for stats import/export John Naylor 10:58
Re: Considering fractional paths in Append node 📎 Andrei Lepikhov 11:04
Re: Add an option to skip loading missing publication to avoid logical replication failure Amit Kapila 11:11
Re: Considering fractional paths in Append node Alena Rybakina 11:17
Re: [BUG]: the walsender does not update its IO statistics until it exits 📎 Bertrand Drouvot 11:54
Re: pg_stat_statements and "IN" conditions 📎 Álvaro Herrera 11:56
RE: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. Hayato Kuroda (Fujitsu) 12:29
Re: Add connection active, idle time to pg_stat_activity 📎 Sergey Dudoladov 12:29
Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw Ashutosh Bapat 12:51
Re: Sample rate added to pg_stat_statements 📎 Ilia Evdokimov 12:55
Re: pg_stat_statements and "IN" conditions Dmitry Dolgov 13:13
Re: making EXPLAIN extensible Matheus Alcantara 13:27
Re: RFC: Additional Directory for Extensions Gabriele Bartolini 13:39
Re: Add -k/--link option to pg_combinebackup 📎 Israel Barth Rubio 14:00
Re: Log connection establishment timings Bertrand Drouvot 14:07
Re: making EXPLAIN extensible Matthias van de Meent 14:14
Re: bug when apply fast default mechanism for adding new column over domain with default value 📎 jian he 14:20
Re: Introduce "log_connection_stages" setting. Melanie Plageman 14:40
Re: RFC: Additional Directory for Extensions David E. Wheeler 15:05
Re: RFC: Additional Directory for Extensions David E. Wheeler 15:10
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly 📎 Vitaly Davydov 15:12
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot torikoshia 15:20
Re: Adding support for SSLKEYLOGFILE in the frontend 📎 Daniel Gustafsson 15:23
Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw Tom Lane 15:49
[PATCH] Improve selectivity estimation for OR clauses with equality conditions on the same column 📎 Ilia Evdokimov 15:57
Re: making EXPLAIN extensible Robert Haas 16:05
Re: Log connection establishment timings Bertrand Drouvot 16:14
Re: Parallel CREATE INDEX for GIN indexes 📎 Tomas Vondra 16:16
Re: bug when apply fast default mechanism for adding new column over domain with default value Tom Lane 16:18
Re: vacuumdb changes for stats import/export 📎 Nathan Bossart 16:21
Re: PATCH: warn about, and deprecate, clear text passwords Nathan Bossart 16:33
Re: Considering fractional paths in Append node Alena Rybakina 16:34
Re: Statistics Import and Export: difference in statistics dumped Ashutosh Bapat 16:34
Re: making EXPLAIN extensible Robert Haas 16:38
Re: lwlocknames.h beautification attempt Robert Haas 16:40
Re: Flaky 003_start_stop.pl test Andres Freund 16:48
Re: dblink: Add SCRAM pass-through authentication 📎 Jacob Champion 17:01
Re: PATCH: warn about, and deprecate, clear text passwords Greg Sabino Mullane 17:06
Re: Log connection establishment timings Fujii Masao 17:08
Re: PATCH: warn about, and deprecate, clear text passwords Isaac Morland 17:11
Re: lwlocknames.h beautification attempt Álvaro Herrera 17:14
Re: Trigger more frequent autovacuums of heavy insert tables 📎 Melanie Plageman 17:18
Re: pg_stat_statements and "IN" conditions 📎 Sami Imseih 17:25
Re: Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity Sami Imseih 17:35
Handle interrupts while waiting on Append's async subplans 📎 Heikki Linnakangas 17:44
Re: Add -k/--link option to pg_combinebackup 📎 Robert Haas 17:51
Re: making EXPLAIN extensible 📎 Guillaume Lelarge 18:06
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 18:07
Re: Improve monitoring of shared memory allocations Andres Freund 18:07
Re: scalability bottlenecks with (many) partitions (and more) Andres Freund 18:10
Re: PATCH: warn about, and deprecate, clear text passwords Robert Haas 18:10
Re: Trigger more frequent autovacuums of heavy insert tables Nathan Bossart 18:11
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot Fujii Masao 18:17
Re: bug when apply fast default mechanism for adding new column over domain with default value Tom Lane 18:38
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 18:40
Re: RFC: Additional Directory for Extensions 📎 Matheus Alcantara 18:45
Re: PATCH: warn about, and deprecate, clear text passwords Tom Lane 18:47
Re: PATCH: warn about, and deprecate, clear text passwords Robert Haas 18:54
Re: Statistics Import and Export Greg Sabino Mullane 19:00
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Masahiko Sawada 19:06
Re: Improve CRC32C performance on SSE4.2 Nathan Bossart 19:11
Re: SQL:2023 JSON simplified accessor support Matheus Alcantara 19:16
Re: int64 support in List API James Hunter 19:19
what's going on with lapwing? Robert Haas 19:38
Re: SQL:2023 JSON simplified accessor support Matheus Alcantara 19:43
Re: Trigger more frequent autovacuums of heavy insert tables Melanie Plageman 19:47
Ubsan complaint on kestrel Andres Freund 19:53
Re: what's going on with lapwing? Tom Lane 19:53
Re: Ubsan complaint on kestrel Tom Lane 20:00
Re: SQL:2023 JSON simplified accessor support 📎 Alexandra Wang 20:22
Re: scalability bottlenecks with (many) partitions (and more) Tomas Vondra 20:31
Re: Flaky 003_start_stop.pl test Thomas Munro 20:48
Re: Ubsan complaint on kestrel Andres Freund 20:50
Re: scalability bottlenecks with (many) partitions (and more) Andres Freund 20:52
Re: what's going on with lapwing? Robert Haas 20:52
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) Robert Haas 21:01
Re: Ubsan complaint on kestrel Tom Lane 21:49
Re: Ubsan complaint on kestrel Andres Freund 21:58
Re: Adding NetBSD and OpenBSD to Postgres CI Thomas Munro 22:35
Re: Adding NetBSD and OpenBSD to Postgres CI Jacob Champion 22:38
Re: Adding NetBSD and OpenBSD to Postgres CI Andres Freund 22:39
RE: Improve CRC32C performance on SSE4.2 Devulapalli, Raghuveer 22:40
Re: [PATCH] SVE popcount support Nathan Bossart 23:00
Re: proposal - plpgsql - support standard syntax for named arguments for cursors Tom Lane 23:04
Re: what's going on with lapwing? Julien Rouhaud 23:08
Re: what's going on with lapwing? Tom Lane 23:12
Re: Parallel heap vacuum 📎 Masahiko Sawada 23:24
Re: Log connection establishment timings Melanie Plageman 23:24
Re: Introduce "log_connection_stages" setting. Melanie Plageman 23:43
Re: Update docs for UUID data type Masahiko Sawada 23:46

March 4, 2025

Thread Author Time
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 00:07
Re: Adding NetBSD and OpenBSD to Postgres CI Thomas Munro 00:14
Re: ci: Allow running mingw tests by default via environment variable 📎 Thomas Munro 00:27
Re: per backend WAL statistics 📎 Michael Paquier 00:28
Re: New commitfest app release on March 4th Jelte Fennema-Nio 00:42
Re: Statistics Import and Export: difference in statistics dumped Jeff Davis 00:55
Re: Add Pipelining support in psql Michael Paquier 00:56
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot torikoshia 01:01
Next commitfest app release is planned for March 18th 📎 Jelte Fennema-Nio 01:21
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation 📎 Masahiko Sawada 01:23
Re: Add assertion for failed alloc to palloc0() and palloc_extended() Michael Paquier 02:01
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback Amit Kapila 03:59
Re: [PoC] Federated Authn/z with OAUTHBEARER Thomas Munro 04:10
Allow LISTEN on patterns 📎 Quan Zongliang 04:39
Re: Log connection establishment timings Fujii Masao 04:45
Re: Statistics Import and Export: difference in statistics dumped Ashutosh Bapat 04:58
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎 Shubham Khanna 04:59
Re: Improve CRC32C performance on SSE4.2 John Naylor 05:09
Re: Improve CRC32C performance on SSE4.2 John Naylor 05:13
Re: proposal - plpgsql - support standard syntax for named arguments for cursors Pavel Stehule 05:34
Re: [PATCH] Add regression tests of ecpg command notice (error / warning) Fujii Masao 06:01
Re: vacuumdb changes for stats import/export John Naylor 06:05
Re: Allow table AMs to define their own reloptions Julien Tachoires 06:16
Re: Add an option to skip loading missing publication to avoid logical replication failure 📎 vignesh C 06:52
Re: Doc fix of aggressive vacuum threshold for multixact members storage 📎 John Naylor 06:58
Re: Enhancing Memory Context Statistics Reporting 📎 Rahila Syed 07:00
possible ALTER TABLE ALTER COLUMN TYPE enhancing - safe mode Pavel Stehule 07:22
Re: bug: ALTER TABLE ADD VIRTUAL GENERATED COLUMN with table rewrite Peter Eisentraut 08:28
Re: per backend WAL statistics Bertrand Drouvot 08:48
Re: Accidental assignment instead of compare in GetOperatorFromCompareType? Peter Eisentraut 08:50
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible 📎 Michael Paquier 08:51
Re: Add assertion for failed alloc to palloc0() and palloc_extended() Andreas Karlsson 08:52
Re: ci: Allow running mingw tests by default via environment variable 📎 Nazir Bilal Yavuz 08:53
encode/decode support for base64url Przemysław Sztoch 08:54
Re: tests for pg_stat_progress_copy.tuples_skipped jian he 08:57
Re: 64 bit numbers vs format strings Peter Eisentraut 09:02
Re: encode/decode support for base64url Daniel Gustafsson 09:10
Re: Allow table AMs to define their own reloptions Yura Sokolov 09:19
Re: Next commitfest app release is planned for March 18th Peter Eisentraut 09:22
reduce overhead in shared memory TID store 📎 John Naylor 09:23
Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2 📎 Andreas Karlsson 09:24
Re: Add Pipelining support in psql 📎 Anthonin Bonnefoy 09:31
Re: Reduce the instruction overhead of OpenSSL calls Daniel Gustafsson 09:36
Re: tests for pg_stat_progress_copy.tuples_skipped Josef Šimánek 09:40
Re: Log connection establishment timings Bertrand Drouvot 09:40
Re: Next commitfest app release is planned for March 18th Jelte Fennema-Nio 10:33
Re: Next commitfest app release is planned for March 18th Álvaro Herrera 10:34
Re: Draft for basic NUMA observability 📎 Jakub Wartak 10:48
Re: [PATCH] Add native windows on arm64 support Dave Cramer 10:54
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. Nisha Moond 11:00
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback Jakub Wartak 11:14
Re: Docs for pg_basebackup needs v17 note for incremental backup Daniel Gustafsson 11:27
Re: Elimination of the repetitive code at the SLRU bootstrap functions. Evgeny 11:41
RE: Selectively invalidate caches in pgoutput module 📎 Hayato Kuroda (Fujitsu) 11:43
Re: FileFallocate misbehaving on XFS Jakub Wartak 12:04
Re: Add -k/--link option to pg_combinebackup 📎 Israel Barth Rubio 12:06
Re: Add Pipelining support in psql Daniel Verite 12:32
Re: Next commitfest app release is planned for March 18th Amit Kapila 12:35
Re: ci: Allow running mingw tests by default via environment variable Andres Freund 12:58
Re: ci: Allow running mingw tests by default via environment variable Andres Freund 13:00
Re: scalability bottlenecks with (many) partitions (and more) 📎 Tomas Vondra 13:05
Re: scalability bottlenecks with (many) partitions (and more) Andres Freund 13:11
Re: Add an option to skip loading missing publication to avoid logical replication failure 📎 vignesh C 13:24
Re: Next commitfest app release is planned for March 18th Jelte Fennema-Nio 13:30
Re: what's going on with lapwing? Robert Haas 13:33
Re: making EXPLAIN extensible Andrei Lepikhov 13:56
Re: SQL:2023 JSON simplified accessor support Mark Dilger 14:05
Re: new commitfest transition guidance jian he 14:10
Vacuum timing in pg_stat_all_tables Magnus Hagander 14:12
Re: what's going on with lapwing? Andrew Dunstan 14:19

Browse Archives

Prev | Next