pgsql-hackers since 2026-06-20 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

June 20, 2026

Thread	Author	Time
Improve UNION's output rowcount estimate 📎	Richard Guo	02:21
Re: Row pattern recognition	Tatsuo Ishii	03:17
Re: use of SPI by postgresImportForeignStatistics	Corey Huinker	04:11
Re: PROXY protocol support 📎	Julien Riou	05:46
Re: Unexpected behavior after OOM errors	Michael Paquier	06:03
Re: Fix race in ReplicationSlotRelease for ephemeral slots	Xuneng Zhou	06:41
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision	Tatsuya Kawata	06:44
Re: [PATCH] O_CLOEXEC not honored on Windows - handle inheritance chain	Alexander Lakhin	07:00
Compile warnings under -DMEMORY_CONTEXT_CHECKING and no assertions 📎	Michael Paquier	07:40
Re: Unexpected behavior after OOM errors	Michael Paquier	07:45
Re: [PATCH] Fix two incorrect code comments	Michael Paquier	07:49
Re: Unexpected behavior after OOM errors	Alexander Lakhin	08:00
Re: More jsonpath methods: translate, split, join 📎	Florents Tselai	08:34
Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope 📎	Tatsuya Kawata	09:14
Re: PROXY protocol support 📎	Julien Riou	09:18
Re: Fix publisher-side sequence permission reporting	Fujii Masao	09:24
Re: Fix race in ReplicationSlotRelease for ephemeral slots	Amit Kapila	09:42
Re: Row pattern recognition	Tatsuo Ishii	09:58
Re: Fix publisher-side sequence permission reporting	Amit Kapila	10:20
Re: Fix \crosstabview to honor \pset display_true/display_false	Álvaro Herrera	10:32
Re: Performance Degradation (Table becomes bloat) During Repeated Bulk UPDATE Operations	Álvaro Herrera	10:35
Re: Compile warnings under -DMEMORY_CONTEXT_CHECKING and no assertions	Álvaro Herrera	10:45
Re: enhance wraparound warnings 📎	Fujii Masao	11:54
Re: Fix publisher-side sequence permission reporting	Fujii Masao	12:43
Re: PG20 Minimum Dependency Thread	Peter Eisentraut	13:16
Re: BUG with accessing to temporary tables of other sessions still exists	ZizhuanLiu X-MAN	15:48
Re: [PATCH] O_CLOEXEC not honored on Windows - handle inheritance chain	Bryan Green	17:48
[PATCH v2] Standardize log polling using wait_for_log() across recovery tests	Zakariyah Ali	17:49
Re: BUG with accessing to temporary tables of other sessions still exists	Daniil Davydov	18:52
Re: SQL/JSON: JSON_TRANSFORM (SQL standard, subclause 6.44)	Zsolt Parragi	21:30
Re: Fix HAVING-to-WHERE pushdown with mismatched operator families	Zsolt Parragi	21:46
Re: [PATCH] DOCS: Distinguish table and index storage parameters	Andreas Karlsson	22:14

June 21, 2026

