pgsql-hackers since 2023-12-08 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. 8, 2023

Thread Author Time
Re: Improve WALRead() to suck data directly from WAL buffers when possible Jeff Davis 00:34
Re: micro-optimizing json.c Tom Lane 00:40
Re: [HACKERS] pg_upgrade vs vacuum_cost_delay Bruce Momjian 01:06
Re: Row pattern recognition 📎 Tatsuo Ishii 01:16
Re: Test 002_pg_upgrade fails with olddump on Windows Michael Paquier 01:55
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 01:56
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 02:24
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Junwang Zhao 02:32
Re: [HACKERS] psql casts aspersions on server reliability Bruce Momjian 02:59
Re: Synchronizing slots from primary to standby shveta malik 03:03
Re: micro-optimizing json.c David Rowley 03:11
Re: UBSan pointer overflow in xlogreader.c Thomas Munro 03:17
Re: micro-optimizing json.c Tom Lane 03:19
Re: micro-optimizing json.c 📎 Nathan Bossart 03:20
Re: micro-optimizing json.c Tom Lane 03:28
Re: micro-optimizing json.c Nathan Bossart 03:32
Re: micro-optimizing json.c 📎 Nathan Bossart 04:02
Re: GUC names in messages 📎 Peter Smith 04:10
Re: micro-optimizing json.c Tom Lane 04:10
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 04:37
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Andrei Lepikhov 04:37
Re: Is WAL_DEBUG related code still relevant today? Michael Paquier 04:45
Re: micro-optimizing json.c John Naylor 04:51
Re: Memory consumed by paths during partitionwise join planning Ashutosh Bapat 05:02
Re: [PATCH] New [relation] option engine 📎 Yura Sokolov 05:10
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 05:17
Re: Remove MSVC scripts from the tree Michael Paquier 05:23
Re: [PATCH] New [relation] option engine Michael Paquier 05:59
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 06:42
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 06:45
Re: Sequence Access Methods, round two 📎 Michael Paquier 06:53
Re: remaining sql/json patches Amit Langote 06:59
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 07:02
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) Alena Rybakina 07:09
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Alexander Pyhalov 07:13
Re: Extending SMgrRelation lifetimes Heikki Linnakangas 07:20
Re: Memory consumed by paths during partitionwise join planning David Rowley 07:31
Re: introduce dynamic shared memory registry Michael Paquier 07:36
Re: Rename ShmemVariableCache and initialize it in more standard way Heikki Linnakangas 07:51
Re: Transaction timeout Japin Li 07:59
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 08:05
Re: Synchronizing slots from primary to standby Amit Kapila 09:06
Re: [HACKERS] make async slave to wait for lsn to be replayed Kartyshov Ivan 09:20
Re: Proposal to add page headers to SLRU pages 📎 Li, Yong 09:35
Re: Oversight in reparameterize_path_by_child leading to executor crash Alena Rybakina 09:38
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎 Kartyshov Ivan 09:46
Re: trying again to get incremental backup Jakub Wartak 10:02
Re: Transaction timeout 📎 Andrey M. Borodin 10:08
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov 10:27
Re: Transaction timeout Japin Li 10:29
Re: remaining sql/json patches 📎 Amit Langote 10:34
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov 10:39
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 10:46
Re: Test 002_pg_upgrade fails with olddump on Windows Alvaro Herrera 10:51
Re: Adding a pg_get_owned_sequence function? Shubham Khanna 11:06
Re: [PATCH] minor reloption regression tests improvement Alvaro Herrera 11:19
Add code indentation check to cirrus-ci (was Re: Add BF member koel-like indentation checks to SanityCheck CI) 📎 Bharath Rupireddy 11:39
Remove some unnecessary includes of "access/xlog_internal.h" 📎 Peter Eisentraut 11:44
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION 📎 Amit Kapila 11:45
Assistance Needed: PostgreSQL Migration Errors 13.2 to 15 Charan K 12:04
RE: Synchronizing slots from primary to standby 📎 Zhijie Hou (Fujitsu) 12:05
Re: Refactoring backend fork+exec code 📎 Heikki Linnakangas 12:33
Re: Remove some unnecessary includes of "access/xlog_internal.h" Heikki Linnakangas 12:36
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 12:44
Re: [PATCH] New [relation] option engine Nikolay Shaplov 12:49
Re: GUC names in messages 📎 Alvaro Herrera 12:55
Re: [PATCH] New [relation] option engine Alvaro Herrera 12:59
Re: initdb caching during tests Daniel Gustafsson 12:59
Re: [PATCH] New [relation] option engine Nikolay Shaplov 13:04
Re: backtrace_on_internal_error 📎 Peter Eisentraut 13:21
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Ashutosh Bapat 13:27
Re: Forbid the use of invalidated physical slots in streaming replication. Ashutosh Bapat 13:44
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Shlok Kyal 13:46
Re: Emitting JSON to file using COPY TO Dave Cramer 14:01
Re: Memory consumed by paths during partitionwise join planning Ashutosh Bapat 14:06
Re: GUC names in messages Peter Eisentraut 14:48
Re: backtrace_on_internal_error Tom Lane 15:05
Re: UBSan pointer overflow in xlogreader.c Robert Haas 16:29
Re: remaining sql/json patches Robert Haas 16:37
Re: remaining sql/json patches Andrew Dunstan 17:05
Re: Parallel CREATE INDEX for BRIN indexes 📎 Tomas Vondra 17:28
Re: remaining sql/json patches Andres Freund 17:30
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Alexander Korotkov 17:54
Re: backtrace_on_internal_error Andres Freund 18:14
Re: backtrace_on_internal_error Tom Lane 18:23
Re: Streaming I/O, vectored I/O (WIP) Andres Freund 18:25
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) Alexander Korotkov 18:30
Re: backtrace_on_internal_error Andres Freund 18:34
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) 📎 Alexander Korotkov 18:46
Re: backtrace_on_internal_error Tom Lane 18:46
Re: backtrace_on_internal_error Andres Freund 18:51
Re: backtrace_on_internal_error Andres Freund 19:33
Re: Emitting JSON to file using COPY TO Daniel Verite 19:45
Re: micro-optimizing json.c Nathan Bossart 19:45
Re: Change GUC hashtable to use simplehash? Jeff Davis 20:32
Re: Change GUC hashtable to use simplehash? Jeff Davis 20:34
Re: Emitting JSON to file using COPY TO Daniel Verite 20:35
Re: micro-optimizing json.c 📎 Nathan Bossart 20:37
Re: Emitting JSON to file using COPY TO Joe Conway 21:26
Re: backtrace_on_internal_error 📎 Andres Freund 22:15
Re: Row pattern recognition 📎 Tatsuo Ishii 22:22
Re: backtrace_on_internal_error 📎 Tom Lane 22:29
Re: backtrace_on_internal_error Tom Lane 22:35
Re: micro-optimizing json.c Tom Lane 22:56
Re: backtrace_on_internal_error Andres Freund 23:36
Re: backtrace_on_internal_error Andres Freund 23:40

