pgsql-hackers - December 2023

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Dec. 1, 2023

Thread Author Time
Re: Something seems weird inside tts_virtual_copyslot() Andres Freund 00:14
Re: PostgreSql: Canceled on conflict out to old pivot Andres Freund 00:31
Re: [PATCH] ltree hash functions 📎 Tommy Pavlicek 00:44
Re: Something seems weird inside tts_virtual_copyslot() 📎 David Rowley 01:30
Re: Refactoring backend fork+exec code Andres Freund 01:42
Re: Annoying build warnings from latest Apple toolchain Andres Freund 02:12
Re: Testing autovacuum wraparound (including failsafe) Masahiko Sawada 02:14
Re: Annoying build warnings from latest Apple toolchain Tom Lane 02:24
Re: Report planning memory in EXPLAIN ANALYZE Andrei Lepikhov 02:57
Re: Bug in pgbench prepared statements 📎 Lev Kokotov 03:15
Re: optimize atomic exchanges Nathan Bossart 03:18
Re: Synchronizing slots from primary to standby shveta malik 03:19
Re: optimize atomic exchanges Andres Freund 03:56
Re: Custom explain options Andrei Lepikhov 03:57
Re: [Proposal] global sequence implemented by snowflake ID Michael Paquier 04:02
Re: Annoying build warnings from latest Apple toolchain 📎 Andres Freund 04:05
Re: meson: Stop using deprecated way getting path of files Andres Freund 04:06
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 04:10
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer Nathan Bossart 04:20
Re: optimize atomic exchanges Nathan Bossart 04:35
Re: Synchronizing slots from primary to standby shveta malik 04:51
Sequence Access Methods, round two 📎 Michael Paquier 05:00
processes stuck in shutdown following OOM/recovery Justin Pryzby 05:13
Re: pg_upgrade and logical replication Peter Smith 05:26
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 05:47
Re: [Proposal] global sequence implemented by snowflake ID Amit Kapila 06:15
Materialized view in Postgres from the variables rather than SQL query results Nurul Karim Rafi 06:18
doc: improve document of ECPG host variable 📎 Ryo Matsumura (Fujitsu) 06:32
Re: Memory consumed by paths during partitionwise join planning Ashutosh Bapat 06:59
Re: Synchronizing slots from primary to standby shveta malik 07:17
Re: Bug in pgbench prepared statements Michael Paquier 07:18
Remove unnecessary includes of system headers in header files 📎 Peter Eisentraut 07:53
Re: [PoC] pg_upgrade: allow to upgrade publisher node Masahiko Sawada 08:20
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎 li jie 08:25
Re: Show WAL write and fsync stats in pg_stat_io Nazir Bilal Yavuz 08:30
Re: PostgreSql: Canceled on conflict out to old pivot Wirch, Eduard 08:55
Improving asan/ubsan support Alexander Lakhin 09:00
Re: Show WAL write and fsync stats in pg_stat_io 📎 Nazir Bilal Yavuz 09:02
Re: pg_upgrade and logical replication Amit Kapila 09:15
Re: Synchronizing slots from primary to standby 📎 shveta malik 09:33
Re: Is this a problem in GenericXLogFinish()? Amit Kapila 09:57
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 Richard Guo 10:07
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 10:13
Re: Synchronizing slots from primary to standby shveta malik 10:44
RE: Remove unnecessary includes of system headers in header files [email protected] 10:51
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 10:57
Re: Synchronizing slots from primary to standby Amit Kapila 11:06
RE: logical decoding and replication of sequences, take 2 📎 Hayato Kuroda (Fujitsu) 11:08
A wrong comment about search_indexed_tlist_for_var Richard Guo 11:12
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 11:15
Re: Fix a wrong comment in setrefs.c Richard Guo 11:17
Re: pgsql: Clean up role created in new subscription test. 📎 Daniel Gustafsson 11:22
Re: pgsql: Clean up role created in new subscription test. Heikki Linnakangas 11:37
Re: pgsql: Clean up role created in new subscription test. Daniel Gustafsson 11:46
Re: Refactoring backend fork+exec code 📎 Heikki Linnakangas 12:10
Re: Synchronizing slots from primary to standby Nisha Moond 12:10
Re: pgsql: Clean up role created in new subscription test. Alvaro Herrera 12:19
Re: A wrong comment about search_indexed_tlist_for_var Alvaro Herrera 12:25
Re: pgsql: Clean up role created in new subscription test. 📎 Daniel Gustafsson 12:52
Re: Postgres Partitions Limitations (5.11.2.3) Ashutosh Bapat 13:19
Re: Materialized view in Postgres from the variables rather than SQL query results David G. Johnston 13:40
Re: Refactoring backend fork+exec code Alexander Lakhin 14:00
Re: Various small doc improvements; plpgsql, schemas, permissions, oidvector Karl O. Pinc 14:00
Re: pgsql: meson: docs: Add {html,man} targets, rename install-doc-* Andrew Dunstan 14:04
Re: EXCLUDE COLLATE in CREATE/ALTER TABLE document 📎 Daniel Verite 14:59
Re: Materialized view in Postgres from the variables rather than SQL query results Nurul Karim Rafi 15:15
Re: Synchronizing slots from primary to standby Nisha Moond 16:00
Re: meson: Stop using deprecated way getting path of files Tristan Partin 16:18
Re: Refactoring backend fork+exec code Tristan Partin 16:31
Re: Remove unnecessary includes of system headers in header files Tom Lane 16:41
Building PosgresSQL with LLVM fails on Solaris 11.4 Sacha Hottinger 17:02
Re: pgsql: meson: docs: Add {html,man} targets, rename install-doc-* Andres Freund 17:12
Re: pg_upgrade and logical replication 📎 vignesh C 17:54
Re: meson: Stop using deprecated way getting path of files Tom Lane 18:07
Re: meson: Stop using deprecated way getting path of files Tristan Partin 18:16
Re: A wrong comment about search_indexed_tlist_for_var Tom Lane 18:27
Re: pgsql: meson: docs: Add {html,man} targets, rename install-doc-* Andrew Dunstan 19:06
Re: Fix bogus Asserts in calc_non_nestloop_required_outer shihao zhong 19:18
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 19:28
Re: Building PosgresSQL with LLVM fails on Solaris 11.4 📎 Andres Freund 19:49
Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list" Tom Lane 19:57
Re: Refactoring backend fork+exec code Heikki Linnakangas 20:44
Re: encoding affects ICU regex character classification 📎 Jeff Davis 20:49
Re: Refactoring backend fork+exec code Tristan Partin 21:11
Re: Improving asan/ubsan support Tristan Partin 21:48
Re: [PATCH] pg_convert improvement Nathan Bossart 21:50
Re: pgsql: meson: docs: Add {html,man} targets, rename install-doc-* Tristan Partin 21:55
Re: [RFC] Clang plugin for catching suspicious typedef casting Tristan Partin 22:01
Re: Clean up some signal usage mainly related to Windows Tristan Partin 22:10
Re: pgsql: meson: docs: Add {html,man} targets, rename install-doc-* Andres Freund 22:12
AW: Building PosgresSQL with LLVM fails on Solaris 11.4 📎 Sacha Hottinger 23:06
Re: Emitting JSON to file using COPY TO Nathan Bossart 23:09
Re: Refactoring backend fork+exec code Tom Lane 23:55

