pgsql-hackers before 2024-09-08 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. 4, 2024

Thread	Author	Time
Re: Avoid possible dereference null pointer (src/bin/pg_dump/pg_dump.c)	Daniel Gustafsson	18:35
Re: Large expressions in indexes can't be stored (non-TOASTable) 📎	Nathan Bossart	18:40
Re: Use read streams in pg_visibility	Noah Misch	18:43
Re: GetRelationPath() vs critical sections	Noah Misch	19:03
Re: Large expressions in indexes can't be stored (non-TOASTable)	Tom Lane	19:08
Re: Large expressions in indexes can't be stored (non-TOASTable)	Jonathan S. Katz	19:20
Re: race condition in pg_class 📎	Noah Misch	19:57
Re: json_query conditional wrapper bug	Andrew Dunstan	20:10
Re: psql: fix variable existence tab completion	Tom Lane	20:26
Re: GetRelationPath() vs critical sections	Thomas Munro	20:46
PostgreSQL 17 release announcement draft 📎	Jonathan S. Katz	21:04
Re: [PATCH] Avoid mixing custom and OpenSSL BIO functions	David Benjamin	21:19
Re: tiny step toward threading: reduce dependence on setlocale()	Jeff Davis	21:45
Re: [PATCH] Avoid mixing custom and OpenSSL BIO functions	Daniel Gustafsson	22:10
Re: Invalid "trailing junk" error message when non-English letters are used	Tom Lane	22:52
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎	Jehan-Guillaume de Rorthais	22:57
Re: Use streaming read API in ANALYZE	Thomas Munro	23:34
Re: Avoid overflowed array index (src/backend/utils/activity/pgstat.c) 📎	Michael Paquier	23:58

Sept. 5, 2024

