pgsql-hackers - September 2024

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

Sept. 1, 2024

Thread	Author	Time
Re: ANALYZE ONLY 📎	Michael Harris	01:31
Re: ANALYZE ONLY	Michael Harris	01:41
Re: Partitioned tables and [un]loggedness	Junwang Zhao	05:24
Re: not null constraints, again	Tender Wang	05:45
AIO v2.0 📎	Andres Freund	06:27
Re: ANALYZE ONLY	David Rowley	09:31
Add ExprState hashing for GROUP BY and hashed SubPlans 📎	David Rowley	11:49
Re: Improving tracking/processing of buildfarm test failures	Alexander Lakhin	12:00
Re: Re: bt Scankey in another contradictory case	[email protected]	15:44
Re: Improving tracking/processing of buildfarm test failures	sia kc	18:46
BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match()	PG Bug reporting form	19:00
Re: In-placre persistance change of a relation	Heikki Linnakangas	19:15
Re: scalability bottlenecks with (many) partitions (and more) 📎	Tomas Vondra	19:30
Re: pgsql: Implement pg_wal_replay_wait() stored procedure	Alexander Korotkov	19:35
Re: optimizing pg_upgrade's once-in-each-database steps 📎	Nathan Bossart	21:05
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	21:19
Re: Collect statistics about conflicts in logical replication	Peter Smith	22:44
Re: Collect statistics about conflicts in logical replication	Peter Smith	22:49
Re: pgsql: Implement pg_wal_replay_wait() stored procedure	Michael Paquier	23:27
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch	Michael Paquier	23:44
Re: scalability bottlenecks with (many) partitions (and more)	Robert Haas	23:53
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎	Alexander Korotkov	23:55

Sept. 2, 2024

Thread	Author	Time
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible	Michael Paquier	00:10
DOCS - pg_replication_slot . Fix the 'inactive_since' description 📎	Peter Smith	00:16
Re: pgsql: Implement pg_wal_replay_wait() stored procedure	Michael Paquier	00:24
Re: In-placre persistance change of a relation	Michael Paquier	00:30
Re: Minor refactor: Use more consistent names for the labels of PG_Locale_Strategy	Michael Paquier	00:43
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points	Michael Paquier	00:53
Re: query_id, pg_stat_activity, extended query protocol	Michael Paquier	01:11
Re: JIT: Remove some unnecessary instructions. 📎	Xing Guo	02:23
Re: Make printtup a bit faster	Andy Fan	03:18
Re: Collect statistics about conflicts in logical replication	shveta malik	03:28
Re: ANALYZE ONLY	torikoshia	03:29
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	shveta malik	03:43
Re: long-standing data loss bug in initial sync of logical replication	Amit Kapila	04:42
Regarding canditate_restart_lsn in logical decoding.	reddy manjunath	04:55
Re: Track the amount of time waiting due to cost_delay 📎	Bertrand Drouvot	05:11
Invalid Assert while validating REPLICA IDENTITY?	Dilip Kumar	05:51
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	06:55
Re: thread-safety: getpwuid_r()	Peter Eisentraut	07:28
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? 📎	Daniel Gustafsson	08:03
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Peter Smith	08:06
Re: pgsql: Add more SQL/JSON constructor functions 📎	Amit Langote	08:17
Re: generic plans and "initial" pruning	Amit Langote	08:19
Re: More performance improvements for pg_dump in binary upgrade mode	Daniel Gustafsson	08:59
Windows socket problems, interesting connection to AIO	Thomas Munro	09:20
pg_stats_subscription_stats order of the '*_count' columns	Peter Smith	09:24
Re: Collect statistics about conflicts in logical replication	Peter Smith	09:28
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	09:50
Re: Invalid Assert while validating REPLICA IDENTITY?	Amit Kapila	10:02
Re: AIO v2.0	Heikki Linnakangas	10:03
Re: not null constraints, again	Tender Wang	10:33
Re: Jargon and acronyms on this mailing list	Dagfinn Ilmari Mannsåker	11:06
Re: Avoiding superfluous buffer locking during nbtree backwards scans 📎	Matthias van de Meent	11:31
Re: Jargon and acronyms on this mailing list	Daniel Gustafsson	11:38
Re: Use read streams in pg_visibility 📎	Nazir Bilal Yavuz	12:20
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Daniel Gustafsson	12:26
Re: Invalid Assert while validating REPLICA IDENTITY?	Dilip Kumar	12:52
Re: Proposal for implementing OCSP Stapling in PostgreSQL	Daniel Gustafsson	12:54
Re: Virtual generated columns	jian he	13:25
Re: Virtual generated columns 📎	Nazir Bilal Yavuz	13:29
Re: Use XLOG_CONTROL_FILE macro everywhere?	Daniel Gustafsson	13:44
Re: proposal: schema variables	Laurenz Albe	14:00
Re: Flush pgstats file during checkpoints	Heikki Linnakangas	14:08
per backend I/O statistics 📎	Bertrand Drouvot	14:55
Re: Track IO times in pg_stat_io	Bertrand Drouvot	15:00
Re: PG_TEST_EXTRA and meson	Nazir Bilal Yavuz	15:02
Re: long-standing data loss bug in initial sync of logical replication	Nitin Motiani	15:49
Re: scalability bottlenecks with (many) partitions (and more) 📎	Tomas Vondra	17:46
Re: Typos in the code and README 📎	Alexander Lakhin	18:00
Re: [PATCH] Add roman support for to_number function	Maciek Sakrejda	18:40
Re: JIT: Remove some unnecessary instructions.	Andreas Karlsson	19:06
Re: JIT: Remove some unnecessary instructions.	Andreas Karlsson	19:10
Re: query_id, pg_stat_activity, extended query protocol	Andrei Lepikhov	19:30
thread-safety: strerror_r() 📎	Peter Eisentraut	19:45
Re: thread-safety: strerror_r()	Tom Lane	19:56
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Jehan-Guillaume de Rorthais	21:01
Re: Improving tracking/processing of buildfarm test failures	Andrew Dunstan	21:45
Re: Track IO times in pg_stat_io	Michael Paquier	23:19