Dec. 2, 2023

Thread Author Time
Re: [Proposal] global sequence implemented by snowflake ID Tomas Vondra 00:00
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 00:10
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 00:23
Re: [PATCH] plpython function causes server panic 📎 Tom Lane 01:04
Re: processes stuck in shutdown following OOM/recovery Thomas Munro 01:18
Re: [PATCH] plpython function causes server panic Andres Freund 01:30
Re: [PATCH] plpython function causes server panic Tom Lane 01:46
Re: [PATCH] plpython function causes server panic Tom Lane 01:51
Re: processes stuck in shutdown following OOM/recovery Thomas Munro 02:30
Re: Refactoring backend fork+exec code Alexander Lakhin 03:00
Re: Emitting JSON to file using COPY TO Davin Shearer 03:00
Re: Bug in pgbench prepared statements 📎 Lev Kokotov 03:06
Re: Emitting JSON to file using COPY TO Joe Conway 03:10
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Amit Kapila 04:11
Re: Synchronizing slots from primary to standby Amit Kapila 04:19
Re: Improving asan/ubsan support Alexander Lakhin 06:00
Re: User functions for building SCRAM secrets John Naylor 06:51
Commitfest 2023-11 is almost over John Naylor 07:23
Re: Change GUC hashtable to use simplehash? John Naylor 08:35
Re: Remove unnecessary includes of system headers in header files Peter Eisentraut 08:39
Is WAL_DEBUG related code still relevant today? Bharath Rupireddy 14:06
Re: Emitting JSON to file using COPY TO Joe Conway 14:31
Re: Emitting JSON to file using COPY TO Tom Lane 15:11
Re: about help message for new pg_dump's --filter option Alvaro Herrera 16:02
Re: undetected deadlock in ALTER SUBSCRIPTION ... REFRESH PUBLICATION 📎 Shlok Kyal 16:22
Re: SQL:2011 application time 📎 Paul Jungwirth 18:11
Re: SQL:2011 application time Paul Jungwirth 18:41
Re: Emitting JSON to file using COPY TO Maciek Sakrejda 18:50
Proposal: In-flight explain logging 📎 Rafael Thofehrn Castro 19:30
Re: Proposal: In-flight explain logging Maciek Sakrejda 20:20
Proposal obfuscate password in pg logs Guanqun Yang 20:36
Re: Proposal: In-flight explain logging Rafael Thofehrn Castro 20:56
Re: Proposal obfuscate password in pg logs Tom Lane 21:04
Re: Emitting JSON to file using COPY TO Nathan Bossart 21:53
Re: about help message for new pg_dump's --filter option Daniel Gustafsson 22:01
Re: Is WAL_DEBUG related code still relevant today? Nathan Bossart 22:30
Re: Emitting JSON to file using COPY TO Joe Conway 22:37
Re: Emitting JSON to file using COPY TO Joe Conway 22:43
Re: Is WAL_DEBUG related code still relevant today? Tom Lane 22:46
Re: postgres_fdw test timeouts Thomas Munro 23:48

