pgsql-hackers since 2023-07-08 19:34

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

July 8, 2023

Thread Author Time
Re: Cleaning up array_in() 📎 Tom Lane 19:34
Re: Cleaning up array_in() 📎 Heikki Linnakangas 19:38
Re: DecodeInterval fixes Gurjeet Singh 19:47
Re: Cleaning up array_in() Tom Lane 19:49
Re: Cleaning up array_in() Heikki Linnakangas 20:03
Re: DecodeInterval fixes Tom Lane 20:33
Re: Preventing non-superusers from altering session authorization Joseph Koshakow 20:44
Re: DecodeInterval fixes Gurjeet Singh 21:05
Re: Reducing connection overhead in pg_upgrade compat check phase Nathan Bossart 21:43
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) Heikki Linnakangas 21:57
Re: Preventing non-superusers from altering session authorization Nathan Bossart 22:09
Re: Preventing non-superusers from altering session authorization 📎 Joseph Koshakow 23:08

July 9, 2023

Thread Author Time
Re: check_strxfrm_bug() Thomas Munro 00:03
Re: Check lateral references within PHVs for memoize cache keys David Rowley 01:11
Re: Exclusion constraints on partitioned tables 📎 Paul A Jungwirth 01:21
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns 📎 Zhang Mingli 03:51
Re: Initial Schema Sync for Logical Replication Amit Kapila 03:59
Re: Check lateral references within PHVs for memoize cache keys David Rowley 04:17
Re: Autogenerate some wait events code and documentation 📎 Michael Paquier 04:32
Re: Preventing non-superusers from altering session authorization 📎 Nathan Bossart 04:47
Re: check_strxfrm_bug() Peter Eisentraut 06:20
Re: check_strxfrm_bug() Thomas Munro 06:35
Re: [PATCH] Remove unnecessary unbind in LDAP search+bind mode Peter Eisentraut 06:57
Re: BUG #18016: REINDEX TABLE failure Gurjeet Singh 07:01
Re: Autogenerate some wait events code and documentation Drouvot, Bertrand 07:15
Re: Fix last unitialized memory warning Peter Eisentraut 07:23
Re: Synchronizing slots from primary to standby 📎 Bharath Rupireddy 07:30
Re: Autogenerate some wait events code and documentation Michael Paquier 07:36
Re: BUG #18016: REINDEX TABLE failure Michael Paquier 07:55
Re: psql: Add role's membership options to the \du+ command Pavel Luzanov 10:56
RE: BUG #18016: REINDEX TABLE failure Richard Veselý 13:54
Re: BUG #18016: REINDEX TABLE failure Tom Lane 14:18
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) Tomas Vondra 16:16
Re: Preventing non-superusers from altering session authorization 📎 Joseph Koshakow 17:03
Re: DecodeInterval fixes 📎 Joseph Koshakow 17:24
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) Heikki Linnakangas 18:05
Re: [PATCH] Remove unnecessary unbind in LDAP search+bind mode Anatoly Zaretsky 18:11
Re: RFC: pg_stat_logmsg Joe Conway 18:13
Re: DecodeInterval fixes reid.thompson 19:11
Re: Support logical replication of DDLs Zheng Li 19:22
Re: BRIN indexes vs. SK_SEARCHARRAY (and preprocessing scan keys) Tomas Vondra 21:44
Re: Cleaning up threading code 📎 Thomas Munro 22:45

July 10, 2023

