pgsql-hackers since 2024-09-04 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: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Tatsuo Ishii	00:06
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points 📎	Michael Paquier	00:40
Re: Wrong results with grouping sets	Richard Guo	01:16
Re: Typos in the code and README 📎	Michael Paquier	01:25
Re: optimizing pg_upgrade's once-in-each-database steps 📎	Nathan Bossart	01:41
Re: Improving the latch handling between logical replication launcher and worker processes.	Kyotaro Horiguchi	03:02
Re: Collect statistics about conflicts in logical replication	Peter Smith	03:47
Re: Introduce XID age and inactive timeout based replication slot invalidation	shveta malik	03:47
Re: Eager aggregation, take 3	Tender Wang	03:48
Re: Inconsistency between try_mergejoin_path and create_mergejoin_plan	Richard Guo	03:50
Re: per backend I/O statistics	Bertrand Drouvot	04:45
Re: broken devel package for rocky linux	Zaid Shabbir	04:49
Re: Collect statistics about conflicts in logical replication	Amit Kapila	04:56
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description 📎	Peter Smith	04:59
Re: tiny step toward threading: reduce dependence on setlocale()	Jeff Davis	05:04
Re: Add callbacks for fixed-numbered stats flush in pgstats	Kyotaro Horiguchi	05:05
Re: Add callback in pgstats for backend initialization	Kyotaro Horiguchi	05:15
Re: Add callbacks for fixed-numbered stats flush in pgstats	Bertrand Drouvot	05:28
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Kyotaro Horiguchi	05:32
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	Maxim Orlov	05:34
Re: GUC names in messages	Michael Paquier	05:54
Re: Add callback in pgstats for backend initialization	Michael Paquier	06:04
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	David G. Johnston	06:04
Re: Add callbacks for fixed-numbered stats flush in pgstats	Michael Paquier	06:12
Re: Add callbacks for fixed-numbered stats flush in pgstats	Bertrand Drouvot	06:27
Re: Parallel workers stats in pg_stat_database	Bertrand Drouvot	06:46
Commit Timestamp and LSN Inversion issue	shveta malik	06:53
Re: altering a column's collation leaves an invalid foreign key 📎	jian he	06:54
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match()	Tomas Vondra	07:21
Re: Optimize mul_var() for var1ndigits >= 8	Dean Rasheed	07:22
Re: Use XLOG_CONTROL_FILE macro everywhere? 📎	Kyotaro Horiguchi	08:09
Re: Typos in the code and README	Daniel Gustafsson	08:23
RecoveryTargetAction is left out in xlog_interna.h 📎	Kyotaro Horiguchi	08:30
Re: Commit Timestamp and LSN Inversion issue	Aleksander Alekseev	08:34
Re: Virtual generated columns 📎	Peter Eisentraut	08:40
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes	Bertrand Drouvot	08:47
Re: list of acknowledgments for PG17	Peter Eisentraut	08:48
Re: POC: make mxidoff 64 bits	Maxim Orlov	08:49
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN	jian he	08:57
Re: Introduce XID age and inactive timeout based replication slot invalidation	shveta malik	09:18
Re: [PoC] Federated Authn/z with OAUTHBEARER	Peter Eisentraut	09:28
Re: scalability bottlenecks with (many) partitions (and more)	Jakub Wartak	09:29
Re: Add callbacks for fixed-numbered stats flush in pgstats	Kyotaro Horiguchi	09:37
Re: Add callback in pgstats for backend initialization	Kyotaro Horiguchi	09:42
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match()	Junwang Zhao	09:55
Re: json_query conditional wrapper bug 📎	Peter Eisentraut	10:16
Re: Virtual generated columns	Dean Rasheed	10:33
Re: Use streaming read API in ANALYZE	Thomas Munro	10:40
Re: scalability bottlenecks with (many) partitions (and more)	Tomas Vondra	11:15
Re: First draft of PG 17 release notes	jian he	11:18
Re: Improving the latch handling between logical replication launcher and worker processes. 📎	vignesh C	11:24
Re: Commit Timestamp and LSN Inversion issue	Amit Kapila	11:34
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Antonin Houska	11:41
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match()	Tomas Vondra	11:54
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match()	Junwang Zhao	12:24
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes 📎	Guillaume Lelarge	12:51
Re: Optimize mul_var() for var1ndigits >= 8	Joel Jacobson	12:52
Re: thread-safety: strerror_r()	Peter Eisentraut	12:54
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes	Bertrand Drouvot	12:58
Re: Commit Timestamp and LSN Inversion issue	Aleksander Alekseev	13:04
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Ashutosh Bapat	13:18
Re: [PATCH] Avoid mixing custom and OpenSSL BIO functions 📎	Daniel Gustafsson	13:22
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes	Guillaume Lelarge	13:25
Re: Improving the latch handling between logical replication launcher and worker processes.	Heikki Linnakangas	13:53
Re: Index AM API cleanup	Alexandra Wang	14:15
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes	Bertrand Drouvot	14:18
Re: scalability bottlenecks with (many) partitions (and more)	Matthias van de Meent	14:25
Re: Refactoring postmaster's code to cleanup after child exit	Andres Freund	14:35
Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes 📎	Guillaume Lelarge	14:37
Re: Optimize WindowAgg's use of tuplestores 📎	David Rowley	14:49
Re: using extended statistics to improve join estimates 📎	Andrei Lepikhov	14:50
Re: scalability bottlenecks with (many) partitions (and more)	David Rowley	15:12
Re: Parallel workers stats in pg_stat_database	Benoit Lobréau	15:25
Re: race condition in pg_class	Nitin Motiani	15:30
Re: Logging parallel worker draught	Benoit Lobréau	15:31
Re: POC, WIP: OR-clause support for indexes 📎	Alena Rybakina	15:31
Re: scalability bottlenecks with (many) partitions (and more)	Tomas Vondra	15:32
Re: Typos in the code and README	David Rowley	15:34
Re: Use streaming read API in ANALYZE	Robert Haas	15:36
Re: scalability bottlenecks with (many) partitions (and more)	Tomas Vondra	15:37
Re: POC, WIP: OR-clause support for indexes 📎	Alena Rybakina	15:42
GetRelationPath() vs critical sections	Andres Freund	15:58
Re: GUC names in messages	Alexander Lakhin	16:00
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points	Maxim Orlov	16:05
Avoid dead code (contrib/pg_visibility/pg_visibility.c) 📎	Ranier Vilela	16:50
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	16:52
Avoid possible dereference null pointer (src/bin/pg_dump/pg_dump.c) 📎	Ranier Vilela	17:10
Re: Vacuum statistics 📎	Alena Rybakina	17:23
Re: Avoid possible dereference null pointer (src/bin/pg_dump/pg_dump.c)	Nathan Bossart	17:30
Re: AIO v2.0	陈宗志	17:37
Fix possible resource leaks (src/backend/replication/logical/conflict.c) 📎	Ranier Vilela	17:53
Re: gamma() and lgamma() functions 📎	Dean Rasheed	17:55
Re: Fix possible resource leaks (src/backend/replication/logical/conflict.c)	Tom Lane	18:06
Avoid overflowed array index (src/backend/utils/activity/pgstat.c) 📎	Ranier Vilela	18:14
Re: gamma() and lgamma() functions	Tom Lane	18:21
Re: gamma() and lgamma() functions	Tom Lane	18:34
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

Browse Archives

Prev | Next