pgsql-hackers - June 2024

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

Browse Archives

Prev | Next

June 1, 2024

Thread	Author	Time
Re: Add memory context type to pg_backend_memory_contexts view	Michael Paquier	00:55
pltcl crashes due to a syntax error	a.kozhemyakin	04:36
Re: ResourceOwner refactoring	Alexander Lakhin	08:00
Re: pltcl crashes due to a syntax error	Tom Lane	18:18
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	Andres Freund	18:52
Re: meson and check-tests	Tristan Partin	20:47
Fix grammar oddities in comments 📎	James Coleman	22:08

June 2, 2024

Thread	Author	Time
Extension security improvement: Add support for extensions with an owned schema 📎	Jelte Fennema-Nio	00:08
Re: meson and check-tests	jian he	04:05
Re: meson and check-tests	Tom Lane	05:25
Re: POC: GROUP BY optimization 📎	jian he	07:55
Re: pltcl crashes due to a syntax error	Pierre Forstmann	12:32
Re: POC: GROUP BY optimization 📎	Alexander Korotkov	13:18
Re: The xversion-upgrade test fails to stop server	Andrew Dunstan	18:39
Optimizing COPY with SIMD 📎	Neil Conway	19:17
Re: meson and check-tests	Andrew Dunstan	19:47
Re: The xversion-upgrade test fails to stop server	Alexander Lakhin	20:00
Re: pltcl crashes due to a syntax error	Erik Wienhold	20:44
Re: Fix possible dereference null pointer (PQprint)	Ranier Vilela	21:06
Re: Avoid an odd undefined behavior with memcmp (src/bin/pg_rewind/pg_rewind.c)	Ranier Vilela	21:14
Re: pgsql: Add more SQL/JSON constructor functions	Peter Eisentraut	21:17
Re: Switch background worker on/off in runtime.	Peter Eisentraut	21:22
Re: Schema variables - new implementation for Postgres 15	Peter Eisentraut	21:31
Re: pltcl crashes due to a syntax error	Tom Lane	22:15
Re: Fix overflow hazard in interval rounding	Joseph Koshakow	23:01
Re: Improve the connection failure error messages	Peter Smith	23:57

June 3, 2024

