pgsql-hackers since 2022-03-19 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

March 19, 2022

Thread Author Time
Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs) Andres Freund 00:15
Re: Allow parallel plan for referential integrity checks? Imseih (AWS), Sami 00:57
Re: pgsql: Add option to use ICU as global locale provider Julien Rouhaud 00:59
Re: [PATCH] Add reloption for views to enable RLS 📎 Dean Rasheed 01:10
Re: ICU for global collation Andres Freund 01:47
Re: Replication slot drop message is sent after pgstats shutdown. Noah Misch 02:26
Re: logical replication empty transactions 📎 Ajin Cherian 03:40
Re: pgsql: Add option to use ICU as global locale provider 📎 Julien Rouhaud 04:14
Re: Why is src/test/modules/committs/t/002_standby.pl flaky? Noah Misch 08:47
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Pavel Borisov 09:52
Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD Michael Paquier 10:31
Re: support for MERGE Alvaro Herrera 10:48
Which hook to use when overriding utility commands (COPY ...) Hannu Krosing 11:28
Re: Which hook to use when overriding utility commands (COPY ...) Michael Paquier 12:44
Re: Add pg_freespacemap extension sql test 📎 Dong Wook Lee 16:18
Re: [PATCH] pgbench: add multiconnect option 📎 Fabien COELHO 16:43
Re: Column Filtering in Logical Replication 📎 Tomas Vondra 17:11
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby 17:40
Re: Column Filtering in Logical Replication 📎 Tomas Vondra 17:41
Re: pgsql: Add option to use ICU as global locale provider Christoph Berg 17:53
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov 18:08
Re: Add pg_freespacemap extension sql test 📎 Fabrízio de Royes Mello 18:13
Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b 📎 Andres Freund 18:16
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors 📎 Yugo NAGATA 18:23
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 18:33
Re: Problem with moderation of messages with patched attached. Andres Freund 18:48
Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b Andres Freund 18:51
Re: a misbehavior of partition row movement (?) 📎 Alvaro Herrera 20:13
Re: Commitfest manager for 2022-03 Justin Pryzby 20:35
Re: Schema variables - new implementation for Postgres 15 📎 Justin Pryzby 21:46

March 20, 2022

Thread Author Time
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Tatsuo Ishii 00:52
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Tatsuo Ishii 02:53
Re: a misbehavior of partition row movement (?) 📎 Amit Langote 02:58
Re: Column Filtering in Logical Replication Amit Kapila 03:11
Hardening heap pruning code (was: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum) 📎 Peter Geoghegan 03:48
Re: Schema variables - new implementation for Postgres 15 Julien Rouhaud 03:56
Re: A test for replay of regression tests Thomas Munro 04:20
Re: WIP: WAL prefetch (another approach) 📎 Thomas Munro 04:36
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Dilip Kumar 05:34
Re: Column Filtering in Logical Replication 📎 Amit Kapila 06:23
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Tatsuo Ishii 07:11
Re: WIP: WAL prefetch (another approach) Thomas Munro 07:52
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats 📎 Bharath Rupireddy 08:58
Re: A test for replay of regression tests 📎 Thomas Munro 09:36
Re: BufferAlloc: don't take two simultaneous locks 📎 Yura Sokolov 09:38
Re: pgsql: Add option to use ICU as global locale provider Peter Eisentraut 10:03
Re: pgsql: Add option to use ICU as global locale provider Peter Eisentraut 10:04
Re: Column Filtering in Logical Replication Tomas Vondra 11:23
Re: pgsql: Add option to use ICU as global locale provider Julien Rouhaud 11:46
Re: Probable CF bot degradation Matthias van de Meent 12:58
Re: Probable CF bot degradation Julien Rouhaud 13:28
Re: A test for replay of regression tests Andrew Dunstan 13:34
Re: Problem with moderation of messages with patched attached. Andrew Dunstan 13:52
Re: [PATCH v2] use has_privs_for_role for predefined roles 📎 Joe Conway 16:27
Re: [PATCH v2] use has_privs_for_role for predefined roles Joshua Brindle 16:31
Re: pgsql: Add option to use ICU as global locale provider Andres Freund 16:31
Re: shared-memory based stats collector - v66 📎 Melanie Plageman 16:32
Re: [PATCH v2] use has_privs_for_role for predefined roles Joe Conway 16:34
Re: [PATCH v2] use has_privs_for_role for predefined roles Joshua Brindle 16:37
Re: [PATCH v2] use has_privs_for_role for predefined roles Stephen Frost 16:38
Re: shared-memory based stats collector - v66 Andres Freund 16:58
Re: Problem with moderation of messages with patched attached. Pavel Borisov 17:02
Re: Possible fails in pg_stat_statements test 📎 Anton A. Melnikov 17:09
Re: Possible fails in pg_stat_statements test Andres Freund 17:36
Re: a misbehavior of partition row movement (?) Alvaro Herrera 17:58
Re: Concurrent deadlock scenario with DROP INDEX on partitioned index 📎 Tom Lane 18:39
Re: support for MERGE 📎 Alvaro Herrera 18:40
Re: refactoring basebackup.c (zstd workers) 📎 Robert Haas 19:05
Re: refactoring basebackup.c (zstd workers) Tom Lane 19:11
Re: refactoring basebackup.c (zstd workers) Justin Pryzby 19:40
Patch proposal - parameter to limit amount of FPW because of hint bits per second 📎 Michail Nikolaev 19:43
Re: Tab completion for SET TimeZone Dagfinn Ilmari Mannsåker 19:47
Re: Tab completion for SET TimeZone Tom Lane 20:11
Re: Hardening heap pruning code (was: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum) Matthias van de Meent 20:12
Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second Peter Geoghegan 20:35
Re: A test for replay of regression tests Thomas Munro 20:44
Re: shared-memory based stats collector - v66 📎 Melanie Plageman 20:56
Re: [PATCH] pg_statio_all_tables: several rows per table due to invalid TOAST index 📎 Tom Lane 22:08
Re: [PATCH] pg_statio_all_tables: several rows per table due to invalid TOAST index 📎 Tom Lane 22:33
Re: logical decoding and replication of sequences 📎 Tomas Vondra 22:55
Re: Probable CF bot degradation Thomas Munro 23:23
Re: Probable CF bot degradation Thomas Munro 23:46

