pgsql-hackers since 2023-12-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)

Browse Archives

Prev | Next

Dec. 4, 2023

Thread Author Time
Re: collect_corrupt_items_vacuum.patch 📎 Alexander Korotkov 00:23
Re: PATCH: Add REINDEX tag to event triggers Michael Paquier 01:04
Re: Emitting JSON to file using COPY TO Joe Conway 01:14
Re: Is WAL_DEBUG related code still relevant today? Michael Paquier 01:14
Re: Emitting JSON to file using COPY TO Davin Shearer 01:27
Use PGAlignedBlock instead of "char buf[BLCKSZ]" in more places 📎 Bharath Rupireddy 01:29
Re: Syncrep and improving latency due to WAL throttling 📎 Tomas Vondra 01:45
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. 📎 Anton A. Melnikov 01:49
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding li jie 02:01
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding li jie 02:05
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 jian he 02:23
connection timeout hint Jeff Janes 02:46
Re: [RFC] Clang plugin for catching suspicious typedef casting Peter Geoghegan 03:02
Re: connection timeout hint Tom Lane 03:10
gai_strerror() is not thread-safe on Windows 📎 Thomas Munro 03:21
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 03:33
Re: Parent/child context relation in pg_get_backend_memory_contexts() torikoshia 04:43
Re: Separate memory contexts for relcache and catcache torikoshia 04:59
Re: Bug in pgbench prepared statements Michael Paquier 05:07
Re: Synchronizing slots from primary to standby shveta malik 05:10
Re: Change GUC hashtable to use simplehash? John Naylor 05:12
Re: Synchronizing slots from primary to standby shveta malik 05:15
Should REINDEX be listed under DDL? Michael Paquier 05:26
Re: Remove unnecessary includes of system headers in header files Peter Eisentraut 05:42
Re: Use PGAlignedBlock instead of "char buf[BLCKSZ]" in more places Michael Paquier 05:46
Which parts of src/backend/nodes/print.c are used? Peter Eisentraut 06:01
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 06:29
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) John Naylor 06:34
Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 06:35
Avoid detoast overhead when possible 📎 zhihuifan1213 06:37
proposal: plpgsql - OPEN LOCAL statement Pavel Stehule 06:41
Re: [PATCH] ltree hash functions jian he 06:46
Re: POC, WIP: OR-clause support for indexes 📎 Andrei Lepikhov 06:50
Re: Report planning memory in EXPLAIN ANALYZE 📎 Ashutosh Bapat 07:24
RE: CRC32C Parallel Computation Optimization on ARM 📎 Xiang Gao 07:27
cost_incremental_sort() and limit_tuples 📎 Antonin Houska 07:46
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎 Dmitry Koval 07:52
Re: Should REINDEX be listed under DDL? Laurenz Albe 07:53
Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list" 📎 Haotian Chen 07:58
Failure with pgbench and --disable-thread-safety in ~v16 Michael Paquier 07:59
Re: Remove MSVC scripts from the tree Michael Paquier 08:05
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Pavel Borisov 08:12
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 08:21
Re: Avoid detoast overhead when possible Nikita Malakhov 08:40
Re: A wrong comment about search_indexed_tlist_for_var 📎 Richard Guo 08:42
Re: Add missing error codes to PANIC/FATAL error reports in xlogrecovery 📎 Krishnakumar R 09:07
Re: Add pg_basetype() function to obtain a DOMAIN base type John Naylor 09:10
Re: [PATCH] plpython function causes server panic Hao Zhang 09:21
Re: Avoid detoast overhead when possible zhihuifan1213 09:31
Re: collect_corrupt_items_vacuum.patch Alexander Lakhin 10:00
Move bki file pre-processing from initdb - part 1 - initdb->genbki.pl 📎 Krishnakumar R 10:03
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) John Naylor 10:22
Commitfest 2023-11 is now closed John Naylor 10:52
table inheritance versus column compression and storage settings Peter Eisentraut 10:52
Re: pg_upgrade and logical replication 📎 Amit Kapila 11:00
Re: Failure with pgbench and --disable-thread-safety in ~v16 Alvaro Herrera 11:09
Re: Failure with pgbench and --disable-thread-safety in ~v16 Alvaro Herrera 11:17
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Amit Kapila 11:37
Re: Row pattern recognition 📎 Tatsuo Ishii 11:40
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Tomas Vondra 12:00
Re: Avoid detoast overhead when possible Matthias van de Meent 12:10
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Amit Kapila 12:11
Adding OLD/NEW support to RETURNING 📎 Dean Rasheed 12:14
Re: Emitting JSON to file using COPY TO Andrew Dunstan 12:41
Rename ShmemVariableCache and initialize it in more standard way 📎 Heikki Linnakangas 12:49
Re: Should REINDEX be listed under DDL? Isaac Morland 12:50
Re: Avoid detoast overhead when possible zhihuifan1213 12:55
Re: Emitting JSON to file using COPY TO Joe Conway 13:37
Re: Move bki file pre-processing from initdb - part 1 - initdb->genbki.pl John Naylor 13:38
Re: Which parts of src/backend/nodes/print.c are used? Tom Lane 13:50
回复: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Thomas wen 14:02
Re: Emitting JSON to file using COPY TO Andrew Dunstan 14:25
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 14:37
Re: Avoid detoast overhead when possible Matthias van de Meent 14:41
Re: Use PGAlignedBlock instead of "char buf[BLCKSZ]" in more places Peter Eisentraut 14:53
Re: PATCH: Add REINDEX tag to event triggers Alexander Lakhin 15:00
Re: Parallel CREATE INDEX for BRIN indexes Matthias van de Meent 15:00
Re: Clean up some signal usage mainly related to Windows Peter Eisentraut 15:22
Re: Parallel CREATE INDEX for BRIN indexes Tomas Vondra 15:33
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 15:45
Re: pg_upgrade failing for 200+ million Large Objects 📎 Kumar, Sachin 16:07
Re: Proposal: In-flight explain logging Ashutosh Bapat 16:18
Re: Rename ShmemVariableCache and initialize it in more standard way Tristan Partin 16:31
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 16:36
Re: Proposal to use JSON for Postgres Parser format Matthias van de Meent 16:44
Re: PATCH: Add REINDEX tag to event triggers jian he 16:49
Fwd: Extensible storage manager API - SMGR hook Redux Kirill Reshke 16:50
Re: Clean up some signal usage mainly related to Windows Tristan Partin 17:20
Re: Use PGAlignedBlock instead of "char buf[BLCKSZ]" in more places Andres Freund 17:47
Re: [PATCH] pg_convert improvement Nathan Bossart 17:58
Re: optimize atomic exchanges Nathan Bossart 18:18
Re: Emitting JSON to file using COPY TO Davin Shearer 18:37
Re: Change GUC hashtable to use simplehash? Jeff Davis 18:57
Re: Extensible storage manager API - SMGR hook Redux Matthias van de Meent 19:21
Re: gai_strerror() is not thread-safe on Windows 📎 Thomas Munro 19:26
Re: meson: Stop using deprecated way getting path of files Tristan Partin 19:55
Re: Emitting JSON to file using COPY TO Andrew Dunstan 20:06
Re: Postgres Partitions Limitations (5.11.2.3) 📎 Laurenz Albe 20:10
Re: meson: Stop using deprecated way getting path of files Tom Lane 20:10
Re: Remove MSVC scripts from the tree Andrew Dunstan 20:11
Re: meson: Stop using deprecated way getting path of files Tristan Partin 20:26
Re: trying again to get incremental backup Robert Haas 20:58
Re: Extensible storage manager API - SMGR hook Redux Kirill Reshke 21:02
Re: optimize atomic exchanges 📎 Nathan Bossart 21:08
Re: Extensible storage manager API - SMGR hook Redux Matthias van de Meent 21:30
Re: Failure with pgbench and --disable-thread-safety in ~v16 Michael Paquier 22:22
Re: Remove MSVC scripts from the tree Michael Paquier 22:29
Re: Emitting JSON to file using COPY TO Davin Shearer 22:55
Re: PATCH: Add REINDEX tag to event triggers 📎 Michael Paquier 23:45

