pgsql-hackers - January 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)

Browse Archives

Prev | Next

Jan. 1, 2023

Thread Author Time
Re: Add SHELL_EXIT_CODE to psql Corey Huinker 00:15
Fixing a couple of buglets in how VACUUM sets visibility map bits 📎 Peter Geoghegan 00:53
Re: Announcing Release 15 of the PostgreSQL Buildfarm client Noah Misch 01:55
Re: Infinite Interval Vik Fearing 02:05
+infinity for dates and timestamps 📎 Vik Fearing 02:10
Re: Announcing Release 15 of the PostgreSQL Buildfarm client Andrew Dunstan 02:11
Re: +infinity for dates and timestamps 📎 Vik Fearing 02:31
Re: +infinity for dates and timestamps Tom Lane 05:24
Re: Add a test to ldapbindpasswd Andrew Dunstan 14:04
Re: Add a test to ldapbindpasswd Thomas Munro 19:02
Re: +infinity for dates and timestamps Tom Lane 19:21
Re: +infinity for dates and timestamps Vik Fearing 19:22
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? Thomas Munro 19:38
Re: Add a test to ldapbindpasswd Andrew Dunstan 19:58
Re: postgres_fdw: using TABLESAMPLE to collect remote sample Tomas Vondra 22:36
Re: Add a test to ldapbindpasswd 📎 Andrew Dunstan 23:31
Re: Announcing Release 15 of the PostgreSQL Buildfarm client Andrew Dunstan 23:34

Jan. 2, 2023

Thread Author Time
enable_timeout_every() and fin_time Andres Freund 00:36
Re: Add index scan progress to pg_stat_progress_vacuum 📎 Imseih (AWS), Sami 04:34
Re: mprove tab completion for ALTER EXTENSION ADD/DROP 📎 vignesh C 07:49
Re: Support logical replication of DDLs vignesh C 08:06
Re: [DOCS] Stats views and functions not in order? Peter Eisentraut 08:17
Re: Allow placeholders in ALTER ROLE w/o superuser 📎 Pavel Borisov 08:53
Re: heapgettup refactoring Peter Eisentraut 10:22
Re: Perform streaming logical transactions by background workers and parallel apply 📎 Amit Kapila 10:53
Sampling-based timing for EXPLAIN ANALYZE 📎 Lukas Fittl 11:36
Re: Add BufFileRead variants with short read and EOF detection Amit Kapila 12:13
Bug in check for unreachable MERGE WHEN clauses 📎 Dean Rasheed 12:13
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Amit Kapila 12:49
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎 David Geier 13:28
Re: Add a test to ldapbindpasswd 📎 Andrew Dunstan 14:45
Re: Allow placeholders in ALTER ROLE w/o superuser Alexander Korotkov 15:14
verbose mode for pg_input_error_message? Andrew Dunstan 15:30
Re: Allow placeholders in ALTER ROLE w/o superuser Justin Pryzby 15:42
Re: verbose mode for pg_input_error_message? Tom Lane 15:44
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Tom Lane 15:57
Re: [RFC] Add jit deform_counter 📎 Dmitry Dolgov 16:55
Is OpenSSL AES-NI not available in pgcrypto? [email protected] 16:57
Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row Tom Lane 18:05
Re: Infinite Interval Joseph Koshakow 18:21
Re: MERGE ... WHEN NOT MATCHED BY SOURCE 📎 Dean Rasheed 18:24
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits 📎 Peter Geoghegan 18:31
Re: Infinite Interval 📎 Joseph Koshakow 18:53
Why is char an internal-use category Dave Cramer 19:09
Re: Why is char an internal-use category Tom Lane 19:44
Re: New strategies for freezing, advancing relfrozenxid early 📎 Peter Geoghegan 19:45
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl 19:50
Re: daitch_mokotoff module Dag Lem 20:43
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Maciek Sakrejda 20:44
Re: doc: add missing "id" attributes to extension packaging page 📎 Karl O. Pinc 20:53
Re: daitch_mokotoff module 📎 Dag Lem 21:00
Re: An oversight in ExecInitAgg for grouping sets Tom Lane 21:25
TAP tests for psql \g piped into program 📎 Daniel Verite 21:32
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎 Melanie Plageman 22:46
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Andres Freund 23:46

Jan. 3, 2023