Thread	Author	Time
Re: Typos in the code and README	Michael Paquier	00:03
Re: Eager aggregation, take 3	Tender Wang	01:40
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points	Michael Paquier	01:59
Re: meson and check-tests	jian he	03:29
Re: Add callback in pgstats for backend initialization	Michael Paquier	03:41
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	03:55
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	04:00
Role Granting Issues in PostgreSQL: Need Help	Muhammad Imtiaz	04:05
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match() 📎	Junwang Zhao	04:06
Re: Role Granting Issues in PostgreSQL: Need Help	David G. Johnston	04:14
Re: Role Granting Issues in PostgreSQL: Need Help	Tom Lane	04:25
Re: relfilenode statistics 📎	Bertrand Drouvot	04:48
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	David Rowley	04:52
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Tender Wang	04:56
Re: Track the amount of time waiting due to cost_delay 📎	Bertrand Drouvot	04:59
Re: psql: fix variable existence tab completion	Anton A. Melnikov	05:07
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match() 📎	Junwang Zhao	05:20
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes	Bertrand Drouvot	05:36
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	05:38
Re: Commit Timestamp and LSN Inversion issue	Amit Kapila	05:39
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	06:10
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes 📎	Guillaume Lelarge	06:19
Re: In-placre persistance change of a relation	Kyotaro Horiguchi	06:34
Re: Use streaming read API in ANALYZE	Mats Kindahl	06:45
Re: In-placre persistance change of a relation	Kyotaro Horiguchi	06:46
Re: Add callback in pgstats for backend initialization	Michael Paquier	07:08
Re: Support run-time partition pruning for hash join	Andrei Lepikhov	07:56
Re: [PATCH] Add roman support for to_number function 📎	Hunaid Sohail	08:07
updatable view set default interact with base rel generated stored columns	jian he	08:08
Re: Virtual generated columns	jian he	08:27
meson vs. llvm bitcode files	Peter Eisentraut	08:56
Re: Use streaming read API in ANALYZE	Thomas Munro	09:12
Re: meson vs. llvm bitcode files	Nazir Bilal Yavuz	09:24
Re: [PATCH] Add roman support for to_number function	Aleksander Alekseev	09:41
Re: generic plans and "initial" pruning 📎	Amit Langote	09:55
Re: long-standing data loss bug in initial sync of logical replication	Amit Kapila	10:34
Re: optimizing pg_upgrade's once-in-each-database steps	Daniel Gustafsson	11:32
Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	11:36
Re: SQL:2011 application time	Peter Eisentraut	12:09
Re: Jargon and acronyms on this mailing list	Alvaro Herrera	12:14
Re: Avoid overflowed array index (src/backend/utils/activity/pgstat.c) 📎	Ranier Vilela	12:18
Re: Avoid overflowed array index (src/backend/utils/activity/pgstat.c) 📎	Ranier Vilela	12:25
Re: Vacuum statistics	jian he	12:47
Re: Thread-safe nl_langinfo() and localeconv()	Peter Eisentraut	12:50
Re: pgsql: Add more SQL/JSON constructor functions 📎	Amit Langote	12:58
Re: Use read streams in pg_visibility	Nazir Bilal Yavuz	12:59
Re: per backend I/O statistics	Alvaro Herrera	13:03
Re: [PATCH] Add roman support for to_number function	Hunaid Sohail	13:07
Re: strange context message in spi.c?	Peter Eisentraut	13:25
Re: Avoid possible dereference null pointer (src/bin/pg_dump/pg_dump.c)	Daniel Gustafsson	13:39
Re: race condition in pg_class	Nitin Motiani	13:40
Re: Create syscaches for pg_extension 📎	Andrei Lepikhov	13:41
Re: Avoid possible dereference null pointer (src/bin/pg_dump/pg_dump.c)	Ranier Vilela	13:43
Re: Create syscaches for pg_extension	Pavel Stehule	13:43
Re: SQL:2011 application time	Paul A Jungwirth	13:45
ATExecColumnDefault comments	jian he	13:50
Re: updatable view set default interact with base rel generated stored columns	Tom Lane	13:58
Re: per backend I/O statistics	Bertrand Drouvot	14:14
Re: json_query conditional wrapper bug	Andrew Dunstan	15:01
Re: Invalid "trailing junk" error message when non-English letters are used	Karina Litskevich	15:07
Re: Invalid "trailing junk" error message when non-English letters are used 📎	Karina Litskevich	15:11
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎	Pavel Stehule	15:24
Re: Don't overwrite scan key in systable_beginscan()	Peter Eisentraut	15:43
Re: Make query cancellation keys longer	Jacob Champion	15:43
Re: json_query conditional wrapper bug	Peter Eisentraut	15:51
Re: Use read streams in pg_visibility	Noah Misch	15:54
Adding NOTICE for differences between estimated and actual rows 📎	Ilia Evdokimov	16:05
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points	Maxim Orlov	16:08
Re: Make query cancellation keys longer	Tom Lane	16:21
Re: scalability bottlenecks with (many) partitions (and more)	Robert Haas	16:25
Re: Make query cancellation keys longer	Jacob Champion	16:33
Re: Make query cancellation keys longer	Jelte Fennema-Nio	16:36
Not able to compile PG16 with custom flags in freebsd 14.1 - Please Help	Moksh Chadha	16:36
Re: json_query conditional wrapper bug	Andrew Dunstan	16:44
Re: Invalid "trailing junk" error message when non-English letters are used	Tom Lane	16:49
Re: Create syscaches for pg_extension	Jelte Fennema-Nio	16:50
Re: Make query cancellation keys longer	Jacob Champion	17:08
Re: scalability bottlenecks with (many) partitions (and more) 📎	Tomas Vondra	17:21
Re: Statistics Import and Export	Corey Huinker	17:29
Re: scalability bottlenecks with (many) partitions (and more)	Tomas Vondra	17:33
Re: Statistics Import and Export	Corey Huinker	17:34
Re: change regexp_substr first argument make tests more easier to understand.	Tom Lane	17:45
Re: Invalid "trailing junk" error message when non-English letters are used	Pavel Borisov	17:56
Re: Add GiST support for mixed-width integer operators	Tom Lane	18:45
Re: Create syscaches for pg_extension 📎	Andrei Lepikhov	20:03
Re: Adding NOTICE for differences between estimated and actual rows	Euler Taveira	20:32
Re: CREATE OR REPLACE MATERIALIZED VIEW 📎	Erik Wienhold	20:33
Re: Create syscaches for pg_extension	Jelte Fennema-Nio	20:56
Re: Adding NOTICE for differences between estimated and actual rows	Euler Taveira	20:57
Re: Vacuum statistics 📎	Alena Rybakina	21:00
Re: Adding NOTICE for differences between estimated and actual rows	Ilia Evdokimov	21:11
Re: SPI_connect, SPI_connect_ext return type 📎	Tom Lane	21:13
Re: Add trim_trailing_whitespace to editorconfig file 📎	Jelte Fennema-Nio	21:28
Re: race condition in pg_class	Noah Misch	22:04
Re: Avoid overflowed array index (src/backend/utils/activity/pgstat.c)	Michael Paquier	23:21
Re: Create syscaches for pg_extension	Michael Paquier	23:29

