pgsql-hackers since 2023-07-27 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)
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

July 27, 2023

Thread Author Time
Re: psql: Could we get "-- " prefixing on the **** QUERY **** outputs? (ECHO_HIDDEN) Nathan Bossart 00:05
Re: Performance degradation on concurrent COPY into a single relation in PG16. 📎 David Rowley 00:17
Re: Improve pg_stat_statements by making jumble handle savepoint names better Michael Paquier 00:57
Re: [PATCH] Check more invariants during syscache initialization Michael Paquier 01:05
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 01:13
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 01:16
Fwd: BUG #18016: REINDEX TABLE failure Gurjeet Singh 01:42
Fwd: BUG #18016: REINDEX TABLE failure Gurjeet Singh 01:43
Re: [PATCH] Check more invariants during syscache initialization Zhang Mingli 01:48
Re: [PATCH] Check more invariants during syscache initialization Michael Paquier 01:57
Re: pg_usleep for multisecond delays Kyotaro Horiguchi 02:50
Re: Performance degradation on concurrent COPY into a single relation in PG16. David Rowley 02:51
Re: Retiring is_pushed_down 📎 Richard Guo 02:55
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 04:13
Re: PATCH: Add REINDEX tag to event triggers Garrett Thornburg 04:33
Re: PATCH: Add REINDEX tag to event triggers Garrett Thornburg 04:35
Re: WAL Insertion Lock Improvements Michael Paquier 04:36
Re: PATCH: Add REINDEX tag to event triggers 📎 Garrett Thornburg 04:43
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 05:02
Re: Synchronizing slots from primary to standby Amit Kapila 05:24
Re: Synchronizing slots from primary to standby shveta malik 06:43
Re: Synchronizing slots from primary to standby Amit Kapila 06:54
Re: [PoC] Reducing planning time when tables have many partitions 📎 Andrey Lepikhov 07:58
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" David Steele 08:18
Improvements in pg_dump/pg_restore toc format and performances 📎 Pierre Ducroquet 08:51
Re: Performance degradation on concurrent COPY into a single relation in PG16. David Rowley 08:53
Re: Support to define custom wait events for extensions 📎 Michael Paquier 09:16
Re: Support to define custom wait events for extensions Masahiro Ikeda 09:29
RE: remaining sql/json patches 📎 Shinoda, Noriyoshi (HPE Services Japan - FSIP) 09:36
Re: incremental-checkopints Tomas Vondra 10:50
Re: POC: Extension for adding distributed tracing - pg_tracing 📎 Nikita Malakhov 10:56
Re: Issue in postgres_fdw causing unnecessary wait for cancel request reply Kuwamura Masaki 11:01
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Matthias van de Meent 11:59
Re: Let's make PostgreSQL multi-threaded David Geier 13:27
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 13:29
Memory consumption during partitionwise join planning 📎 Ashutosh Bapat 13:58
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 📎 Matthias van de Meent 13:59
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 14:00
Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎 Ashutosh Bapat 14:05
Memory consumed by paths during partitionwise join planning 📎 Ashutosh Bapat 14:06
Memory consumed by child SpecialJoinInfo in partitionwise join planning 📎 Ashutosh Bapat 14:09
Re: [May be a bug] double free or corruption Ashutosh Bapat 14:40
Re: POC: Extension for adding distributed tracing - pg_tracing Nikita Malakhov 14:45
Re: POC: Extension for adding distributed tracing - pg_tracing 📎 Aleksander Alekseev 15:38
Re: Removing the fixed-size buffer restriction in hba.c Tom Lane 16:11
Re: Removing the fixed-size buffer restriction in hba.c Michael Paquier 22:42
Re: Fwd: BUG #18016: REINDEX TABLE failure Nathan Bossart 23:10
Re: Fwd: BUG #18016: REINDEX TABLE failure Nathan Bossart 23:14
add timing information to pg_upgrade 📎 Nathan Bossart 23:51
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 23:57

July 28, 2023

