pgsql-hackers - April 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

April 1, 2023

Thread Author Time
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode 📎 David Rowley 00:05
Re: zstd compression for pg_dump Tomas Vondra 00:11
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode Justin Pryzby 00:13
Add "host" to startup packet 📎 Lev Kokotov 00:23
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode Melanie Plageman 00:24
Re: zstd compression for pg_dump Justin Pryzby 00:28
WL_SOCKET_ACCEPT fairness on Windows 📎 Thomas Munro 00:42
RE: Non-superuser subscription owners [email protected] 01:24
Re: WL_SOCKET_ACCEPT fairness on Windows Andres Freund 01:35
Re: WL_SOCKET_ACCEPT fairness on Windows 📎 Thomas Munro 03:00
Re: regression coverage gaps for gist and hash indexes Drouvot, Bertrand 04:02
Re: Minimal logical decoding on standbys Amit Kapila 04:50
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 05:21
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() Andres Freund 05:21
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() Pavel Borisov 07:24
Re: zstd compression for pg_dump Tomas Vondra 12:49
Re: is_superuser is not documented Joseph Koshakow 13:34
Re: zstd compression for pg_dump Justin Pryzby 13:36
Re: BUG #17877: Referencing a system column in a foreign key leads to incorrect memory access Ranier Vilela 13:56
Re: Non-superuser subscription owners Alexander Lakhin 16:00
Re: Infinite Interval 📎 Joseph Koshakow 17:23
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode Melanie Plageman 17:29
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode Justin Pryzby 17:57
Re: zstd compression for pg_dump Tomas Vondra 20:26
Re: Non-superuser subscription owners Andres Freund 23:07

April 2, 2023

Thread Author Time
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎 Alexander Korotkov 00:37
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() Andres Freund 00:47
Re: Minimal logical decoding on standbys Andres Freund 03:42
Re: Minimal logical decoding on standbys Drouvot, Bertrand 08:11
Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() 📎 Drouvot, Bertrand 08:23
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 08:27
Support logical replication of DDLs Phil Florent 09:55
Re: Add "host" to startup packet 📎 Andrey Borodin 15:28
Re: Add "host" to startup packet Tom Lane 15:38
Re: Add "host" to startup packet Greg Stark 16:21
Re: regression coverage gaps for gist and hash indexes Andres Freund 16:24
Re: Add "host" to startup packet Tom Lane 16:33
Re: regression coverage gaps for gist and hash indexes Tom Lane 16:38
Re: regression coverage gaps for gist and hash indexes Andres Freund 16:54
Re: regression coverage gaps for gist and hash indexes Tom Lane 17:03
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() Peter Geoghegan 17:18
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() Peter Geoghegan 17:22
Re: Add "host" to startup packet Daniel Gustafsson 17:37
Re: O(n) tasks cause lengthy startups and checkpoints Tom Lane 17:40
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 17:46
Re: regression coverage gaps for gist and hash indexes Andres Freund 17:50
Re: O(n) tasks cause lengthy startups and checkpoints Andres Freund 18:42
Re: GUC for temporarily disabling event triggers Daniel Gustafsson 19:24
Re: O(n) tasks cause lengthy startups and checkpoints Nathan Bossart 19:30
Re: GUC for temporarily disabling event triggers Justin Pryzby 19:48
Re: O(n) tasks cause lengthy startups and checkpoints Nathan Bossart 19:50
Re: Minimal logical decoding on standbys Jeff Davis 20:01
Re: Minimal logical decoding on standbys Andres Freund 20:10
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode 📎 Melanie Plageman 20:11
Re: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind 📎 Tom Lane 20:13
Re: O(n) tasks cause lengthy startups and checkpoints Tom Lane 20:23
Re: Making background psql nicer to use in tap tests 📎 Daniel Gustafsson 20:24
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert Daniel Gustafsson 20:35
Re: O(n) tasks cause lengthy startups and checkpoints Tom Lane 20:37
Re: O(n) tasks cause lengthy startups and checkpoints Nathan Bossart 21:17
Re: Minimal logical decoding on standbys Jeff Davis 21:25
Re: Infinite Interval 📎 Joseph Koshakow 21:25
Re: O(n) tasks cause lengthy startups and checkpoints Nathan Bossart 21:31
Re: Minimal logical decoding on standbys Andres Freund 21:35
Re: Infinite Interval Tom Lane 21:36
Re: Making background psql nicer to use in tap tests Andres Freund 21:37
Re: Minimal logical decoding on standbys Jeff Davis 22:15
Re: Minimal logical decoding on standbys Andres Freund 22:29
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() Andres Freund 22:30
Re: Infinite Interval Joseph Koshakow 22:34
Re: hio.c does visibilitymap_pin()/IO while holding buffer lock Andres Freund 22:40
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() Peter Geoghegan 22:52
Re: Infinite Interval Tom Lane 22:54
Re: Minimal logical decoding on standbys Jeff Davis 22:56
Re: Minimal logical decoding on standbys Jeff Davis 23:04
Re: Minimal logical decoding on standbys Alvaro Herrera 23:09

