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

Browse Archives

Prev | Next

Sept. 11, 2024

Thread Author Time
Re: Make printtup a bit faster Andy Fan 01:02
Re: not null constraints, again jian he 01:11
Re: Make printtup a bit faster Tom Lane 01:18
Re: Disallow altering invalidated replication slots Peter Smith 01:29
Re: Eager aggregation, take 3 Tender Wang 02:52
RE: Conflict detection for update_deleted in logical replication Zhijie Hou (Fujitsu) 03:02
Re: query_id, pg_stat_activity, extended query protocol Michael Paquier 03:06
Re: Disallow altering invalidated replication slots shveta malik 03:11
Re: Pgoutput not capturing the generated columns Peter Smith 03:24
Allow pushdown of HAVING clauses with grouping sets 📎 Richard Guo 03:43
Re: Conflict detection for update_deleted in logical replication shveta malik 04:18
Re: Invalid Assert while validating REPLICA IDENTITY? Amit Kapila 04:35
RE: Conflict detection for update_deleted in logical replication Zhijie Hou (Fujitsu) 04:45
Re: Add contrib/pg_logicalsnapinspect Amit Kapila 05:00
Re: Conflict detection for update_deleted in logical replication shveta malik 05:02
RE: Conflict detection for update_deleted in logical replication Zhijie Hou (Fujitsu) 05:36
Re: query_id, pg_stat_activity, extended query protocol 📎 Michael Paquier 05:43
Re: Use read streams in pg_visibility Nazir Bilal Yavuz 06:19
Inconsistency in lock structure after reporting "lock already held" error 高增琦 06:30
Re: Pgoutput not capturing the generated columns Peter Smith 07:06
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 07:37
Re: Separate HEAP WAL replay logic into its own file Michael Paquier 07:41
Re: ANALYZE ONLY 📎 Michael Harris 07:47
Re: json_query conditional wrapper bug 📎 Amit Langote 07:51
Re: broken build - FC 41 Daniel Gustafsson 07:54
Re: Psql meta-command conninfo+ 📎 Hunaid Sohail 08:16
Re: Conflict detection for update_deleted in logical replication Amit Kapila 09:10
Re: Fix orphaned 2pc file which may casue instance restart failed Michael Paquier 09:21
Re: not null constraints, again jian he 09:27
Re: Test improvements and minor code fixes for formatting.c. Aleksander Alekseev 09:32
Re: broken build - FC 41 Pavel Stehule 09:42
Re: json_query conditional wrapper bug Peter Eisentraut 09:57
Re: Psql meta-command conninfo+ Jim Jones 10:03
Re: PG_TEST_EXTRA and meson Ashutosh Bapat 10:03
Re: Document DateStyle effect on jsonpath string() Peter Eisentraut 10:20
Re: Trim the heap free memory Rafia Sabih 10:24
Re: Add contrib/pg_logicalsnapinspect 📎 Bertrand Drouvot 10:51
Make pg_stat_io view count IOs as bytes instead of blocks 📎 Nazir Bilal Yavuz 11:19
Re: json_query conditional wrapper bug Amit Langote 11:25
Re: Test improvements and minor code fixes for formatting.c. Hunaid Sohail 11:29
Re: Psql meta-command conninfo+ Hunaid Sohail 11:35
Re: json_query conditional wrapper bug Peter Eisentraut 11:56
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match() Tomas Vondra 12:08
Re: Jargon and acronyms on this mailing list Robert Haas 12:34
Allow CI to only run the compiler warnings task 📎 Bertrand Drouvot 12:36
RE: AIX support 📎 Srirama Kucherlapati 12:38
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Robert Haas 13:00
[PATCH] Refactor SLRU to always use long file names 📎 Aleksander Alekseev 13:07
Re: PG_TEST_EXTRA and meson 📎 Nazir Bilal Yavuz 13:26
Re: Allow CI to only run the compiler warnings task Nazir Bilal Yavuz 13:39
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Daniel Gustafsson 13:44
Re: Test improvements and minor code fixes for formatting.c. Tom Lane 14:01
Re: First draft of PG 17 release notes Bruce Momjian 14:10
Re: Document DateStyle effect on jsonpath string() Tom Lane 14:11
Re: First draft of PG 17 release notes Bruce Momjian 14:12
Re: Detailed release notes Bruce Momjian 14:16
Re: First draft of PG 17 release notes Nathan Bossart 14:36
Re: Add on_error and log_verbosity options to file_fdw Fujii Masao 14:50
Re: Remove old RULE privilege completely Fujii Masao 14:55
Re: BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match() Junwang Zhao 14:56
Re: Document DateStyle effect on jsonpath string() David E. Wheeler 15:00
Re: Jargon and acronyms on this mailing list Andrew Dunstan 15:04
Re: Document DateStyle effect on jsonpath string() Tom Lane 15:11
Re: Detailed release notes Bruce Momjian 15:19
Re: Use read streams in pg_visibility Noah Misch 15:51
Re: Document DateStyle effect on jsonpath string() David E. Wheeler 15:52
Re: Document DateStyle effect on jsonpath string() Tom Lane 16:06
Re: Document DateStyle effect on jsonpath string() 📎 Tom Lane 16:26
Re: Invalid Assert while validating REPLICA IDENTITY? vignesh C 16:59
Re: Document DateStyle effect on jsonpath string() David E. Wheeler 17:06
Re: First draft of PG 17 release notes Alvaro Herrera 17:50
Re: Document DateStyle effect on jsonpath string() 📎 Tom Lane 19:08
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Lars Kanis 19:08
Re: Document DateStyle effect on jsonpath string() David E. Wheeler 19:20
Re: not null constraints, again Alvaro Herrera 19:32
Re: Document DateStyle effect on jsonpath string() Tom Lane 19:43
Accept invalidation messages before the query starts inside a transaction 📎 Andrei Lepikhov 19:50
Re: Document DateStyle effect on jsonpath string() David E. Wheeler 19:52
Re: Accept invalidation messages before the query starts inside a transaction Tom Lane 19:55
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 20:36
Re: Extract numeric filed in JSONB more effectively 📎 David Rowley 21:00
Re: Support run-time partition pruning for hash join David Rowley 21:14
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Jacob Champion 21:29
Re: AIX support Heikki Linnakangas 21:57
Re: query_id, pg_stat_activity, extended query protocol 📎 Sami Imseih 22:02
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Matthias van de Meent 22:02
Re: AIX support Thomas Munro 22:06
Using per-transaction memory contexts for storing decoded tuples 📎 Masahiko Sawada 22:32
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 22:54
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Jacob Champion 23:00
Re: query_id, pg_stat_activity, extended query protocol Michael Paquier 23:07
Re: Separate HEAP WAL replay logic into its own file Michael Paquier 23:12
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Michael Paquier 23:42
Re: [PATCH] Refactor SLRU to always use long file names Michael Paquier 23:55

