pgsql-hackers since 2024-09-14 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

Sept. 14, 2024

Thread	Author	Time
Re: Exporting float_to_shortest_decimal_buf(n) with Postgres 17 on Windows	Michael Paquier	00:15
Re: Why don't we consider explicit Incremental Sort?	Richard Guo	03:37
Re: Why don't we consider explicit Incremental Sort?	Richard Guo	03:50
Obsolete comment in pg_stat_statements 📎	Julien Rouhaud	04:24
Re: Obsolete comment in pg_stat_statements	Tom Lane	04:39
Re: Obsolete comment in pg_stat_statements	Julien Rouhaud	04:56
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	08:12
Re: Mutable foreign key constraints	Andrew Dunstan	11:15
Re: Use streaming read API in ANALYZE 📎	Mats Kindahl	12:14
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Tomas Vondra	12:23
Re: Psql meta-command conninfo+	Hunaid Sohail	12:28
Robocopy might be not robust enough for never-ending testing on Windows 📎	Alexander Lakhin	13:00
Regression tests fail with tzdata 2024b 📎	Wolfgang Walther	13:02
Re: First draft of PG 17 release notes	Bruce Momjian	13:38
Re: Detailed release notes	Bruce Momjian	13:44
Re: Robocopy might be not robust enough for never-ending testing on Windows	Andrew Dunstan	14:22
Re: meson vs windows perl	Andrew Dunstan	14:39
Re: Mutable foreign key constraints	Tom Lane	14:51
Re: why there is not VACUUM FULL CONCURRENTLY?	Junwang Zhao	14:54
Re: Robocopy might be not robust enough for never-ending testing on Windows	Alexander Lakhin	15:00
Re: Obsolete comment in pg_stat_statements	Tom Lane	15:44
Re: Psql meta-command conninfo+	Alvaro Herrera	17:37
Re: Psql meta-command conninfo+	Tom Lane	17:50
Re: access numeric data in module	Ed Behn	18:09
Re: WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts	Akshat Jaimini	18:57
Cleaning up ERRCODE usage in our XML code 📎	Tom Lane	19:14
Re: Robocopy might be not robust enough for never-ending testing on Windows	Thomas Munro	20:32
Re: Regression tests fail with tzdata 2024b	Tom Lane	20:37
Re: Robocopy might be not robust enough for never-ending testing on Windows	Thomas Munro	20:45
Re: may be a mismatch between the construct_array and construct_md_array comments	Alena Rybakina	21:31
Re: Why don't we consider explicit Incremental Sort?	Tomas Vondra	21:50
Re: Why don't we consider explicit Incremental Sort?	Tomas Vondra	22:01

Sept. 15, 2024

Thread	Author	Time
Re: Detailed release notes 📎	Bruce Momjian	00:37
[PATCH] WIP: replace method for jsonpath	Florents Tselai	01:15
Re: Obsolete comment in pg_stat_statements	Julien Rouhaud	02:30
Re: Regression tests fail with tzdata 2024b	Wolfgang Walther	09:08
Re: Trim the heap free memory 📎	shawn wang	17:48
how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind 📎	Tomas Vondra	18:20
Re: Trim the heap free memory	Tom Lane	18:22
Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind	Tom Lane	18:31
Re: Trim the heap free memory 📎	Tom Lane	19:16
Re: A starter task	sia kc	19:42
Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind	Tomas Vondra	19:47
Re: A starter task	Tomas Vondra	20:00
Re: A starter task	sia kc	20:10
Re: A starter task	Tom Lane	20:43
Re: A starter task	Tomas Vondra	20:47
Re: A starter task	Tomas Vondra	20:53
Re: A starter task	sia kc	21:15
Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind	Thomas Munro	21:22
Re: A starter task	Tom Lane	21:45
Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind	Tom Lane	21:59
Re: A starter task	sia kc	22:17
Re: A starter task	Tom Lane	22:32

Sept. 16, 2024