Dec. 3, 2023

Thread Author Time
Re: Patch: Improve Boolean Predicate JSON Path Docs shihao zhong 01:17
Re: postgres_fdw test timeouts Alexander Lakhin 05:00
Re: Schema variables - new implementation for Postgres 15 Pavel Stehule 05:04
Re: postgres_fdw test timeouts Thomas Munro 06:00
Re: SQL:2011 application time Vik Fearing 10:13
RE: logical decoding and replication of sequences, take 2 📎 Hayato Kuroda (Fujitsu) 12:55
答复: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list" 📎 Haotian Chen 13:38
Re: Emitting JSON to file using COPY TO Andrew Dunstan 13:46
Re: Schema variables - new implementation for Postgres 15 Dmitry Dolgov 14:14
Re: [RFC] Clang plugin for catching suspicious typedef casting Dmitry Dolgov 14:27
Re: Refactoring backend fork+exec code Heikki Linnakangas 14:41
Re: Emitting JSON to file using COPY TO 📎 Joe Conway 14:53
Re: Is WAL_DEBUG related code still relevant today? 📎 Bharath Rupireddy 14:53
Re: Is WAL_DEBUG related code still relevant today? Bharath Rupireddy 15:00
Re: Emitting JSON to file using COPY TO Andrew Dunstan 15:10
Make PostgreSQL work with newer libxml2. 📎 Xing Guo 15:17
Re: Emitting JSON to file using COPY TO Davin Shearer 15:31
Re: Emitting JSON to file using COPY TO Joe Conway 15:51
Re: Emitting JSON to file using COPY TO Joe Conway 16:03
Re: More new SQL/JSON item methods Andrew Dunstan 16:14
Re: Parallel CREATE INDEX for BRIN indexes 📎 Tomas Vondra 16:46
Re: Emitting JSON to file using COPY TO Joe Conway 17:11
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 17:52
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 18:26
Re: Is WAL_DEBUG related code still relevant today? Noah Misch 19:07
Re: Emitting JSON to file using COPY TO Joe Conway 19:24
Re: Emitting JSON to file using COPY TO Andrew Dunstan 19:47
Re: Emitting JSON to file using COPY TO Andrew Dunstan 19:52
Re: Emitting JSON to file using COPY TO Joe Conway 20:09
Re: Add semi-join pushdown to postgres_fdw 📎 Alexander Korotkov 20:52
Re: Change GUC hashtable to use simplehash? Jeff Davis 21:16
Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list" David Rowley 22:08
Re: Emitting JSON to file using COPY TO Davin Shearer 22:38

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31