Dec. 9, 2023

Thread Author Time
Re: backtrace_on_internal_error Tom Lane 00:39
Re: Streaming I/O, vectored I/O (WIP) Thomas Munro 00:41
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) Peter Geoghegan 02:29
RE: Make COPY format extendable: Extract COPY TO format implementations Hayato Kuroda (Fujitsu) 02:43
How abnormal server shutdown could be detected by tests? Alexander Lakhin 04:00
Re: Eager page freeze criteria clarification 📎 Melanie Plageman 04:11
Re: remaining sql/json patches jian he 05:05
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Amit Kapila 06:46
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 08:39
Re: Streaming I/O, vectored I/O (WIP) Heikki Linnakangas 09:23
Why are wal_keep_size, max_slot_wal_keep_size requiring server restart? Hannu Krosing 11:32
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Hannu Krosing 11:38
Re: Change GUC hashtable to use simplehash? 📎 John Naylor 11:52
Re: Emitting JSON to file using COPY TO Hannu Krosing 11:56
Postgres db Update to Version 15 Ritthaler, Axel 12:26
Re: Why are wal_keep_size, max_slot_wal_keep_size requiring server restart? Alvaro Herrera 12:31
Re: Eager page freeze criteria clarification Joe Conway 14:24
Re: Assistance Needed: PostgreSQL Migration Errors 13.2 to 15 Tom Lane 16:00
Re: backtrace_on_internal_error Andres Freund 17:10
Re: backtrace_on_internal_error 📎 Tom Lane 17:41
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 17:59
Re: index prefetching 📎 Tomas Vondra 18:08
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 📎 Peter Geoghegan 18:38
Re: Change GUC hashtable to use simplehash? 📎 Jeff Davis 19:18
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 20:44
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 20:54
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 21:01
Re: backtrace_on_internal_error Andres Freund 21:06
Re: encoding affects ICU regex character classification Thomas Munro 21:39
Recording whether Heap2/PRUNE records are from VACUUM or from opportunistic pruning (Was: Show various offset arrays for heap WAL records) 📎 Peter Geoghegan 21:48
Re: backtrace_on_internal_error 📎 Tom Lane 23:14

