pgsql-hackers - July 2024

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

July 1, 2024

Thread	Author	Time
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	00:15
Re: PostgreSQL does not compile on macOS SDK 15.0	Thomas Munro	00:40
Re: Should we document how column DEFAULT expressions work?	David Rowley	00:47
Re: [PATCH] Add ACL (Access Control List) acronym	Michael Paquier	01:00
Re: PgStat_KindInfo.named_on_disk not required in shared stats	Michael Paquier	01:04
Re: speed up a logical replica setup	Tom Lane	01:32
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	01:41
Re: Linux likely() unlikely() for PostgreSQL	wenhui qiu	01:52
Re: PostgreSQL does not compile on macOS SDK 15.0	Tom Lane	02:06
Re: Linux likely() unlikely() for PostgreSQL	Peter Geoghegan	02:07
Re: Linux likely() unlikely() for PostgreSQL	David Rowley	02:22
Re: speed up a logical replica setup	Noah Misch	02:33
Re: Should we document how column DEFAULT expressions work?	David Rowley	02:52
RE: Improve EXPLAIN output for multicolumn B-Tree Index	Masahiro.Ikeda	02:53
RE: Improve EXPLAIN output for multicolumn B-Tree Index	Masahiro.Ikeda	02:55
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	03:08
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	03:14
Re: speed up a logical replica setup	Tom Lane	03:22
Re: Track the amount of time waiting due to cost_delay	Bertrand Drouvot	04:59
Re: long-standing data loss bug in initial sync of logical replication 📎	vignesh C	05:20
Re: Use pgstat_kind_infos to read fixed shared stats structs	Michael Paquier	05:48
Assertion failure with summarize_wal enabled during pg_createsubscriber	Fujii Masao	05:54
Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)	Ashutosh Bapat	05:55
Optimize numeric multiplication for one and two base-NBASE digit multiplicands. 📎	Joel Jacobson	06:04
Re: [PATCH] Fix docs to use canonical links	Michael Paquier	06:06
Re: Assertion failure with summarize_wal enabled during pg_createsubscriber	Michael Paquier	06:07
RE: pg_createsubscriber: drop pre-existing subscriptions from the converted node 📎	Hayato Kuroda (Fujitsu)	06:14
Re: Conflict Detection and Resolution	Masahiko Sawada	06:16
Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING 📎	Bertrand Drouvot	06:42
Re: Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING	Bharath Rupireddy	07:05
Re: Virtual generated columns	Peter Eisentraut	07:06
Re: pgsql: Add more SQL/JSON constructor functions 📎	jian he	07:10
Re: Logical Replication of sequences 📎	Peter Smith	07:27
Re: [PATCH] Fix docs to use canonical links	Daniel Gustafsson	07:35
Re: Backporting BackgroundPsql	Daniel Gustafsson	07:39
Re: Conflict Detection and Resolution	Ajin Cherian	07:47
Re: Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING	Bertrand Drouvot	07:52
Re: Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING	Michael Paquier	08:01
Re: Conflict Detection and Resolution	Masahiko Sawada	08:05
Re: Adminpack removal	Daniel Gustafsson	08:07
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. 📎	Joel Jacobson	08:07
Re: Wrong results with grouping sets 📎	Richard Guo	08:29
Re: Is missing LOGIN Event on Trigger Firing Matrix ? 📎	Daniel Gustafsson	08:45
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Daniel Gustafsson	08:52
Make tuple deformation faster 📎	David Rowley	08:55
Re: LogwrtResult contended spinlock 📎	Alvaro Herrera	09:10
Re: doc: modify the comment in function libpqrcv_check_conninfo()	Jelte Fennema-Nio	09:15
Re: Make tuple deformation faster	Andy Fan	09:17
Re: A new strategy for pull-up correlated ANY_SUBLINK	Andrei Lepikhov	09:17
Re: Add memory context type to pg_backend_memory_contexts view	David Rowley	09:20
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Daniel Gustafsson	09:20
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	09:39
Re: Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING	Bertrand Drouvot	09:41
Re: Converting README documentation to Markdown	Daniel Gustafsson	09:42
Re: Conflict Detection and Resolution	Amit Kapila	09:43
Re: Conflict Detection and Resolution	Amit Kapila	09:54
Re: cfbot update: Using GitHub for patch review	Ashutosh Bapat	10:01
Re: Make tuple deformation faster	David Rowley	10:07
Re: Make tuple deformation faster	Matthias van de Meent	10:07
Alias of VALUES RTE in explain plan	Ashutosh Bapat	10:17
Re: Converting README documentation to Markdown 📎	Daniel Gustafsson	10:22
gamma() and lgamma() functions 📎	Dean Rasheed	10:33
Re: Pgoutput not capturing the generated columns 📎	Shubham Khanna	10:38
Re: New standby_slot_names GUC in PG 17	Amit Kapila	10:44
Re: pgsql: Add more SQL/JSON constructor functions 📎	Amit Langote	10:45
Re: Make tuple deformation faster	David Rowley	10:49
Re: Virtual generated columns	Peter Eisentraut	10:56
Re: Virtual generated columns	Peter Eisentraut	10:59
Re: [PATCH] Fix docs to use canonical links	Joel Jacobson	11:09
Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)	David Christensen	11:28
Re: Make tuple deformation faster	Matthias van de Meent	11:42
Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node	Amit Kapila	12:06
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.	Dagfinn Ilmari Mannsåker	12:25
RE: New standby_slot_names GUC in PG 17 📎	Zhijie Hou (Fujitsu)	12:31
Re: [PATCH] Fix docs to use canonical links	Daniel Gustafsson	12:45
psql: Add leakproof field to \dAo+ meta-command results 📎	Yugo NAGATA	13:08
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.	Joel Jacobson	13:11
Re: PATCH: Add query for operators unusable with RLS to documentation	Yugo NAGATA	13:13
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. 📎	Joel Jacobson	13:14
Re: Reg: Alternate way of hashing database role passwords	Daniel Gustafsson	13:25
Re: Should we document how column DEFAULT expressions work?	James Coleman	13:37
Re: Wrong security context for deferred triggers?	Bennie Swart	13:39
Re: [PATCH] Handle SK_SEARCHNULL and SK_SEARCHNOTNULL in HeapKeyTest	Aleksander Alekseev	13:48
Re: LogwrtResult contended spinlock	Tom Lane	14:08
Re: Backporting BackgroundPsql 📎	Pavan Deolasee	14:11
Re: Should we move the resowner field from JitContext to LLVMJitContext?	Daniel Gustafsson	14:19
Re: gamma() and lgamma() functions	Stepan Neretin	14:20
Re: Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING	Tom Lane	14:21
Re: gamma() and lgamma() functions	Daniel Gustafsson	14:22
Re: Should we document how column DEFAULT expressions work?	Peter Eisentraut	14:26
Re: gamma() and lgamma() functions	Stepan Neretin	14:31
Re: LogwrtResult contended spinlock	Alvaro Herrera	14:35
Re: Surround CheckRelation[Oid]LockedByMe() with USE_ASSERT_CHECKING	Bertrand Drouvot	14:38
Re: Should we document how column DEFAULT expressions work?	Tom Lane	14:43
RE: speed up a logical replica setup 📎	Hayato Kuroda (Fujitsu)	14:52
Re: LogwrtResult contended spinlock	Alvaro Herrera	14:54
Re: LogwrtResult contended spinlock	Tom Lane	14:59
jsonpath: Inconsistency of timestamp_tz() Output	David E. Wheeler	15:02
Re: gamma() and lgamma() functions	Alvaro Herrera	15:04
Re: small pg_dump code cleanup	Daniel Gustafsson	15:08
Re: add --no-sync to pg_upgrade's calls to pg_dump and pg_dumpall	Nathan Bossart	15:22
Windows perl/tcl requirement documentation	Andrew Dunstan	15:27
Re: Wrong security context for deferred triggers?	Laurenz Albe	15:45
Re: Restart pg_usleep when interrupted	Sami Imseih	16:16
Re: Backporting BackgroundPsql	Heikki Linnakangas	16:33
Re: pg_sequence_last_value() for unlogged sequences on standbys	Nathan Bossart	16:51
Re: LogwrtResult contended spinlock 📎	Alvaro Herrera	17:04
Re: call for applications: mentoring program for code contributors	Robert Haas	17:15
Re: LogwrtResult contended spinlock	Andres Freund	17:17
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c) 📎	Ranier Vilela	17:35
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c) 📎	Ranier Vilela	17:38
Commitfest manager for July 2024	Andrey M. Borodin	17:40
Re: Remove last traces of HPPA support	Tom Lane	17:56
Re: LogwrtResult contended spinlock	Alvaro Herrera	19:12
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Alvaro Herrera	19:15
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Daniel Gustafsson	19:19
Re: Built-in CTYPE provider	Jeff Davis	19:24
Re: optimizing pg_upgrade's once-in-each-database steps 📎	Nathan Bossart	19:46
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Ranier Vilela	19:47
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. 📎	Joel Jacobson	19:56
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c) 📎	Ranier Vilela	19:58
Re: optimizing pg_upgrade's once-in-each-database steps	Robert Haas	19:58
Re: optimizing pg_upgrade's once-in-each-database steps	Nathan Bossart	20:00
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Daniel Gustafsson	20:08
Re: Commitfest manager for July 2024	Kirill Reshke	20:16
Re: WIP: parallel GiST index builds 📎	Tomas Vondra	20:20
Re: Relation bulk write facility	Noah Misch	20:52
Re: Relation bulk write facility	Heikki Linnakangas	21:53
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. 📎	Dean Rasheed	22:19
Re: Built-in CTYPE provider	Noah Misch	23:03
Re: Relation bulk write facility	Noah Misch	23:24

