pgsql-hackers since 2023-08-01 20:11

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

Aug. 1, 2023

Thread Author Time
Re: POC, WIP: OR-clause support for indexes Finnerty, Jim 20:11
Re: document the need to analyze partitioned tables Daniel Gustafsson 20:24
Re: Partial aggregates pushdown Finnerty, Jim 20:25
Re: explain analyze rows=%.0f Daniel Gustafsson 20:29
Re: Add GUC to tune glibc's malloc implementation. Daniel Gustafsson 20:54
Re: bug: ANALYZE progress report with inheritance tables Daniel Gustafsson 21:03
Re: POC, WIP: OR-clause support for indexes Peter Geoghegan 21:16
Re: stats test intermittent failure Andres Freund 21:19
Re: pgsql: Fix search_path to a safe value during maintenance operations. Jeff Davis 21:38
Re: pgsql: Fix search_path to a safe value during maintenance operations. David G. Johnston 21:47
Re: pgsql: Fix search_path to a safe value during maintenance operations. Jeff Davis 22:00
Re: stats test intermittent failure Tom Lane 22:28
Re: Extract numeric filed in JSONB more effectively Andy Fan 23:33
Re: Support to define custom wait events for extensions Ranier Vilela 23:38
Re: Incorrect handling of OOM in WAL replay leading to data loss Jeff Davis 23:39
Re: pgsql: Fix search_path to a safe value during maintenance operations. Jeff Davis 23:40
Re: Correct the documentation for work_mem Imseih (AWS), Sami 23:59
Re: Faster "SET search_path" 📎 Jeff Davis 23:59

Aug. 2, 2023

Thread Author Time
Re: Performance degradation on concurrent COPY into a single relation in PG16. David Rowley 00:25
Re: Support to define custom wait events for extensions Masahiro Ikeda 00:34
Re: Support to define custom wait events for extensions Ranier Vilela 00:46
Re: Use of additional index columns in rows filtering Peter Geoghegan 00:50
Re: Extract numeric filed in JSONB more effectively Andy Fan 01:05
Re: Performance degradation on concurrent COPY into a single relation in PG16. David Rowley 01:35
Re: [PoC] pg_upgrade: allow to upgrade publisher node Jonathan S. Katz 02:16
Re: Inaccurate comments in ReorderBufferCheckMemoryLimit() Amit Kapila 02:20
Re: Adding a LogicalRepWorker type field 📎 Peter Smith 02:31
Re: Documentation of psql's \df no longer matches reality David G. Johnston 02:36
Re: Adding a LogicalRepWorker type field Peter Smith 02:40
Re: Simplify some logical replication worker type checking Amit Kapila 02:50
Re: Adding a LogicalRepWorker type field Amit Kapila 03:00
Inquiry about Functionality Availability in PostgreSQL Sultan Berentaev 03:10
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 03:31
Re: [PATCH] [zh_CN.po] fix a typo in simplified Chinese translation file jian he 03:45
Re: Incorrect handling of OOM in WAL replay leading to data loss 📎 Kyotaro Horiguchi 04:16
Re: Faster "SET search_path" Nathan Bossart 04:52
Re: Faster "SET search_path" Nathan Bossart 05:07
Re: Faster "SET search_path" Isaac Morland 05:14
Re: Adding a LogicalRepWorker type field Masahiko Sawada 05:34
Re: Faster "SET search_path" Jeff Davis 05:53
Re: Extract numeric filed in JSONB more effectively jian he 06:01
Re: Inaccurate comments in ReorderBufferCheckMemoryLimit() Masahiko Sawada 06:03
Re: Faster "SET search_path" Jeff Davis 06:06
Re: Adding a LogicalRepWorker type field Peter Smith 06:27
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 06:40
Re: Adding a LogicalRepWorker type field 📎 Peter Smith 06:43
Re: add timing information to pg_upgrade Peter Eisentraut 07:14
Re: add timing information to pg_upgrade Peter Eisentraut 07:15
Re: add timing information to pg_upgrade Bharath Rupireddy 07:32
Re: pgbnech: allow to cancel queries during benchmark Yugo NAGATA 07:37
Re: [PATCH] [zh_CN.po] fix a typo in simplified Chinese translation file Peter Eisentraut 07:55
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 08:13
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 08:13
Re: cataloguing NOT NULL constraints Peter Eisentraut 08:29
Re: add timing information to pg_upgrade Bharath Rupireddy 08:30
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 09:01
Re: PG_CATCH used without PG_RETHROW 正华吕 09:03
Re: Adding a LogicalRepWorker type field Bharath Rupireddy 09:15
Re: add timing information to pg_upgrade Peter Eisentraut 09:22
Re: Adding a LogicalRepWorker type field Amit Kapila 09:26
Re: multiple membership grants and information_schema.applicable_roles Peter Eisentraut 09:32
Re: Support to define custom wait events for extensions Masahiro Ikeda 09:34
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 09:42
Re: [PoC] Reducing planning time when tables have many partitions Andrey Lepikhov 09:43
Improve const use in zlib-using code 📎 Peter Eisentraut 09:50
Re: pgbnech: allow to cancel queries during benchmark 📎 Yugo NAGATA 10:01
ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression 📎 Amul Sul 10:35
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 10:39
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎 Richard Guo 11:02
Re: Potential memory leak in contrib/intarray's g_intbig_compress Matthias van de Meent 11:44
Re: Adding a LogicalRepWorker type field Melih Mutlu 11:57
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Amit Kapila 13:19
Re: generic plans and "initial" pruning 📎 Amit Langote 13:39
Re: Use of additional index columns in rows filtering Tomas Vondra 13:48
Re: pg_upgrade fails with in-place tablespace 📎 Rui Zhao 14:38
Re: Improve const use in zlib-using code Tristan Partin 14:39
Re: PATCH: Using BRIN indexes for sorted output 📎 Sergey Dudoladov 15:25
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression jian he 15:46
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 15:58
Re: add timing information to pg_upgrade Nathan Bossart 15:59
Re: PATCH: Using BRIN indexes for sorted output Tomas Vondra 16:04
Re: add timing information to pg_upgrade Nathan Bossart 16:09
Re: SIGQUIT handling, redux Andres Freund 16:25
Re: SIGQUIT handling, redux Tom Lane 16:35
Re: SIGQUIT handling, redux Andres Freund 16:48
Re: add timing information to pg_upgrade 📎 Nathan Bossart 17:39
Re: Synchronizing slots from primary to standby Bharath Rupireddy 18:57
Re: POC, WIP: OR-clause support for indexes Peter Geoghegan 18:58
Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication Daniel Gustafsson 19:47
Re: [PATCH] Allow Postgres to pick an unused port to listen Daniel Gustafsson 19:52
First draft of back-branch release notes is done Tom Lane 21:48
Re: Configurable FP_LOCK_SLOTS_PER_BACKEND Matt Smiley 23:51