Dec. 10, 2023

Thread Author Time
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 00:24
Re: Change GUC hashtable to use simplehash? 📎 John Naylor 06:26
Re: postgres_fdw test timeouts Alexander Lakhin 09:00
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 jian he 10:32
Re: Synchronizing slots from primary to standby Amit Kapila 11:03
Re: Change GUC hashtable to use simplehash? 📎 John Naylor 14:57
Re: GUC names in messages Peter Smith 23:07
Re: GUC names in messages Peter Smith 23:14

Dec. 11, 2023

Thread Author Time
Re: Synchronizing slots from primary to standby Peter Smith 00:16
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 00:36
unconstify()/unvolatize() vs g++/clang++ Thomas Munro 00:42
Some useless includes in llvmjit_inline.cpp 📎 Thomas Munro 00:57
Re: pg_upgrade failing for 200+ million Large Objects 📎 Tom Lane 01:42
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 01:57
RE: Synchronizing slots from primary to standby 📎 Zhijie Hou (Fujitsu) 02:19
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Richard Guo 02:31
Re: Postgres db Update to Version 15 David Rowley 02:32
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Andrei Lepikhov 02:40
Re: Oversight in reparameterize_path_by_child leading to executor crash Richard Guo 03:02
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock 📎 Dilip Kumar 05:11
Re: Adding facility for injection points (or probe points?) for more advanced tests Dilip Kumar 05:39
Re: RFC: Logging plan of the running query torikoshia 05:46
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Amit Kapila 06:12
Re: trying again to get incremental backup Dilip Kumar 06:14
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 Masahiko Sawada 06:17
Re: Synchronizing slots from primary to standby Peter Smith 07:32
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 07:52
Re: trying again to get incremental backup Dilip Kumar 07:52
Re: Synchronizing slots from primary to standby Dilip Kumar 08:17
Re: SQL:2011 application time jian he 08:31
Re: Synchronizing slots from primary to standby Amit Kapila 08:35
Re: Report planning memory in EXPLAIN ANALYZE jian he 08:36
Re: [Proposal] Add foreign-server health checks infrastructure Shubham Khanna 08:41
Re: Synchronizing slots from primary to standby shveta malik 08:50
Re: Synchronizing slots from primary to standby 📎 shveta malik 09:02
Re: Synchronizing slots from primary to standby shveta malik 09:11
Re: Streaming I/O, vectored I/O (WIP) 📎 Thomas Munro 09:12
Re: unconstify()/unvolatize() vs g++/clang++ Peter Eisentraut 09:17
Re: Streaming I/O, vectored I/O (WIP) Heikki Linnakangas 09:27
Re: backtrace_on_internal_error Peter Eisentraut 09:29
Re: Synchronizing slots from primary to standby shveta malik 09:30
Re: Streaming I/O, vectored I/O (WIP) Thomas Munro 09:37
Re: Adding facility for injection points (or probe points?) for more advanced tests Michael Paquier 09:44
Re: GUC names in messages Michael Paquier 10:00
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 10:19
Re: unconstify()/unvolatize() vs g++/clang++ 📎 Thomas Munro 10:32
Re: Make COPY format extendable: Extract COPY TO format implementations Junwang Zhao 10:44
Re: Is WAL_DEBUG related code still relevant today? Michael Paquier 10:52
Re: Synchronizing slots from primary to standby Dilip Kumar 11:17
Re: Synchronizing slots from primary to standby shveta malik 11:43
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression 📎 Amul Sul 12:22
Re: Memory consumption during partitionwise join planning Ashutosh Bapat 13:13
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)' Ashutosh Bapat 13:25
Re: Report planning memory in EXPLAIN ANALYZE Ashutosh Bapat 13:35
Re: Synchronizing slots from primary to standby Amit Kapila 13:42
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎 Alena Rybakina 14:05
Re: [CAUTION!! freemail] Re: Partial aggregates pushdown Robert Haas 14:24
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Masahiko Sawada 14:31
Re: brininsert optimization opportunity Alexander Lakhin 15:00
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION Tomas Vondra 15:36
Re: brininsert optimization opportunity Tomas Vondra 15:41
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) Alexander Korotkov 15:56
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) Peter Geoghegan 16:16

Browse Archives

Prev | Next