pgsql-hackers since 2024-04-21 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

April 21, 2024

Thread	Author	Time
Re: pgsql: Fix restore of not-null constraints with inheritance	Justin Pryzby	01:25
Re: Support a wildcard in backtrace_functions	Peter Eisentraut	07:26
Re: Support a wildcard in backtrace_functions	Jelte Fennema-Nio	11:52
Re: fix tablespace handling in pg_combinebackup	Alexander Lakhin	12:00
Re: createdb compares strategy as case-sensitive 📎	Tomas Vondra	12:35
Re: createdb compares strategy as case-sensitive	Tom Lane	15:10
Re: createdb compares strategy as case-sensitive	Tomas Vondra	19:34
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Tom Lane	21:08
Re: fix tablespace handling in pg_combinebackup 📎	Thomas Munro	21:49
Re: allow changing autovacuum_max_workers without restarting	Imseih (AWS), Sami	23:26

April 22, 2024

Thread	Author	Time
RE: Disallow changing slot's failover option in transaction block 📎	Zhijie Hou (Fujitsu)	00:27
RE: promotion related handling in pg_sync_replication_slots()	Zhijie Hou (Fujitsu)	00:31
Re: pg_combinebackup does not detect missing files	David Steele	00:47
Assert failure in _bt_preprocess_array_keys	Richard Guo	02:36
Re: Assert failure in _bt_preprocess_array_keys	Peter Geoghegan	02:52
Re: POC: GROUP BY optimization 📎	Andrei Lepikhov	03:51
Re: [PATCH] Replace magic constant 3 with NUM_MERGE_MATCH_KINDS	Michael Paquier	05:04
Re: fix tablespace handling in pg_combinebackup	Alexander Lakhin	05:59
Re: Disallow changing slot's failover option in transaction block	shveta malik	06:02
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Michael Paquier	06:20
Re: Assert failure in _bt_preprocess_array_keys	Richard Guo	06:22
Re: Support a wildcard in backtrace_functions	Michael Paquier	06:36
Re: Direct SSL connection with ALPN and HBA rules	Michael Paquier	07:19
Re: Slow catchup of 2PC (twophase) transactions on replica in LR	Ajin Cherian	07:34
Re: Direct SSL connection with ALPN and HBA rules	Heikki Linnakangas	07:47
Re: [PATCH] Replace magic constant 3 with NUM_MERGE_MATCH_KINDS	Dean Rasheed	07:55
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan	Alexander Lakhin	08:00
Re: Fix parallel vacuum buffer usage reporting 📎	Anthonin Bonnefoy	08:07
slightly misleading Error message in guc.c	jian he	08:43
Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	08:45
Re: Patch to avoid orphaned dependencies	Bertrand Drouvot	08:49
RE: Slow catchup of 2PC (twophase) transactions on replica in LR	Hayato Kuroda (Fujitsu)	08:54
Re: POC: GROUP BY optimization 📎	jian he	08:56
RE: Slow catchup of 2PC (twophase) transactions on replica in LR 📎	Hayato Kuroda (Fujitsu)	08:56
Re: Disallow changing slot's failover option in transaction block	Bertrand Drouvot	09:01
Re: Avoid orphaned objects dependencies, take 3	Alexander Lakhin	10:00
Re: AIX support	Sriram RK	10:12
Re: cataloguing NOT NULL constraints 📎	Alvaro Herrera	10:22
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Alexander Korotkov	10:31
Re: Avoid orphaned objects dependencies, take 3	Bertrand Drouvot	10:52
Re: promotion related handling in pg_sync_replication_slots() 📎	Amit Kapila	11:39
Re: Avoid orphaned objects dependencies, take 3 📎	Alexander Lakhin	12:00
Re: promotion related handling in pg_sync_replication_slots() 📎	shveta malik	12:02
RE: Slow catchup of 2PC (twophase) transactions on replica in LR 📎	Hayato Kuroda (Fujitsu)	12:54
Re: Support event trigger for logoff	Japin Li	13:24
Re: Support a wildcard in backtrace_functions	Robert Haas	13:25
Re: promotion related handling in pg_sync_replication_slots()	Masahiko Sawada	13:33
Re: GUC-ify walsender MAX_SEND_SIZE constant	Majid Garoosi	13:40
Re: Introduce XID age and inactive timeout based replication slot invalidation	Masahiko Sawada	13:50
Re: pg_combinebackup does not detect missing files	Robert Haas	13:53
Re: slightly misleading Error message in guc.c	Nazir Bilal Yavuz	14:08
Re: allow changing autovacuum_max_workers without restarting	Robert Haas	14:17
RE: Slow catchup of 2PC (twophase) transactions on replica in LR	Vitaly Davydov	14:22
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	14:26
Re: AIX support	Tristan Partin	14:54
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan	Peter Geoghegan	15:13
Cleanup: remove unused fields from nodes 📎	Matthias van de Meent	15:21
Re: subscription/026_stats test is intermittently slow?	vignesh C	15:32
Re: Cleanup: remove unused fields from nodes	Tom Lane	15:41
Re: slightly misleading Error message in guc.c 📎	Tom Lane	16:04
Re: TerminateOtherDBBackends code comments inconsistency.	Noah Misch	16:26
Re: Cleanup: remove unused fields from nodes	Matthias van de Meent	16:46
Re: BitmapHeapScan streaming read user and prelim refactoring	Melanie Plageman	17:01
Re: subscription/026_stats test is intermittently slow?	Andres Freund	17:55
Re: Statistics Import and Export	Jeff Davis	17:56
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan	Peter Geoghegan	17:59
Re: Add notes to pg_combinebackup docs 📎	Robert Haas	18:52
Re: improve performance of pg_dump --binary-upgrade 📎	Nathan Bossart	19:01
doc: create table improvements 📎	David G. Johnston	19:19
Re: post-freeze damage control	Robert Haas	19:19
Why does pgindent's README say to download typedefs.list from the buildfarm?	Nathan Bossart	19:22
Re: fix tablespace handling in pg_combinebackup 📎	Robert Haas	20:05
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Tom Lane	20:08
Re: Statistics Import and Export	Tom Lane	20:19
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Nathan Bossart	20:20
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Tom Lane	20:28
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Daniel Gustafsson	21:09
Re: fix tablespace handling in pg_combinebackup	Thomas Munro	21:15
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	21:19
Re: [Doc] Improve hostssl related descriptions and option presentation	David G. Johnston	21:20
Re: fix tablespace handling in pg_combinebackup	Andres Freund	21:23
Re: [Doc] Improvements to ddl.sgl Privileges Section and Glossary	David G. Johnston	21:29
Re: fix tablespace handling in pg_combinebackup	Robert Haas	22:10
Re: POC: GROUP BY optimization	Alexander Korotkov	22:19
Re: Direct SSL connection with ALPN and HBA rules 📎	Heikki Linnakangas	22:48

