pgsql-hackers before 2023-07-24 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 19, 2023

Thread Author Time
Re: Extracting cross-version-upgrade knowledge from buildfarm client Andrew Dunstan 13:07
Re: Disabling Heap-Only Tuples Thom Brown 13:13
Re: Report distinct wait events when waiting for WAL "operation" Amit Kapila 13:19
pg_rewind fails with in-place tablespace 📎 赵锐 (惜元) 13:31
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎 Dmitry Koval 13:43
Re: Remove backend warnings from SSL tests Tom Lane 13:44
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 14:02
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 14:03
Re: Remove backend warnings from SSL tests Tom Lane 14:22
Re: Let's make PostgreSQL multi-threaded Ashutosh Bapat 14:46
Re: [RFC] Add jit deform_counter Dmitry Dolgov 15:18
Re: psql: Add role's membership options to the \du+ command Tom Lane 15:39
Re: Support to define custom wait events for extensions Tristan Partin 15:57
Re: Extracting cross-version-upgrade knowledge from buildfarm client 📎 Alvaro Herrera 16:05
Re: Support to define custom wait events for extensions Tristan Partin 16:16
Re: Row pattern recognition Jacob Champion 16:30
Re: psql: Add role's membership options to the \du+ command Tom Lane 16:47
Re: psql: Add role's membership options to the \du+ command David G. Johnston 16:59
Re: Fix last unitialized memory warning Tristan Partin 17:15
Re: Use of additional index columns in rows filtering Jeff Davis 17:17
Re: There should be a way to use the force flag when restoring databases Gurjeet Singh 17:28
Re: Adding argument names to aggregate functions 📎 Dagfinn Ilmari Mannsåker 17:32
Re: harmonize password reuse in vacuumdb, clusterdb, and reindexdb Nathan Bossart 17:43
Re: psql: Add role's membership options to the \du+ command Pavel Luzanov 17:44
Re: Use COPY for populating all pgbench tables 📎 Tristan Partin 18:01
Re: Use COPY for populating all pgbench tables 📎 Tristan Partin 18:03
Re: Use of additional index columns in rows filtering Tomas Vondra 18:03
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables 📎 Justin Pryzby 18:13
Re: Requiring recovery.signal or standby.signal when recovering with a backup_label David Zhang 18:21
Re: Atomic ops for unlogged LSN John Morris 18:55
Re: Extracting cross-version-upgrade knowledge from buildfarm client Andrew Dunstan 19:20
Re: Adding argument names to aggregate functions Daniel Gustafsson 19:38
Re: Giving more detail in pg_upgrade errormessage 📎 Daniel Gustafsson 20:26
Re: Extracting cross-version-upgrade knowledge from buildfarm client Andrew Dunstan 20:44
Re: Use of additional index columns in rows filtering Jeff Davis 20:46
Re: Extracting cross-version-upgrade knowledge from buildfarm client Andrew Dunstan 20:47
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 21:01
Re: Use of additional index columns in rows filtering Peter Geoghegan 21:38
Re: Move un-parenthesized syntax docs to "compatibility" for few SQL commands Nathan Bossart 22:41
Re: Requiring recovery.signal or standby.signal when recovering with a backup_label 📎 Michael Paquier 23:19
Re: Support to define custom wait events for extensions Michael Paquier 23:34
Re: [PATCH] Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans 📎 Jacob Champion 23:44
Re: Performance degradation on concurrent COPY into a single relation in PG16. 📎 David Rowley 23:56

July 20, 2023

