pgsql-hackers since 2024-08-30 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

Aug. 30, 2024

Thread Author Time
Re: Make printtup a bit faster Andy Fan 00:09
Re: Make printtup a bit faster David Rowley 00:31
Re: Make printtup a bit faster David Rowley 00:38
Re: Make printtup a bit faster Andy Fan 01:04
Re: Make printtup a bit faster David Rowley 01:13
Re: Make printtup a bit faster Andy Fan 01:34
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Peter Smith 02:43
JIT: Remove some unnecessary instructions. 📎 Xing Guo 03:55
Re: configure failures on chipmunk Alexander Lakhin 04:00
Re: Collect statistics about conflicts in logical replication shveta malik 04:10
Re: [PATCH] Add CANONICAL option to xmlserialize Pavel Stehule 04:46
Re: Make printtup a bit faster 📎 Andy Fan 05:00
Re: [PATCH] Enable using llvm jitlink as an alternative llvm jit linker of old Rtdyld. Thomas Munro 05:19
Re: Collect statistics about conflicts in logical replication Peter Smith 05:23
Re: Conflict Detection and Resolution 📎 Nisha Moond 05:30
Supporting pg freeze in pg_dump, restore. Stepan Neretin 05:34
Re: [PATCH] Add CANONICAL option to xmlserialize 📎 Jim Jones 06:05
Re: Collect statistics about conflicts in logical replication shveta malik 06:23
Re: Collect statistics about conflicts in logical replication shveta malik 06:24
Re: Conflict Detection and Resolution Nisha Moond 06:34
Re: define PG_REPLSLOT_DIR Michael Paquier 06:34
Re: Conflict Detection and Resolution Nisha Moond 06:34
Re: list of acknowledgments for PG17 Peter Eisentraut 06:36
Re: Conflict Detection and Resolution Amit Kapila 06:42
RE: Collect statistics about conflicts in logical replication 📎 Zhijie Hou (Fujitsu) 06:45
Re: ANALYZE ONLY torikoshia 06:45
Re: Conflict Detection and Resolution shveta malik 06:48
Re: Conflict Detection and Resolution Amit Kapila 06:57
[PATCH] Add roman support for to_number function 📎 Hunaid Sohail 07:21
Re: consider -Wmissing-variable-declarations Peter Eisentraut 07:27
Re: pgsql: Add more SQL/JSON constructor functions 📎 Amit Langote 07:32
Re: Set query_id for query contained in utility statement 📎 Anthonin Bonnefoy 07:37
Re: ANALYZE ONLY jian he 08:19
Re: Sequence Access Methods, round two 📎 Michael Paquier 08:24
回复: bt Scankey in another contradictory case 📎 b ro 08:27
Re: Collect statistics about conflicts in logical replication shveta malik 08:35
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎 Dmitry Koval 08:43
Re: ANALYZE ONLY David Rowley 08:43
Re: Add contrib/pg_logicalsnapinspect 📎 Bertrand Drouvot 09:02
Re: long-standing data loss bug in initial sync of logical replication 📎 Shlok Kyal 09:35
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 09:49
Re: Add contrib/pg_logicalsnapinspect Amit Kapila 10:13
Re: why there is not VACUUM FULL CONCURRENTLY? Junwang Zhao 10:18
Re: allowing extensions to control planner behavior Robert Haas 11:33
Re: Add contrib/pg_logicalsnapinspect Bertrand Drouvot 11:48
Re: pgstattuple: fix free space calculation Andreas Karlsson 12:06
Re: define PG_REPLSLOT_DIR 📎 Bertrand Drouvot 12:21
Re: JIT: Remove some unnecessary instructions. Andreas Karlsson 12:50
Re: bt Scankey in another contradictory case Peter Geoghegan 14:32
Re: Segfault in jit tuple deforming on arm64 due to LLVM issue 📎 Anthonin Bonnefoy 14:34
Re: Restart pg_usleep when interrupted Sami Imseih 15:50
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) Matthias van de Meent 16:00
Jargon and acronyms on this mailing list Greg Sabino Mullane 16:01
Re: Make printtup a bit faster Andreas Karlsson 16:20
Re: Inline non-SQL SRFs using SupportRequestSimplify 📎 Paul Jungwirth 16:26
Re: allowing extensions to control planner behavior Jeff Davis 17:42
Re: PG_TEST_EXTRA and meson 📎 Jacob Champion 18:35
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel 📎 Tom Lane 19:21
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Peter Eisentraut 19:42
Re: Avoiding superfluous buffer locking during nbtree backwards scans 📎 Matthias van de Meent 19:43
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Jelte Fennema-Nio 19:49
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD Andrew Dunstan 19:49
Re: allowing extensions to control planner behavior Robert Haas 20:04
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Robert Haas 20:07
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Andrew Dunstan 20:10
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Tom Lane 20:11
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD Andrew Dunstan 20:12
Add tests for PL/pgSQL SRFs 📎 Paul Jungwirth 20:28
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD Mark Murawski 20:46
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Tom Lane 20:55
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Nathan Bossart 21:06
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Jelte Fennema-Nio 21:24
Re: Interrupts vs signals 📎 Heikki Linnakangas 22:17
Re: Use read streams in pg_visibility Noah Misch 23:51