April 23, 2024

Thread	Author	Time
Re: GUC-ify walsender MAX_SEND_SIZE constant	Michael Paquier	00:23
datfrozen/relfrozen update race condition 📎	Noah Misch	00:39
Re: Cleanup: remove unused fields from nodes	Michael Paquier	01:14
Re: fix tablespace handling in pg_combinebackup	Andres Freund	01:30
Re: Statistics Import and Export	Jeff Davis	02:48
Re: logicalrep_worker_launch -- counting/checking the worker limits	Peter Smith	03:06
clamp_row_est avoid infinite	jian he	03:22
Re: promotion related handling in pg_sync_replication_slots()	Amit Kapila	03:37
Re: Statistics Import and Export	Tom Lane	03:52
Re: clamp_row_est avoid infinite	Tom Lane	03:54
Re: query_id, pg_stat_activity, extended query protocol	Imseih (AWS), Sami	04:16
Re: query_id, pg_stat_activity, extended query protocol	Andrei Lepikhov	04:42
Internal error codes triggered by tests 📎	Michael Paquier	04:54
Re: Avoid orphaned objects dependencies, take 3	Bertrand Drouvot	04:59
Re: Support a wildcard in backtrace_functions	Michael Paquier	05:05
Is it acceptable making COPY format extendable?	Sutou Kouhei	05:14
Re: Direct SSL connection with ALPN and HBA rules	Michael Paquier	05:42
Re: query_id, pg_stat_activity, extended query protocol	Michael Paquier	05:49
Add privileges test for pg_stat_statements to improve coverage 📎	kuroda.keisuke	06:44
Re: Direct SSL connection with ALPN and HBA rules	Michael Paquier	07:07
Re: pg_stat_statements and "IN" conditions	Dmitry Dolgov	08:18
POC: make mxidoff 64 bits 📎	Maxim Orlov	08:23
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 📎	Tender Wang	08:59
Re: pgsql: Introduce "builtin" collation provider.	Peter Eisentraut	09:23
Re: query_id, pg_stat_activity, extended query protocol	Andrei Lepikhov	09:37
Re: POC: make mxidoff 64 bits	Heikki Linnakangas	09:37
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Alvaro Herrera	10:23
Minor document typo 📎	Tatsuo Ishii	11:17
Re: Race condition in FetchTableStates() breaks synchronization of subscription tables	Amit Kapila	11:23
Re: Minor document typo	David Rowley	11:36
Re: subscription/026_stats test is intermittently slow?	Amit Kapila	12:10
Re: Minor document typo	Tatsuo Ishii	12:11
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Robert Haas	12:12
RE: Slow catchup of 2PC (twophase) transactions on replica in LR 📎	Hayato Kuroda (Fujitsu)	12:15
Re: slightly misleading Error message in guc.c	Daniel Gustafsson	12:21
Re: GUC-ify walsender MAX_SEND_SIZE constant	Jakub Wartak	12:47
Re: POC: make mxidoff 64 bits	Andrey M. Borodin	13:02
Re: POC: make mxidoff 64 bits	wenhui qiu	13:03
Re: Minor document typo	David Rowley	13:45
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Tom Lane	14:11
pg_trgm comparison bug on cross-architecture replication due to different char implementation	Guo, Adam	14:45
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Tom Lane	14:57
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	15:03
Background Processes in Postgres Extension	Sushrut Shivaswamy	15:17
Re: pgsql: Introduce "builtin" collation provider.	Andrew Dunstan	15:33
Re: slightly misleading Error message in guc.c	Tom Lane	15:53
Re: Background Processes in Postgres Extension	Tom Lane	15:59
Re: Popcount optimization using AVX512	Nathan Bossart	16:02
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	16:05
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	16:20
Re: Statistics Import and Export	Matthias van de Meent	16:33
Re: gcc 12.1.0 warning	Andres Freund	16:59
Re: Cleanup: remove unused fields from nodes	Tom Lane	17:01
Re: Direct SSL connection with ALPN and HBA rules	Jacob Champion	17:02
Re: Direct SSL connection with ALPN and HBA rules	Jacob Champion	17:22
Re: soliciting patches to review	Robert Haas	17:27
Re: soliciting patches to review	Melanie Plageman	17:39
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jacob Champion	17:39
Re: Direct SSL connection with ALPN and HBA rules	Robert Haas	17:43
Re: soliciting patches to review	Robert Haas	17:56
Re: Direct SSL connection with ALPN and HBA rules	Jacob Champion	19:33
Re: Why does pgindent's README say to download typedefs.list from the buildfarm? 📎	Nathan Bossart	20:04
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Daniel Gustafsson	20:08
Re: Direct SSL connection with ALPN and HBA rules 📎	Heikki Linnakangas	21:19
Re: GUC-ify walsender MAX_SEND_SIZE constant	Andres Freund	22:00
Tarball builds in the new world order	Tom Lane	22:05
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Michael Paquier	22:20
Re: BitmapHeapScan streaming read user and prelim refactoring	Tomas Vondra	22:43
Re: pg_combinebackup does not detect missing files	David Steele	23:22
Re: Requiring LLVM 14+ in PostgreSQL 18 📎	Thomas Munro	23:43