Thread Author Time
Re: pg_recvlogical prints bogus error when interrupted Michael Paquier 00:34
Re: pg_recvlogical prints bogus error when interrupted Michael Paquier 01:25
Re: remaining sql/json patches jian he 01:35
Support worker_spi to execute the function dynamically. 📎 Masahiro Ikeda 02:15
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 02:32
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 02:41
Re: Use COPY for populating all pgbench tables Michael Paquier 03:07
Re: logicalrep_message_type throws an error Amit Kapila 03:40
Re: logicalrep_message_type throws an error 📎 Amit Kapila 03:41
Re: Issue in _bt_getrootheight 📎 Gurjeet Singh 03:45
Re: Support worker_spi to execute the function dynamically. 📎 Michael Paquier 03:55
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 03:59
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 04:10
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 04:13
Re: FATAL: operator class "xxxx" does not exist for access method "btree" mao zhang 04:25
Re: Support worker_spi to execute the function dynamically. Michael Paquier 04:39
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 04:50
Re: Make mesage at end-of-recovery less scary. Kyotaro Horiguchi 05:02
Re: Row pattern recognition Tatsuo Ishii 05:15
Re: Do we want to enable foreign key constraints on subscriber? Amit Kapila 05:17
Re: Report distinct wait events when waiting for WAL "operation" Michael Paquier 05:18
Re: Report distinct wait events when waiting for WAL "operation" Bharath Rupireddy 05:29
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 05:48
Re: ObjectIdGetDatum() missing from SearchSysCache*() callers Michael Paquier 06:28
Re: POC: GROUP BY optimization 📎 Andrey Lepikhov 06:37
Re: There should be a way to use the force flag when restoring databases Joan 06:44
inconsistency between the VM page visibility status and the visibility status of the page 📎 yanhui.xiong 06:44
Re: remaining sql/json patches Amit Langote 07:03
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns Zhang Mingli 07:06
Re: logical decoding and replication of sequences, take 2 📎 Ashutosh Bapat 07:24
Re: Atomic ops for unlogged LSN Bharath Rupireddy 07:28
Re: Assertion failure in SnapBuildInitialSnapshot() Daniel Gustafsson 07:34
Re: remaining sql/json patches 📎 Amit Langote 08:19
Re: Performance degradation on concurrent COPY into a single relation in PG16. 📎 Dean Rasheed 08:36
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 08:38
Re: Support worker_spi to execute the function dynamically. Masahiro Ikeda 08:54
Re: Support worker_spi to execute the function dynamically. 📎 Masahiro Ikeda 09:08
Re: WAL Insertion Lock Improvements 📎 Bharath Rupireddy 09:08
Re: There should be a way to use the force flag when restoring databases Daniel Gustafsson 09:09
Re: Support worker_spi to execute the function dynamically. Michael Paquier 09:29
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 09:39
Re: Extracting cross-version-upgrade knowledge from buildfarm client 📎 Alvaro Herrera 09:52
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 10:14
Re: inconsistency between the VM page visibility status and the visibility status of the page Tomas Vondra 10:16
Re: Partial aggregates pushdown 📎 Alexander Pyhalov 10:23
Re: Synchronizing slots from primary to standby 📎 shveta malik 11:34
Re: Use of additional index columns in rows filtering Tomas Vondra 11:35
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 11:42
Re: POC: GROUP BY optimization Tomas Vondra 11:46
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands stephane tachoires 11:56
Re: Extracting cross-version-upgrade knowledge from buildfarm client Andrew Dunstan 12:29
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 12:37
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Melih Mutlu 13:40
Re: psql: Add role's membership options to the \du+ command Jonathan S. Katz 14:02
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" Daniel Gustafsson 14:37
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 14:51
Re: Printing backtrace of postgres processes Daniel Gustafsson 14:52
Re: sslinfo extension - add notbefore and notafter timestamps Daniel Gustafsson 15:24
Re: cataloguing NOT NULL constraints 📎 Alvaro Herrera 15:31
pg15.3: dereference null *plan in CachedPlanIsSimplyValid/plpgsql Justin Pryzby 15:42
Re: remaining sql/json patches Amit Langote 15:48
Re: pg15.3: dereference null *plan in CachedPlanIsSimplyValid/plpgsql Tom Lane 15:55
Re: remaining sql/json patches Alvaro Herrera 16:02
Re: Atomic ops for unlogged LSN John Morris 16:32
Re: logicalrep_message_type throws an error Ashutosh Bapat 16:39
Re: logical decoding and replication of sequences, take 2 Tomas Vondra 16:49
Re: There should be a way to use the force flag when restoring databases Gurjeet Singh 18:36
Re: Inefficiency in parallel pg_restore with many tables 📎 Nathan Bossart 19:06
Re: Use COPY for populating all pgbench tables 📎 Tristan Partin 19:22
Re: In Postgres 16 BETA, should the ParseNamespaceItem have the same index as it's RangeTableEntry? Farias de Oliveira 20:05
Re: Bytea PL/Perl transform 📎 Ivan Panchenko 21:29
Re: Performance degradation on concurrent COPY into a single relation in PG16. David Rowley 22:35
Re: Atomic ops for unlogged LSN 📎 John Morris 23:13
Re: Row pattern recognition 📎 Jacob Champion 23:36

July 21, 2023