Sept. 6, 2024

Thread	Author	Time
Re: Support run-time partition pruning for hash join	David Rowley	01:22
Re: AIO v2.0	David Rowley	01:42
Re: First draft of PG 17 release notes	Bruce Momjian	01:49
Re: First draft of PG 17 release notes	Bruce Momjian	01:51
Re: pgsql: Add more SQL/JSON constructor functions	Amit Langote	03:07
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN 📎	Tatsuo Ishii	04:21
Re: Trying out read streams in pgvector (an extension) 📎	Thomas Munro	04:28
Re: pgsql: Add more SQL/JSON constructor functions	Amit Langote	04:34
Re: Trying out read streams in pgvector (an extension)	Thomas Munro	04:49
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN 📎	David Rowley	05:07
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	06:02
Re: Optimize WindowAgg's use of tuplestores	Ashutosh Bapat	06:30
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Ashutosh Bapat	07:07
Re: Support run-time partition pruning for hash join	Richard Guo	07:18
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	07:50
Re: pgsql: Add more SQL/JSON constructor functions 📎	Amit Langote	08:01
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Antonin Houska	08:08
Re: Conflict Detection and Resolution 📎	Ajin Cherian	08:35
Re: On disable_cost	Alexander Lakhin	09:00
Re: On disable_cost	Richard Guo	09:27
Re: Typos in the code and README	Daniel Gustafsson	09:42
Re: gamma() and lgamma() functions 📎	Dean Rasheed	09:42
Re: On disable_cost	Richard Guo	09:51
Re: Refactoring postmaster's code to cleanup after child exit	Heikki Linnakangas	09:52
Re: race condition in pg_class	Nitin Motiani	09:52
Re: On disable_cost	Alexander Lakhin	10:10
Господарський суд Одеської області -позовна заява	Господарський суд Одеської області	10:29
Remove one TimestampTzGetDatum call in pg_stat_get_io() 📎	Bertrand Drouvot	10:48
Remove emode argument from XLogFileRead/XLogFileReadAnyTLI 📎	Yugo Nagata	11:10
Re: pgstattuple: fix free space calculation	Rafia Sabih	11:18
Re: Invalid Assert while validating REPLICA IDENTITY?	vignesh C	11:18
PATCH: Issue with set_indexsafe_procflags in ReindexRelationConcurrently 📎	Michail Nikolaev	11:27
Re: PATCH: Issue with set_indexsafe_procflags in ReindexRelationConcurrently	Michail Nikolaev	11:39
Re: Conflict Detection and Resolution	Nisha Moond	11:40
Re: [BUG?] XMLSERIALIZE( ... INDENT) won't work with blank nodes	Jim Jones	11:55
Re: scalability bottlenecks with (many) partitions (and more)	Jakub Wartak	11:56
Re: gamma() and lgamma() functions 📎	Dean Rasheed	11:58
Re: Refactoring postmaster's code to cleanup after child exit	Heikki Linnakangas	13:13
Re: Refactoring postmaster's code to cleanup after child exit	Robert Haas	13:32
Re: Optimize WindowAgg's use of tuplestores	David Rowley	13:37
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	David Rowley	13:51
Re: Remove one TimestampTzGetDatum call in pg_stat_get_io()	Tom Lane	14:38
Re: per backend I/O statistics 📎	Bertrand Drouvot	15:03
Re: Remove one TimestampTzGetDatum call in pg_stat_get_io()	Tom Lane	15:40
Re: Remove one TimestampTzGetDatum call in pg_stat_get_io()	Bertrand Drouvot	15:45
Re: [BUG?] XMLSERIALIZE( ... INDENT) won't work with blank nodes	Tom Lane	16:34
Re: PostgreSQL 17 release announcement draft 📎	Jonathan S. Katz	17:03
Re: PostgreSQL 17 release announcement draft	Matthias van de Meent	18:01
Re: [PATCH] TODO “Allow LISTEN on patterns”	Tom Lane	18:42
Re: race condition in pg_class	Noah Misch	18:55
Re: AIO v2.0 📎	Andres Freund	19:38
Re: Remove hardcoded hash opclass function signature exceptions	Tom Lane	19:43
Re: AIO v2.0	Andres Freund	19:47
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Masahiko Sawada	21:07
Re: index prefetching 📎	Tomas Vondra	21:49
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Noah Misch	21:59
Re: Trying out read streams in pgvector (an extension)	Thomas Munro	22:27
Re: Detailed release notes	Jelte Fennema-Nio	22:30
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Tom Lane	22:36
Re: PostgreSQL 17 release announcement draft	Jelte Fennema-Nio	22:40
Re: [BUG?] XMLSERIALIZE( ... INDENT) won't work with blank nodes 📎	Jim Jones	22:46
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Noah Misch	23:25
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Tom Lane	23:37

