pgsql-hackers since 2024-06-29 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)

Browse Archives

Prev | Next

June 29, 2024

Thread Author Time
Re: race condition in pg_class 📎 Noah Misch 02:42
Re: Inval reliability, especially for inplace updates 📎 Noah Misch 03:11
Re: Backporting BackgroundPsql Pavan Deolasee 04:38
Incremental backup from a streaming replication standby Laurenz Albe 05:01
Re: LogwrtResult contended spinlock Alexander Lakhin 07:00
Re: cfbot update: Using GitHub for patch review Jelte Fennema-Nio 08:42
Re: Converting README documentation to Markdown Jelte Fennema-Nio 09:24
Re: LogwrtResult contended spinlock Alvaro Herrera 10:23
Re: LogwrtResult contended spinlock Alexander Lakhin 12:00
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Dean Rasheed 12:22
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Tom Lane 15:25
Re: pgsql: Add more SQL/JSON constructor functions Alvaro Herrera 18:24
Re: pgsql: Add more SQL/JSON constructor functions Tom Lane 18:56
Re: Flush pgstats file during checkpoints Tomas Vondra 21:13
Re: Built-in CTYPE provider Noah Misch 22:08

June 30, 2024

Thread Author Time
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows Noah Misch 02:12
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Dean Rasheed 08:44
Question about maxTapes & selectnewtape & dumptuples Andy Fan 09:48
Re: Question about maxTapes & selectnewtape & dumptuples Heikki Linnakangas 10:22
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Joel Jacobson 10:22
Re: [PATCH] Add ACL (Access Control List) acronym Joel Jacobson 10:27
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Alvaro Herrera 10:41
Re: Question about maxTapes & selectnewtape & dumptuples Andy Fan 11:17
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Joel Jacobson 11:24
Re: speed up a logical replica setup Alexander Lakhin 13:00
Extension using Meson as build system Junwang Zhao 13:17
Re: Extension using Meson as build system Pavel Stehule 13:20
Re: Extension using Meson as build system Junwang Zhao 13:28
Re: Extension using Meson as build system Pavel Stehule 13:31
Re: Extension using Meson as build system Junwang Zhao 13:39
Re: Extension using Meson as build system Pavel Stehule 13:48
Linux likely() unlikely() for PostgreSQL wenhui qiu 13:55
Re: Linux likely() unlikely() for PostgreSQL Matthias van de Meent 14:47
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Joel Jacobson 15:17
Re: Linux likely() unlikely() for PostgreSQL Tom Lane 15:23
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm Tom Lane 15:44
Re: speed up a logical replica setup Tom Lane 16:59
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Noah Misch 17:48
Re: Optimize numeric.c mul_var() using the Karatsuba algorithm 📎 Joel Jacobson 18:30
Re: speed up a logical replica setup Tom Lane 18:40
[PATCH] Handle SK_SEARCHNULL and SK_SEARCHNOTNULL in HeapKeyTest 📎 Sven Klemm 18:45
Re: speed up a logical replica setup Tom Lane 18:58
Re: pg_combinebackup --clone doesn't work 📎 Tomas Vondra 18:58
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel Noah Misch 19:00
Re: speed up a logical replica setup Noah Misch 19:25
Re: speed up a logical replica setup Tom Lane 21:01
Re: speed up a logical replica setup Noah Misch 21:08
RE: Partial aggregates pushdown 📎 [email protected] 21:42
RE: Partial aggregates pushdown [email protected] 22:07
Re: MAINTAIN privilege -- what do we need to un-revert it? Noah Misch 22:23
Re: Faster "SET search_path" Noah Misch 22:30
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel 📎 Jelte Fennema-Nio 22:38
Re: collect_corrupt_items_vacuum.patch Noah Misch 23:18
Re: walsender.c comment with no context is hard to understand 📎 Peter Smith 23:34
Creation of REL_17_STABLE and upcoming Commit Fest 2024-07 Michael Paquier 23:35
Re: Should we document how column DEFAULT expressions work? David Rowley 23:54

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

Browse Archives

Prev | Next