pgsql-hackers since 2025-04-09 22:53

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

April 9, 2025

Thread Author Time
Re: n_ins_since_vacuum stats for aborted transactions Sami Imseih 22:53
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 23:08
Re: [PoC] Federated Authn/z with OAUTHBEARER Jelte Fennema-Nio 23:42
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎 Peter Smith 23:52
Re: Large expressions in indexes can't be stored (non-TOASTable) Euler Taveira 23:54

April 10, 2025

Thread Author Time
Re: n_ins_since_vacuum stats for aborted transactions 📎 David Rowley 01:48
Re: sync_standbys_defined read/write race on startup 📎 Michael Paquier 02:25
Re: speedup COPY TO for partitioned table. 📎 jian he 02:44
Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c Michael Paquier 02:53
Re: Fix 035_standby_logical_decoding.pl race conditions Michael Paquier 03:00
Re: [PoC] Reducing planning time when tables have many partitions David Rowley 03:03
Re: n_ins_since_vacuum stats for aborted transactions 📎 Sami Imseih 03:42
Improve a few appendStringInfo calls new to v18 📎 David Rowley 03:51
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Peter Smith 04:26
Re: Feature Recommendations for Logical Subscriptions YeXiu 04:42
Re: [PoC] Reducing planning time when tables have many partitions Amit Langote 04:57
Re: [PoC] Reducing planning time when tables have many partitions David Rowley 05:35
Re: Possible api miuse bms_next_member David Rowley 05:57
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro 06:00
Add .DS_Store to .gitignore 📎 Dianjin Wang 06:04
Re: Add .DS_Store to .gitignore David Rowley 06:10
Fw: Mention the default io_method? Daniel Westermann (DWE) 06:11
Re: [PoC] Reducing planning time when tables have many partitions Amit Langote 06:28
Re: sync_standbys_defined read/write race on startup Maksim.Melnikov 07:12
Re: Add .DS_Store to .gitignore Dianjin Wang 07:15
Re: Cannot find a working 64-bit integer type on Illumos Thomas Munro 07:20
The varnullingrels bitmapset is not only about outer joins 📎 Andrei Lepikhov 07:40
Re: 64 bit numbers vs format strings Thomas Munro 08:16
Re: Improve a few appendStringInfo calls new to v18 Heikki Linnakangas 08:24
Re: speedup COPY TO for partitioned table. Kirill Reshke 08:25
Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c Tender Wang 08:44
Re: bug in stored generated column over domain with constraints. 📎 jian he 08:53
wrong comments in rewriteTargetListIU jian he 08:57
Re: sync_standbys_defined read/write race on startup 📎 Michael Paquier 09:15
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Amit Kapila 09:43
Re: long-standing data loss bug in initial sync of logical replication Amit Kapila 09:45
Re: wrong comments in rewriteTargetListIU Amit Langote 09:46
Correct documentation for protocol version 📎 Dave Cramer 09:52
Re: sync_standbys_defined read/write race on startup Maksim.Melnikov 09:55
Re: Memoize ANTI and SEMI JOIN inner 📎 Richard Guo 10:36
Re: Skipping schema changes in publication Amit Kapila 11:24
Re: Feature Recommendations for Logical Subscriptions Amit Kapila 11:29
Re: Some problems regarding the self-join elimination code Alexander Korotkov 11:36
Re: pgsql: Add function to get memory context stats for processes 📎 Laurenz Albe 11:42
Re: pgsql: Add function to get memory context stats for processes Aleksander Alekseev 11:48
Re: PostgreSQL 18 Release Management Team & Feature Freeze Aleksander Alekseev 11:57
Re: PostgreSQL 18 Release Management Team & Feature Freeze Heikki Linnakangas 12:11
Re: PostgreSQL 18 Release Management Team & Feature Freeze Aleksander Alekseev 12:14
Re: PostgreSQL 18 Release Management Team & Feature Freeze Heikki Linnakangas 12:19
Capturing both IP address and hostname in the log Tefft, Michael J 12:22
Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c Peter Eisentraut 12:25
Re: speedup COPY TO for partitioned table. jian he 12:37
Re: Consistently use macro HeapTupleIsValid to check the validity of tuples in tablecmds.c Peter Eisentraut 12:37
Re: Some problems regarding the self-join elimination code Andrei Lepikhov 12:39
Re: pgsql: Add function to get memory context stats for processes Daniel Gustafsson 12:46
Re: long-standing data loss bug in initial sync of logical replication Tomas Vondra 12:51
Re: pgsql: Add function to get memory context stats for processes Laurenz Albe 12:51
Add os_page_num to pg_buffercache 📎 Bertrand Drouvot 13:17
Re: pgsql: Add function to get memory context stats for processes Robert Haas 13:31
Re: Add os_page_num to pg_buffercache Tomas Vondra 13:35
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Bertrand Drouvot 13:50
Re: Correct documentation for protocol version Fujii Masao 13:54
Re: PostgreSQL 18 Release Management Team & Feature Freeze Nathan Bossart 13:58
Re: n_ins_since_vacuum stats for aborted transactions 📎 Sami Imseih 14:01
Re: Correct documentation for protocol version 📎 Dave Cramer 14:40
Re: Improve a few appendStringInfo calls new to v18 Nathan Bossart 14:51
Re: Add os_page_num to pg_buffercache Nathan Bossart 14:58
Re: Add os_page_num to pg_buffercache Bertrand Drouvot 15:05
Re: tab complete for COPY populated materialized view TO 📎 Fujii Masao 15:07
Re: Correct documentation for protocol version Jacob Champion 15:14
Re: Correct documentation for protocol version Fujii Masao 15:17
Re: Capturing both IP address and hostname in the log Adrian Klaver 15:22
Re: Proposal: Limitations of palloc inside checkpointer 📎 Xuneng Zhou 15:43
Re: Correct documentation for protocol version 📎 Dave Cramer 15:49
Re: Capturing both IP address and hostname in the log Tom Lane 16:00
Re: Add missing PGDLLIMPORT markings Robert Haas 16:03
Re: Correct documentation for protocol version Fujii Masao 16:17
Re: as per commit 643a1a61985bef2590496, move create/open dir code to function using switch case of pg_backup_directory.c file also Andrew Dunstan 16:17
Re: Add missing PGDLLIMPORT markings Tom Lane 16:19
Re: Capturing both IP address and hostname in the log David G. Johnston 16:33
Re: Capturing both IP address and hostname in the log David G. Johnston 16:35
merge file_exists_in_directory and _fileExistsInDirectory functions and move into common file dumputils.c 📎 Mahendra Singh Thalor 17:11
Re: as per commit 643a1a61985bef2590496, move create/open dir code to function using switch case of pg_backup_directory.c file also Mahendra Singh Thalor 17:12
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 17:13
Re: BitmapHeapScan streaming read user and prelim refactoring James Hunter 17:50
Silence resource leaks alerts 📎 Ranier Vilela 18:10
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote 📎 Mahendra Singh Thalor 18:28
Re: Non-text mode for pg_dumpall 📎 Ranier Vilela 18:38
Re: Add connection active, idle time to pg_stat_activity Robert Haas 18:46
Re: Non-text mode for pg_dumpall Andrew Dunstan 18:58
catcache search while BUFFER_LOCK_EXCLUSIVE on catalog 📎 Noah Misch 19:18
Re: tab complete for COPY populated materialized view TO Kirill Reshke 19:19
Re: tab complete for COPY populated materialized view TO David G. Johnston 19:33
Re: tab complete for COPY populated materialized view TO Kirill Reshke 19:37
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Robert Haas 19:45
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Tom Lane 19:54
Re: pgsql: Add function to get memory context stats for processes Andres Freund 20:05
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Robert Haas 20:05
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Robert Haas 20:07
Re: Correct documentation for protocol version 📎 Dave Cramer 20:17
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Tom Lane 20:33
stats.sql fails during installcheck on mac 📎 Sami Imseih 21:39
Re: Non-text mode for pg_dumpall Ranier Vilela 21:45
Re: Feature Recommendations for Logical Subscriptions Peter Smith 22:10
Re: Improve a few appendStringInfo calls new to v18 David Rowley 22:10
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Andres Freund 22:27
Re: stats.sql fails during installcheck on mac Tom Lane 22:36
Re: Add missing PGDLLIMPORT markings Daniel Gustafsson 22:38
Re: Improve a few appendStringInfo calls new to v18 David Rowley 22:40
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Matthias van de Meent 22:47
Re: Non-text mode for pg_dumpall Andrew Dunstan 23:08
Re: Non-text mode for pg_dumpall Ranier Vilela 23:23
Re: stats.sql fails during installcheck on mac Sami Imseih 23:45
Re: n_ins_since_vacuum stats for aborted transactions David Rowley 23:45

