pgsql-hackers - January 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

Jan. 1, 2024

Thread	Author	Time
Re: Commitfest 2024-01 starting in 3 days!	vignesh C	03:19
Re: Add support for __attribute__((returns_nonnull))	John Naylor	03:29
Re: Commitfest manager January 2024	vignesh C	03:35
Re: Track in pg_replication_slots the reason why slots conflict?	shveta malik	03:44
Re: Commitfest manager January 2024	Shubham Khanna	04:36
Re: Build versionless .so for Android 📎	Matthias Kuhn	05:25
Re: Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid	Maxim Orlov	06:14
Re: Autonomous transactions 2023, WIP	Pavel Stehule	06:47
Re: Track in pg_replication_slots the reason why slots conflict? 📎	shveta malik	07:01
Re: Remove unneeded PGDATABASE setting from TAP tests 📎	Bharath Rupireddy	08:22
Re: Assorted typo fixes	Shubham Khanna	09:03
Re: speed up a logical replica setup	vignesh C	10:14
Update for copyright messages to 2024 (Happy New Year!)	Michael Paquier	10:25
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	11:00
Re: Autonomous transactions 2023, WIP	Ivan Kush	11:15
Re: Track in pg_replication_slots the reason why slots conflict? 📎	shveta malik	11:47
Re: Track in pg_replication_slots the reason why slots conflict? 📎	shveta malik	11:53
Re: add AVX2 support to simd.h	John Naylor	12:12
Re: warn if GUC set to an invalid shared library	John Naylor	12:16
Re: Proposal to include --exclude-extension Flag in pg_dump	Ashutosh Bapat	12:48
Re: Autonomous transactions 2023, WIP	Pavel Stehule	12:49
Re: Proposal to include --exclude-extension Flag in pg_dump	Ayush Vatsa	13:28
Re: Shared detoast Datum proposal 📎	Andy Fan	13:55
Re: Transaction timeout 📎	Andrey M. Borodin	14:28
Re: Commitfest manager January 2024	Magnus Hagander	15:30
Re: add function argument names to regex* functions.	Dian Fay	18:05
Minor cleanup for search path cache 📎	Tom Lane	21:38
Re: Assorted typo fixes 📎	Dagfinn Ilmari Mannsåker	23:05
Re: Change GUC hashtable to use simplehash?	jian he	23:55

Jan. 2, 2024

Thread	Author	Time
Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value 📎	jian he	00:00
Re: Add pg_basetype() function to obtain a DOMAIN base type 📎	jian he	00:00
Re: SQL:2011 application time 📎	Paul Jungwirth	01:59
Re: Commitfest manager January 2024	vignesh C	02:45
Re: Random pg_upgrade test failure on drongo	Alexander Lakhin	05:00
Re: Track in pg_replication_slots the reason why slots conflict? 📎	Amit Kapila	05:05
Re: Minor cleanup for search path cache	Zhang Mingli	05:12
Re: Minor cleanup for search path cache	Tom Lane	05:20
The presence of a NULL "defaclacl" value in pg_default_acl prevents the dropping of a role.	杨伯宇 (长堂)	06:33
INFORMATION_SCHEMA node	Tatsuo Ishii	06:39
Re: Revise the Asserts added to bimapset manipulation functions	Richard Guo	07:18
Re: Extract numeric filed in JSONB more effectively	jian he	08:18
Re: UUID v7 📎	Andrey M. Borodin	09:17
Re: Synchronizing slots from primary to standby 📎	shveta malik	09:23
Re: [17] CREATE SUBSCRIPTION ... SERVER	Bharath Rupireddy	09:44
Re: Adding facility for injection points (or probe points?) for more advanced tests	Ashutosh Bapat	10:06
Re: Commitfest manager January 2024	Magnus Hagander	10:12
Re: Assorted typo fixes 📎	Shubham Khanna	10:21
Re: Commitfest manager January 2024	vignesh C	10:25
Re: pg_upgrade and logical replication	Amit Kapila	10:28
Re: Reducing output size of nodeToString	Peter Eisentraut	10:30
Re: Synchronizing slots from primary to standby 📎	shveta malik	10:31
Re: Proposal to add page headers to SLRU pages	Aleksander Alekseev	11:35
Re: POC: Extension for adding distributed tracing - pg_tracing	Aleksander Alekseev	12:14
Re: Password leakage avoidance	Sehrope Sarkuni	12:23
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	Masahiko Sawada	13:01
Re: Track in pg_replication_slots the reason why slots conflict?	Bertrand Drouvot	14:07
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Robert Haas	14:23
Re: Things I don't like about \du's "Attributes" column	Robert Haas	14:41
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs 📎	Jelte Fennema-Nio	14:57
Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs 📎	Daniel Verite	14:58
Re: WIP Incremental JSON Parser	Robert Haas	15:14
Re: trying again to get incremental backup	Robert Haas	15:34
Re: add AVX2 support to simd.h	Nathan Bossart	16:11
Re: introduce dynamic shared memory registry	Nathan Bossart	16:20
Re: introduce dynamic shared memory registry	Robert Haas	16:31
Re: The presence of a NULL "defaclacl" value in pg_default_acl prevents the dropping of a role.	Tom Lane	16:56
verify predefined LWLocks have entries in wait_event_names.txt 📎	Nathan Bossart	17:31
Re: pg_upgrade failing for 200+ million Large Objects 📎	Kumar, Sachin	17:33
Re: Assorted typo fixes	Robert Haas	17:34
Re: Confine vacuum skip logic to lazy_scan_skip 📎	Melanie Plageman	17:36
Re: SET ROLE x NO RESET	Robert Haas	17:36
Re: Build versionless .so for Android	Robert Haas	17:43
Re: add AVX2 support to simd.h	Tom Lane	17:50
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	17:51
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	18:06
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Andrey M. Borodin	18:10
Re: verify predefined LWLocks have entries in wait_event_names.txt	Robert Haas	18:13
Re: Things I don't like about \du's "Attributes" column	Tom Lane	18:17
Re: UUID v7	Andrey M. Borodin	18:18
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Robert Haas	18:30
Re: Things I don't like about \du's "Attributes" column	Robert Haas	18:35
Re: Things I don't like about \du's "Attributes" column	Tom Lane	18:46
Re: Eager page freeze criteria clarification 📎	Melanie Plageman	18:47
Re: Minor cleanup for search path cache	Jeff Davis	19:20
Re: Minor cleanup for search path cache	Tom Lane	19:30
Re: Things I don't like about \du's "Attributes" column	Robert Haas	19:38
JIT compilation per plan node 📎	Melih Mutlu	19:50
Re: Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid	Robert Haas	19:58
Re: verify predefined LWLocks have entries in wait_event_names.txt	Nathan Bossart	21:45
Re: add AVX2 support to simd.h	Nathan Bossart	22:00
Re: SET ROLE x NO RESET	Michał Kłeczek	22:23
Re: introduce dynamic shared memory registry 📎	Nathan Bossart	22:49
Re: SET ROLE x NO RESET 📎	Jim Nasby	22:53
Re: Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid 📎	Jim Nasby	23:09
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	23:20
Re: Re: UUID v7	Przemysław Sztoch	23:37
Re: Things I don't like about \du's "Attributes" column 📎	Jim Nasby	23:37
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jacob Burroughs	23:43