March 21, 2022

Thread Author Time
Re: Tab completion for SET TimeZone Dagfinn Ilmari Mannsåker 00:05
Re: Probable CF bot degradation Andres Freund 00:17
Re: Probable CF bot degradation Andres Freund 00:36
Re: logical replication restrictions 📎 Euler Taveira 00:40
Re: Probable CF bot degradation Peter Geoghegan 00:41
Re: refactoring basebackup.c (zstd workers) Robert Haas 01:24
Re: refactoring basebackup.c (zstd workers) Tom Lane 01:32
Re: refactoring basebackup.c (zstd workers) Robert Haas 01:38
Re: Skipping logical replication transactions on subscriber side Euler Taveira 01:39
Re: Probable CF bot degradation Thomas Munro 01:44
Re: Probable CF bot degradation Peter Geoghegan 01:48
Re: refactoring basebackup.c (zstd workers) Robert Haas 02:03
Re: Probable CF bot degradation Andres Freund 02:11
Re: Skipping logical replication transactions on subscriber side Amit Kapila 02:19
Re: Probable CF bot degradation Thomas Munro 02:41
Re: Skipping logical replication transactions on subscriber side 📎 Amit Kapila 03:25
Summary Sort workers Stats in EXPLAIN ANALYZE 📎 Jian Guo 03:36
Re: [PATCH] add relation and block-level filtering to pg_waldump 📎 Thomas Munro 03:36
Re: [PATCH] add relation and block-level filtering to pg_waldump Thomas Munro 04:55
Re: Logical replication timeout problem Amit Kapila 05:30
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir 📎 Bharath Rupireddy 05:57
Re: Summary Sort workers Stats in EXPLAIN ANALYZE 📎 Jian Guo 07:50
Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second Michail Nikolaev 07:58
Re: Support logical replication of DDLs Dilip Kumar 08:13
Re: WIP: WAL prefetch (another approach) Julien Rouhaud 08:29
[PATCH] Remove workarounds to format [u]int64's 📎 Aleksander Alekseev 08:52
Re: [PATCH] Remove workarounds to format [u]int64's Pavel Borisov 09:12
Re: [PATCH] Remove workarounds to format [u]int64's 📎 Aleksander Alekseev 09:23
Re: [PATCH] Remove workarounds to format [u]int64's Pavel Borisov 09:30
Re: Problem with moderation of messages with patched attached. Dave Page 09:41
Re: [PATCH] Add reloption for views to enable RLS Laurenz Albe 09:47
Re: logical replication empty transactions 📎 Amit Kapila 10:01
Re: [PATCH] Remove workarounds to format [u]int64's 📎 Japin Li 10:13
Re: Detaching a partition with a FK on itself is not possible Jehan-Guillaume de Rorthais 10:36
Re: Column Filtering in Logical Replication Amit Kapila 10:38
Re: Detaching a partition with a FK on itself is not possible Arne Roland 10:50
Re: [PATCH] Remove workarounds to format [u]int64's 📎 Aleksander Alekseev 10:55
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Alvaro Herrera 11:24
Re: [PATCH] Remove workarounds to format [u]int64's Aleksander Alekseev 11:25
Re: Column Filtering in Logical Replication Amit Kapila 11:28
Re: Column Filtering in Logical Replication Amit Kapila 11:55
Re: Fix unsigned output for signed values in SLRU error reporting Pavel Borisov 12:11
Re: Add pg_freespacemap extension sql test Dong Wook Lee 12:12
Re: Column Filtering in Logical Replication Alvaro Herrera 12:16
Re: Skipping logical replication transactions on subscriber side Euler Taveira 12:21
Re: [PATCH] Add reloption for views to enable RLS Laurenz Albe 12:40
Re: logical decoding and replication of sequences Peter Eisentraut 13:05
Re: refactoring basebackup.c (zstd workers) Justin Pryzby 13:18
Re: [PATCH] Add reloption for views to enable RLS Japin Li 13:26
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 13:36
Re: [PATCH] Remove workarounds to format [u]int64's Tom Lane 13:41
Re: Column Filtering in Logical Replication Amit Kapila 14:12
Re: [PATCH] Remove workarounds to format [u]int64's 📎 Aleksander Alekseev 14:37
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Dilip Kumar 14:59
Re: [PATCH] Remove workarounds to format [u]int64's Tom Lane 15:13
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Dilip Kumar 15:21
Re: New Object Access Type hooks Andrew Dunstan 15:41
Re: [PATCH] add relation and block-level filtering to pg_waldump David Christensen 16:10
Re: refactoring basebackup.c (zstd workers) 📎 Robert Haas 16:57
Re: pgsql: Add option to use ICU as global locale provider Christoph Berg 16:59
Re: [PATCH] add relation and block-level filtering to pg_waldump 📎 David Christensen 17:14
Re: refactoring basebackup.c (zstd workers) Justin Pryzby 18:22
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas 18:23
Re: refactoring basebackup.c (zstd workers) 📎 Robert Haas 18:25
Re: pgsql: Add option to use ICU as global locale provider Tom Lane 18:37
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Peter Eisentraut 18:40
Re: refactoring basebackup.c (zstd workers) Dagfinn Ilmari Mannsåker 18:41
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎 Alvaro Herrera 18:43
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Andres Freund 18:50
Re: standby recovery fails (tablespace related) (tentative patch and discussion) Alvaro Herrera 19:03
Re: New Object Access Type hooks 📎 Mark Dilger 19:57
Re: New Object Access Type hooks Mark Dilger 19:58
Re: jsonpath syntax extensions Greg Stark 20:09
Re: jsonpath syntax extensions Greg Stark 20:13
Re: [PATCH v2] use has_privs_for_role for predefined roles Joe Conway 20:15
Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Nathan Bossart 20:24
Re: jsonpath syntax extensions Erik Rijkers 20:25
Re: New Object Access Type hooks Andrew Dunstan 20:30
Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second Peter Geoghegan 20:36
Re: Support logical replication of DDLs Zheng Li 20:56
RE: WIP: Aggregation push-down 📎 [email protected] 21:09
Re: shared-memory based stats collector - v67 📎 Andres Freund 21:30
Re: freeing bms explicitly Zhihong Yu 21:30
Re: [PATCH] add relation and block-level filtering to pg_waldump 📎 Thomas Munro 21:38
Re: shared-memory based stats collector - v66 📎 Melanie Plageman 21:41
Re: logical decoding and replication of sequences Tomas Vondra 21:54
Re: freeing bms explicitly Tom Lane 22:05
Re: Estimating HugePages Requirements? Nathan Bossart 22:12
Re: freeing bms explicitly 📎 Zhihong Yu 22:13
Re: Concurrent deadlock scenario with DROP INDEX on partitioned index Jimmy Yih 22:57
Re: [PATCH] add relation and block-level filtering to pg_waldump 📎 David Christensen 23:01
Re: New Object Access Type hooks 📎 Mark Dilger 23:08
Re: Pluggable toaster 📎 Nikita Malakhov 23:31
Re: PoC: using sampling to estimate joins / complex conditions Andres Freund 23:35
Re: Add sub-transaction overflow status in pg_stat_activity Andres Freund 23:45
Re: TAP output format in pg_regress Andres Freund 23:49
Re: Add parameter jit_warn_above_fraction Andres Freund 23:50
Re: pgcrypto: Remove internal padding implementation Nathan Bossart 23:51
Re: Fast COPY FROM based on batch insert Andres Freund 23:58
Re: Identify missing publications from publisher while create/alter subscription. Andres Freund 23:59