Sept. 3, 2024

Thread	Author	Time
Re: define PG_REPLSLOT_DIR	Michael Paquier	00:15
Re: Partitioned tables and [un]loggedness	Michael Paquier	00:22
Re: Flush pgstats file during checkpoints	Michael Paquier	01:08
Re: Partitioned tables and [un]loggedness	Nathan Bossart	01:35
Re: macOS prefetching support 📎	Thomas Munro	01:47
Add callback in pgstats for backend initialization 📎	Michael Paquier	01:52
Re: GUC names in messages 📎	Peter Smith	02:00
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Tender Wang	02:16
Remove no-op PlaceHolderVars 📎	Richard Guo	02:53
Re: Remove no-op PlaceHolderVars	Tom Lane	03:31
Re: Improving the latch handling between logical replication launcher and worker processes. 📎	vignesh C	03:40
Re: define PG_REPLSLOT_DIR	Bertrand Drouvot	04:35
Add callbacks for fixed-numbered stats flush in pgstats 📎	Michael Paquier	04:48
Re: Virtual generated columns 📎	jian he	04:59
Re: v17 vs v16 performance comparison 📎	Alexander Lakhin	05:00
Re: Add callback in pgstats for backend initialization	Bertrand Drouvot	05:00
Re: Make tuple deformation faster 📎	David Rowley	05:05
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Amit Kapila	05:13
Re: Typos in the code and README	Michael Paquier	05:24
Re: Use XLOG_CONTROL_FILE macro everywhere?	Kyotaro Horiguchi	05:37
Re: Typos in the code and README	Michael Paquier	05:51
Re: Add callback in pgstats for backend initialization	Michael Paquier	05:58
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	shveta malik	06:12
Re: Add const qualifiers to XLogRegister*() functions	Peter Eisentraut	06:15
Re: v17 vs v16 performance comparison	Thomas Munro	06:21
Re: Expand applicability of aggregate's sortop optimization	Andrei Lepikhov	06:25
Re: define PG_REPLSLOT_DIR	Michael Paquier	06:27
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Bertrand Drouvot	06:35
Re: GUC names in messages	Michael Paquier	06:35
Re: per backend I/O statistics	Kyotaro Horiguchi	06:37
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	06:55
Re: per backend I/O statistics	Kyotaro Horiguchi	07:07
Re: not null constraints, again	Tender Wang	07:17
Re: per backend I/O statistics	Bertrand Drouvot	07:21
Re: SQLFunctionCache and generic plans 📎	Alexander Pyhalov	07:33
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Peter Smith	07:52
Re: Partitioned tables and [un]loggedness 📎	Michael Paquier	07:59
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Bertrand Drouvot	08:39
Re: Remove no-op PlaceHolderVars	Richard Guo	08:50
Re: Use XLOG_CONTROL_FILE macro everywhere? 📎	Anton A. Melnikov	09:02
Re: pgsql: Add more SQL/JSON constructor functions	jian he	09:05
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Jehan-Guillaume de Rorthais	09:26
Re: Introduce XID age and inactive timeout based replication slot invalidation	shveta malik	09:31
Re: altering a column's collation leaves an invalid foreign key	Peter Eisentraut	09:41
Re: Conflict Detection and Resolution	vignesh C	09:41
Re: Inconsistency between try_mergejoin_path and create_mergejoin_plan 📎	Richard Guo	09:51
Re: POC, WIP: OR-clause support for indexes 📎	Andrei Lepikhov	09:52
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Tender Wang	09:55
Re: Typos in the code and README	Daniel Gustafsson	10:00
Re: Conflict Detection and Resolution	vignesh C	10:33
broken devel package for rocky linux	Pavel Stehule	10:34
Re: broken devel package for rocky linux	Devrim Gündüz	10:38
Re: broken devel package for rocky linux	Pavel Stehule	10:40
Re: broken devel package for rocky linux	Zaid Shabbir	10:48
Re: broken devel package for rocky linux	Devrim Gündüz	10:55
Re: Collect statistics about conflicts in logical replication	Amit Kapila	11:12
RE: Collect statistics about conflicts in logical replication 📎	Zhijie Hou (Fujitsu)	11:23
RE: Collect statistics about conflicts in logical replication 📎	Zhijie Hou (Fujitsu)	11:28
Re: proposal: schema variables 📎	Pavel Stehule	11:41
Re: JIT: The nullness of casetest.value can be determined at the JIT compile time. 📎	Andreas Karlsson	12:09
Re: [PATCH] Avoid mixing custom and OpenSSL BIO functions 📎	Daniel Gustafsson	12:18
Re: Parallel workers stats in pg_stat_database 📎	Benoit Lobréau	12:34
Re: using extended statistics to improve join estimates	Andrei Lepikhov	12:58
Re: pgsql: Implement pg_wal_replay_wait() stored procedure	Alexander Korotkov	13:07
Re: [PATCH] Add roman support for to_number function	Hunaid Sohail	13:28
Re: POC: make mxidoff 64 bits 📎	Maxim Orlov	13:30
Re: POC: make mxidoff 64 bits	Alexander Korotkov	13:32
Re: Set log_lock_waits=on by default	Jakub Wartak	13:37
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎	Alexander Korotkov	13:45
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Maxim Orlov	13:53
Re: AIO v2.0	Andres Freund	14:29
Re: [PATCH] Add CANONICAL option to xmlserialize 📎	Jim Jones	14:43
Re: query_id, pg_stat_activity, extended query protocol 📎	Andrei Lepikhov	14:49
Re: scalability bottlenecks with (many) partitions (and more)	Robert Haas	15:06
Re: JIT: The nullness of casetest.value can be determined at the JIT compile time.	Xing Guo	15:18
Re: Partitioned tables and [un]loggedness	Nathan Bossart	15:33
Re: First draft of PG 17 release notes	Nathan Bossart	15:44
Re: [PATCH] Add roman support for to_number function	Maciek Sakrejda	15:47
Re: Jargon and acronyms on this mailing list	Nathan Bossart	15:50
Re: race condition in pg_class	Nitin Motiani	15:54
Re: Broken layout: CommitFest Add Review Form	Maciek Sakrejda	15:58
Re: scalability bottlenecks with (many) partitions (and more)	Tomas Vondra	16:19
Large expressions in indexes can't be stored (non-TOASTable)	Jonathan S. Katz	16:35
Re: Inline non-SQL SRFs using SupportRequestSimplify	Tom Lane	16:42
Re: Index AM API cleanup 📎	Peter Eisentraut	16:52
Re: Proposal for implementing OCSP Stapling in PostgreSQL	Jacob Champion	17:20
Re: Index AM API cleanup	Mark Dilger	17:26
Re: Use read streams in pg_visibility	Noah Misch	17:50
Re: list of acknowledgments for PG17	Matthias van de Meent	17:59
Re: Minor cleanups in the SSL tests	Daniel Gustafsson	18:35
Re: optimizing pg_upgrade's once-in-each-database steps 📎	Nathan Bossart	18:39
Re: Use read streams in pg_visibility	Noah Misch	19:20
Re: Set log_lock_waits=on by default	Christoph Berg	19:39
Re: Use read streams in pg_visibility 📎	Nazir Bilal Yavuz	19:46
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch 📎	Nathan Bossart	19:52
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch	Matthias van de Meent	20:19
Re: macOS prefetching support	Peter Eisentraut	20:28
Re: Optimize mul_var() for var1ndigits >= 8	Tom Lane	20:30
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch	Nathan Bossart	20:40
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	20:56
Re: [PATCH] Add min/max aggregate functions to BYTEA	Tom Lane	21:19
Re: race condition in pg_class	Noah Misch	21:23
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible	Jacob Champion	21:47
Re: GUC names in messages 📎	Peter Smith	23:17
Re: optimizing pg_upgrade's once-in-each-database steps	Ilya Gladyshev	23:28

