pgsql-hackers since 2024-12-27 17:09

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

Dec. 27, 2024

Thread Author Time
Re: POC: make mxidoff 64 bits 📎 Maxim Orlov 17:09
Re: [PATCHES] Post-special page storage TDE support Greg Sabino Mullane 17:19
Re: [PATCHES] Post-special page storage TDE support Greg Sabino Mullane 17:25
Re: Connection limits/permissions, slotsync workers, etc 📎 Tom Lane 17:30
Re: RFC: Allow EXPLAIN to Output Page Fault Information Jeremy Schneider 18:32
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 19:14
Re: [PATCHES] Post-special page storage TDE support Bruce Momjian 19:58
Re: Connection limits/permissions, slotsync workers, etc 📎 Tom Lane 20:51
Re: Add Postgres module info David E. Wheeler 22:02
Re: More reliable nbtree detection of unsatisfiable RowCompare quals involving a leading NULL key/element 📎 Peter Geoghegan 22:03

Dec. 28, 2024

Thread Author Time
Re: [PATCHES] Post-special page storage TDE support David Christensen 00:15
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Tomas Vondra 01:25
Re: Add the ability to limit the amount of memory that can be allocated to backends. Tomas Vondra 01:48
RE: Connection limits/permissions, slotsync workers, etc Zhijie Hou (Fujitsu) 03:16
Re: Logging parallel worker draught Sami Imseih 04:17
Re: Expand applicability of aggregate's sortop optimization 📎 Andrei Lepikhov 04:24
Re: Proposal: add new API to stringinfo Tatsuo Ishii 05:45
Re: Should fix a comment referring to stats collector? 📎 Junwang Zhao 07:25
Re: pg_attribute_noreturn(), MSVC, C11 📎 Peter Eisentraut 10:28
Re: Re: proposal: schema variables jian he 10:34
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎 Anton A. Melnikov 12:36
Re: Add the ability to limit the amount of memory that can be allocated to backends. Tomas Vondra 14:57
Re: Re: proposal: schema variables Pavel Stehule 15:32
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 16:09
Re: Document NULL Marcos Pegoraro 16:33
Re: Re: proposal: schema variables jian he 16:46
Re: Re: proposal: schema variables Pavel Stehule 17:29
Re: WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4) Noah Misch 18:10
Re: Add the ability to limit the amount of memory that can be allocated to backends. Jeremy Schneider 18:26
Re: which wire protocol fields are signed int and which ones are unsigned Bruce Momjian 19:31
Re: Connection limits/permissions, slotsync workers, etc Tom Lane 21:24
Re: Re: proposal: schema variables 📎 Pavel Stehule 21:49
Re: IANA timezone abbreviations versus timezone_abbreviations Bruce Momjian 23:47

Dec. 29, 2024

Thread Author Time
Re: Query regarding pg_prewarm extension 📎 Bruce Momjian 00:59
Re: Re: proposal: schema variables jian he 02:48
Re: Document NULL jian he 03:30
Re: Re: proposal: schema variables Pavel Stehule 06:24
Re: Add the ability to limit the amount of memory that can be allocated to backends. Jim Nasby 07:24
Re: Re: proposal: schema variables 📎 Pavel Stehule 08:42
Re: Query regarding pg_prewarm extension David Rowley 11:15
table_tuple_lock's snapshot argument Heikki Linnakangas 13:58
meson: Fix missing name arguments of cc.compiles() calls 📎 Peter Eisentraut 14:13
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Robert Treat 15:39
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Tomas Vondra 18:25
Re: Converting contrib SQL functions to new style Tom Lane 18:56
Re: Converting contrib SQL functions to new style Tom Lane 20:01
Re: IANA timezone abbreviations versus timezone_abbreviations Jelte Fennema-Nio 22:37
Re: IANA timezone abbreviations versus timezone_abbreviations Jelte Fennema-Nio 22:49
Re: IANA timezone abbreviations versus timezone_abbreviations Tom Lane 22:56

Dec. 30, 2024