Thread	Author	Time
cannot drop intarray extension	jian he	04:14
Re: cannot drop intarray extension	Kashif Zeeshan	04:17
Re: pgsql: Add more SQL/JSON constructor functions	Tom Lane	04:46
Re: cannot drop intarray extension	jian he	05:45
walsender.c comment with no context is hard to understand	Peter Smith	05:50
Re: meson and check-tests	Nazir Bilal Yavuz	05:56
Re: meson "experimental"?	Aleksander Alekseev	07:10
Re: Conflict Detection and Resolution	Amit Kapila	07:30
Re: Pgoutput not capturing the generated columns 📎	Shubham Khanna	07:33
Re: [PATCH] New [relation] option engine 📎	jian he	07:52
Re: allow sorted builds for btree_gist	Bernd Helmle	08:53
Re: pgsql: Add more SQL/JSON constructor functions	Peter Eisentraut	09:15
Re: Pgoutput not capturing the generated columns	Shubham Khanna	09:30
Re: Pgoutput not capturing the generated columns	Shubham Khanna	09:55
Re: Pgoutput not capturing the generated columns	Shubham Khanna	10:01
Re: Pgoutput not capturing the generated columns	Shubham Khanna	10:24
Re: Pgoutput not capturing the generated columns	vignesh C	10:43
Re: relfilenode statistics	Bertrand Drouvot	11:11
Re: Pgoutput not capturing the generated columns 📎	Shlok Kyal	11:52
Re: CREATE DATABASE with filesystem cloning	Nazir Bilal Yavuz	12:49
Re: Optimizing COPY with SIMD	Joe Conway	13:22
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) 📎	Justin Pryzby	14:10
Re: Optimizing COPY with SIMD	Neil Conway	14:16
differential test coverage when working on a patch	Andy Fan	14:20
Build with LTO / -flto on macOS 📎	Wolfgang Walther	14:22
Re: Build with LTO / -flto on macOS	Peter Eisentraut	14:32
Unexpected results from CALL and AUTOCOMMIT=off	Victor Yegorov	14:41
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)	Pavel Stehule	14:49
Re: Optimizing COPY with SIMD	Nathan Bossart	14:56
Re: Build with LTO / -flto on macOS	Wolfgang Walther	15:07
Re: An improved README experience for PostgreSQL	Nathan Bossart	15:10
SQL/JSON query functions context_item doc entry and type requirement	jian he	15:11
Re: Volatile write caches on macOS and Windows, redux	Nathan Bossart	15:28
Re: POC: GROUP BY optimization	Pavel Borisov	15:54
Re: pltcl crashes due to a syntax error	Erik Wienhold	16:16
Re: meson and check-tests	Tristan Partin	16:34
Re: pltcl crashes due to a syntax error 📎	Tom Lane	16:57
Re: Build with LTO / -flto on macOS	walther	17:11
Re: problems with "Shared Memory and Semaphores" section of docs	Nathan Bossart	17:18
Re: pgsql: Add more SQL/JSON constructor functions	Tom Lane	17:20
Will there be https://wiki.postgresql.org/wiki/PgCon_2024_Developer_Unconference ?	Hannu Krosing	17:36
Re: Unexpected results from CALL and AUTOCOMMIT=off	Pierre Forstmann	17:40
Re: Will there be https://wiki.postgresql.org/wiki/PgCon_2024_Developer_Unconference ?	Nathan Bossart	18:03
Re: Unexpected results from CALL and AUTOCOMMIT=off	Victor Yegorov	18:15
Re: Psql meta-command conninfo+	Nathan Bossart	18:30
Re: Build with LTO / -flto on macOS	Andres Freund	18:40
Proposal: Document ABI Compatibility	David E. Wheeler	18:43
Re: allow changing autovacuum_max_workers without restarting 📎	Nathan Bossart	18:52
Re: Proposal: Document ABI Compatibility	Andres Freund	18:58
Re: problems with "Shared Memory and Semaphores" section of docs 📎	Nathan Bossart	19:04
Re: allow changing autovacuum_max_workers without restarting	Andres Freund	19:08
Re: Proposal: Document ABI Compatibility	David E. Wheeler	19:21
Re: Unexpected results from CALL and AUTOCOMMIT=off	Tom Lane	19:28
Re: allow changing autovacuum_max_workers without restarting	Nathan Bossart	19:28
Re: Proposal: Document ABI Compatibility	Tom Lane	19:38
Re: Proposal: Document ABI Compatibility	David Christensen	20:22
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)	David Christensen	20:48
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	20:55
Revive num_dead_tuples column of pg_stat_progress_vacuum 📎	Masahiko Sawada	21:26
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	21:41
Re: pltcl crashes due to a syntax error	Erik Wienhold	21:48
Re: Revive num_dead_tuples column of pg_stat_progress_vacuum	Peter Geoghegan	21:49
Re: Proposal: Document ABI Compatibility	Andres Freund	21:56
Re: Proposal: Document ABI Compatibility	David E. Wheeler	22:02
Re: Fix an incorrect assertion condition in mdwritev().	Michael Paquier	22:17
Re: Fix an incorrect assertion condition in mdwritev().	Andres Freund	22:24
Re: Fix an incorrect assertion condition in mdwritev().	Michael Paquier	22:43
Re: POC: GROUP BY optimization 📎	Alexander Korotkov	22:47
Re: ResourceOwner refactoring	Heikki Linnakangas	22:49
Re: Test to dump and restore objects left behind by regression	Michael Paquier	22:58
Re: allow changing autovacuum_max_workers without restarting	Andres Freund	23:24
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows	Michael Paquier	23:30

June 4, 2024