Thread Author Time
Re: Support to define custom wait events for extensions 📎 Michael Paquier 01:06
Re: Fwd: BUG #18016: REINDEX TABLE failure Michael Paquier 01:50
Re: Postgres v15 windows bincheck regression test failures Noah Misch 02:17
Re: Support worker_spi to execute the function dynamically. 📎 Andres Freund 02:23
Add assertion on held AddinShmemInitLock in GetNamedLWLockTranche() 📎 Michael Paquier 03:24
Re: Postgres v15 windows bincheck regression test failures Alexander Lakhin 04:00
Re: [PoC] Reducing planning time when tables have many partitions 📎 Andrey Lepikhov 04:27
Re: Support worker_spi to execute the function dynamically. 📎 Michael Paquier 04:45
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 05:17
Re: Add assertion on held AddinShmemInitLock in GetNamedLWLockTranche() Bharath Rupireddy 05:37
Re: POC: Extension for adding distributed tracing - pg_tracing 📎 Nikita Malakhov 06:10
Re: POC: Extension for adding distributed tracing - pg_tracing Anthonin Bonnefoy 06:35
Re: unrecognized node type while displaying a Path due to dangling pointer Ashutosh Bapat 06:42
Re: remaining sql/json patches Amit Langote 06:57
Re: Row pattern recognition Tatsuo Ishii 07:09
Re: Support to define custom wait events for extensions Bharath Rupireddy 07:13
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Peter Smith 07:22
Re: POC: Extension for adding distributed tracing - pg_tracing Nikita Malakhov 07:34
Re: add timing information to pg_upgrade Bharath Rupireddy 07:40
Re: pg_rewind fails with in-place tablespace 📎 Michael Paquier 07:54
Re: Support worker_spi to execute the function dynamically. Michael Paquier 07:56
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning Richard Guo 08:33
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 08:41
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 08:49
Re: Avoid unused value (src/fe_utils/print.c) Karina Litskevich 08:53
Re: postgres_fdw: wrong results with self join + enable_nestloop off 📎 Etsuro Fujita 08:55
Re: Row pattern recognition Vik Fearing 08:56
Re: Support worker_spi to execute the function dynamically. Michael Paquier 09:19
Re: Row pattern recognition Vik Fearing 09:21
Re: logical decoding and replication of sequences, take 2 Amit Kapila 09:42
Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids) 📎 Ashutosh Bapat 09:46
Re: [PoC] Reducing planning time when tables have many partitions 📎 Ashutosh Bapat 09:50
Re: Support worker_spi to execute the function dynamically. Alvaro Herrera 10:06
Re: cataloguing NOT NULL constraints Alvaro Herrera 10:47
Re: Row pattern recognition Tatsuo Ishii 11:02
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Matthias van de Meent 11:11
Re: WAL Insertion Lock Improvements Bharath Rupireddy 11:27
Re: Postgres v15 windows bincheck regression test failures Noah Misch 11:42
Re: POC: Extension for adding distributed tracing - pg_tracing Anthonin Bonnefoy 11:45
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎 vignesh C 11:59
Re: logical decoding and replication of sequences, take 2 Ashutosh Bapat 12:35
Re: Row pattern recognition Vik Fearing 12:36
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 12:42
Re: logical decoding and replication of sequences, take 2 Ashutosh Bapat 12:44
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 12:56
Re: Postgres v15 windows bincheck regression test failures Alexander Lakhin 13:00
Re: POC: Extension for adding distributed tracing - pg_tracing Nikita Malakhov 13:01
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning Ashutosh Bapat 13:58
Re: POC: Extension for adding distributed tracing - pg_tracing Anthonin Bonnefoy 14:06
Re: Synchronizing slots from primary to standby Bharath Rupireddy 14:39
Eager page freeze criteria clarification Melanie Plageman 15:12
Re: Synchronizing slots from primary to standby Bharath Rupireddy 15:24
New PostgreSQL Contributors Christoph Berg 15:29
Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb Nathan Bossart 17:14
Re: New PostgreSQL Contributors Vik Fearing 17:19
Re: add timing information to pg_upgrade Nathan Bossart 17:38
Re: New PostgreSQL Contributors Nathan Bossart 17:40
Re: Fwd: BUG #18016: REINDEX TABLE failure Nathan Bossart 18:00
Re: Let's make PostgreSQL multi-threaded Matthias van de Meent 18:10
Re: In Postgres 16 BETA, should the ParseNamespaceItem have the same index as it's RangeTableEntry? Farias de Oliveira 18:37
Re: add timing information to pg_upgrade 📎 Nathan Bossart 18:47
Re: Eager page freeze criteria clarification Peter Geoghegan 18:59
Re: Eager page freeze criteria clarification Melanie Plageman 19:27
Re: Eager page freeze criteria clarification Peter Geoghegan 19:45
Re: Eager page freeze criteria clarification Robert Haas 20:19
Re: Eager page freeze criteria clarification Andres Freund 20:30
Re: Support worker_spi to execute the function dynamically. Andres Freund 20:34
Re: Eager page freeze criteria clarification Peter Geoghegan 20:49
Re: Eager page freeze criteria clarification Robert Haas 20:49
Re: Eager page freeze criteria clarification Melanie Plageman 21:03
Re: Extension Enhancement: Buffer Invalidation in pg_buffercache Cary Huang 21:25
Re: Eager page freeze criteria clarification Peter Geoghegan 21:30

July 29, 2023