March 22, 2022

Thread Author Time
Re: Make mesage at end-of-recovery less scary. Andres Freund 00:01
Re: Parameter for planner estimate of recursive queries Andres Freund 00:04
Re: [PATCH] Full support for index LP_DEAD hint bits on standby Andres Freund 00:07
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Yugo NAGATA 00:08
Re: [PATCH] Add TOAST support for several system tables Andres Freund 00:09
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Yugo NAGATA 00:10
Re: Add connection active, idle time to pg_stat_activity Andres Freund 00:13
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Andres Freund 00:15
Re: Mingw task for Cirrus CI Andres Freund 00:15
Re: PoC: using sampling to estimate joins / complex conditions Tomas Vondra 00:17
Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path Andres Freund 00:18
Re: Extensible storage manager API - smgr hooks Andres Freund 00:20
Re: Allow batched insert during cross-partition updates Andres Freund 00:30
Re: Fix overflow in DecodeInterval 📎 Tom Lane 00:31
Re: Supply restore_command to pg_rewind via CLI argument Andres Freund 00:32
Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path Tomas Vondra 00:33
Re: [WIP] Allow pg_upgrade to copy segments of the same relfilenode in parallel Andres Freund 00:34
Re: [PATCH] Proof of concept for GUC improvements Andres Freund 00:37

Browse Archives

Prev | Next