Thread Author Time
Doc: Rework contrib appendix -- informative titles, tweaked sentences 📎 Karl O. Pinc 00:00
Re: Infinite Interval 📎 Joseph Koshakow 00:44
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎 Melanie Plageman 01:15
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Andres Freund 01:21
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable() Michael Paquier 02:17
Re: CFM for 2023-01 Michael Paquier 02:22
Re: [PATCH] random_normal function Michael Paquier 02:24
Re: New strategies for freezing, advancing relfrozenxid early Jeff Davis 02:26
Re: [PATCH] random_normal function Tom Lane 02:38
Re: CFM for 2023-01 vignesh C 02:46
Re: Todo: Teach planner to evaluate multiple windows in the optimal order David Rowley 02:51
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG David Rowley 03:08
RADIUS tests and improvements 📎 Thomas Munro 03:11
Re: wake up logical workers after ALTER SUBSCRIPTION Amit Kapila 05:33
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 05:40
Re: Add a test to ldapbindpasswd Julien Rouhaud 05:48
Re: wake up logical workers after ALTER SUBSCRIPTION Amit Kapila 06:13
Re: Allow placeholders in ALTER ROLE w/o superuser 📎 Alexander Korotkov 06:29
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG Ankit Kumar Pandey 06:59
Re: Time delayed LR (WAS Re: logical replication restrictions) vignesh C 07:01
Re: Todo: Teach planner to evaluate multiple windows in the optimal order Ankit Kumar Pandey 07:09
Re: typos Michael Paquier 07:28
Re: typos Amit Kapila 07:33
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 07:41
[Commitfest 2023-01] has started vignesh C 07:43
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎 David Geier 08:38
Re: typos Michael Paquier 08:41
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Michail Nikolaev 08:43
Re: Allow placeholders in ALTER ROLE w/o superuser Pavel Borisov 08:50
Re: Perform streaming logical transactions by background workers and parallel apply 📎 shveta malik 09:09
Re: An oversight in ExecInitAgg for grouping sets Richard Guo 09:20
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable() Bharath Rupireddy 09:23
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable() Bharath Rupireddy 09:52
128-bit integers can range only up to (2 ^ 63 -1) jian he 10:27
Re: TAP output format in pg_regress vignesh C 10:31
Re: Add BufFileRead variants with short read and EOF detection vignesh C 10:33
Re: Add SHELL_EXIT_CODE to psql vignesh C 10:36
Re: [Proposal] Add foreign-server health checks infrastructure vignesh C 10:37
Re: Add last_vacuum_index_scans in pg_stat_all_tables vignesh C 10:40
Re: Allow placeholders in ALTER ROLE w/o superuser Alexander Korotkov 10:48
Re: Add index scan progress to pg_stat_progress_vacuum vignesh C 10:49
Re: Add the ability to limit the amount of memory that can be allocated to backends. vignesh C 10:52
Re: Add tracking of backend memory allocated to pg_stat_activity vignesh C 10:55
Re: Question about initial logical decoding snapshot Amit Kapila 11:14
Re: Question about initial logical decoding snapshot Amit Kapila 11:19
Re: Allow placeholders in ALTER ROLE w/o superuser Pavel Borisov 11:20
Re: Time delayed LR (WAS Re: logical replication restrictions) shveta malik 11:22
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Amit Kapila 12:00
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions vignesh C 12:10
Re: [PATCH] CF app: add "Returned: Needs more interest" vignesh C 12:13
Re: CI and test improvements vignesh C 12:16
Re: Cygwin cleanup vignesh C 12:24
Re: [PATCH] Expand character set for ltree labels vignesh C 12:27
Re: [PATCH]Feature improvement for MERGE tab completion vignesh C 12:30
Re: MultiXact\SLRU buffers configuration vignesh C 13:01
Re: SLRUs in the main buffer pool - Page Header definitions vignesh C 13:05
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable) vignesh C 13:06
Re: [PATCH] New [relation] option engine vignesh C 13:08
Re: Optimizing Node Files Support vignesh C 13:10
Re: WIN32 pg_import_system_collations Peter Eisentraut 13:48
Re: Todo: Teach planner to evaluate multiple windows in the optimal order Ankit Kumar Pandey 14:11
Re: Split index and table statistics into different types of stats 📎 Drouvot, Bertrand 14:19
Re: Cygwin cleanup Justin Pryzby 14:25
Re: Allow placeholders in ALTER ROLE w/o superuser Justin Pryzby 14:28
Re: Allow placeholders in ALTER ROLE w/o superuser 📎 Pavel Borisov 14:40
Re: Allow placeholders in ALTER ROLE w/o superuser 📎 Alexander Korotkov 14:41
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 14:53
Re: 128-bit integers can range only up to (2 ^ 63 -1) Tom Lane 15:20
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Michail Nikolaev 15:20
Re: Stack overflow issue Егор Чиндяскин 15:40
Re: Stack overflow issue Sascha Kuhl 15:45
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Tom Lane 15:48
Re: Is OpenSSL AES-NI not available in pgcrypto? Peter Eisentraut 15:54
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Tom Lane 16:02
Re: Is OpenSSL AES-NI not available in pgcrypto? [email protected] 16:07
Re: 128-bit integers can range only up to (2 ^ 63 -1) jian he 16:12
Re: typos Peter Eisentraut 16:16
Re: 128-bit integers can range only up to (2 ^ 63 -1) Tom Lane 16:17
Re: [PATCH] CF app: add "Returned: Needs more interest" Jacob Champion 16:30
Re: [PATCH] random_normal function Tom Lane 16:41
Re: Add index scan progress to pg_stat_progress_vacuum 📎 Imseih (AWS), Sami 16:46
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Andrew Dunstan 17:08
Re: recovery modules 📎 Nathan Bossart 17:59
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Corey Huinker 18:02
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 18:10
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Tom Lane 18:14
Re: Error-safe user functions Robert Haas 18:16
Re: wake up logical workers after ALTER SUBSCRIPTION Nathan Bossart 18:21
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Vik Fearing 18:32
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable() Nathan Bossart 18:33
Re: enable_timeout_every() and fin_time Robert Haas 18:33
Re: [PATCH] Expand character set for ltree labels 📎 Garen Torikian 18:56
Re: recovery modules 📎 Nathan Bossart 19:05
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable) Tom Lane 19:13
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Tom Lane 19:15
pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 19:23
Re: allowing for control over SET ROLE Robert Haas 19:43
Re: [PATCH] pg_dump: lock tables in batches Gilles Darold 19:46
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier 📎 Andres Freund 20:05
Re: fixing CREATEROLE 📎 Robert Haas 20:11
Re: enable_timeout_every() and fin_time Andres Freund 20:14
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Robert Haas 20:19
Re: New strategies for freezing, advancing relfrozenxid early 📎 Peter Geoghegan 20:30
Why are we using blocking libpq in the backend? Andres Freund 20:30
Re: enable_timeout_every() and fin_time Robert Haas 20:30
Re: doc: add missing "id" attributes to extension packaging page Brar Piening 20:35
Re: heapgettup refactoring 📎 Melanie Plageman 20:39
Re: RADIUS tests and improvements Andreas Karlsson 21:03
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert 📎 Jacob Champion 21:06
Re: RADIUS tests and improvements Andreas Karlsson 21:07
Re: RADIUS tests and improvements Thomas Munro 21:16
Re: RADIUS tests and improvements Thomas Munro 21:18
Re: RADIUS tests and improvements Andreas Karlsson 21:21
Re: typos Justin Pryzby 21:39
Re: allowing for control over SET ROLE Noah Misch 22:03
Re: doc: add missing "id" attributes to extension packaging page Karl O. Pinc 22:43
Re: [PATCH] pg_dump: lock tables in batches Tom Lane 23:00
Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX Nathan Bossart 23:45