Thread	Author	Time
Re: A starter task	Tomas Vondra	00:00
Re: SQL:2011 application time	Paul A Jungwirth	02:12
Re: ANALYZE ONLY	jian he	02:29
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	02:53
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	03:25
information_schema.view attgenerated	jian he	04:12
Re: Regression tests fail with tzdata 2024b	Tom Lane	05:09
Re: Allow logical failover slots to wait on synchronous replication	Amit Kapila	05:43
Re: Robocopy might be not robust enough for never-ending testing on Windows	Alexander Lakhin	06:00
Re: Support LIKE with nondeterministic collations 📎	Peter Eisentraut	06:26
Re: A starter task	Tony Wayne	06:49
Re: Psql meta-command conninfo+ 📎	Hunaid Sohail	06:51
Re: Add system column support to the USING clause	Denis Garsh	07:19
Re: Pgoutput not capturing the generated columns	Peter Smith	07:41
Re: A starter task	Tomas Vondra	07:49
Re: A starter task	Tomas Vondra	07:58
Re: Regression tests fail with tzdata 2024b	Sven Klemm	08:33
Re: A starter task	sia kc	08:35
Re: Doc: Move standalone backup section, mention -X argument	Marlene Reiterer	08:45
Re: Virtual generated columns 📎	jian he	09:22
Re: Allow logical failover slots to wait on synchronous replication	shveta malik	09:25
Re: A starter task	Tomas Vondra	09:27
Re: Introduce XID age and inactive timeout based replication slot invalidation	Bharath Rupireddy	09:47
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Bharath Rupireddy	10:01
Re: Add contrib/pg_logicalsnapinspect	shveta malik	10:32
Re: Allow logical failover slots to wait on synchronous replication	Amit Kapila	10:34
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row	Jim Jones	10:38
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Ashutosh Bapat	11:11
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	11:24
Re: how to speed up 002_pg_upgrade.pl and 025_stream_regress.pl under valgrind 📎	Tomas Vondra	11:34
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	12:13
Re: POC, WIP: OR-clause support for indexes	Andrei Lepikhov	12:44
Re: scalability bottlenecks with (many) partitions (and more)	Jakub Wartak	13:11
Re: Fix some ubsan/asan related issues	Junwang Zhao	13:29
Re: Psql meta-command conninfo+	Jim Jones	13:40
Re: scalability bottlenecks with (many) partitions (and more)	Tomas Vondra	14:19
Re: Psql meta-command conninfo+	Alvaro Herrera	14:22
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. 📎	Anton A. Melnikov	14:30
Re: Add contrib/pg_logicalsnapinspect 📎	Bertrand Drouvot	14:33
Re: AIO v2.0 📎	Noah Misch	14:43
Re: Regression tests fail with tzdata 2024b	Tom Lane	15:19
Re: Psql meta-command conninfo+	Tom Lane	15:30
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Noah Misch	16:24
Re: Introduce XID age and inactive timeout based replication slot invalidation	Bharath Rupireddy	17:10
Re: Using per-transaction memory contexts for storing decoded tuples	Masahiko Sawada	17:12
Re: Document DateStyle effect on jsonpath string()	David E. Wheeler	17:25
Re: Document DateStyle effect on jsonpath string()	Tom Lane	17:29
Re: not null constraints, again 📎	Alvaro Herrera	17:47
Re: AIO v2.0	Andres Freund	17:51
Re: AIO v2.0	Andres Freund	17:56
Re: Detailed release notes	Bruce Momjian	18:15
Re: Detailed release notes	Marcos Pegoraro	18:42
Re: Document DateStyle effect on jsonpath string()	David E. Wheeler	18:43
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎	Alexander Korotkov	18:55
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	19:13
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	19:13
Re: Detailed release notes	Bruce Momjian	19:18
Re: SQL:2023 JSON simplified accessor support	Peter Eisentraut	19:44
Re: Pgoutput not capturing the generated columns	Masahiko Sawada	21:01
Re: optimizing pg_upgrade's once-in-each-database steps	Nathan Bossart	21:16
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Tomas Vondra	22:05
Re: [PATCH] WIP: replace method for jsonpath	Florents Tselai	22:39

Sept. 17, 2024