Thread	Author	Time
Re: In-placre persistance change of a relation	Michael Paquier	00:09
Re: Proposal: Document ABI Compatibility	Laurenz Albe	00:11
Re: Unexpected results from CALL and AUTOCOMMIT=off 📎	Tom Lane	01:32
Re: Pgoutput not capturing the generated columns	Peter Smith	02:41
Re: Use the same Windows image on both VS and MinGW tasks	Andres Freund	02:44
Re: Statistics Import and Export 📎	Corey Huinker	03:34
Re: Conflict Detection and Resolution	Amit Kapila	04:07
Re: pg_parse_json() should not leak token copies on failure	Kyotaro Horiguchi	04:32
Re: Pgoutput not capturing the generated columns	Peter Smith	04:51
Re: ON ERROR in json_query and the like	jian he	05:00
Re: Ambiguous description on new columns	vignesh C	05:39
Re: Ambiguous description on new columns	Amit Kapila	05:56
Re: In-placre persistance change of a relation	Kyotaro Horiguchi	07:00
Re: meson: Specify -Wformat as a common warning flag for extensions	Peter Eisentraut	07:00
Re: Proposal: Document ABI Compatibility	Peter Eisentraut	07:18
Re: Build with LTO / -flto on macOS	Peter Eisentraut	07:26
Re: [PATCH]A minor improvement to the error-report in SimpleLruWriteAll()	Kyotaro Horiguchi	07:44
Re: Minor fixes for couple some comments around MERGE RETURNING	Dean Rasheed	08:39
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	09:30
Re: Recent 027_streaming_regress.pl hangs	Alexander Lakhin	10:00
Re:Re: [PATCH]A minor improvement to the error-report in SimpleLruWriteAll()	Long Song	10:03
Re: pgsql: Add more SQL/JSON constructor functions	Amit Langote	10:03
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 📎	Tender Wang	10:51
Logical Replication of sequences	Amit Kapila	10:57
Re: plpgsql: fix parsing of integer range with underscores	Dean Rasheed	11:21
Re: Logical Replication of sequences	Bharath Rupireddy	11:22
Re: The xversion-upgrade test fails to stop server	Andrew Dunstan	11:56
Re: Logical Replication of sequences	Amit Kapila	12:10
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Justin Pryzby	12:49
Re: relfilenode statistics	Robert Haas	13:26
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Robert Haas	13:30
Re: Logical Replication of sequences	Ashutosh Bapat	14:09
Re: UniqueKey v2	Antonin Houska	14:14
Re: DROP OWNED BY fails to clean out pg_init_privs grants	Robert Haas	14:16
Re: Infinite loop in XLogPageRead() on standby	Alexander Kukushkin	14:16
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	14:47
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	15:00
Re: meson "experimental"?	Robert Haas	15:24
Re: Logical Replication of sequences	Yogesh Sharma	15:26
Re: meson "experimental"?	Dave Page	15:28
Re: Revive num_dead_tuples column of pg_stat_progress_vacuum	Alvaro Herrera	15:35
Patch bug: Fix jsonpath .* on Arrays 📎	David E. Wheeler	16:07
Re: Patch bug: Fix jsonpath .* on Arrays	David G. Johnston	16:28
Re: Build with LTO / -flto on macOS 📎	Wolfgang Walther	16:30
Re: meson "experimental"?	Heikki Linnakangas	16:36
Re: Build with LTO / -flto on macOS	Tom Lane	16:41
Re: meson "experimental"?	Peter Eisentraut	16:56
Re: pg_parse_json() should not leak token copies on failure	Jacob Champion	17:10
Re: Partial aggregates pushdown	Bruce Momjian	17:12
Re: meson "experimental"?	Robert Haas	17:40
Re: POC: GROUP BY optimization 📎	Alexander Korotkov	18:05
Re: plpgsql: fix parsing of integer range with underscores	Erik Wienhold	18:08
Re: Unexpected results from CALL and AUTOCOMMIT=off 📎	Tom Lane	18:28
use CREATE DATABASE STRATEGY = FILE_COPY in pg_upgrade 📎	Nathan Bossart	19:39
Re: Unexpected results from CALL and AUTOCOMMIT=off	Nathan Bossart	20:13
Re: Unexpected results from CALL and AUTOCOMMIT=off	Tom Lane	20:31
Re: In-placre persistance change of a relation	Nathan Bossart	20:50
Re: pltcl crashes due to a syntax error	Tom Lane	22:03
Re: Injection points: preloading and runtime arguments 📎	Michael Paquier	22:52