July 2, 2024

Thread	Author	Time
Re: Parallel CREATE INDEX for GIN indexes 📎	Andy Fan	00:07
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Michael Paquier	00:23
Re: Make tuple deformation faster	David Rowley	00:23
Re: Removing unneeded self joins 📎	jian he	00:25
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Michael Paquier	00:33
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Tom Lane	00:40
Re: Make tuple deformation faster	Andy Fan	01:07
Re: Cleaning up perl code	Michael Paquier	01:11
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Michael Paquier	01:18
Re: Built-in CTYPE provider	Jeff Davis	01:19
CREATE OR REPLACE MATERIALIZED VIEW 📎	Erik Wienhold	01:22
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables	Tom Lane	01:29
Re: Should we document how column DEFAULT expressions work?	David Rowley	01:48
Re: Use pgstat_kind_infos to read fixed shared stats structs	Michael Paquier	03:23
RE: Improve EXPLAIN output for multicolumn B-Tree Index 📎	Masahiro.Ikeda	03:44
Re: Conflict Detection and Resolution	shveta malik	03:54
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	04:23
Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node	Shlok Kyal	04:27
Re: Speed up JSON escape processing with SIMD plus other optimisations 📎	David Rowley	04:49
Re: LogwrtResult contended spinlock	Alexander Lakhin	05:00
Re: Pgoutput not capturing the generated columns	Peter Smith	05:29
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	05:56
Re: pgsql: Add more SQL/JSON constructor functions	jian he	06:19
Re: New standby_slot_names GUC in PG 17	Amit Kapila	06:25
Re: consider -Wmissing-variable-declarations	Peter Eisentraut	06:30
Re: [PATCH] Handle SK_SEARCHNULL and SK_SEARCHNOTNULL in HeapKeyTest	Jelte Fennema-Nio	07:26
Add has_large_object_privilege function 📎	Yugo NAGATA	07:34
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.	Joel Jacobson	07:49
Re: gamma() and lgamma() functions	Dean Rasheed	07:57
Re: Incremental View Maintenance, take 2 📎	Yugo NAGATA	08:03
Re: pgsql: Add more SQL/JSON constructor functions	Amit Langote	08:03
Re: Underscore in positional parameters?	Peter Eisentraut	08:14
Re: [PATCH] Handle SK_SEARCHNULL and SK_SEARCHNOTNULL in HeapKeyTest	Aleksander Alekseev	08:15
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands. 📎	Dean Rasheed	08:22
Re: Underscore in positional parameters?	Erik Wienhold	08:45
Re: Underscore in positional parameters?	Peter Eisentraut	08:45
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.	Joel Jacobson	09:05
Re: Restart pg_usleep when interrupted	Bertrand Drouvot	09:05
Re: Conflict Detection and Resolution	shveta malik	09:09
Re: [PATCH] Handle SK_SEARCHNULL and SK_SEARCHNOTNULL in HeapKeyTest	Jelte Fennema-Nio	09:22
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm	Dean Rasheed	09:34
Re: Underscore in positional parameters?	Erik Wienhold	09:37
Re: Logical Replication of sequences 📎	vignesh C	09:39
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm	Dean Rasheed	09:42
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Daniel Gustafsson	09:44
Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node	Amit Kapila	10:03
Re: New function normal_rand_array function to contrib/tablefunc.	Jim Jones	10:18
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.	Joel Jacobson	10:23
Re: Add pg_get_acl() function get the ACL for a database object 📎	Joel Jacobson	10:38
Test_extensions installcheck fails with ICU provider, workaround 📎	Aleksei Fakeev	10:38
Re: CREATE OR REPLACE MATERIALIZED VIEW	Aleksander Alekseev	10:46
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Ranier Vilela	11:07
Re: Relation bulk write facility 📎	Heikki Linnakangas	11:42
Re: Optimize numeric multiplication for one and two base-NBASE digit multiplicands.	Dean Rasheed	11:44
Re: plenty code is confused about function level static	Ranier Vilela	11:49
Re: LogwrtResult contended spinlock	Alvaro Herrera	11:55
Re: Improving tracking/processing of buildfarm test failures	Alexander Lakhin	12:00
Re: LogwrtResult contended spinlock	Andres Freund	12:17
Re: Use generation memory context for tuplestore.c	Matthias van de Meent	12:20
Re: speed up a logical replica setup	Amit Kapila	12:24
Re: CREATE OR REPLACE MATERIALIZED VIEW	Daniel Gustafsson	12:27
Re: Doc Rework: Section 9.16.13 SQL/JSON Query Functions 📎	Amit Langote	12:38
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Aleksander Alekseev	12:52
Re: Cleaning up perl code 📎	Dagfinn Ilmari Mannsåker	12:55
Re: Inline non-SQL SRFs using SupportRequestSimplify	Heikki Linnakangas	12:59
Re: Parent/child context relation in pg_get_backend_memory_contexts() 📎	Melih Mutlu	13:08
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	13:30
Re: Cannot find a working 64-bit integer type on Illumos	Heikki Linnakangas	13:34
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	13:40

Browse Archives

Prev | Next