Sept. 12, 2024

Thread Author Time
Re: Add 64-bit XIDs into PostgreSQL 15 Michael Paquier 00:12
Remove shadowed declaration warnings 📎 Peter Smith 00:32
Re: Remove shadowed declaration warnings David Rowley 00:58
Re: Incremental Sort Cost Estimation Instability David Rowley 01:05
Re: CI, macports, darwin version problems Thomas Munro 01:05
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 01:41
Re: Remove useless GROUP BY columns considering unique index David Rowley 01:43
Re: Remove shadowed declaration warnings Tom Lane 02:02
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN Tatsuo Ishii 02:03
Re: Opinion poll: Sending an automated email to a thread when it gets added to the commitfest David Rowley 02:07
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options David G. Johnston 02:11
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Michael Paquier 02:19
Re: json_query conditional wrapper bug Amit Langote 02:24
Re: Remove shadowed declaration warnings David Rowley 02:25
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN David Rowley 02:28
Re: Inconsistency in lock structure after reporting "lock already held" error 📎 高增琦 02:28
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 02:30
Re: Trim the heap free memory 📎 shawn wang 02:40
Re: query_id, pg_stat_activity, extended query protocol Sami Imseih 02:41
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN Tatsuo Ishii 02:42
Re: Extract numeric filed in JSONB more effectively Andy Fan 03:03
Re: query_id, pg_stat_activity, extended query protocol Michael Paquier 03:11
Re: Accept invalidation messages before the query starts inside a transaction Andrey M. Borodin 04:48
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 05:09
Re: proposal: schema variables 📎 Pavel Stehule 05:15
Re: Avoid dead code (contrib/pg_visibility/pg_visibility.c) Michael Paquier 05:18
Re: Allow CI to only run the compiler warnings task Bertrand Drouvot 05:21
Re: Pgoutput not capturing the generated columns Peter Smith 05:30
Re: Separate HEAP WAL replay logic into its own file Michael Paquier 05:39
Re: Avoid dead code (contrib/pg_visibility/pg_visibility.c) Nazir Bilal Yavuz 06:10
Re: Accept invalidation messages before the query starts inside a transaction David G. Johnston 06:31
Re: [PATCH] Add roman support for to_number function Hunaid Sohail 07:44
Re: not null constraints, again 📎 jian he 08:18
Re: Conflict Detection and Resolution 📎 Ajin Cherian 08:33
Re: Trim the heap free memory David Rowley 08:42
Re: Opinion poll: Sending an automated email to a thread when it gets added to the commitfest Jelte Fennema-Nio 08:44
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov 08:49
Re: Accept invalidation messages before the query starts inside a transaction Andrei Lepikhov 09:32
Re: [PATCH] Refactor SLRU to always use long file names Aleksander Alekseev 09:33
Re: Allow logical failover slots to wait on synchronous replication shveta malik 09:34
Re: PG_TEST_EXTRA and meson 📎 Ashutosh Bapat 09:35
[PATCH] Add some documentation on how to call internal functions Florents Tselai 09:41
Re: Incremental Sort Cost Estimation Instability Andrei Lepikhov 09:51
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev 09:52
Re: Add has_large_object_privilege function Fujii Masao 10:07
Re: Incremental Sort Cost Estimation Instability David Rowley 10:12
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row 📎 jian he 10:13
Re: Make printtup a bit faster 📎 Andy Fan 10:31
Re: Docs: Order of json aggregate functions David Rowley 10:41
Re: not null constraints, again Alvaro Herrera 10:41
Re: CI, macports, darwin version problems Joe Conway 10:48
Re: Add has_large_object_privilege function 📎 Yugo NAGATA 10:51
Re: Disallow altering invalidated replication slots Amit Kapila 10:54
Re: [PATCH] Add CANONICAL option to xmlserialize 📎 Jim Jones 10:56
Re: PG_TEST_EXTRA and meson 📎 Nazir Bilal Yavuz 10:58
Re: pg_verifybackup: TAR format backup verification 📎 Amul Sul 11:04
Re: Psql meta-command conninfo+ Jim Jones 11:08
[PATCH] Support Int64 GUCs 📎 Aleksander Alekseev 11:08
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev 11:12
Re: [PATCH] Support Int64 GUCs Pavel Borisov 11:29
Re: [PATCH] Support Int64 GUCs Aleksander Alekseev 11:34
Re: Avoid dead code (contrib/pg_visibility/pg_visibility.c) Ranier Vilela 12:07
Re: POC: make mxidoff 64 bits Pavel Borisov 12:09
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN 📎 Tatsuo Ishii 12:12
Re: POC: make mxidoff 64 bits Pavel Borisov 12:25
Re: POC: make mxidoff 64 bits Alvaro Herrera 13:14
Re: Switch PgStat_HashKey.objoid from Oid to uint64 Bertrand Drouvot 13:37
Re: [PATCH] Support Int64 GUCs Nathan Bossart 13:46
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎 Matthias van de Meent 14:49
Re: Incremental Sort Cost Estimation Instability Tomas Vondra 14:57
may be a mismatch between the construct_array and construct_md_array comments Alena Rybakina 15:43
Re: [PATCH] Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges Christoph Berg 15:46
Re: may be a mismatch between the construct_array and construct_md_array comments Tom Lane 17:44
Re: tiny step toward threading: reduce dependence on setlocale() Jeff Davis 20:01
Re: query_id, pg_stat_activity, extended query protocol Sami Imseih 20:58
Re: tiny step toward threading: reduce dependence on setlocale() Andreas Karlsson 21:09
Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN David Rowley 21:20
Mutable foreign key constraints Tom Lane 21:33
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 21:39
Re: scalability bottlenecks with (many) partitions (and more) 📎 Tomas Vondra 21:40
Re: AIO v2.0 📎 Robert Pang 21:55
Re: Mutable foreign key constraints David G. Johnston 21:59
Re: Mutable foreign key constraints Tom Lane 22:23
Re: Switch PgStat_HashKey.objoid from Oid to uint64 Michael Paquier 22:34
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation 📎 Masahiko Sawada 22:42
Re: [PATCH] audo-detect and use -moutline-atomics compilation flag for aarch64 Thomas Munro 22:55
Re: type cache cleanup improvements 📎 Alexander Korotkov 23:38
Re: scalability bottlenecks with (many) partitions (and more) 📎 Tomas Vondra 23:44

Sept. 13, 2024

Thread Author Time
Re: Avoid dead code (contrib/pg_visibility/pg_visibility.c) Michael Paquier 00:10
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 00:41
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Michael Paquier 00:47
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 00:56
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 01:42
Re: ANALYZE ONLY torikoshia 01:50
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch 📎 Nathan Bossart 02:12
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Tom Lane 02:40
Re: Mutable foreign key constraints Laurenz Albe 02:41
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 03:41
Re: Switch PgStat_HashKey.objoid from Oid to uint64 Bertrand Drouvot 04:03
Re: Why don't we consider explicit Incremental Sort? 📎 Richard Guo 04:04
Re: per backend I/O statistics Bertrand Drouvot 04:25
Re: Psql meta-command conninfo+ 📎 Hunaid Sohail 04:49
Re: Using per-transaction memory contexts for storing decoded tuples torikoshia 05:26
Re: long-standing data loss bug in initial sync of logical replication Shlok Kyal 05:27
Re: query_id, pg_stat_activity, extended query protocol 📎 Michael Paquier 05:58

Browse Archives

Prev | Next