pgsql-hackers since 2025-03-01 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)

Advanced Search

Browse Archives

Prev | Next

March 1, 2025

Thread	Author	Time
Add assertion for failed alloc to palloc0() and palloc_extended() 📎	Andreas Karlsson	00:05
Re: [PoC] Federated Authn/z with OAUTHBEARER	Thomas Munro	00:36
Re: Trigger more frequent autovacuums of heavy insert tables	wenhui qiu	00:57
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Sutou Kouhei	02:50
Re: Licence preamble update	Noah Misch	03:50
Improve monitoring of shared memory allocations 📎	Rahila Syed	04:49
bug when apply fast default mechanism for adding new column over domain with default value	jian he	05:39
RE: SIMD optimization for list_sort	Shankaran, Akash	06:23
Re: bug when apply fast default mechanism for adding new column over domain with default value	Tom Lane	06:43
Re: Re: proposal: schema variables 📎	Pavel Stehule	07:23
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎	Lukas Fittl	07:45
Re: SQLFunctionCache and generic plans	Pavel Stehule	08:18
Re: RFC: Additional Directory for Extensions	Gabriele Bartolini	09:15
Re: [PoC] Reducing planning time when tables have many partitions 📎	Yuya Watari	10:06
Re: [PATCH] Add regression tests of ecpg command notice (error / warning) 📎	Ryo Kanbayashi	10:45
Re: [PATCH] Add get_bytes() and set_bytes() functions 📎	Dean Rasheed	11:30
Re: Replace IN VALUES with ANY in WHERE clauses during optimization 📎	Alena Rybakina	11:39
Re: Adding NetBSD and OpenBSD to Postgres CI 📎	Thomas Munro	12:37
Re: Separate GUC for replication origins	Amit Kapila	13:08
Re: Licence preamble update	Amit Kapila	13:13
Re: DOCS - Generated Column Replication Examples	Amit Kapila	13:31
Re: Index AM API cleanup 📎	Mark Dilger	13:42
Re: bug when apply fast default mechanism for adding new column over domain with default value 📎	jian he	14:02
Re: access numeric data in module 📎	Ed Behn	14:30
Re: Amcheck verification of GiST and GIN 📎	Kirill Reshke	14:55
Re: access numeric data in module	Tom Lane	16:33
Re: Statistics Import and Export	Alexander Lakhin	17:00
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	17:50
Re: [Patch] add new parameter to pg_replication_origin_session_setup 📎	Doruk Yilmaz	17:52
Re: Statistics Import and Export	Tom Lane	18:04
Re: Statistics Import and Export	Alexander Lakhin	18:20
Re: Statistics Import and Export	Greg Sabino Mullane	18:52
Re: Statistics Import and Export	Tom Lane	18:56
Re: access numeric data in module	Ed Behn	20:32
Re: Statistics Import and Export	Jeff Davis	20:48
Re: Statistics Import and Export	Tom Lane	21:23
Re: access numeric data in module	Jelte Fennema-Nio	22:01
Re: access numeric data in module	Ed Behn	22:25
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) 📎	Peter Geoghegan	22:39
Re: bug when apply fast default mechanism for adding new column over domain with default value	Tom Lane	23:54

March 2, 2025

Thread	Author	Time
Re: Incorrect result of bitmap heap scan.	Peter Geoghegan	00:32
Re: Incorrect result of bitmap heap scan.	Tom Lane	00:35
Re: Statistics Import and Export	Corey Huinker	01:55
Re: Emitting JSON to file using COPY TO 📎	Junwang Zhao	05:28
lwlocknames.h beautification attempt	Gurjeet Singh	06:09
Re: lwlocknames.h beautification attempt	Tom Lane	06:26
Re: lwlocknames.h beautification attempt	Gurjeet Singh	06:35
Re: lwlocknames.h beautification attempt	Tom Lane	07:00
Re: Make COPY format extendable: Extract COPY TO format implementations	Junwang Zhao	07:40
Re: Improving tracking/processing of buildfarm test failures 📎	Alexander Lakhin	08:00
Re: Considering fractional paths in Append node	Alexander Korotkov	08:46
Re: Considering fractional paths in Append node	Alexander Korotkov	08:53
Allow table AMs to define their own reloptions 📎	Julien Tachoires	08:56
Re: bug when apply fast default mechanism for adding new column over domain with default value 📎	jian he	09:50
Re: gamma() and lgamma() functions 📎	Dean Rasheed	10:29
Re: Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity 📎	Alex Friedman	10:42
Options to control remote transactions’ access/deferrable modes in postgres_fdw 📎	Etsuro Fujita	11:44
Re: Get rid of WALBufMappingLock	Alexander Korotkov	11:58
Re: Get rid of WALBufMappingLock	Alexander Korotkov	11:59
Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw	Etsuro Fujita	12:01
Re: Allow table AMs to define their own reloptions 📎	Julien Tachoires	13:23
Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py 📎	Mats Kindahl	13:26
Re: Statistics Import and Export	Magnus Hagander	14:38
Re: Allow table AMs to define their own reloptions	Yura Sokolov	15:20
Re: Make COPY format extendable: Extract COPY TO format implementations	Tom Lane	16:27
Re: 64 bit numbers vs format strings	Peter Eisentraut	17:21
Re: making EXPLAIN extensible	Srinath Reddy	17:54
Re: Logging which local address was connected to in log_line_prefix	Jim Jones	18:26
Re: Add Postgres module info	Andrei Lepikhov	18:35
Re: Add Postgres module info 📎	Andrei Lepikhov	19:35
Re: Statistics Import and Export	Corey Huinker	20:29
Re: Optimization for lower(), upper(), casefold() functions.	Alexander Borisov	20:33
Re: 64 bit numbers vs format strings 📎	Thomas Munro	21:08
Re: 64 bit numbers vs format strings	Tom Lane	21:48
Re: bug when apply fast default mechanism for adding new column over domain with default value 📎	Tom Lane	22:08
Re: Cannot find a working 64-bit integer type on Illumos	Thomas Munro	22:35

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

Browse Archives

Prev | Next