Jan. 3, 2024

Thread	Author	Time
Re: pg_upgrade and logical replication	Michael Paquier	00:51
Re: Remove unneeded PGDATABASE setting from TAP tests	Michael Paquier	01:30
Re: Track in pg_replication_slots the reason why slots conflict?	Michael Paquier	01:39
Re: Reducing output size of nodeToString	David Rowley	02:02
Re: verify predefined LWLocks have entries in wait_event_names.txt	Michael Paquier	02:34
Re: Track in pg_replication_slots the reason why slots conflict? 📎	Amit Kapila	03:23
Re: verify predefined LWLocks have entries in wait_event_names.txt	Robert Haas	03:49
LLVM 18 📎	Thomas Munro	05:04
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Dilip Kumar	05:08
Re: Adding facility for injection points (or probe points?) for more advanced tests	Nathan Bossart	05:14
Re: Assorted typo fixes	Michael Paquier	05:34
Re: pg_upgrade and logical replication	Amit Kapila	05:54
Re: Assorted typo fixes	Tom Lane	05:56
Re: pg_upgrade and logical replication	Michael Paquier	06:03
Re: speed up a logical replica setup	vignesh C	06:39
Re: Transaction timeout	Andrey M. Borodin	06:39
Re: Track in pg_replication_slots the reason why slots conflict?	Bertrand Drouvot	07:33
Re: verify predefined LWLocks have entries in wait_event_names.txt	Bertrand Drouvot	07:59
Re: Update docs for default value of fdw_tuple_cost	Chris Travers	08:03
Re: speed up a logical replica setup	Amit Kapila	09:19
Re: speed up a logical replica setup	vignesh C	09:47
Re: pg_upgrade and logical replication	Amit Kapila	09:48
Re: XLog size reductions: Reduced XLog record header size for PG17	Pavel Borisov	10:15
Re: Adding OLD/NEW support to RETURNING 📎	Dean Rasheed	10:22
Re: Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid	Pavel Borisov	10:33
Re: Synchronizing slots from primary to standby	Amit Kapila	10:50
Re: remaining sql/json patches 📎	jian he	10:50
Re: remaining sql/json patches	jian he	10:53
Re: Separate memory contexts for relcache and catcache 📎	Melih Mutlu	11:26
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	11:26
Re: Switching XLog source from archive to streaming when primary available 📎	Bharath Rupireddy	11:28
Re: Parent/child context relation in pg_get_backend_memory_contexts() 📎	Melih Mutlu	11:40
Re: Random pg_upgrade test failure on drongo	Amit Kapila	11:42
Re: Transaction timeout	Andrey M. Borodin	11:46
Re: WIP Incremental JSON Parser	Andrew Dunstan	11:57
Re: More new SQL/JSON item methods	Peter Eisentraut	12:01
Re: Transaction timeout 📎	Andrey M. Borodin	12:04
Re: add function argument names to regex* functions.	Peter Eisentraut	12:13
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	13:02
Re: Show WAL write and fsync stats in pg_stat_io 📎	Nazir Bilal Yavuz	13:10
Re: WIP Incremental JSON Parser	Robert Haas	13:45
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Robert Haas	13:45
Re: Password leakage avoidance	Robert Haas	13:53
Re: Password leakage avoidance	Dave Cramer	13:59
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	John Naylor	14:10
Re: Change GUC hashtable to use simplehash?	John Naylor	14:12
Re: add AVX2 support to simd.h	John Naylor	14:13
Re: WIP Incremental JSON Parser	Andrew Dunstan	14:59
Re: trying again to get incremental backup	Robert Haas	15:10
Re: WIP Incremental JSON Parser	Robert Haas	15:12
Re: add AVX2 support to simd.h	Nathan Bossart	15:29
Re: Password leakage avoidance	Jonathan S. Katz	15:33
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs 📎	Jelte Fennema-Nio	15:54
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache	Cédric Villemain	16:25
Re: Assorted typo fixes	Dagfinn Ilmari Mannsåker	16:45
Re: WIP Incremental JSON Parser	Andrew Dunstan	16:55
Re: SET ROLE x NO RESET	Jelte Fennema-Nio	17:22
Re: Set log_lock_waits=on by default	Jeremy Schneider	18:31
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer 📎	Nathan Bossart	19:55
Re: More new SQL/JSON item methods	Peter Eisentraut	21:04
Re: Things I don't like about \du's "Attributes" column	Pavel Luzanov	21:22
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer	Jelte Fennema-Nio	21:57
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer	Nathan Bossart	22:13
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer	Tom Lane	22:13
Re: add function argument names to regex* functions. 📎	Jim Nasby	22:23
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer	Jelte Fennema-Nio	22:36
Re: Password leakage avoidance 📎	Jim Nasby	22:43
Re: Reducing output size of nodeToString	Matthias van de Meent	23:02
Re: add function argument names to regex* functions.	Dian Fay	23:05
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache 📎	Jim Nasby	23:15
Change prefetch and read strategies to use range in pg_prewarm ... and raise a question about posix_fadvise WILLNEED 📎	Cedric Villemain	23:23
Re: Reducing output size of nodeToString 📎	Matthias van de Meent	23:23
Re: add function argument names to regex* functions. 📎	Jim Nasby	23:25
Re: WIP Incremental JSON Parser	Nico Williams	23:36
Re: Add a perl function in Cluster.pm to generate WAL	Tom Lane	23:39
Re: SET ROLE x NO RESET	Nico Williams	23:40
Re: SET ROLE x NO RESET	Nico Williams	23:47
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	23:53
Re: pg_upgrade and logical replication	Michael Paquier	23:54
doing also VM cache snapshot and restore with pg_prewarm, having more information of the VM inside PostgreSQL	Cedric Villemain	23:57