Sept. 7, 2024

Thread	Author	Time
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Noah Misch	00:19
Re: Detailed release notes 📎	jian he	02:12
Re: POC: make mxidoff 64 bits 📎	Maxim Orlov	04:36
Re: Use XLOG_CONTROL_FILE macro everywhere? 📎	Anton A. Melnikov	07:38
Re: [PATCH] Add roman support for to_number function 📎	Hunaid Sohail	09:24
Re: First draft of PG 17 release notes	Alvaro Herrera	09:55
Re: Create syscaches for pg_extension	Michael Paquier	11:44
Yet another way for pg_ctl stop to fail on Windows	Alexander Lakhin	12:00
Re: Detailed release notes	Marcos Pegoraro	14:16
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Tomas Vondra	15:27
Re: PostgreSQL 17 release announcement draft	Jonathan S. Katz	18:05
Re: Yet another way for pg_ctl stop to fail on Windows	Noah Misch	18:11
Re: PostgreSQL 17 release announcement draft 📎	Jonathan S. Katz	18:44
Re: [PATCH] Add roman support for to_number function	Maciek Sakrejda	18:51
Re: [PATCH] Add roman support for to_number function	Maciek Sakrejda	18:57
Undocumented functions	Marcos Pegoraro	18:58
Re: Undocumented functions	Pavel Stehule	19:51
Re: pgstattuple: fix free space calculation	Tom Lane	20:10
Re: Undocumented functions	Tom Lane	20:18
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎	Oliver Ford	20:25
Re: pgstattuple: fix free space calculation	Tom Lane	20:45
Re: PostgreSQL 17 release announcement draft	David Rowley	22:58
Re: [PATCH] Add roman support for to_number function	Tom Lane	23:09

Browse Archives

Prev | Next