Thread Author Time
Re: Preventing non-superusers from altering session authorization Joseph Koshakow 00:54
Re: Add hint message for check_log_destination() Japin Li 01:04
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower David Rowley 02:14
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. Peter Smith 02:24
RE: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Hayato Kuroda (Fujitsu) 02:37
Re: check_strxfrm_bug() 📎 Thomas Munro 02:51
Re: POC, WIP: OR-clause support for indexes 📎 Andrey Lepikhov 03:12
doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL 📎 Hayato Kuroda (Fujitsu) 03:33
RE: [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL Hayato Kuroda (Fujitsu) 03:35
Re: Synchronizing slots from primary to standby Amit Kapila 03:36
Re: Add more sanity checks around callers of changeDependencyFor() Michael Paquier 04:10
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. Amit Kapila 04:21
Re: pg_recvlogical prints bogus error when interrupted Michael Paquier 04:44
Re: Autogenerate some wait events code and documentation Drouvot, Bertrand 05:05
Re: Add hint message for check_log_destination() Kyotaro Horiguchi 05:07
Re: Add hint message for check_log_destination() Michael Paquier 05:17
Re: Autogenerate some wait events code and documentation Michael Paquier 05:20
Re: Autogenerate some wait events code and documentation Drouvot, Bertrand 05:52
RE: Support logical replication of DDLs Zhijie Hou (Fujitsu) 06:04
Re: Add hint message for check_log_destination() Masahiko Sawada 06:23
Re: Standardize type of variable when extending Buffers Kyotaro Horiguchi 06:27
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 Richard Guo 06:39
Re: Should we remove db_user_namespace? Michael Paquier 06:43
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 07:08
Re: Autogenerate some wait events code and documentation Alvaro Herrera 07:11
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 07:23
RE: Partial aggregates pushdown 📎 [email protected] 07:35
Re: Show various offset arrays for heap WAL records 📎 Heikki Linnakangas 07:44
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Peter Smith 07:44
Valgrind errors on 32-bit OS 📎 o.tselebrovskiy 07:51
Check invalid pages at the end of recovery to alarm lost data 📎 王伟 (学弈) 07:53
Re: add non-option reordering to in-tree getopt_long Kyotaro Horiguchi 07:57
Re: pg_usleep for multisecond delays Daniel Gustafsson 08:12
Re: [PATCH] Slight improvement of worker_spi.c example Daniel Gustafsson 08:18
Re: Eliminating SPI from RI triggers - take 2 Daniel Gustafsson 08:27
Re: Eliminating SPI from RI triggers - take 2 Amit Langote 08:30
Re: POC, WIP: OR-clause support for indexes 📎 Alena Rybakina 08:38
RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL 📎 Hayato Kuroda (Fujitsu) 09:03
Re: RADIUS tests and improvements Daniel Gustafsson 09:08
Re: Split index and table statistics into different types of stats Daniel Gustafsson 09:14
Re: Cross-database SERIALIZABLE safe snapshots 📎 Heikki Linnakangas 09:17
[Question] Can someone provide some links related to the MemoryContext? Wen Yi 09:20
Re: Prefetch the next tuple's memory during seqscans 📎 Daniel Gustafsson 09:32
Re: Prefetch the next tuple's memory during seqscans 📎 Daniel Gustafsson 09:34
Re: Some revises in adding sorting path Daniel Gustafsson 09:37
Re: gcc -Wclobbered in PostgresMain Sergey Shinderuk 09:39
Re: [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL Amit Kapila 09:54
Re: Request for comment on setting binary format output per session Daniel Gustafsson 09:56
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Amit Kapila 10:16
Re: PATCH: Using BRIN indexes for sorted output Matthias van de Meent 10:22
Re: optimize several list functions with SIMD intrinsics Heikki Linnakangas 10:50
Re:doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Sergei Kornilov 11:03
RE: Initial Schema Sync for Logical Replication Kumar, Sachin 11:06
Re: Standardize type of variable when extending Buffers Ranier Vilela 11:08
Re: PATCH: Using BRIN indexes for sorted output Tomas Vondra 11:43
Re: POC, WIP: OR-clause support for indexes Ranier Vilela 12:03
Re: POC, WIP: OR-clause support for indexes Ranier Vilela 12:15
Re: [PATCH] Allow Postgres to pick an unused port to listen Daniel Gustafsson 12:27
Re: HOT readme missing documentation on summarizing index handling Aleksander Alekseev 12:33
Re: ResourceOwner refactoring Peter Eisentraut 12:37
Re: PATCH: Using BRIN indexes for sorted output Matthias van de Meent 12:38
Re: [PATCH] Slight improvement of worker_spi.c example Aleksander Alekseev 12:40
Re: [PATCH] Slight improvement of worker_spi.c example Daniel Gustafsson 12:44
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Amit Kapila 12:46
Re: [PATCH] Infinite loop while acquiring new TOAST Oid Aleksander Alekseev 12:50
Re: remaining sql/json patches 📎 Amit Langote 12:56
Re: Things I don't like about \du's "Attributes" column Pavel Luzanov 13:10
Re: Performance degradation on concurrent COPY into a single relation in PG16. Alvaro Herrera 13:25
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Sergei Kornilov 13:56
Re: Exclusion constraints on partitioned tables Peter Eisentraut 14:05
Re: [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL Önder Kalacı 14:13
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 14:22
Re: check_strxfrm_bug() Peter Eisentraut 14:28
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Melih Mutlu 14:31
Re: Changing types of block and chunk sizes in memory contexts 📎 Melih Mutlu 14:41
Re: Reducing connection overhead in pg_upgrade compat check phase 📎 Daniel Gustafsson 14:43
Re: remaining sql/json patches Alvaro Herrera 14:47
Re: Add more sanity checks around callers of changeDependencyFor() Tom Lane 14:51
Re: remaining sql/json patches Alvaro Herrera 14:51
Re: Add more sanity checks around callers of changeDependencyFor() Alvaro Herrera 14:55
Re: Add more sanity checks around callers of changeDependencyFor() Tom Lane 15:04
Re: Exclusion constraints on partitioned tables Paul A Jungwirth 15:06
Re: PATCH: Using BRIN indexes for sorted output 📎 Tomas Vondra 15:09
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 15:28
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 15:34
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 15:44
Re: gcc -Wclobbered in PostgresMain Tom Lane 16:17
Re: PATCH: Using BRIN indexes for sorted output Matthias van de Meent 16:18
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 16:24
Re: BUG #18016: REINDEX TABLE failure 📎 Gurjeet Singh 16:35
Re: BUG #18016: REINDEX TABLE failure Gurjeet Singh 16:43
Re: UUID v7 Peter Eisentraut 16:50
Re: cataloguing NOT NULL constraints 📎 Alvaro Herrera 16:52
Re: DecodeInterval fixes Reid Thompson 17:14
Re: Problems with estimating OR conditions, IS NULL on LEFT JOINs 📎 Alena Rybakina 17:25
Re: pg_usleep for multisecond delays Nathan Bossart 17:39
Re: DecodeInterval fixes Jacob Champion 17:42
Re: Should we remove db_user_namespace? Nathan Bossart 17:47
Re: add non-option reordering to in-tree getopt_long Nathan Bossart 18:12
stats test intermittent failure 📎 Melanie Plageman 18:35
Re: pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value Sergei Kornilov 18:39
Re: ResourceOwner refactoring Andres Freund 19:14
Re: ResourceOwner refactoring Andres Freund 19:40
Re: PATCH: Using BRIN indexes for sorted output Tomas Vondra 20:04
Re: add non-option reordering to in-tree getopt_long 📎 Nathan Bossart 20:06
Re: Preventing non-superusers from altering session authorization 📎 Nathan Bossart 20:31
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? 📎 Nikolay Samokhvalov 20:36
Re: Preventing non-superusers from altering session authorization Joseph Koshakow 20:46
Re: Preventing non-superusers from altering session authorization Nathan Bossart 20:49
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? Michael Banck 21:02
Re: Refactoring backend fork+exec code Tristan Partin 21:07
Re: Allowing parallel-safe initplans Tom Lane 21:36
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? 📎 Nikolay Samokhvalov 21:37
Re: check_strxfrm_bug() Thomas Munro 21:54
Re: Generating code for query jumbling through gen_node_support.pl Michael Paquier 22:35
Re: Refactoring backend fork+exec code Andres Freund 22:50
Re: Autogenerate some wait events code and documentation Michael Paquier 22:52
Re: [PoC] Implementation of distinct in Window Aggregates Andreas Karlsson 23:06
Re: Reducing connection overhead in pg_upgrade compat check phase Nathan Bossart 23:09
Re: sslinfo extension - add notbefore and notafter timestamps 📎 Cary Huang 23:09
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 23:21
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. Peter Smith 23:23
Re: Reducing connection overhead in pg_upgrade compat check phase Daniel Gustafsson 23:26
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 23:50
Re: Add bump memory context type and use it for tuplesorts 📎 David Rowley 23:51

July 11, 2023

Thread Author Time
Re: WAL Insertion Lock Improvements Michael Paquier 00:20
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 00:52
Re: Add hint message for check_log_destination() Japin Li 01:24
Re: Add more sanity checks around callers of changeDependencyFor() Michael Paquier 01:40
pg16b2: REINDEX segv on null pointer in RemoveFromWaitQueue Justin Pryzby 02:01
Re: Performance degradation on concurrent COPY into a single relation in PG16. Masahiko Sawada 02:02
Re: Performance degradation on concurrent COPY into a single relation in PG16. Masahiko Sawada 02:32
Re: [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL Amit Kapila 02:33
Got FATAL in lock_twophase_recover() during recovery 📎 suyu.cmj 02:35
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 02:36
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 02:59
Re: Make pgbench exit on SIGINT more reliably Michael Paquier 03:29
Re: Cleaning up array_in() jian he 03:34
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Amit Kapila 03:44
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. Amit Kapila 04:05
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Amit Kapila 04:30
Re: Autogenerate some wait events code and documentation Drouvot, Bertrand 04:54
Re: Use COPY for populating all pgbench tables Michael Paquier 05:03
RE: [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL 📎 Hayato Kuroda (Fujitsu) 05:17
Re: Show various offset arrays for heap WAL records Peter Geoghegan 05:29
Re: Generating code for query jumbling through gen_node_support.pl Andrey Lepikhov 05:29
unrecognized node type while displaying a Path due to dangling pointer Jeevan Chalke 05:31
Re: Generating code for query jumbling through gen_node_support.pl Michael Paquier 05:35
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. 📎 Masahiko Sawada 05:47
Re: Exclusion constraints on partitioned tables 📎 Paul A Jungwirth 05:52
Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada 05:54
Re: Initial Schema Sync for Logical Replication Masahiko Sawada 06:21
Re: Generating code for query jumbling through gen_node_support.pl Andrey Lepikhov 06:44
RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL 📎 Hayato Kuroda (Fujitsu) 07:00
RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Hayato Kuroda (Fujitsu) 07:04
Re: Performance degradation on concurrent COPY into a single relation in PG16. Jakub Wartak 07:09
Re: add non-option reordering to in-tree getopt_long Kyotaro Horiguchi 07:16
RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Hayato Kuroda (Fujitsu) 07:17

Browse Archives

Prev | Next