Thread Author Time
Re: Support worker_spi to execute the function dynamically. Michael Paquier 02:38
Re: Support worker_spi to execute the function dynamically. Michael Paquier 02:48
Re: Avoid possible memory leak (src/common/rmtree.c) Michael Paquier 02:54
Re: Row pattern recognition Tatsuo Ishii 03:05
Re: logical decoding and replication of sequences, take 2 Amit Kapila 04:54
Re: add timing information to pg_upgrade Bharath Rupireddy 06:47
Re: Postgres v15 windows bincheck regression test failures Noah Misch 11:24
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 12:23
Avoid undefined behavior with msvc compiler (src/include/port/pg_bitutils.h) 📎 Ranier Vilela 12:37
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 12:38
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 13:03
pg_upgrade fails with in-place tablespace 📎 Rui Zhao 15:10
Faster "SET search_path" 📎 Jeff Davis 15:59
Re: POC, WIP: OR-clause support for indexes Peter Geoghegan 16:15
Re: brininsert optimization opportunity 📎 Soumyadeep Chakraborty 16:28
Re: Faster "SET search_path" Isaac Morland 16:44
Re: add timing information to pg_upgrade Nathan Bossart 21:14
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 21:40
Postmaster doesn't correctly handle crashes in PM_STARTUP state Andres Freund 21:51
CDC/ETL system on top of logical replication with pgoutput, custom client José Neves 23:07
Re: buildfarm instance bichir stuck 📎 Thomas Munro 23:33

July 30, 2023

Thread Author Time
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 00:00
Re: Faster "SET search_path" Nathan Bossart 04:51
Re: Avoid undefined behavior with msvc compiler (src/include/port/pg_bitutils.h) John Naylor 08:07
Re: UUID v7 Andrey M. Borodin 10:08
Re: Avoid undefined behavior with msvc compiler (src/include/port/pg_bitutils.h) Tom Lane 14:45
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" 📎 Anton A. Melnikov 19:22
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" 📎 Anton A. Melnikov 19:30
Re: pg_rewind fails with in-place tablespace Michael Paquier 22:48

July 31, 2023

Thread Author Time
Re: Support to define custom wait events for extensions 📎 Michael Paquier 01:10
Re: New PostgreSQL Contributors Dianjin Wang 01:34
Adding a LogicalRepWorker type field 📎 Peter Smith 01:46
回复：pg_rewind fails with in-place tablespace Rui Zhao 02:07
Re: 回复：pg_rewind fails with in-place tablespace Michael Paquier 02:14
Re: New PostgreSQL Contributors Chris Travers 03:18
Re: New PostgreSQL Contributors Amul Sul 04:37
Re: New PostgreSQL Contributors Rahila Syed 04:51
Re: add timing information to pg_upgrade Bharath Rupireddy 06:04
Re: Support to define custom wait events for extensions Bharath Rupireddy 06:37
Re: Support to define custom wait events for extensions Masahiro Ikeda 06:53
Re: Support to define custom wait events for extensions Michael Paquier 06:55
Re: Support to define custom wait events for extensions 📎 Michael Paquier 07:28
Re: Support to define custom wait events for extensions Masahiro Ikeda 07:49
Re: Avoid undefined behavior with msvc compiler (src/include/port/pg_bitutils.h) John Naylor 07:56
Re: Support to define custom wait events for extensions Bharath Rupireddy 08:07
Re: Support to define custom wait events for extensions Kyotaro Horiguchi 08:10
Re: postgres_fdw: wrong results with self join + enable_nestloop off Richard Guo 08:52
Re: logical decoding and replication of sequences, take 2 Amit Kapila 09:25
Re: Performance degradation on concurrent COPY into a single relation in PG16. John Naylor 09:39
Re: Adding a LogicalRepWorker type field Bharath Rupireddy 09:55
Missing comments/docs about custom scan path 📎 Etsuro Fujita 10:05
Re: Support to define custom wait events for extensions Michael Paquier 10:22
Re: Support to define custom wait events for extensions Michael Paquier 10:24
Re: Support to define custom wait events for extensions Bharath Rupireddy 10:29
Re: Avoid undefined behavior with msvc compiler (src/include/port/pg_bitutils.h) Tom Lane 10:57
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 11:34
Re: Avoid undefined behavior with msvc compiler (src/include/port/pg_bitutils.h) John Naylor 11:55
Re: stats test intermittent failure Masahiko Sawada 12:03
Re: New PostgreSQL Contributors Matthias van de Meent 12:39
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails Alvaro Herrera 12:57
Re: Adding a LogicalRepWorker type field Amit Kapila 13:11
Re: CDC/ETL system on top of logical replication with pgoutput, custom client Amit Kapila 13:31
Re: Improve join_search_one_level readibilty (one line change) Julien Rouhaud 13:48
RE: CDC/ETL system on top of logical replication with pgoutput, custom client José Neves 14:16
Re: CDC/ETL system on top of logical replication with pgoutput, custom client Euler Taveira 14:27
Inaccurate comments in ReorderBufferCheckMemoryLimit() 📎 Masahiko Sawada 15:15
Re: pg_upgrade fails with in-place tablespace Junwang Zhao 15:26
Re: proposal: psql: show current user in prompt Jelte Fennema 15:46
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Alena Rybakina 16:24
Re: Request for comment on setting binary format output per session 📎 Dave Cramer 16:27
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 16:34
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 16:38
Re: pgsql: Fix search_path to a safe value during maintenance operations. Robert Haas 16:53
Re: Faster "SET search_path" Robert Haas 16:55
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan Peter Geoghegan 17:04
Re: pgsql: Fix search_path to a safe value during maintenance operations. Joe Conway 17:17
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 17:51
Re: add timing information to pg_upgrade 📎 Nathan Bossart 18:37

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