pgsql-hackers since 2023-07-09 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 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 πŸ“Ž Fujii.Yuki@df.MitsubishiElectric.co.jp 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
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Amit Kapila 07:37
Re: logical decoding and replication of sequences, take 2 Amit Kapila 07:41
Re: Support to define custom wait events for extensions πŸ“Ž Michael Paquier 07:45
[PATCH]Add a tip to the check mode πŸ“Ž Wen Yi 07:45
Re: unrecognized node type while displaying a Path due to dangling pointer Alvaro Herrera 07:49
Re: logicalrep_message_type throws an error Masahiko Sawada 08:05
Re: doc: improve the restriction description of using indexes on REPLICA IDENTITY FULL table. Peter Smith 08:31
Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL Sergei Kornilov 08:47
Re: POC, WIP: OR-clause support for indexes πŸ“Ž Andrey Lepikhov 08:47
Re: unrecognized node type while displaying a Path due to dangling pointer Jeevan Chalke 09:28
RE: BUG #18016: REINDEX TABLE failure Richard VeselΓ½ 09:31
Re: unrecognized node type while displaying a Path due to dangling pointer πŸ“Ž Jeevan Chalke 09:48

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