Jan. 4, 2024

Thread	Author	Time
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	00:02
Re: Update for copyright messages to 2024 (Happy New Year!)	Bruce Momjian	01:49
Re: Transaction timeout	Japin Li	02:14
Re: speed up a logical replica setup	Euler Taveira	02:54
Re: Change GUC hashtable to use simplehash? 📎	jian he	03:01
Re: speed up a logical replica setup	Euler Taveira	03:21
Re: Synchronizing slots from primary to standby	shveta malik	03:48
Re: Synchronizing slots from primary to standby 📎	shveta malik	04:57
Re: speed up a logical replica setup	Amit Kapila	05:41
Re: speed up a logical replica setup	Amit Kapila	06:05
Re: Synchronizing slots from primary to standby	Dilip Kumar	06:18
Re: speed up a logical replica setup	Shlok Kyal	06:51
Re: GUC names in messages 📎	Peter Smith	06:53
the s_lock_stuck on perform_spin_delay 📎	Andy Fan	06:59
Re: speed up a logical replica setup	Ashutosh Bapat	07:00
Re: add function argument names to regex* functions. 📎	jian he	07:03
Re: [PATCH] Exponential backoff for auth_delay 📎	Michael Banck	07:30
Re: Transaction timeout 📎	Andrey M. Borodin	08:41
Documentation to upgrade logical replication cluster 📎	vignesh C	08:51
Re: Synchronizing slots from primary to standby	Amit Kapila	08:52
Re: pg_upgrade and logical replication	vignesh C	09:39
Re: pg_upgrade and logical replication	vignesh C	10:09

Browse Archives

Prev | Next