Aug. 31, 2024

Thread Author Time
Re: Interrupts vs signals Thomas Munro 00:12
Re: optimizing pg_upgrade's once-in-each-database steps Ilya Gladyshev 00:18
Re: Inval reliability, especially for inplace updates 📎 Noah Misch 01:07
Re: race condition in pg_class Noah Misch 01:10
Re: query_id, pg_stat_activity, extended query protocol jian he 01:47
Re: 039_end_of_wal: error in "xl_tot_len zero" test Thomas Munro 03:10
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation Noah Misch 03:10
not null constraints, again 📎 Alvaro Herrera 03:58
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Alexander Lakhin 04:04
Re: Streaming read-ready sequential scan code Thomas Munro 05:38
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Jelte Fennema-Nio 07:08
JIT: The nullness of casetest.value can be determined at the JIT compile time. 📎 Xing Guo 08:04
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Bharath Rupireddy 08:15
Re: generic plans and "initial" pruning Junwang Zhao 12:30
Re: In-placre persistance change of a relation 📎 Kyotaro Horiguchi 16:09
Re: Add tests for PL/pgSQL SRFs Tom Lane 16:59
Re: type cache cleanup improvements Andrei Lepikhov 19:33
Re: index prefetching 📎 Tomas Vondra 20:37

Sept. 1, 2024

Thread Author Time
Re: ANALYZE ONLY 📎 Michael Harris 01:31
Re: ANALYZE ONLY Michael Harris 01:41
Re: Partitioned tables and [un]loggedness Junwang Zhao 05:24
Re: not null constraints, again Tender Wang 05:45
AIO v2.0 📎 Andres Freund 06:27
Re: ANALYZE ONLY David Rowley 09:31
Add ExprState hashing for GROUP BY and hashed SubPlans 📎 David Rowley 11:49
Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin 12:00
Re: Re: bt Scankey in another contradictory case bigbro_wq@hotmail.com 15:44
Re: Improving tracking/processing of buildfarm test failures sia kc 18:46
BUG #18598: AddressSanitizer detects use after free inside json_unique_hash_match() PG Bug reporting form 19:00
Re: In-placre persistance change of a relation Heikki Linnakangas 19:15
Re: scalability bottlenecks with (many) partitions (and more) 📎 Tomas Vondra 19:30
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 19:35
Re: optimizing pg_upgrade's once-in-each-database steps 📎 Nathan Bossart 21:05
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Michail Nikolaev 21:19
Re: Collect statistics about conflicts in logical replication Peter Smith 22:44
Re: Collect statistics about conflicts in logical replication Peter Smith 22:49
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 23:27
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch Michael Paquier 23:44
Re: scalability bottlenecks with (many) partitions (and more) Robert Haas 23:53
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎 Alexander Korotkov 23:55

Sept. 2, 2024