Thread	Author	Time
Re: Fix \crosstabview to honor \pset display_true/display_false 📎	Chao Li	00:37
Re: Row pattern recognition 📎	Henson Choi	06:39
Re: Row pattern recognition	Henson Choi	06:52
Re: PG20 Minimum Dependency Thread	Zsolt Parragi	07:57
Re: BUG with accessing to temporary tables of other sessions still exists	ZizhuanLiu X-MAN	08:08
Re: BUG with accessing to temporary tables of other sessions still exists	ZizhuanLiu X-MAN	08:25
Re: pg_rewind does not rewind diverging timelines	Mats Kindahl	09:09
Re: BUG with accessing to temporary tables of other sessions still exists 📎	Daniil Davydov	09:13
Re: [PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks 📎	JoongHyuk Shin	09:27
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Alexander Korotkov	12:11
Re: [PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks	Álvaro Herrera	12:31
Re: BUG with accessing to temporary tables of other sessions still exists	ZizhuanLiu X-MAN	12:35
Re: Proposal: Conflict log history table for Logical Replication	vignesh C	12:55
Re: PG20 Minimum Dependency Thread	Andrew Dunstan	13:23
Re: SQL/JSON: JSON_TRANSFORM (SQL standard, subclause 6.44)	Srinath Reddy Sadipiralla	13:48
Re: Proposal: Conflict log history table for Logical Replication 📎	Amit Kapila	13:48
Re: PG20 Minimum Dependency Thread	Tom Lane	14:02
Re: Proposal: Conflict log history table for Logical Replication	vignesh C	14:22
Re: [PATCH] Preserve replication origin OIDs in pg_upgrade	Rui Zhao	16:22
Re: Require SSL connection to postgres for oauth	Jonathan Gonzalez V.	17:25
Re: Error while processing invalidation message during ATTACH PARTITION leaves invalid relcache entry	Alexander Lakhin	18:00
Global temporary tables 📎	Dean Rasheed	19:08
Re: DOCS - Clarify behaviour when EXCEPT tables are moved/renamed	Peter Smith	21:23
Re: Global temporary tables 📎	Andrew Dunstan	22:05
Re: pg_stat_replication docs incomplete for logical replication	Peter Smith	22:39

June 22, 2026

Thread	Author	Time
Re: Improve UNION's output rowcount estimate	David Rowley	00:39
Re: Support EXCEPT for TABLES IN SCHEMA publications	Peter Smith	02:16
Re: Improve UNION's output rowcount estimate 📎	Richard Guo	02:59
Re: Proposal: Conflict log history table for Logical Replication	Amit Kapila	03:10
bytea(uuid) missing proleakproof? 📎	Chao Li	03:59
Re: Fix publisher-side sequence permission reporting	Amit Kapila	04:03
Re: Proposal: Conflict log history table for Logical Replication	vignesh C	04:03
Re: [PATCH] Change wait_time column of pg_stat_lock to double precision	Bertrand Drouvot	04:26
Re: Support EXCEPT for ALL SEQUENCES publications	Peter Smith	04:35
Re: [PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks 📎	JoongHyuk Shin	04:37
Re: Improve UNION's output rowcount estimate	David Rowley	04:38
Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope	Bertrand Drouvot	05:05
Re: [PATCH] Add support for INSERT ... SET syntax	solai v	05:14
Re: Proposal: Conflict log history table for Logical Replication 📎	vignesh C	05:26
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements 📎	Akshay Joshi	06:26
Re: assertion failure with unique index + partitioning + join	Richard Guo	06:37
doc: should pg_createsubscriber be grouped as a client application?	Peter Eisentraut	06:39
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Chao Li	06:54
RE: doc: should pg_createsubscriber be grouped as a client application?	Hayato Kuroda (Fujitsu)	06:56
Re: Row pattern recognition 📎	Henson Choi	07:07
Fix handling of copy_file_range() return value 📎	Peter Eisentraut	07:19
Re: doc: should pg_createsubscriber be grouped as a client application?	Kyotaro Horiguchi	07:46
truncating casts of pgoff_t 📎	Peter Eisentraut	07:56
Re: pgbench --continue-on-error: clarify TPS and failure reporting 📎	Chao Li	08:10
Re: 048_vacuum_horizon_floor.pl hangs due to wakeup lost inside LockBufferForCleanup 📎	Xuneng Zhou	08:14
Re: Reorganize GUC structs 📎	Anton Voloshin	08:15
Re: Fix handling of copy_file_range() return value	Nazir Bilal Yavuz	08:17
Re: Proposal: Conflict log history table for Logical Replication	shveta malik	08:26
enum_in cache lookup failed for type 📎	jian he	08:28
Re: Fix handling of copy_file_range() return value	Kyotaro Horiguchi	08:34
Re: Proposal: Conflict log history table for Logical Replication	shveta malik	08:38
Re: Remove redundant DISTINCT when GROUP BY already guarantees uniqueness	Andres Taylor	08:44
Re: Fix handling of copy_file_range() return value	Yingying Chen	08:46
Re: Remove redundant DISTINCT when GROUP BY already guarantees uniqueness	Andrés Taylor	08:49
Re: truncating casts of pgoff_t	Heikki Linnakangas	08:55
Re: Global temporary tables 📎	Dean Rasheed	08:56
Re: GRAPH_TABLE: aggregates/window/set-returning functions in COLUMNS crash the backend 📎	Ewan Young	08:57
Re: Proposal: Conflict log history table for Logical Replication 📎	Amit Kapila	09:07
Re: Show hashed SAOP decision in EXPLAIN 📎	Andrei Lepikhov	09:14
Re: Proposal: Conflict log history table for Logical Replication	shveta malik	09:21
Re: truncating casts of pgoff_t	Chao Li	09:29
psql: Fix CREATE SCHEMA scanning of nested routine bodies 📎	Chao Li	09:34
RE: [PATCH] Improving index selection for logical replication apply with replica identity full	Hayato Kuroda (Fujitsu)	10:05
Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values 📎	Dean Rasheed	10:13
Re: Heads Up: cirrus-ci is shutting down June 1st	Tatsuo Ishii	10:23
Re: Remove inner joins based on foreign keys	Tender Wang	10:42
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Pavel Borisov	10:44
Re: [PATCH] Improving index selection for logical replication apply with replica identity full	Önder Kalacı	10:57
Re: Proposal: Conflict log history table for Logical Replication 📎	Nisha Moond	11:02
Re: Performance Degradation (Table becomes bloat) During Repeated Bulk UPDATE Operations	Jeyaprakash Rajamani	11:09
Re: REPACK CONCURRENTLY fails on tables with generated columns 📎	Antonin Houska	11:12
Re: [PATCH] Add support for SAOP in the optimizer for partial index paths	Nishant Sharma	11:34
Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope 📎	Tatsuya Kawata	11:34
Re: TID recycling race during nbtree index-only scans that run on a standby 📎	Matthias van de Meent	11:38
Re: Report bytes and transactions actually sent downtream 📎	Ashutosh Sharma	11:54
RE: [PATCH] Improving index selection for logical replication apply with replica identity full	Hayato Kuroda (Fujitsu)	12:10
Re: [PATCH] btree_gist: add cross-type integer operator support for GiST 📎	Maxime Schoemans	12:20
RE: Include sequences in publications created by pg_createsubscriber	Hayato Kuroda (Fujitsu)	12:39
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements 📎	Akshay Joshi	12:40
Re: Support EXCEPT for TABLES IN SCHEMA publications 📎	Nisha Moond	12:49
Re: REPACK CONCURRENTLY fails on tables with generated columns	Ewan Young	12:49
[WIP] Adding a { LOCK ROWS | LOCK KEY INDEX } clause to FK definitions 📎	Matthias van de Meent	12:50
Re: Row pattern recognition	Tatsuo Ishii	12:55
Fix contradictory comment for pgstat_slru_flush_cb() 📎	Shinya Kato	13:00
Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement	Akshay Joshi	13:04
Re: log_checkpoints: count WAL segment creations from all processes	solai v	13:04
Allow pg_log_backend_memory_contexts() for postmaster 📎	Jakub Wartak	13:15
Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement 📎	Akshay Joshi	13:19
Re: Global temporary tables	Andrew Dunstan	13:43
Re: RFC: Logging plan of the running query	Robert Haas	13:50
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Chao Li	14:00
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Akshay Joshi	14:11
Re: [PATCH v3] Add ssl_cert_files/ssl_key_files for multi-certificate support 📎	Renaud Métrich	14:53
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Marcos Pegoraro	14:54
Re: Proposal: Conflict log history table for Logical Replication 📎	Dilip Kumar	15:22
Re: Global temporary tables	Pavel Stehule	15:30
Re: Add a greedy join search algorithm to handle large join problems 📎	Tomas Vondra	15:33
Re: psql: Fix CREATE SCHEMA scanning of nested routine bodies	Tom Lane	16:04
Re: 048_vacuum_horizon_floor.pl hangs due to wakeup lost inside LockBufferForCleanup	Melanie Plageman	16:43
Re: Deadlock detector fails to activate on a hot standby replica	Vitaly Davydov	18:32
Re: [PATCH v3] Add ssl_cert_files/ssl_key_files for multi-certificate support	Zsolt Parragi	18:40
Re: More jsonpath methods: translate, split, join	Zsolt Parragi	18:51
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Zsolt Parragi	18:56
Re: Is there value in having optimizer stats for joins/foreignkeys?	Tomas Vondra	19:03
Re: use of SPI by postgresImportForeignStatistics 📎	Corey Huinker	19:08
Re: Allow pg_log_backend_memory_contexts() for postmaster	Andres Freund	19:36
The PostgreSQL C Dialect	Christophe Pettus	19:39
Fix unsafe coding in ResourceOwnerReleaseAll() 📎	Tom Lane	19:45
Re: 048_vacuum_horizon_floor.pl hangs due to wakeup lost inside LockBufferForCleanup	Andres Freund	20:03
Re: 048_vacuum_horizon_floor.pl hangs due to wakeup lost inside LockBufferForCleanup	Andres Freund	20:11
Re: The PostgreSQL C Dialect	Tom Lane	20:15
Re: The PostgreSQL C Dialect	Bruce Momjian	20:37
Re: postgres_fdw: Emit message when batch_size is reduced	Corey Huinker	20:40
Re: index prefetching 📎	Peter Geoghegan	20:48
Re: PG20 Minimum Dependency Thread	Jacob Champion	20:50
Re: Support EXCEPT for ALL SEQUENCES publications	Peter Smith	21:03
Re: Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server	Jeff Davis	21:10
[PATCH] Warn when io_min_workers exceeds io_max_workers 📎	Baji Shaik	21:21
Re: Handle concurrent drop when doing whole database vacuum	surya poondla	21:26
Re: [RFC PATCH v0 0/7] Add EXPLAIN ANALYZE wait event reporting	Robert Haas	21:34
Re: [RFC PATCH v0 0/7] Add EXPLAIN ANALYZE wait event reporting	Andres Freund	21:50
Re: The PostgreSQL C Dialect	Roberto Mello	22:10
[PATCH v1] Allow excluded tables to remain in the pg_restore data-loading path for directory-format dumps 📎	Kirk Wolak	22:17
Re: [PATCH] Warn when io_min_workers exceeds io_max_workers	Tristan Partin	22:30
Re: Add a hook for handling logical decoding messages on subscribers.	Bharath Rupireddy	22:39
Re: Show estimated number of groups for IncrementalSort in EXPLAIN	David Rowley	22:39
Re: psql: Fix CREATE SCHEMA scanning of nested routine bodies	Chao Li	23:08
Re: The PostgreSQL C Dialect	Christophe Pettus	23:14
Re: Fix contradictory comment for pgstat_slru_flush_cb()	Michael Paquier	23:29
Re: Support EXCEPT for TABLES IN SCHEMA publications	Peter Smith	23:40

June 23, 2026

Thread	Author	Time
Re: Include sequences in publications created by pg_createsubscriber	Peter Smith	01:03
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Masahiko Sawada	01:06
Re: Performance Degradation (Table becomes bloat) During Repeated Bulk UPDATE Operations	Bharath Rupireddy	01:19
Re: Fix HAVING-to-WHERE pushdown with mismatched operator families	Richard Guo	01:20
Re: [PATCH] Warn when io_min_workers exceeds io_max_workers	Baji Shaik	01:27
Re: [PATCH] Warn when io_min_workers exceeds io_max_workers	Michael Paquier	01:29
md5_password_warnings for password auth with MD5-encrypted passwords 📎	Fujii Masao	01:39
Re: Small patch to improve safety of utf8_to_unicode(). 📎	Jeff Davis	02:02
Fix variadic argument types for pg_get_xxx_ddl() functions	Chao Li	02:11
Re: 048_vacuum_horizon_floor.pl hangs due to wakeup lost inside LockBufferForCleanup	Xuneng Zhou	02:15
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Chao Li	02:18
Re: md5_password_warnings for password auth with MD5-encrypted passwords	Chao Li	02:44
Re: 048_vacuum_horizon_floor.pl hangs due to wakeup lost inside LockBufferForCleanup	Xuneng Zhou	02:44
Re: [PATCH] Warn when io_min_workers exceeds io_max_workers 📎	Baji Shaik	02:47
Re: Remove inner joins based on foreign keys	Richard Guo	02:47
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 📎	jian he	02:50
Re: Random pg_upgrade 004_subscription test failure on drongo	Alexander Lakhin	03:00
Re: Heads Up: cirrus-ci is shutting down June 1st	Thomas Munro	03:10
Re: Deadlock detector fails to activate on a hot standby replica 📎	Fujii Masao	03:13
Re: md5_password_warnings for password auth with MD5-encrypted passwords	Japin Li	03:17
Re: The PostgreSQL C Dialect	John Naylor	03:32
Re: The PostgreSQL C Dialect	Bertrand Drouvot	03:53
Re: [PATCH] Warn when io_min_workers exceeds io_max_workers	Michael Paquier	04:03
Re: [PATCH] doc: clarify pg_stat_lock.fastpath_exceeded scope	Bertrand Drouvot	04:07
Re: md5_password_warnings for password auth with MD5-encrypted passwords	Fujii Masao	04:31
Re: md5_password_warnings for password auth with MD5-encrypted passwords	Kyotaro Horiguchi	04:49
Re: Handle concurrent drop when doing whole database vacuum 📎	cca5507	05:20
Re: Proposal: Conflict log history table for Logical Replication	shveta malik	05:27
Re: [PATCH] Warn when io_min_workers exceeds io_max_workers	Kyotaro Horiguchi	05:36
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	05:41
Re: IGNORE/RESPECT NULLS can be specified for (prokind == 'f').	Fujii Masao	05:55
Re: The PostgreSQL C Dialect	Christophe Pettus	06:15
Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements	Kyotaro Horiguchi	06:15

Browse Archives

Prev | Next