April 11, 2025

Thread Author Time
Re: Fundamental scheduling bug in parallel restore of partitioned tables 📎 Tom Lane 00:08
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 00:12
Re: n_ins_since_vacuum stats for aborted transactions 📎 Sami Imseih 00:38
Re: Streaming relation data out of order Thomas Munro 00:50
Re: sync_standbys_defined read/write race on startup Michael Paquier 01:10
Re: n_ins_since_vacuum stats for aborted transactions David G. Johnston 01:37
Re: Add connection active, idle time to pg_stat_activity Richard Guo 01:41
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Andres Freund 02:06
Re: BitmapHeapScan streaming read user and prelim refactoring Thomas Munro 03:14
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Peter Smith 03:14
Re: Feature Recommendations for Logical Subscriptions Amit Kapila 04:00
Re: stats.sql fails during installcheck on mac 📎 Michael Paquier 04:17
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Peter Smith 04:21
Re: stats.sql fails during installcheck on mac Michael Paquier 04:26
Re: merge file_exists_in_directory and _fileExistsInDirectory functions and move into common file dumputils.c Michael Paquier 04:51
Re: Silence resource leaks alerts Michael Paquier 05:08
Fix replica identity checks for MERGE command on published table. 📎 Zhijie Hou (Fujitsu) 05:24
Re: Silence resource leaks alerts Tom Lane 05:37
Re: Feature Recommendations for Logical Subscriptions YeXiu 05:47
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Peter Smith 06:05
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo 06:51
Re: Improve a few appendStringInfo calls new to v18 Peter Eisentraut 07:07
Re: Add missing PGDLLIMPORT markings Peter Eisentraut 07:08
Re: Fix slot synchronization with two_phase decoding enabled 📎 Nisha Moond 07:32
disallow ALTER VIEW SET DEFAULT when the corresponding base relation column is a generated column 📎 jian he 07:41
Regression test fails when 1) old PG is installed and 2) meson/ninja build is used Hayato Kuroda (Fujitsu) 07:53
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz 08:01
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz 08:02
Re: Correct documentation for protocol version Fujii Masao 09:05
Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache 📎 Nazir Bilal Yavuz 09:13
Re: why there is not VACUUM FULL CONCURRENTLY? 📎 Antonin Houska 09:25
Re: Correct documentation for protocol version 📎 Dave Cramer 09:27
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 09:28
Re: merge file_exists_in_directory and _fileExistsInDirectory functions and move into common file dumputils.c Álvaro Herrera 09:38
Re: Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. 📎 Daniel Gustafsson 10:23
Re: Silence resource leaks alerts Ranier Vilela 11:27
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Robert Haas 11:43
Re: as per commit 643a1a61985bef2590496, move create/open dir code to function using switch case of pg_backup_directory.c file also Álvaro Herrera 12:07
Re: Silence resource leaks alerts Ranier Vilela 12:16
add some more error checks into _fileExistsInDirectory function to report "too long name" error 📎 Mahendra Singh Thalor 12:26
Re: merge file_exists_in_directory and _fileExistsInDirectory functions and move into common file dumputils.c Mahendra Singh Thalor 12:30
Re: add some more error checks into _fileExistsInDirectory function to report "too long name" error Daniel Gustafsson 13:08
Re: RFC: Allow EXPLAIN to Output Page Fault Information 📎 torikoshia 13:18
COALESCE with single argument looks like identity function 📎 Maksim Milyutin 13:26
Re: Feature Recommendations for Logical Subscriptions YeXiu 13:29
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Andres Freund 13:36
Re: Correct documentation for protocol version Fujii Masao 13:39
Re: Improve a few appendStringInfo calls new to v18 Tom Lane 13:45
Re: Regression test fails when 1) old PG is installed and 2) meson/ninja build is used Andres Freund 13:47
Re: COALESCE with single argument looks like identity function Tom Lane 14:00
Re: disallow ALTER VIEW SET DEFAULT when the corresponding base relation column is a generated column Tom Lane 14:07
Conflicting updates of command progress Antonin Houska 14:12
Re: Changing shared_buffers without restart Ashutosh Bapat 14:34
Re: Improve a few appendStringInfo calls new to v18 Nathan Bossart 14:41
Re: Some problems regarding the self-join elimination code 📎 Andrei Lepikhov 14:46
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Nathan Bossart 14:47
Re: Correct documentation for protocol version Dave Cramer 14:56
Re: Correct documentation for protocol version Jelte Fennema-Nio 14:59
Re: Changing shared_buffers without restart Dmitry Dolgov 15:01
Re: Correct documentation for protocol version Jelte Fennema-Nio 15:02
Re: disallow ALTER VIEW SET DEFAULT when the corresponding base relation column is a generated column David G. Johnston 15:32
Re: stats.sql fails during installcheck on mac Sami Imseih 15:44
Re: [PoC] Federated Authn/z with OAUTHBEARER Wolfgang Walther 16:21
someone else to do the list of acknowledgments Peter Eisentraut 16:25
Re: Things I don't like about \du's "Attributes" column David G. Johnston 17:09
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 17:32
remove unnecessary explicit type conversion (to char) for appendStringInfoChar function calls 📎 Mahendra Singh Thalor 17:36
Re: SQL/JSON json_table plan clause 📎 Nikita Malakhov 18:57
Re: Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. Rahila Syed 19:08
Re: n_ins_since_vacuum stats for aborted transactions 📎 Sami Imseih 19:33
Re: Horribly slow pg_upgrade performance with many Large Objects Nathan Bossart 20:11
Re: Fixing various typos in comments and docs Daniel Gustafsson 20:23
New committer: Jacob Champion Jonathan S. Katz 20:26
Re: type cache cleanup improvements Noah Misch 20:32
Re: New committer: Jacob Champion Joe Conway 20:53
Re: New committer: Jacob Champion Nathan Bossart 21:02
Re: Large expressions in indexes can't be stored (non-TOASTable) 📎 Nathan Bossart 21:21
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Alexander Korotkov 21:42
Re: type cache cleanup improvements Alexander Korotkov 21:43
Re: n_ins_since_vacuum stats for aborted transactions David G. Johnston 22:03
Re: New committer: Jacob Champion Michael Paquier 23:01
Re: stats.sql fails during installcheck on mac Michael Paquier 23:06
Re: New committer: Jacob Champion Bharath Rupireddy 23:35

April 12, 2025

Thread Author Time
Re: Fixing various typos in comments and docs Jacob Brazeal 00:18
Re: n_ins_since_vacuum stats for aborted transactions Sami Imseih 00:18
Re: stats.sql fails during installcheck on mac Sami Imseih 00:37

Browse Archives

Prev | Next