Thread Author Time
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Michael Paquier 00:10
DOCS - pg_replication_slot . Fix the 'inactive_since' description 📎 Peter Smith 00:16
Re: pgsql: Implement pg_wal_replay_wait() stored procedure Michael Paquier 00:24
Re: In-placre persistance change of a relation Michael Paquier 00:30
Re: Minor refactor: Use more consistent names for the labels of PG_Locale_Strategy Michael Paquier 00:43
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points Michael Paquier 00:53
Re: query_id, pg_stat_activity, extended query protocol Michael Paquier 01:11
Re: JIT: Remove some unnecessary instructions. 📎 Xing Guo 02:23
Re: Make printtup a bit faster Andy Fan 03:18
Re: Collect statistics about conflicts in logical replication shveta malik 03:28
Re: ANALYZE ONLY torikoshia 03:29
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description shveta malik 03:43
Re: long-standing data loss bug in initial sync of logical replication Amit Kapila 04:42
Regarding canditate_restart_lsn in logical decoding. reddy manjunath 04:55
Re: Track the amount of time waiting due to cost_delay 📎 Bertrand Drouvot 05:11
Invalid Assert while validating REPLICA IDENTITY? Dilip Kumar 05:51
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 06:55
Re: thread-safety: getpwuid_r() Peter Eisentraut 07:28
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? 📎 Daniel Gustafsson 08:03
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Peter Smith 08:06
Re: pgsql: Add more SQL/JSON constructor functions 📎 Amit Langote 08:17
Re: generic plans and "initial" pruning Amit Langote 08:19
Re: More performance improvements for pg_dump in binary upgrade mode Daniel Gustafsson 08:59
Windows socket problems, interesting connection to AIO Thomas Munro 09:20
pg_stats_subscription_stats order of the '*_count' columns Peter Smith 09:24
Re: Collect statistics about conflicts in logical replication Peter Smith 09:28
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 09:50
Re: Invalid Assert while validating REPLICA IDENTITY? Amit Kapila 10:02
Re: AIO v2.0 Heikki Linnakangas 10:03
Re: not null constraints, again Tender Wang 10:33
Re: Jargon and acronyms on this mailing list Dagfinn Ilmari Mannsåker 11:06
Re: Avoiding superfluous buffer locking during nbtree backwards scans 📎 Matthias van de Meent 11:31
Re: Jargon and acronyms on this mailing list Daniel Gustafsson 11:38
Re: Use read streams in pg_visibility 📎 Nazir Bilal Yavuz 12:20
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Daniel Gustafsson 12:26
Re: Invalid Assert while validating REPLICA IDENTITY? Dilip Kumar 12:52
Re: Proposal for implementing OCSP Stapling in PostgreSQL Daniel Gustafsson 12:54
Re: Virtual generated columns jian he 13:25
Re: Virtual generated columns 📎 Nazir Bilal Yavuz 13:29
Re: Use XLOG_CONTROL_FILE macro everywhere? Daniel Gustafsson 13:44
Re: proposal: schema variables Laurenz Albe 14:00
Re: Flush pgstats file during checkpoints Heikki Linnakangas 14:08
per backend I/O statistics 📎 Bertrand Drouvot 14:55
Re: Track IO times in pg_stat_io Bertrand Drouvot 15:00
Re: PG_TEST_EXTRA and meson Nazir Bilal Yavuz 15:02
Re: long-standing data loss bug in initial sync of logical replication Nitin Motiani 15:49
Re: scalability bottlenecks with (many) partitions (and more) 📎 Tomas Vondra 17:46
Re: Typos in the code and README 📎 Alexander Lakhin 18:00
Re: [PATCH] Add roman support for to_number function Maciek Sakrejda 18:40
Re: JIT: Remove some unnecessary instructions. Andreas Karlsson 19:06
Re: JIT: Remove some unnecessary instructions. Andreas Karlsson 19:10
Re: query_id, pg_stat_activity, extended query protocol Andrei Lepikhov 19:30
thread-safety: strerror_r() 📎 Peter Eisentraut 19:45
Re: thread-safety: strerror_r() Tom Lane 19:56
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Jehan-Guillaume de Rorthais 21:01
Re: Improving tracking/processing of buildfarm test failures Andrew Dunstan 21:45
Re: Track IO times in pg_stat_io Michael Paquier 23:19

Sept. 3, 2024

Thread Author Time
Re: define PG_REPLSLOT_DIR Michael Paquier 00:15
Re: Partitioned tables and [un]loggedness Michael Paquier 00:22
Re: Flush pgstats file during checkpoints Michael Paquier 01:08
Re: Partitioned tables and [un]loggedness Nathan Bossart 01:35
Re: macOS prefetching support 📎 Thomas Munro 01:47
Add callback in pgstats for backend initialization 📎 Michael Paquier 01:52
Re: GUC names in messages 📎 Peter Smith 02:00
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Tender Wang 02:16
Remove no-op PlaceHolderVars 📎 Richard Guo 02:53
Re: Remove no-op PlaceHolderVars Tom Lane 03:31
Re: Improving the latch handling between logical replication launcher and worker processes. 📎 vignesh C 03:40
Re: define PG_REPLSLOT_DIR Bertrand Drouvot 04:35
Add callbacks for fixed-numbered stats flush in pgstats 📎 Michael Paquier 04:48
Re: Virtual generated columns 📎 jian he 04:59
Re: v17 vs v16 performance comparison 📎 Alexander Lakhin 05:00
Re: Add callback in pgstats for backend initialization Bertrand Drouvot 05:00
Re: Make tuple deformation faster 📎 David Rowley 05:05
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description Amit Kapila 05:13
Re: Typos in the code and README Michael Paquier 05:24
Re: Use XLOG_CONTROL_FILE macro everywhere? Kyotaro Horiguchi 05:37
Re: Typos in the code and README Michael Paquier 05:51
Re: Add callback in pgstats for backend initialization Michael Paquier 05:58
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description shveta malik 06:12
Re: Add const qualifiers to XLogRegister*() functions Peter Eisentraut 06:15
Re: v17 vs v16 performance comparison Thomas Munro 06:21
Re: Expand applicability of aggregate's sortop optimization Andrei Lepikhov 06:25
Re: define PG_REPLSLOT_DIR Michael Paquier 06:27
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description Bertrand Drouvot 06:35
Re: GUC names in messages Michael Paquier 06:35

Browse Archives

Prev | Next