Aug. 3, 2023

Thread Author Time
Re: Extract numeric filed in JSONB more effectively 📎 Andy Fan 00:50
Re: Use of additional index columns in rows filtering Peter Geoghegan 01:32
Fix bogus Asserts in calc_non_nestloop_required_outer 📎 Richard Guo 02:24
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 04:05
Re: Oversight in reparameterize_path_by_child leading to executor crash Ashutosh Bapat 04:38
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) 📎 David Rowley 04:50
Re: Extract numeric filed in JSONB more effectively Pavel Stehule 04:59
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression Amul Sul 05:23
Re: Use of additional index columns in rows filtering Peter Geoghegan 05:26
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 06:08
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 06:15
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 06:21
Re: Exposing the lock manager's WaitForLockers() to SQL 📎 Will Mortensen 06:30
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression jian he 06:34
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 06:38
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) Andy Fan 06:49
Re: Faster "SET search_path" 📎 Jeff Davis 06:50
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails tender wang 06:55
Re: Improve const use in zlib-using code 📎 Peter Eisentraut 07:08
Re: Extract numeric filed in JSONB more effectively Andy Fan 07:53
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 08:19
Re: Inquiry about Functionality Availability in PostgreSQL Ashutosh Bapat 08:21
Adding a pg_servername() function 📎 Laetitia Avrot 08:36
Re: generic plans and "initial" pruning 📎 Amit Langote 08:37
Re: Adding a LogicalRepWorker type field Ashutosh Bapat 08:50
Re: Missing comments/docs about custom scan path Etsuro Fujita 09:01
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera 09:02
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 09:06
Re: On disable_cost 📎 Jian Guo 09:21
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 09:28
Re: Adding a pg_servername() function Matthias van de Meent 09:31
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎 tender wang 09:34
Re: Extract numeric filed in JSONB more effectively Pavel Stehule 09:47
Re: Extract numeric filed in JSONB more effectively Matthias van de Meent 10:04
Re: Adding a pg_servername() function Laetitia Avrot 10:06
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 10:26
Re: Oversight in reparameterize_path_by_child leading to executor crash Richard Guo 10:43
Re: Adding a pg_servername() function 066ce286 10:47
Re: Synchronizing slots from primary to standby shveta malik 10:49
Re: Oversight in reparameterize_path_by_child leading to executor crash Ashutosh Bapat 11:20
Re: Use of additional index columns in rows filtering Tomas Vondra 11:20
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) 📎 David Rowley 11:29
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 11:29
Re: Use of additional index columns in rows filtering Tomas Vondra 11:57
Re: Adding a pg_servername() function Laetitia Avrot 12:25
Re: Extract numeric filed in JSONB more effectively Andy Fan 12:31
Re: Extract numeric filed in JSONB more effectively Chapman Flack 12:34
Re: Adding a pg_servername() function Christoph Moench-Tegeder 13:17
Re: Extract numeric filed in JSONB more effectively Andy Fan 13:22
Re: [PoC] Reducing planning time when tables have many partitions Ashutosh Bapat 13:29
Re: Show WAL write and fsync stats in pg_stat_io 📎 Nazir Bilal Yavuz 13:38
Re: Extract numeric filed in JSONB more effectively Andy Fan 13:50
Re: Extract numeric filed in JSONB more effectively Pavel Stehule 13:52
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) Andy Fan 14:02
Re: Extract numeric filed in JSONB more effectively Andy Fan 14:27
Re: Improve const use in zlib-using code Tristan Partin 14:30
Re: Use of additional index columns in rows filtering Peter Geoghegan 16:47
[RFC] Clang plugin for catching suspicious typedef casting 📎 Dmitry Dolgov 16:56
Re: [RFC] Clang plugin for catching suspicious typedef casting Tristan Partin 17:23
Using defines for protocol characters 📎 Dave Cramer 17:40
Re: Using defines for protocol characters Alvaro Herrera 17:59
Re: Using defines for protocol characters Dave Cramer 18:07
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) Tim Palmer 18:08
Re: Use of additional index columns in rows filtering Tomas Vondra 18:17
Re: Use of additional index columns in rows filtering Peter Geoghegan 18:50
Re: Using defines for protocol characters Nathan Bossart 18:53
Re: POC: Extension for adding distributed tracing - pg_tracing 📎 Nikita Malakhov 19:13
Re: Extract numeric filed in JSONB more effectively Tom Lane 19:13
Re: Use of additional index columns in rows filtering Peter Geoghegan 19:21
Re: Using defines for protocol characters Tatsuo Ishii 19:25
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 19:47
Re: [PoC] Implementation of distinct in Window Aggregates Daniel Gustafsson 20:35
Re: Configurable FP_LOCK_SLOTS_PER_BACKEND Tomas Vondra 20:39
Re: Introduce "log_connection_stages" setting. Daniel Gustafsson 20:58
Re: Track Oldest Initialized WAL Buffer Page Daniel Gustafsson 21:08
Re: Using defines for protocol characters Dave Cramer 21:22
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) David Rowley 21:28
Re: Using defines for protocol characters Dave Cramer 21:42
Re: Use of additional index columns in rows filtering Tomas Vondra 21:46
Re: Use of additional index columns in rows filtering Tomas Vondra 22:04
Re: Using defines for protocol characters Tatsuo Ishii 22:59
Re: Use of additional index columns in rows filtering Peter Geoghegan 23:29
Re: Adding argument names to aggregate functions Nathan Bossart 23:36
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) Nathan Bossart 23:54

