pgsql-hackers since 2024-08-28 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. 28, 2024

Thread	Author	Time
Re: Segfault in jit tuple deforming on arm64 due to LLVM issue 📎	Thomas Munro	00:36
Re: Parallel CREATE INDEX for GIN indexes	Andy Fan	00:37
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Matthias van de Meent	00:40
RE: Doc: fix the note related to the GUC "synchronized_standby_slots"	Masahiro.Ikeda	00:46
Re: Parallel CREATE INDEX for GIN indexes	Matthias van de Meent	01:15
Re: RFC: Additional Directory for Extensions	Craig Ringer	02:24
Re: Allow logical failover slots to wait on synchronous replication	shveta malik	03:16
Re: Conflict detection and logging in logical replication	shveta malik	03:30
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Richard Guo	03:30
Re: consider -Wmissing-variable-declarations	Thomas Munro	03:31
Re: Flush pgstats file during checkpoints	Bertrand Drouvot	03:43
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Richard Guo	03:52
Re: Eager aggregation, take 3	Tender Wang	03:57
RE: Conflict detection and logging in logical replication 📎	Zhijie Hou (Fujitsu)	04:11
RE: Conflict detection and logging in logical replication 📎	Zhijie Hou (Fujitsu)	04:14
Re: Conflict Detection and Resolution	shveta malik	04:27
Re: New function normal_rand_array function to contrib/tablefunc. 📎	Andy Fan	04:27
Re: Streaming read-ready sequential scan code	Thomas Munro	04:45
Re: Conflict Detection and Resolution	Ajin Cherian	05:00
Re: New function normal_rand_array function to contrib/tablefunc. 📎	Japin Li	05:22
Re: Conflict Detection and Resolution	shveta malik	05:28
Re: Conflict detection and logging in logical replication	shveta malik	05:53
Re: Pgoutput not capturing the generated columns	Amit Kapila	06:06
Re: Collect statistics about conflicts in logical replication	shveta malik	06:13
Re: Test 041_checkpoint_at_promote.pl faild in installcheck due to missing injection_points	Maxim Orlov	06:14
Re: macOS prefetching support	Peter Eisentraut	06:21
Re: Conflict detection and logging in logical replication	Peter Smith	06:54
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Justin Clift	06:58
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Richard Guo	07:08
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Richard Guo	07:31
Add const qualifiers to XLogRegister*() functions 📎	Peter Eisentraut	08:09
[BUG?] WAL file archive leads to crash during startup 📎	Kirill Reshke	08:18
[BUG?] XMLSERIALIZE( ... INDENT) won't work with blank nodes 📎	Jim Jones	08:19
Re: Detailed release notes	Peter Eisentraut	08:47
Re: Streaming read-ready sequential scan code	Alexander Lakhin	09:00
Re: Doc: fix the note related to the GUC "synchronized_standby_slots" 📎	Amit Kapila	09:00
Re: [PATCH] Support systemd readiness notifications on reload	Peter Eisentraut	09:01
json_query conditional wrapper bug	Peter Eisentraut	09:21
RE: Doc: fix the note related to the GUC "synchronized_standby_slots" 📎	Masahiro.Ikeda	09:32
Re: Conflict detection and logging in logical replication	Amit Kapila	09:37
Re: Doc: fix the note related to the GUC "synchronized_standby_slots"	Amit Kapila	09:38
Re: Invalid "trailing junk" error message when non-English letters are used 📎	Karina Litskevich	10:00
Re: Add const qualifiers to XLogRegister*() functions	Aleksander Alekseev	10:04
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Ashutosh Bapat	10:18
Re: Conflict Detection and Resolution	shveta malik	10:37
Re: Trim the heap free memory 📎	shawn wang	10:54
Re: Collect statistics about conflicts in logical replication	Amit Kapila	11:18
Re: allowing extensions to control planner behavior	Robert Haas	12:37
Re: Logging parallel worker draught 📎	Benoit Lobréau	12:58
Re: Eager aggregation, take 3	Robert Haas	13:00
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Robert Haas	13:25
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Robert Haas	13:35
Re: PG_TEST_EXTRA and meson	Ashutosh Bapat	13:41
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Peter Geoghegan	13:41
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Robert Haas	13:45
Re: allowing extensions to control planner behavior	Jakub Wartak	13:46
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Robert Haas	13:49
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Peter Geoghegan	13:52
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Peter Geoghegan	13:54
Reading all tuples in Index Access Method	Sushrut Shivaswamy	14:21
Remove unnecessary check on set-returning functions in values_lists 📎	Andrei Lepikhov	14:26
Re: allowing extensions to control planner behavior	Robert Haas	14:57
Minor refactor: Use more consistent names for the labels of PG_Locale_Strategy 📎	Andreas Karlsson	14:58
Parallel workers stats in pg_stat_database 📎	Benoit Lobréau	15:10
Re: PG_TEST_EXTRA and meson	Jacob Champion	15:11
Re: PG_TEST_EXTRA and meson	Nazir Bilal Yavuz	15:15
Re: PG_TEST_EXTRA and meson	Nazir Bilal Yavuz	15:21
Re: Little cleanup of ShmemInit function names	Andreas Karlsson	15:26
Re: PATCH: Add hooks for pg_total_relation_size and pg_indexes_size	Andreas Karlsson	15:53
Re: Reading all tuples in Index Access Method	Matthias van de Meent	15:59
Re: Remaining dependency on setlocale()	Andreas Karlsson	16:26
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	16:31
Re: tiny step toward threading: reduce dependence on setlocale() 📎	Andreas Karlsson	16:43
Re: Reading all tuples in Index Access Method	Sushrut Shivaswamy	16:57
Re: allowing extensions to control planner behavior	Robert Haas	17:06
Re: allowing extensions to control planner behavior	Peter Geoghegan	17:20
Re: Little cleanup of ShmemInit function names 📎	Heikki Linnakangas	17:26
Re: Detailed release notes	Bruce Momjian	17:45
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel 📎	Alexander Lakhin	18:00
Re: PATCH: Add hooks for pg_total_relation_size and pg_indexes_size	Tomas Vondra	18:01
Re: Little cleanup of ShmemInit function names	Andreas Karlsson	18:41
Re: Little cleanup of ShmemInit function names	Tom Lane	18:44
Re: On non-Windows, hard depend on uselocale(3)	Peter Eisentraut	18:50
Re: Thread-safe nl_langinfo() and localeconv()	Peter Eisentraut	19:07
Re: Little cleanup of ShmemInit function names	Robert Haas	19:15
Re: allowing extensions to control planner behavior	Jeff Davis	19:23
Re: allowing extensions to control planner behavior	Robert Haas	20:12
query ID goes missing with extended query protocol	Robert Haas	20:27
Re: allowing extensions to control planner behavior	Jeff Davis	20:29
Re: allowing extensions to control planner behavior	Robert Haas	20:35
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Tom Lane	20:47
Re: Allow logical failover slots to wait on synchronous replication 📎	John H	21:01
Re: optimizing pg_upgrade's once-in-each-database steps 📎	Nathan Bossart	21:46
pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD 📎	Mark Murawski	21:53
pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD 📎	Mark Murawski	21:54
Re: Streaming read-ready sequential scan code	Thomas Munro	22:16
pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD 📎	Mark Murawski	22:34
pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD 📎	Mark Murawski	22:36
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD	Tom Lane	22:38
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD	Mark Murawski	22:39
Re: query ID goes missing with extended query protocol	Michael Paquier	22:48
Re: Removing log_cnt from pg_sequence_read_tuple()	Michael Paquier	23:00
Re: allowing extensions to control planner behavior	Jeff Davis	23:15
Re: allowing extensions to control planner behavior	Tom Lane	23:25
Re: Collect statistics about conflicts in logical replication	Peter Smith	23:29
Re: Switch PgStat_HashKey.objoid from Oid to uint64 📎	Michael Paquier	23:56