June 5, 2024

Thread	Author	Time
RE: Partial aggregates pushdown 📎	Fujii.Yuki@df.MitsubishiElectric.co.jp	00:14
Re: Pgoutput not capturing the generated columns	Peter Smith	00:18
Re: Patch bug: Fix jsonpath .* on Arrays 📎	David E. Wheeler	00:45
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Ajin Cherian	01:24
RE: Should consider materializing the cheapest inner path in consider_parallel_nestloop()	Fujii.Yuki@df.MitsubishiElectric.co.jp	01:26
Re: Partial aggregates pushdown	Bruce Momjian	01:35
RE: Synchronizing slots from primary to standby	Zhijie Hou (Fujitsu)	02:19
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	02:22
Re: More performance improvements for pg_dump in binary upgrade mode	Nathan Bossart	02:39
Re: Logical Replication of sequences	Amit Kapila	03:15
Re: Conflict Detection and Resolution	shveta malik	03:42
Re: Logical Replication of sequences	Amit Kapila	03:43
Re: Fix an incorrect assertion condition in mdwritev(). 📎	Michael Paquier	04:10
Re: Fix use of possible uninitialized variable retval (src/pl/plpgsql/src/pl_handler.c)	Kyotaro Horiguchi	04:12
Re: In-placre persistance change of a relation	Michael Paquier	04:52
Re: Fix use of possible uninitialized variable retval (src/pl/plpgsql/src/pl_handler.c)	Michael Paquier	05:04
Re: Infinite loop in XLogPageRead() on standby	Michael Paquier	05:09
Re: pg_parse_json() should not leak token copies on failure	Michael Paquier	05:15
Re: Partial aggregates pushdown	Alexander Pyhalov	05:19
Re: Schema variables - new implementation for Postgres 15	Pavel Stehule	05:21
Re: Add last_commit_lsn to pg_stat_database	Kyotaro Horiguchi	05:25
Re: relfilenode statistics	Bertrand Drouvot	05:52
Re: Synchronizing slots from primary to standby	Amit Kapila	06:05
RE: Conflict Detection and Resolution 📎	Zhijie Hou (Fujitsu)	06:31
Re: Synchronizing slots from primary to standby	Peter Smith	06:32
Re: Volatile write caches on macOS and Windows, redux	Peter Eisentraut	06:32
Re: Build with LTO / -flto on macOS	Peter Eisentraut	06:36
Re: Build with LTO / -flto on macOS	Wolfgang Walther	07:08
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM 📎	Bharath Rupireddy	07:12
Re: Logical Replication of sequences	Peter Eisentraut	07:21
Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids) 📎	Ashutosh Bapat	07:47
Should we move the resowner field from JitContext to LLVMJitContext? 📎	Andreas Karlsson	08:19
Re:Re: [PATCH]A minor improvement to the error-report in SimpleLruWriteAll() 📎	Long Song	08:30
Re: Logical Replication of sequences	Amit Kapila	08:41
Re: Addressing SECURITY DEFINER Function Vulnerabilities in PostgreSQL Extensions 📎	Ashutosh Sharma	09:06
Re: meson "experimental"?	Dave Page	09:30
Re: Fix grammar oddities in comments	David Rowley	09:34
Re: Wrong results with grouping sets 📎	Richard Guo	09:42
Re: Logical Replication of sequences	Bharath Rupireddy	09:47
Re: Revive num_dead_tuples column of pg_stat_progress_vacuum	Andrey M. Borodin	10:19
Re: apply_scanjoin_target_to_paths and partitionwise join	Ashutosh Bapat	10:57
Re: meson and check-tests	Ashutosh Bapat	11:26
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	11:39

Browse Archives

Prev | Next