Thread Author Time
Re: An improvement of ProcessTwoPhaseBuffer logic Michael Paquier 01:08
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Peter Smith 01:15
Proposal: Progressive explain 📎 Rafael Thofehrn Castro 01:18
Re: Remove support for OpenSSL *eay32 libs on Windows Michael Paquier 01:24
Re: Should fix a comment referring to stats collector? Michael Paquier 03:20
Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 04:04
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size vignesh C 04:40
Re: Memory leak in pg_logical_slot_{get,peek}_changes Michael Paquier 04:42
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 05:02
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 05:34
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 06:34
Re: Exists pull-up application with JoinExpr Alena Rybakina 08:24
Re: Fix handling of injection_points regarding pending stats Bertrand Drouvot 08:34
Correct the reference for plpgsql_yyparse() 📎 Japin Li 09:09
psql: Option to use expanded mode for various meta-commands 📎 Dean Rasheed 09:10
Re: [PoC] XMLCast (SQL/XML X025) 📎 Jim Jones 09:29
Re: AIX support Peter Eisentraut 09:29
Re: AIX support Andres Freund 09:39
Re: Autovacuum giving up on tables after crash because of lack of stats Bertrand Drouvot 09:44
Re: Fix handling of injection_points regarding pending stats Michael Paquier 10:00
Re: Logical Replication of sequences 📎 vignesh C 10:10
Re: Autovacuum giving up on tables after crash because of lack of stats 📎 Michael Paquier 10:12
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size vignesh C 10:33
Re: Remove support for OpenSSL *eay32 libs on Windows Daniel Gustafsson 11:00
Re: IANA timezone abbreviations versus timezone_abbreviations Jelte Fennema-Nio 11:03
Re: IANA timezone abbreviations versus timezone_abbreviations Jelte Fennema-Nio 12:22
Re: Support regular expressions with nondeterministic collations 📎 Peter Eisentraut 12:29
Re: add support for the old naming libs convention on windows (ssleay32.lib and libeay32.lib) Nazir Bilal Yavuz 12:39
Re: Row pattern recognition 📎 Tatsuo Ishii 13:37
Re: Logging parallel worker draught Sami Imseih 15:06
Re: psql: Option to use expanded mode for various meta-commands Greg Sabino Mullane 15:48
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Michail Nikolaev 16:08
Re: RFC: Allow EXPLAIN to Output Page Fault Information Bruce Momjian 16:19
Re: IANA timezone abbreviations versus timezone_abbreviations Tom Lane 16:33
Re: Proposal: Progressive explain Greg Sabino Mullane 16:37
Re: RFC: Allow EXPLAIN to Output Page Fault Information Tom Lane 16:39
Re: Memory leak in pg_logical_slot_{get,peek}_changes 📎 vignesh C 17:01
Re: Query regarding pg_prewarm extension Ayush Vatsa 17:24
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 17:33
Re: Query regarding pg_prewarm extension Bruce Momjian 17:38
Re: Proposal: Progressive explain Sami Imseih 17:43
Re: improve EXPLAIN for wide tables Sami Imseih 17:51
Re: Correct the reference for plpgsql_yyparse() Tom Lane 19:35
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 19:37
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Sami Imseih 19:56
Re: Statistics Import and Export Jeff Davis 20:02
Re: Query regarding pg_prewarm extension David Rowley 20:14
Re: Statistics Import and Export Bruce Momjian 20:45
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Michail Nikolaev 20:48
Re: EphemeralNamedRelation and materialized view 📎 Tom Lane 21:06
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 21:11
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker Peter Smith 21:17
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Jim Nasby 21:40
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 21:50
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 21:58
Re: Add the ability to limit the amount of memory that can be allocated to backends. David Rowley 22:56
Re: RFC: Allow EXPLAIN to Output Page Fault Information Jelte Fennema-Nio 22:57
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 22:58
Re: Add the ability to limit the amount of memory that can be allocated to backends. David Rowley 23:12
Re: Row pattern recognition 📎 Tatsuo Ishii 23:57

Dec. 31, 2024