Jan. 4, 2023

Thread Author Time
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable) Tom Lane 00:15
Re: Common function for percent placeholder replacement Nathan Bossart 00:37
Re: pgsql: Delay commit status checks until freezing executes. Andres Freund 00:54
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG David Rowley 00:57
Re: pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 01:15
Re: pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 01:54
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG Vladimir Churyukin 03:15
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG David Rowley 03:41
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? 📎 Thomas Munro 03:46
Re: pgsql: Delay commit status checks until freezing executes. Andres Freund 03:56
Re: Todo: Teach planner to evaluate multiple windows in the optimal order David Rowley 04:02
Re: wake up logical workers after ALTER SUBSCRIPTION Amit Kapila 04:11
Re: pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 04:29
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG Vladimir Churyukin 04:39
Re: [PATCH] CF app: add "Returned: Needs more interest" vignesh C 04:56
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG David Rowley 05:06
Re: wake up logical workers after ALTER SUBSCRIPTION Amit Kapila 05:27
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 05:31
Re: pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 05:50
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG Tom Lane 05:55
Re: Question regarding "Make archiver process an auxiliary process. commit" Sravan Kumar 06:05
Re: pgsql: Delay commit status checks until freezing executes. Andres Freund 06:33
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 06:39
Re: pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 06:41
Fix showing XID of a spectoken lock in an incorrect field of pg_locks view. 📎 Masahiko Sawada 06:45
Re: pgsql: Delay commit status checks until freezing executes. Andres Freund 06:47
Re: pgsql: Delay commit status checks until freezing executes. Peter Geoghegan 06:52

Browse Archives

Prev | Next