April 3, 2023

Thread Author Time
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() Andres Freund 00:19
Re: Infinite Interval 📎 Joseph Koshakow 00:32
Re: [PATCH] Support % wildcard in extension upgrade filenames Yurii Rashkovskii 02:26
Re: Should vacuum process config file reload more often Masahiko Sawada 02:27
Re: running logical replication as the subscription owner Noah Misch 03:21
Fix a comment in basic_archive about NO_INSTALLCHECK 📎 Bharath Rupireddy 03:26
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? Thomas Munro 03:44
Re: Support logical replication of DDLs Amit Kapila 04:07
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Pavel Luzanov 04:13
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode David Rowley 05:09
Re: Minimal logical decoding on standbys Amit Kapila 05:20
Re: Minimal logical decoding on standbys Amit Kapila 05:35
Re: Minimal logical decoding on standbys Drouvot, Bertrand 06:05
Re: Minimal logical decoding on standbys Drouvot, Bertrand 06:10
Re: BUG #17877: Referencing a system column in a foreign key leads to incorrect memory access Kyotaro Horiguchi 06:31
Re: Minimal logical decoding on standbys Amit Kapila 06:35
RE: Initial Schema Sync for Logical Replication Kumar, Sachin 06:53
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() 📎 Drouvot, Bertrand 07:09
Re: Making background psql nicer to use in tap tests Daniel Gustafsson 08:39
Re: SQL JSON path enhanced numeric literals Peter Eisentraut 08:42
Why enable_hashjoin Completely disables HashJoin 📎 Quan Zongliang 10:23
Re: Sketch of a fix for that truncation data corruption issue Alvaro Herrera 10:34
RE: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind Onur Tirtir 11:09
Re: Why enable_hashjoin Completely disables HashJoin Tomas Vondra 11:44
Re: running logical replication as the subscription owner Amit Kapila 11:54
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode David Rowley 11:56
Re: Why enable_hashjoin Completely disables HashJoin Tom Lane 12:13
Re: hio.c does visibilitymap_pin()/IO while holding buffer lock Tomas Vondra 12:25
Re: [PATCH] Clarify the behavior of the system when approaching XID wraparound 📎 Aleksander Alekseev 12:33
Re: Sketch of a fix for that truncation data corruption issue Tom Lane 12:40
Re: GUC for temporarily disabling event triggers 📎 Daniel Gustafsson 12:45
Re: GUC for temporarily disabling event triggers Robert Haas 13:09
Re: RFC: logical publication via inheritance root? Aleksander Alekseev 13:13
Re: GUC for temporarily disabling event triggers Daniel Gustafsson 13:15
Re: daitch_mokotoff module Dag Lem 13:19
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? Tom Lane 13:25
RE: Support logical replication of DDLs Phil Florent 13:25
Add missing copyright for pg_upgrade/t/* files 📎 Hayato Kuroda (Fujitsu) 13:55
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() Alexander Korotkov 13:57
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎 Pavel Borisov 13:57
Re: Infinite Interval 📎 Ashutosh Bapat 14:07
Re: GUC for temporarily disabling event triggers Robert Haas 14:09
Re: Infinite Interval Ashutosh Bapat 14:11
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎 Pavel Borisov 14:12
Re: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind Tom Lane 14:19
Re: running logical replication as the subscription owner Robert Haas 14:26
Re: running logical replication as the subscription owner Robert Haas 14:34
Re: daitch_mokotoff module Tomas Vondra 14:45
Re: is_superuser is not documented Fujii Masao 14:47
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode 📎 Melanie Plageman 14:49
Re: Initial Schema Sync for Logical Replication Masahiko Sawada 15:15
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 15:20
Re: Minimal logical decoding on standbys Alvaro Herrera 15:34
Re: Request for comment on setting binary format output per session Dave Cramer 16:28
Re: Should vacuum process config file reload more often 📎 Melanie Plageman 16:40
Re: [BUG] pg_stat_statements and extended query protocol Tom Lane 16:43
Re: SQL/JSON revisited 📎 Alvaro Herrera 17:16
Re: possible proposal plpgsql GET DIAGNOSTICS oid = PG_ROUTINE_OID Tom Lane 17:37
Re: Why enable_hashjoin Completely disables HashJoin Robert Haas 17:51
Re: [Proposal] Add foreign-server health checks infrastructure Fujii Masao 17:56
Re: Non-superuser subscription owners Robert Haas 17:56
Re: Why enable_hashjoin Completely disables HashJoin Tom Lane 18:04
Re: [Proposal] Add foreign-server health checks infrastructure Tom Lane 18:10
Re: Minimal logical decoding on standbys 📎 Drouvot, Bertrand 18:17
Re: Should vacuum process config file reload more often Tom Lane 18:43
Re: [BUG] Logical replica crash if there was an error in a function. Tom Lane 18:49
Re: possible proposal plpgsql GET DIAGNOSTICS oid = PG_ROUTINE_OID 📎 Pavel Stehule 18:49
[PATCH] Add statement_timeout in pg_stat_activity 📎 Anthonin Bonnefoy 18:51
Re: Why enable_hashjoin Completely disables HashJoin Robert Haas 18:52
Re: hio.c does visibilitymap_pin()/IO while holding buffer lock 📎 Andres Freund 19:00
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert Jacob Champion 19:04
Re: running logical replication as the subscription owner Jeff Davis 19:05
Re: Thoughts on using Text::Template for our autogenerated code? 📎 Corey Huinker 19:07
Re: Should vacuum process config file reload more often Andres Freund 19:08
Re: running logical replication as the subscription owner Jeff Davis 19:14
Re: zstd compression for pg_dump Justin Pryzby 19:17
Re: Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() Peter Geoghegan 19:20
Re: Minimal logical decoding on standbys Andres Freund 19:23
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert Daniel Gustafsson 19:40
Re: Prefetch the next tuple's memory during seqscans Gregory Stark (as CFM) 19:47
Re: SQL/JSON revisited Alexander Lakhin 20:00
Re: psql - factor out echo code Gregory Stark (as CFM) 20:03
Re: Removing unneeded self joins Gregory Stark (as CFM) 20:30
Re: pg_usleep for multisecond delays Gregory Stark (as CFM) 20:33
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎 Melanie Plageman 20:50
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert 📎 Jacob Champion 21:09
Re: pg_stats and range statistics 📎 Gregory Stark (as CFM) 21:10
Re: [PATCH] Introduce array_shuffle() and array_sample() Gregory Stark (as CFM) 21:16
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Daniel Gustafsson 21:25
Re: zstd compression for pg_dump Tomas Vondra 21:26
Re: GUC for temporarily disabling event triggers Daniel Gustafsson 21:35
Re: WIP: Aggregation push-down - take2 Gregory Stark (as CFM) 21:38
Re: generic plans and "initial" pruning Tom Lane 21:41
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 21:46
Re: Split index and table statistics into different types of stats Gregory Stark (as CFM) 21:47
Re: [PATCH] Introduce array_shuffle() and array_sample() Daniel Gustafsson 21:52
Re: psql: Add role's membership options to the \du+ command David G. Johnston 22:06
Re: Patch proposal: New hooks in the connection path Gregory Stark (as CFM) 22:08
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() Alexander Korotkov 22:25
Re: Should vacuum process config file reload more often 📎 Melanie Plageman 22:35
Re: Kerberos delegation support in libpq and postgres_fdw David Christensen 22:55
Re: Why enable_hashjoin Completely disables HashJoin Andres Freund 23:18
Re: Why enable_hashjoin Completely disables HashJoin David Rowley 23:31
Re: Why enable_hashjoin Completely disables HashJoin Tom Lane 23:31
Re: Why enable_hashjoin Completely disables HashJoin Tom Lane 23:39

April 4, 2023

Thread Author Time
Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode David Rowley 00:37
fairywren exiting in ecpg Andres Freund 01:15
Re: Minimal logical decoding on standbys Masahiko Sawada 01:55
Re: running logical replication as the subscription owner Noah Misch 02:09
Re: [BUG] pg_stat_statements and extended query protocol Imseih (AWS), Sami 02:19
Re: [BUG] pg_stat_statements and extended query protocol Tom Lane 02:47
same query but different result on pg16devel and pg15.2 tender wang 02:53
Re: [BUG] pg_stat_statements and extended query protocol Imseih (AWS), Sami 03:01
Re: zstd compression for pg_dump 📎 Justin Pryzby 03:04
RE: Support logical replication of DDLs 📎 [email protected] 03:13
Re: [BUG] pg_stat_statements and extended query protocol Tom Lane 03:13
RE: Support logical replication of DDLs [email protected] 03:21
Re: [BUG] pg_stat_statements and extended query protocol Imseih (AWS), Sami 03:29
Re: pg_usleep for multisecond delays Nathan Bossart 03:31
Re: O(n) tasks cause lengthy startups and checkpoints Nathan Bossart 03:36
Re: Add missing copyright for pg_upgrade/t/* files Amit Kapila 03:43
Re: RFC: logical publication via inheritance root? Peter Smith 03:53
RE: Add missing copyright for pg_upgrade/t/* files Hayato Kuroda (Fujitsu) 04:18
Re: Prefetch the next tuple's memory during seqscans 📎 David Rowley 04:50

Browse Archives

Prev | Next