Thread Author Time
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 00:34
Re: Remove support for OpenSSL *eay32 libs on Windows Michael Paquier 00:49
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 00:51
Re: WAL-logging facility for pgstats kinds 📎 Michael Paquier 00:52
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 01:03
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 01:05
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Michael Paquier 01:06
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 01:17
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Michael Paquier 01:23
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Tom Lane 02:00
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 03:02
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 03:12
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 03:25
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 03:27
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Sami Imseih 03:52
add vacuum starttime columns wenhui qiu 03:55
Re: add vacuum starttime columns David G. Johnston 04:31
Re: add vacuum starttime columns Sami Imseih 04:40
Re: add vacuum starttime columns wenhui qiu 04:40
POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Masahiko Sawada 04:44
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 05:48
Re: Proposal: Progressive explain jian he 06:00
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 07:00
Re: Introduce XID age and inactive timeout based replication slot invalidation Nisha Moond 07:05
Re: add vacuum starttime columns wenhui qiu 07:32
Re: Autovacuum giving up on tables after crash because of lack of stats Bertrand Drouvot 07:53
Re: ERROR: corrupt MVNDistinct entry 📎 Richard Guo 08:40
RE: AIX support Srirama Kucherlapati 08:55
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Christoph Berg 09:50
Re: [PATCH] New predefined role pg_manage_extensions Michael Banck 11:15
Re: WAL-logging facility for pgstats kinds Bertrand Drouvot 11:29
Re: Test to dump and restore objects left behind by regression 📎 Ashutosh Bapat 11:54
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Andrew Dunstan 12:36
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Tomas Vondra 15:06
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Tomas Vondra 15:20
Re: FileFallocate misbehaving on XFS Andres Freund 15:31
Re: SQLFunctionCache and generic plans Pavel Stehule 15:39
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Tom Lane 15:43
Re: add vacuum starttime columns Sami Imseih 15:53
Modern SHA2- based password hashes for pgcrypto 📎 Bernd Helmle 16:06
Re: using index to speedup add not null constraints to a table 📎 jian he 16:09
Re: add vacuum starttime columns Greg Sabino Mullane 16:18
Re: Proposal: Progressive explain 📎 Rafael Thofehrn Castro 16:23
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 16:36
Re: Modern SHA2- based password hashes for pgcrypto Bernd Helmle 16:36
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 16:50
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 16:52
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Shayon Mukherjee 16:59
Re: Add XMLNamespaces to XMLElement Pavel Stehule 17:03
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 17:14
Re: add vacuum starttime columns Sami Imseih 17:41
Strange issue with NFS mounted PGDATA on ugreen NAS 📎 Larry Rosenman 18:22
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 18:23
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 19:46
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 20:19
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 20:30
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Larry Rosenman 20:46
Re: Add the ability to limit the amount of memory that can be allocated to backends. Jim Nasby 20:46
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) David G. Johnston 20:47
Re: Improve documentation regarding custom settings, placeholders, and the administrative functions David G. Johnston 20:49
Re: Document How Commit Handles Aborted Transactions David G. Johnston 20:49
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 20:52
Re: PoC: history of recent vacuum/checkpoint runs (using new hooks) Jim Nasby 20:54
Re: add vacuum starttime columns Sami Imseih 21:35
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Tom Lane 22:44
Adjusting hash join memory limit to handle batch explosion 📎 Tomas Vondra 23:06
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Thomas Munro 23:24
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Larry Rosenman 23:26
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Tom Lane 23:37
Re: Add the ability to limit the amount of memory that can be allocated to backends. Tomas Vondra 23:41
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Larry Rosenman 23:43
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Tom Lane 23:58

Jan. 1, 2025

Thread Author Time
Re: AIO v2.2 📎 Andres Freund 04:03
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Thomas Munro 05:21
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:36
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Tom Lane 05:39
Re: Logical replication timeout 📎 Shlok Kyal 06:47
Re: Adding OLD/NEW support to RETURNING 📎 Dean Rasheed 08:19
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Ashutosh Bapat 08:52
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Ashutosh Bapat 09:01
Re: Conflict detection for update_deleted in logical replication 📎 Amit Kapila 12:24
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Michail Nikolaev 14:58
Re: Typos in the code and README 📎 Alexander Lakhin 16:00
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Michail Nikolaev 16:16
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Michail Nikolaev 17:53
Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin 18:00
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 18:32
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 20:35
Re: POC: make mxidoff 64 bits Heikki Linnakangas 22:12
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 22:50
Incorrect CHUNKHDRSZ in nodeAgg.c 📎 David Rowley 22:55

Browse Archives

Prev | Next