Thread Author Time
Re: Row pattern recognition Vik Fearing 00:07
Re: logicalrep_message_type throws an error Masahiko Sawada 00:57
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. 📎 Masahiko Sawada 01:25
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 01:48
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 02:00
Re: Avoid stack frame setup in performance critical routines using tail calls 📎 David Rowley 02:03
Re: Use COPY for populating all pgbench tables 📎 Michael Paquier 02:14
Re: Support worker_spi to execute the function dynamically. Michael Paquier 03:08
Re: Use of additional index columns in rows filtering Peter Geoghegan 03:32
Buildfarm failures on chipmunk vignesh C 03:40
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 04:09
Re: Buildfarm failures on chipmunk Mingli Zhang 04:13
Re: Buildfarm failures on chipmunk Kyotaro Horiguchi 04:14
Re: POC: GROUP BY optimization Andrey Lepikhov 04:21
PATCH: Add REINDEX tag to event triggers 📎 Garrett Thornburg 04:47
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 05:39
Re: Support worker_spi to execute the function dynamically. 📎 Bharath Rupireddy 05:54
Re: WAL Insertion Lock Improvements Michael Paquier 05:59
Re: Synchronizing slots from primary to standby Bharath Rupireddy 06:05
table_open/table_close with different lock mode Junwang Zhao 06:05
Re: Row pattern recognition Tatsuo Ishii 06:16
Re: MERGE ... RETURNING Gurjeet Singh 06:19
Re: Support worker_spi to execute the function dynamically. Michael Paquier 06:24
Re: table_open/table_close with different lock mode Michael Paquier 06:26
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 06:34
Re: MERGE ... RETURNING Gurjeet Singh 06:37
Re: table_open/table_close with different lock mode Junwang Zhao 06:38
Re: Support worker_spi to execute the function dynamically. Bharath Rupireddy 06:51
Re: table_open/table_close with different lock mode Gurjeet Singh 06:56
Re: table_open/table_close with different lock mode Junwang Zhao 07:01
Re: Atomic ops for unlogged LSN Bharath Rupireddy 07:03
Re: Switching XLog source from archive to streaming when primary available 📎 Bharath Rupireddy 07:08
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 07:24
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 07:30
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 09:47
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 09:48
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 09:51
Assert failure on bms_equal(child_joinrel->relids, child_joinrelids) 📎 Richard Guo 10:02
Re: remaining sql/json patches 📎 Amit Langote 10:33
Re: Support worker_spi to execute the function dynamically. Masahiro Ikeda 10:35
Re: Synchronizing slots from primary to standby shveta malik 11:46
Re: Use of additional index columns in rows filtering Tomas Vondra 11:52
Re: Avoid unused value (src/fe_utils/print.c) 📎 Karina Litskevich 12:13
Re: postgres_fdw: wrong results with self join + enable_nestloop off 📎 Etsuro Fujita 12:51
Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids) Tom Lane 16:02
Re: Support worker_spi to execute the function dynamically. 📎 Bharath Rupireddy 16:05
Re: Use COPY for populating all pgbench tables Tristan Partin 17:22
Re: Issue in _bt_getrootheight Tom Lane 17:41
Re: MERGE ... RETURNING Jeff Davis 18:30
Re: Use of additional index columns in rows filtering Peter Geoghegan 19:17
Re: Show WAL write and fsync stats in pg_stat_io Melanie Plageman 22:30
Re: Fix search_path for all maintenance commands 📎 Jeff Davis 22:32
Re: Row pattern recognition 📎 Jacob Champion 23:14
Re: Row pattern recognition Jacob Champion 23:16
Re: Row pattern recognition Vik Fearing 23:38

July 22, 2023

Thread Author Time
Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt" 📎 Thomas Munro 00:51
Re: Row pattern recognition Tatsuo Ishii 01:11
Re: MERGE ... RETURNING 📎 Dean Rasheed 02:10
Re: Row pattern recognition Vik Fearing 02:54
Re: logicalrep_message_type throws an error Amit Kapila 04:47
Re: Row pattern recognition Tatsuo Ishii 06:14
Re: WAL Insertion Lock Improvements 📎 Bharath Rupireddy 07:38
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. Amit Kapila 10:32
Re: Fix search_path for all maintenance commands Noah Misch 14:04
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 18:28
Re: Fix search_path for all maintenance commands Jeff Davis 18:52
Re: Inefficiency in parallel pg_restore with many tables 📎 Nathan Bossart 23:19
Re: Inefficiency in parallel pg_restore with many tables Nathan Bossart 23:28
Re: Inefficiency in parallel pg_restore with many tables Tom Lane 23:47

July 23, 2023

Thread Author Time
Re: PG 16 draft release notes ready jian he 04:45
Re: Inefficiency in parallel pg_restore with many tables 📎 Nathan Bossart 05:57
Re: remaining sql/json patches jian he 08:17
Re: PG 16 draft release notes ready Pavel Luzanov 11:09
Re: PG 16 draft release notes ready Michael Paquier 11:19
Re: Use COPY for populating all pgbench tables Michael Paquier 11:21
Re: Use of additional index columns in rows filtering Tomas Vondra 12:04
Re: Making Vars outer-join aware Anton A. Melnikov 12:20
Re: There should be a way to use the force flag when restoring databases 📎 Ahmed Ibrahim 13:08
multiple membership grants and information_schema.applicable_roles Pavel Luzanov 18:28
Re: Use of additional index columns in rows filtering Peter Geoghegan 19:56
Re: multiple membership grants and information_schema.applicable_roles Tom Lane 20:03
[BUG] Crash on pgbench initialization. 📎 Anton A. Melnikov 20:21
Re: Row pattern recognition Vik Fearing 21:29

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