Dec. 5, 2023

Thread Author Time
Re: Avoid detoast overhead when possible zhihuifan1213 00:28
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } 📎 Jeff Davis 00:55
Re: gai_strerror() is not thread-safe on Windows Kyotaro Horiguchi 02:43
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 02:54
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 03:25
Re: Rename ShmemVariableCache and initialize it in more standard way Richard Guo 03:40
introduce dynamic shared memory registry 📎 Nathan Bossart 03:46
Re: Use PGAlignedBlock instead of "char buf[BLCKSZ]" in more places Michael Paquier 03:47
Re: CRC32C Parallel Computation Optimization on ARM Nathan Bossart 04:18
Re: table inheritance versus column compression and storage settings Ashutosh Bapat 04:26
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 05:01
Re: Synchronizing slots from primary to standby shveta malik 05:08
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 05:16
Re: SET ROLE documentation improvement Shubham Khanna 05:20
Re: [DOCS] HOT - correct claim about indexes not referencing old line pointers Shubham Khanna 05:22
Re: pg_upgrade and logical replication Michael Paquier 05:26
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 05:41
Re: Show WAL write and fsync stats in pg_stat_io Michael Paquier 06:16
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION 📎 Shlok Kyal 07:14
Re: btree: downlink right separator/HIKEY optimization Heikki Linnakangas 07:43
Re: Test 002_pg_upgrade fails with olddump on Windows Michael Paquier 07:56
Re: Avoid detoast overhead when possible Nikita Malakhov 08:38
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 08:48
Re: Avoid detoast overhead when possible zhihuifan1213 08:54
Re: Test 002_pg_upgrade fails with olddump on Windows Alexander Lakhin 09:00
Re: pg_upgrade and logical replication Amit Kapila 09:37
Re: [PoC] Federated Authn/z with OAUTHBEARER Daniel Gustafsson 09:43
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) Alena Rybakina 10:07
Re: Avoid detoast overhead when possible Nikita Malakhov 10:09
Re: Synchronizing slots from primary to standby shveta malik 10:29
Re: Add semi-join pushdown to postgres_fdw Alexander Pyhalov 10:29
Re: POC, WIP: OR-clause support for indexes 📎 Andrei Lepikhov 10:55
backtrace_on_internal_error Peter Eisentraut 10:55
UBSan pointer overflow in xlogreader.c 📎 Thomas Munro 11:03
Re: Synchronizing slots from primary to standby Amit Kapila 11:32
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Tomas Vondra 11:48
Re: logical decoding and replication of sequences, take 2 Amit Kapila 12:17
Re: Avoid detoast overhead when possible Andy Fan 12:24
Re: remaining sql/json patches 📎 Amit Langote 12:25
Make attstattarget nullable 📎 Peter Eisentraut 12:52
Re: table inheritance versus column compression and storage settings Peter Eisentraut 12:58
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 13:38
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 14:08
Re: Emitting JSON to file using COPY TO Andrew Dunstan 14:56
Re: Postgres Partitions Limitations (5.11.2.3) Ashutosh Bapat 14:57
Re: introduce dynamic shared memory registry Joe Conway 15:34
Re: Detecting some cases of missing backup_label Stephen Frost 15:54
Re: introduce dynamic shared memory registry Robert Haas 16:16
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } John Naylor 16:22
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 16:53
Re: Emitting JSON to file using COPY TO Joe Conway 16:54
Possible segfault when sending notification within a ProcessUtility hook 📎 Anthonin Bonnefoy 17:33
Add checks in pg_rewind to abort if backup_label file is present 📎 Krishnakumar R 17:36
Re: backtrace_on_internal_error Nathan Bossart 17:40
Re: Emitting JSON to file using COPY TO Davin Shearer 17:43
Re: UBSan pointer overflow in xlogreader.c Nathan Bossart 18:04
Re: trying again to get incremental backup 📎 Robert Haas 18:10
Re: backtrace_on_internal_error Robert Haas 18:16
Re: Make COPY format extendable: Extract COPY TO format implementations Nathan Bossart 18:24
Re: backtrace_on_internal_error Nathan Bossart 18:28
Re: backtrace_on_internal_error Robert Haas 18:30
Re: psql not responding to SIGINT upon db reconnection 📎 Tristan Partin 18:35
Remove WIN32 conditional compilation from win32common.c 📎 Tristan Partin 18:37
Re: backtrace_on_internal_error Matthias van de Meent 18:47
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 18:51
Re: collect_corrupt_items_vacuum.patch Dmitry Koval 19:03
Re: Emitting JSON to file using COPY TO Davin Shearer 19:50
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } 📎 Jeff Davis 19:58
Re: backtrace_on_internal_error Robert Haas 19:59
Re: Possible segfault when sending notification within a ProcessUtility hook Tom Lane 20:03
Re: backtrace_on_internal_error Nathan Bossart 20:06
Re: backtrace_on_internal_error Tom Lane 20:08
Re: Add checks in pg_rewind to abort if backup_label file is present Heikki Linnakangas 20:14
Re: UBSan pointer overflow in xlogreader.c Robert Haas 20:48
Re: Emitting JSON to file using COPY TO Andrew Dunstan 20:55
Re: UBSan pointer overflow in xlogreader.c Nathan Bossart 21:01
Re: Emitting JSON to file using COPY TO Joe Conway 21:02
Re: Emitting JSON to file using COPY TO Joe Conway 21:09
Re: Emitting JSON to file using COPY TO Andrew Dunstan 21:12
Re: Emitting JSON to file using COPY TO Joe Conway 21:15
Re: Emitting JSON to file using COPY TO Andrew Dunstan 21:20
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 21:33
Re: Emitting JSON to file using COPY TO Joe Conway 21:46
Re: [PATCH] plpython function causes server panic Tom Lane 21:56
Re: [PATCH] ltree hash functions 📎 Tommy Pavlicek 22:38
Re: Emitting JSON to file using COPY TO Davin Shearer 23:45
Built-in CTYPE provider 📎 Jeff Davis 23:46
Re: Faster "SET search_path" Jeff Davis 23:55

Dec. 6, 2023

Thread Author Time
Re: Change GUC hashtable to use simplehash? John Naylor 00:39
Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) 📎 Peter Geoghegan 00:41
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) Tom Lane 00:53

Browse Archives

Prev | Next