Aug. 4, 2023

Thread Author Time
Re: Use of additional index columns in rows filtering Peter Geoghegan 00:08
Re: Oversight in reparameterize_path_by_child leading to executor crash Richard Guo 00:38
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) Tom Lane 00:46
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) David Rowley 01:28
Re: Use of additional index columns in rows filtering Peter Geoghegan 02:07
Re: Using defines for protocol characters 📎 Dave Cramer 02:09
Re: Fix incorrect start up costs for WindowAgg paths (bug #17862) Tom Lane 02:23
Re: Improve join_search_one_level readibilty (one line change) 📎 David Rowley 02:36
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 02:56
Re: Extract numeric filed in JSONB more effectively jian he 03:32
Re: Extract numeric filed in JSONB more effectively Pavel Stehule 03:54
Re: Extract numeric filed in JSONB more effectively Andy Fan 03:55
pgbench: allow to exit immediately when any client is aborted 📎 Yugo NAGATA 04:03
Re: Improve join_search_one_level readibilty (one line change) 📎 Richard Guo 04:05
Re: Extract numeric filed in JSONB more effectively Andy Fan 04:38
Re: Using defines for protocol characters Tatsuo Ishii 06:42
Fix a comment in paraminfo_get_equal_hashops 📎 Richard Guo 06:48
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 07:40
Re: Adding a LogicalRepWorker type field Peter Smith 07:45
Re: Adding a pg_servername() function Laetitia Avrot 08:26
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning 📎 Ashutosh Bapat 08:41
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails tender wang 09:04
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 09:14
Re: Split index and table statistics into different types of stats Drouvot, Bertrand 09:17

Browse Archives

Prev | Next