April 24, 2024

Thread	Author	Time
Re: query_id, pg_stat_activity, extended query protocol 📎	Imseih (AWS), Sami	01:40
Re: Streaming I/O, vectored I/O (WIP) 📎	David Rowley	02:32
Extend ALTER DEFAULT PRIVILEGES for large objects 📎	Yugo NAGATA	02:52
Re: Cleanup: remove unused fields from nodes	Michael Paquier	02:57
Re: Cleanup: remove unused fields from nodes	Tom Lane	03:03
Re: Row pattern recognition	Tatsuo Ishii	03:12
Re: Disallow changing slot's failover option in transaction block	Amit Kapila	03:26
Re: Extend ALTER DEFAULT PRIVILEGES for large objects	Tom Lane	03:47
Re: promotion related handling in pg_sync_replication_slots() 📎	shveta malik	04:58
Re: promotion related handling in pg_sync_replication_slots()	Masahiko Sawada	05:43
Re: Add memory context type to pg_backend_memory_contexts view 📎	David Rowley	05:47
Re: POC: GROUP BY optimization	jian he	06:25
Re: Race condition in FetchTableStates() breaks synchronization of subscription tables	Amit Kapila	06:29
Re: ecpg_config.h symbol missing with meson	Peter Eisentraut	06:32
Re: Extend ALTER DEFAULT PRIVILEGES for large objects 📎	Yugo NAGATA	06:32
Re: Fix parallel vacuum buffer usage reporting	Masahiko Sawada	06:34
Feature request: schema diff tool	Neszt Tibor	06:44
Small filx on the documentation of ALTER DEFAULT PRIVILEGES 📎	Yugo NAGATA	06:50
Re: GUC-ify walsender MAX_SEND_SIZE constant	Jakub Wartak	06:57
minor error message inconsistency in make_pathkey_from_sortinfo	jian he	07:05
Partitioned tables and [un]loggedness 📎	Michael Paquier	07:17
Re: Cleanup: remove unused fields from nodes 📎	Michael Paquier	07:28
Rename libpq trace internal functions 📎	Peter Eisentraut	07:39
Re: Feature request: schema diff tool	Heikki Linnakangas	07:51
Re: Is it acceptable making COPY format extendable?	Peter Eisentraut	07:57
Re: Show WAL write and fsync stats in pg_stat_io	Nazir Bilal Yavuz	08:37
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	08:38
Re: WIP Incremental JSON Parser	Michael Paquier	08:56
Re: Use XLOG_CONTROL_FILE macro everywhere?	Peter Eisentraut	09:02
Re: Use XLOG_CONTROL_FILE macro everywhere?	Anton A. Melnikov	09:13
Short-circuit sort_inner_and_outer if there are no mergejoin clauses 📎	Richard Guo	09:13
Re: Fix parallel vacuum buffer usage reporting 📎	Anthonin Bonnefoy	09:19
Re: Use XLOG_CONTROL_FILE macro everywhere?	Daniel Gustafsson	09:19
Re: Use XLOG_CONTROL_FILE macro everywhere?	Anton A. Melnikov	09:32
Re: Q: Escapes in jsonpath Idents	Peter Eisentraut	09:46
Re: minor error message inconsistency in make_pathkey_from_sortinfo	Yugo NAGATA	09:47
Re: Cleanup: remove unused fields from nodes	Matthias van de Meent	09:50
Re: Q: Escapes in jsonpath Idents	Peter Eisentraut	09:51
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.	Alexander Korotkov	09:57
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.	Alexander Korotkov	09:58
Remove unnecessary code rom be_lo_put() 📎	Yugo NAGATA	09:59
Re: Why does pgindent's README say to download typedefs.list from the buildfarm? 📎	Andrew Dunstan	10:07
Re: Why does pgindent's README say to download typedefs.list from the buildfarm?	Peter Eisentraut	10:12
Re: Statistics Import and Export 📎	Corey Huinker	10:18
Re: Race condition in FetchTableStates() breaks synchronization of subscription tables	Amit Kapila	10:19

Browse Archives

Prev | Next