Aug. 29, 2024

Thread	Author	Time
Re: allowing extensions to control planner behavior	Michael Paquier	00:28
Re: Collect statistics about conflicts in logical replication	Peter Smith	00:31
Re: Minor refactor: Use more consistent names for the labels of PG_Locale_Strategy	Michael Paquier	01:06
Re: Little cleanup of ShmemInit function names	Alvaro Herrera	01:06
Re: macOS prefetching support	Thomas Munro	01:22
Re: Removing log_cnt from pg_sequence_read_tuple()	Nathan Bossart	01:28
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	Richard Guo	01:54
RE: Collect statistics about conflicts in logical replication	Zhijie Hou (Fujitsu)	02:05
Re: Eager aggregation, take 3	Richard Guo	02:26
Re: Eager aggregation, take 3	Richard Guo	02:29
Re: Eager aggregation, take 3	Richard Guo	02:45
Re: Remove unnecessary check on set-returning functions in values_lists	Tom Lane	03:03
Re: Pgoutput not capturing the generated columns	Masahiko Sawada	03:13
Re: Collect statistics about conflicts in logical replication	shveta malik	03:17
Re: Eager aggregation, take 3	Tender Wang	03:22
Re: Eager aggregation, take 3	Tender Wang	03:38
Re: Parallel CREATE INDEX for GIN indexes	Andy Fan	04:30
Re: New function normal_rand_array function to contrib/tablefunc. 📎	Andy Fan	04:38
Re: Conflict Detection and Resolution	shveta malik	04:49
Re: Removing log_cnt from pg_sequence_read_tuple() 📎	Michael Paquier	05:11
Re: [PoC] Reducing planning time when tables have many partitions 📎	Yuya Watari	05:34
RE: Collect statistics about conflicts in logical replication 📎	Zhijie Hou (Fujitsu)	05:36
Re: 039_end_of_wal: error in "xl_tot_len zero" test 📎	Thomas Munro	05:41
Re: 039_end_of_wal: error in "xl_tot_len zero" test	Tom Lane	05:55
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Bharath Rupireddy	06:01
Re: Pgoutput not capturing the generated columns	Amit Kapila	06:16
Re: macOS prefetching support	Peter Eisentraut	06:28
Re: Partitioned tables and [un]loggedness	Michael Paquier	06:44
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.	David Rowley	06:49
Re: Little cleanup of ShmemInit function names	Heikki Linnakangas	07:01
Re: Disallow USING clause when altering type of generated column	Peter Eisentraut	07:15
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM	Bharath Rupireddy	07:25
Re: Redux: Throttle WAL inserts before commit	Jakub Wartak	07:28
Re: Virtual generated columns 📎	jian he	09:01
Re: type cache cleanup improvements	Alexander Korotkov	09:01
Re: Add contrib/pg_logicalsnapinspect	Amit Kapila	09:21
Re: Allow logical failover slots to wait on synchronous replication	shveta malik	09:34
Make printtup a bit faster	Andy Fan	09:40
Re: Add contrib/pg_logicalsnapinspect	Bertrand Drouvot	10:14
Re: PG_TEST_EXTRA and meson 📎	Ashutosh Bapat	10:33
Re: Conflict Detection and Resolution	Amit Kapila	11:12
Re: ANALYZE ONLY	Melih Mutlu	11:30
Re: Make printtup a bit faster	David Rowley	11:51
Re: Virtual generated columns 📎	Peter Eisentraut	12:15
Re: Segfault in jit tuple deforming on arm64 due to LLVM issue 📎	Anthonin Bonnefoy	12:18
Re: Eager aggregation, take 3	Robert Haas	12:40
[BUG] Security bugs affected version detected.	James Watt	12:54
Re: Streaming read-ready sequential scan code	Alexander Lakhin	13:00
Re: [BUG] Security bugs affected version detected.	Daniel Gustafsson	13:00
Re: Eager aggregation, take 3	Robert Haas	13:02
Re: Add contrib/pg_logicalsnapinspect	Bharath Rupireddy	13:03
Re: Use streaming read API in ANALYZE 📎	Mats Kindahl	13:15
Re: Switching XLog source from archive to streaming when primary available	Bharath Rupireddy	13:32
Re: generic plans and "initial" pruning 📎	Amit Langote	13:34
Re: Virtual generated columns 📎	jian he	13:35
Re: pg_verifybackup: TAR format backup verification 📎	Amul Sul	13:46
Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes 📎	Guillaume Lelarge	14:04
Re: Add contrib/pg_logicalsnapinspect	Bertrand Drouvot	14:15
Re: Removing log_cnt from pg_sequence_read_tuple()	Nathan Bossart	14:28
Re: 039_end_of_wal: error in "xl_tot_len zero" test	Nathan Bossart	14:34
Re: Partitioned tables and [un]loggedness	Nathan Bossart	14:49
Re: pgstattuple: fix free space calculation 📎	Frédéric Yhuel	14:53
Re: Parallel workers stats in pg_stat_database 📎	Benoit Lobréau	15:02
Re: Make printtup a bit faster	Tom Lane	15:33
Re: race condition in pg_class	Nitin Motiani	15:38
Re: RFC: Additional Directory for Extensions	David E. Wheeler	15:55
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD	Andrew Dunstan	15:56
SQL:2023 JSON simplified accessor support 📎	Alexandra Wang	16:33
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch 📎	Ayush Vatsa	16:47
bt Scankey in another contradictory case	bigbro_wq@hotmail.com	16:56
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD	Mark Murawski	17:01
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)	Peter Geoghegan	17:33
Re: proposal: schema variables 📎	Pavel Stehule	17:33
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch	Nathan Bossart	17:36
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch	Nathan Bossart	17:38
Re: proposal: schema variables	Pavel Stehule	18:17
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch 📎	Ayush Vatsa	18:47
Re: [PATCH] Add CANONICAL option to xmlserialize	Pavel Stehule	18:50
Primary and standby setting cross-checks	Heikki Linnakangas	18:52
Re: Pgstattuple on Sequences: Seeking Community Feedback on Potential Patch	Nathan Bossart	19:25
Re: Allow logical failover slots to wait on synchronous replication	John H	19:26
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM	Jeff Davis	19:29
Add parallel columns for pg_stat_statements 📎	Guillaume Lelarge	20:08
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible 📎	Jacob Champion	20:44
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Masahiko Sawada	20:48
Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. 📎	Tom Lane	20:53
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD	Andrew Dunstan	20:54
Re: Switching XLog source from archive to streaming when primary available	John H	20:58
Re: pl/pgperl Patch for adding $_FN detail just like triggers have for $_TD	Mark Murawski	21:50
Re: [PATCH] Add CANONICAL option to xmlserialize	Jim Jones	21:54
Re: [BUG?] XMLSERIALIZE( ... INDENT) won't work with blank nodes 📎	Jim Jones	22:06
Re: allowing extensions to control planner behavior	Jeff Davis	22:49
Re: Removing log_cnt from pg_sequence_read_tuple()	Michael Paquier	23:59

Aug. 30, 2024

Thread	Author	Time
Re: Make printtup a bit faster	Andy Fan	00:09

Browse Archives

Prev | Next