Sept. 4, 2024

Thread	Author	Time
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	00:06
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points 📎	Michael Paquier	00:40
Re: Wrong results with grouping sets	Richard Guo	01:16
Re: Typos in the code and README 📎	Michael Paquier	01:25
Re: optimizing pg_upgrade's once-in-each-database steps 📎	Nathan Bossart	01:41
Re: Improving the latch handling between logical replication launcher and worker processes.	Kyotaro Horiguchi	03:02
Re: Collect statistics about conflicts in logical replication	Peter Smith	03:47
Re: Introduce XID age and inactive timeout based replication slot invalidation	shveta malik	03:47
Re: Eager aggregation, take 3	Tender Wang	03:48
Re: Inconsistency between try_mergejoin_path and create_mergejoin_plan	Richard Guo	03:50
Re: per backend I/O statistics	Bertrand Drouvot	04:45
Re: broken devel package for rocky linux	Zaid Shabbir	04:49
Re: Collect statistics about conflicts in logical replication	Amit Kapila	04:56
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description 📎	Peter Smith	04:59
Re: tiny step toward threading: reduce dependence on setlocale()	Jeff Davis	05:04
Re: Add callbacks for fixed-numbered stats flush in pgstats	Kyotaro Horiguchi	05:05

Browse Archives

Prev | Next