Thread	Author	Time
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	00:38
Re: Robocopy might be not robust enough for never-ending testing on Windows	Thomas Munro	01:01
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Peter Smith	01:27
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN 📎	Tatsuo Ishii	02:40
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica.	Fujii Masao	02:47
Re: Pgoutput not capturing the generated columns	Peter Smith	03:09
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	David Rowley	03:16
Re: Allow logical failover slots to wait on synchronous replication	shveta malik	03:38
Re: Supporting = operator in gin/gist_trgm_ops 📎	David Rowley	04:42
Re: Add contrib/pg_logicalsnapinspect	shveta malik	04:48
Re: Add contrib/pg_logicalsnapinspect	shveta malik	04:54
Re: Robocopy might be not robust enough for never-ending testing on Windows	Alexander Lakhin	05:00
Re: Add contrib/pg_logicalsnapinspect	David G. Johnston	05:16
Re: Regression tests fail with tzdata 2024b	Sven Klemm	05:38
Re: [Proposal] Add foreign-server health checks infrastructure 📎	Fujii Masao	05:39
Re: Regression tests fail with tzdata 2024b	Tom Lane	05:42
RE: Using per-transaction memory contexts for storing decoded tuples	Hayato Kuroda (Fujitsu)	05:56
Re: [HACKERS] make async slave to wait for lsn to be replayed	Alexander Lakhin	06:00
Wrong results with equality search using trigram index and non-deterministic collation	Laurenz Albe	06:00
pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.	Tatsuo Ishii	06:00
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	06:06
RE: [Proposal] Add foreign-server health checks infrastructure	Hayato Kuroda (Fujitsu)	06:08
Re: Pgoutput not capturing the generated columns	Masahiko Sawada	06:15
Re: Pgoutput not capturing the generated columns	Peter Smith	06:34
Re: Regression tests fail with tzdata 2024b	Wolfgang Walther	06:39
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	06:53
Re: Add contrib/pg_logicalsnapinspect	Bertrand Drouvot	07:05
Re: Add contrib/pg_logicalsnapinspect 📎	Bertrand Drouvot	07:14
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	07:43
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎	Alexander Korotkov	07:47
Re: First draft of PG 17 release notes	Jelte Fennema-Nio	08:01
Re: Detailed release notes	Alvaro Herrera	08:12
Re: First draft of PG 17 release notes	Alvaro Herrera	08:19
Re: Detailed release notes	Jelte Fennema-Nio	08:36
Re: Can we rely on the ordering of paths in pathlist?	wenhui qiu	08:48
Re: [HACKERS] make async slave to wait for lsn to be replayed	Alexander Lakhin	09:00
Re: Statistics Import and Export 📎	Corey Huinker	09:02
Re: Using per-transaction memory contexts for storing decoded tuples	Amit Kapila	09:05
[PATCH] Mention service key word more prominently in pg_service.conf docs 📎	Dagfinn Ilmari Mannsåker	09:24
jsonb_strip_nulls with arrays?	Florents Tselai	09:26
Re: [PATCH] Mention service key word more prominently in pg_service.conf docs	Daniel Gustafsson	09:37
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	09:42
Re: SQL:2011 application time	Peter Eisentraut	09:45
Re: Add contrib/pg_logicalsnapinspect	shveta malik	09:49
Re: per backend I/O statistics	Nazir Bilal Yavuz	11:52
Re: Psql meta-command conninfo+	Hunaid Sohail	11:53
Re: Parallel workers stats in pg_stat_database 📎	Benoit Lobréau	12:22
Re: Exit walsender before confirming remote flush in logical replication	Greg Sabino Mullane	12:29
Re: generic plans and "initial" pruning 📎	Amit Langote	12:57
Re: per backend I/O statistics	Bertrand Drouvot	13:07
Re: per backend I/O statistics	Nazir Bilal Yavuz	13:47
Re: per backend I/O statistics	Bertrand Drouvot	13:56
Re: jsonb_strip_nulls with arrays?	Andrew Dunstan	14:11
Re: Regression tests fail with tzdata 2024b	Tom Lane	14:15
Re: A starter task	Andrew Dunstan	14:48
Re: [PATCH] Add additional extended protocol commands to psql: \parse and \bind	Alexander Lakhin	15:00
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	15:10
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	15:49
RE: AIX support	Srirama Kucherlapati	16:29
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	17:54
Re: AIO v2.0	Noah Misch	18:08
Re: Using per-transaction memory contexts for storing decoded tuples	Masahiko Sawada	18:23
Re: Detailed release notes	Marcos Pegoraro	18:29
Re: [PATCH] WIP: replace method for jsonpath	David E. Wheeler	18:40
Re: Compress ReorderBuffer spill files using LZ4 📎	Tomas Vondra	18:48
Re: [PATCH] WIP: replace method for jsonpath	Florents Tselai	19:03
Re: [PATCH] WIP: replace method for jsonpath	David E. Wheeler	19:16
miscellaneous pg_upgrade cleanup 📎	Nathan Bossart	19:22
Re: scalability bottlenecks with (many) partitions (and more) 📎	Tomas Vondra	20:16
Re: jsonb_strip_nulls with arrays? 📎	Florents Tselai	20:53
Re: Test improvements and minor code fixes for formatting.c.	Nathan Bossart	21:59
Re: query_id, pg_stat_activity, extended query protocol	Sami Imseih	22:01
Custom connstr in background_psql() 📎	a.imamov	22:08
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	22:14
Re: query_id, pg_stat_activity, extended query protocol 📎	Michael Paquier	22:50
Re: Custom connstr in background_psql()	Michael Paquier	22:57
Re: query_id, pg_stat_activity, extended query protocol	Sami Imseih	23:39
Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION	Justin Pryzby	23:47

Sept. 18, 2024

Thread	Author	Time
Re: Detailed release notes 📎	Bruce Momjian	00:13
Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION	Tom Lane	00:16
Re: Detailed release notes	Tom Lane	00:22
Re: query_id, pg_stat_activity, extended query protocol	Michael Paquier	00:38
Re: Detailed release notes	Bruce Momjian	00:54
Re: Virtual generated columns 📎	jian he	02:38

Browse Archives

Prev | Next