pgsql-hackers - August 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
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

Aug. 1, 2024

Thread Author Time
Re: Remove last traces of HPPA support 📎 Thomas Munro 00:33
Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION Tom Lane 00:59
Re: Add LSN <-> time conversion functionality 📎 Melanie Plageman 01:12
RE: Remove duplicate table scan in logical apply worker and code refactoring 📎 Hayato Kuroda (Fujitsu) 01:59
Re: On disable_cost David Rowley 02:01
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState Andres Freund 02:12
v17 vs v16 performance comparison 📎 Alexander Lakhin 03:00
Re: Evaluate arguments of correlated SubPlans in the referencing ExprState Andres Freund 03:24
RE: Conflict detection and logging in logical replication Zhijie Hou (Fujitsu) 03:39
RE: Conflict detection and logging in logical replication 📎 Zhijie Hou (Fujitsu) 03:40
Re: v17 vs v16 performance comparison Tom Lane 03:41
Re: Speed up JSON escape processing with SIMD plus other optimisations 📎 David Rowley 04:15
Re: Remove last traces of HPPA support 📎 Thomas Munro 05:32
RE: [BUG?] check_exclusion_or_unique_constraint false negative Hayato Kuroda (Fujitsu) 05:54
Re: v17 vs v16 performance comparison Thomas Munro 05:57
RE: Conflict detection and logging in logical replication 📎 Zhijie Hou (Fujitsu) 06:09
Re: proposal: schema variables 📎 Pavel Stehule 06:12
Re: Use pgBufferUsage for block reporting in analyze Anthonin Bonnefoy 06:27
Re: Assertion failure with summarize_wal enabled during pg_createsubscriber Michael Paquier 06:57
Re: v17 vs v16 performance comparison Alexander Lakhin 07:00
Memory growth observed with C++ application consuming libpq.dll on Windows Rajesh Kokkonda 07:06
Re: proposal: schema variables Erik Rijkers 07:45
Re: proposal: schema variables Pavel Stehule 07:48
Re: Pgoutput not capturing the generated columns 📎 Peter Smith 08:32
Query results vary depending on the plan cache mode used Richard Guo 08:44
Re: Remove duplicate table scan in logical apply worker and code refactoring Amit Kapila 08:55
RE: Conflict detection and logging in logical replication Hayato Kuroda (Fujitsu) 08:56
Re: Improving tracking/processing of buildfarm test failures 📎 Alexander Lakhin 09:00
Re: Comment in portal.h Etsuro Fujita 09:05
Re: [BUG?] check_exclusion_or_unique_constraint false negative Michail Nikolaev 09:25
Re: rare crash - FailedAssertion snapbuild.c Line: 580 Pradeep Kumar 09:59
Re: make pg_createsubscriber option names more consistent Peter Eisentraut 10:32
Re: Add LSN <-> time conversion functionality Andrey M. Borodin 10:37
Re: PG17beta2: SMGR: inconsistent type for nblocks 📎 Matthias van de Meent 10:45
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 10:54
Re: can we mark upper/lower/textlike functions leakproof? Laurenz Albe 11:17
Re: proposal: schema variables Laurenz Albe 11:22
Re: proposal: schema variables Pavel Stehule 11:24
Re: Adding OLD/NEW support to RETURNING 📎 Dean Rasheed 11:33
Re: Conflict detection and logging in logical replication Amit Kapila 11:53
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Yasir 11:57
Re: can we mark upper/lower/textlike functions leakproof? Robert Haas 11:57
Re: [Patch] remove duplicated smgrclose 📎 Junwang Zhao 12:32
Re: pg_verifybackup: TAR format backup verification 📎 Amul Sul 13:18
Re: Why is citext/regress failing on hamerkop? 📎 Oleg Tselebrovskiy 13:37
Re: can we mark upper/lower/textlike functions leakproof? Joe Conway 13:54
Re: can we mark upper/lower/textlike functions leakproof? Joe Conway 14:05
Re: can we mark upper/lower/textlike functions leakproof? Tom Lane 14:26
Re: Query results vary depending on the plan cache mode used Tom Lane 14:34
Re: can we mark upper/lower/textlike functions leakproof? Robert Haas 14:43
Official devcontainer config 📎 Junwang Zhao 14:56
Re: [PATCH] Add crc32(text) & crc32(bytea) Nathan Bossart 16:21
Re: Official devcontainer config Jelte Fennema-Nio 16:29
Re: PG17beta2: SMGR: inconsistent type for nblocks Andres Freund 16:44
pg_dump: optimize dumpFunc() 📎 Nathan Bossart 16:52
Re: SQL:2011 application time 📎 Paul Jungwirth 17:09
Re: Flush pgstats file during checkpoints 📎 Michael Paquier 17:11
Re: [Proposal] Add foreign-server health checks infrastructure Fujii Masao 17:29
Re: PG17beta2: SMGR: inconsistent type for nblocks Matthias van de Meent 17:29
Re: optimizing pg_upgrade's once-in-each-database steps Nathan Bossart 17:44
Re: On disable_cost 📎 Robert Haas 18:03
Re: rare crash - FailedAssertion snapbuild.c Line: 580 Euler Taveira 18:09
Inconsistency with EXPLAIN ANALYZE CREATE MATERIALIZED VIEW Jeff Davis 18:27
Re: MAINTAIN privilege -- what do we need to un-revert it? Jeff Davis 18:31
Re: Inconsistency with EXPLAIN ANALYZE CREATE MATERIALIZED VIEW Kirill Reshke 18:41
Re: Asymmetric partition-wise JOIN Alexander Korotkov 18:56
Re: Inconsistency with EXPLAIN ANALYZE CREATE MATERIALIZED VIEW Kirill Reshke 19:13
Re: Support LIKE with nondeterministic collations Daniel Verite 19:55
Re: Inconsistency with EXPLAIN ANALYZE CREATE MATERIALIZED VIEW Jeff Davis 20:34
Re: can we mark upper/lower/textlike functions leakproof? Jacob Champion 20:45
Re: can we mark upper/lower/textlike functions leakproof? Jacob Champion 20:51
Re: Pluggable cumulative statistics 📎 Michael Paquier 20:53
Re: Improving tracking/processing of buildfarm test failures Andrew Dunstan 21:19
Re: Official devcontainer config Andrew Dunstan 21:38
Re: optimizing pg_upgrade's once-in-each-database steps 📎 Nathan Bossart 21:41
Re: proposal: schema variables 📎 Pavel Stehule 22:02
Re: Asymmetric partition-wise JOIN Alexander Korotkov 22:51
Casts from jsonb to other types should cope with json null 📎 Tom Lane 22:51
Re: Why is citext/regress failing on hamerkop? Thomas Munro 22:54
Re: Use pgBufferUsage for block reporting in analyze Masahiko Sawada 23:11
Re: Casts from jsonb to other types should cope with json null Maciek Sakrejda 23:29
Re: Casts from jsonb to other types should cope with json null Tom Lane 23:44
Re: Refactoring postmaster's code to cleanup after child exit 📎 Heikki Linnakangas 23:57

Aug. 2, 2024

Thread Author Time
Re: can we mark upper/lower/textlike functions leakproof? Robert Haas 01:02
Re: PG buildfarm member cisticola Thomas Munro 01:27
Re: Query results vary depending on the plan cache mode used Richard Guo 01:27
Re: CI, macports, darwin version problems Thomas Munro 01:42
wrong translation file reference in pg_createsubscriber 📎 Kyotaro Horiguchi 02:57
Re: On disable_cost David Rowley 03:34
Re: rare crash - FailedAssertion snapbuild.c Line: 580 Alexander Lakhin 04:00
Re: Query results vary depending on the plan cache mode used Tom Lane 04:00
Re: [Patch] remove duplicated smgrclose Steven Niu 04:12
Re: Pgoutput not capturing the generated columns 📎 Shubham Khanna 04:26
Casts from jsonb to other types should cope with json null David G. Johnston 04:36
Re: [BUG?] check_exclusion_or_unique_constraint false negative Amit Kapila 04:56
Re: [Patch] remove duplicated smgrclose Junwang Zhao 05:22
Re: pg_dump: optimize dumpFunc() Tom Lane 05:33
RE: [Proposal] Add foreign-server health checks infrastructure 📎 Hayato Kuroda (Fujitsu) 05:56
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 06:09
Re: Statistics Import and Export Jeff Davis 06:44
Re: Recovery of .partial WAL segments Stefan Fercot 06:47
Re: MAINTAIN privilege -- what do we need to un-revert it? 📎 Yugo NAGATA 07:13
Re: Adding OLD/NEW support to RETURNING jian he 07:25
Re: why there is not VACUUM FULL CONCURRENTLY? Kirill Reshke 07:28
Re: [Patch] remove duplicated smgrclose Steven Niu 07:36
Set query_id for query contained in utility statement 📎 Anthonin Bonnefoy 08:21
Small refactoring around vacuum_open_relation 📎 Kirill Reshke 08:25
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Rajesh Kokkonda 08:53
Re: Logical Replication of sequences shveta malik 08:54
Re: v17 vs v16 performance comparison 📎 Alexander Lakhin 09:00
Re: Logical Replication of sequences shveta malik 09:03
Re: [PATCH] Add min/max aggregate functions to BYTEA Andrey M. Borodin 09:20
Re: Small refactoring around vacuum_open_relation Ashutosh Bapat 09:31
Re: Wrong results with grouping sets 📎 Richard Guo 09:45
Re: Adding OLD/NEW support to RETURNING 📎 Dean Rasheed 10:12
Re: Small refactoring around vacuum_open_relation 📎 Kirill Reshke 10:30
Remove obsolete RECHECK keyword completely 📎 Peter Eisentraut 10:41
Re: Conflict detection and logging in logical replication 📎 Amit Kapila 11:03
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Yasir 11:36
Re: pg_verifybackup: TAR format backup verification 📎 Amul Sul 11:43
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Rajesh Kokkonda 11:45
Re: CI, macports, darwin version problems Joe Conway 12:07
Re: Psql meta-command conninfo+ 📎 Hunaid Sohail 12:11
Re: On disable_cost Robert Haas 12:17
Re: Conflict detection and logging in logical replication Nisha Moond 12:58
Re: On disable_cost David Rowley 13:13
Re: pg_combinebackup does not detect missing files 📎 Robert Haas 13:37
Re: can we mark upper/lower/textlike functions leakproof? Jacob Champion 13:48
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Tom Lane 13:53
Re: Remove obsolete RECHECK keyword completely Tom Lane 13:55
Re: can we mark upper/lower/textlike functions leakproof? Joe Conway 13:58
Re: Why is citext/regress failing on hamerkop? David E. Wheeler 14:11
Re: can we mark upper/lower/textlike functions leakproof? David G. Johnston 14:14
Re: can we mark upper/lower/textlike functions leakproof? Tom Lane 15:07
Re: Parallel CREATE INDEX for GIN indexes Matthias van de Meent 15:37
Re: Injection points: preloading and runtime arguments 📎 Andrey M. Borodin 16:03
Re: On disable_cost Robert Haas 16:04
Re: wrong translation file reference in pg_createsubscriber Alvaro Herrera 16:07
Re: can we mark upper/lower/textlike functions leakproof? Joe Conway 16:13
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Ranier Vilela 16:15
Re: can we mark upper/lower/textlike functions leakproof? Jacob Champion 16:22
Re: can we mark upper/lower/textlike functions leakproof? Robert Haas 16:22
Re: can we mark upper/lower/textlike functions leakproof? Jacob Champion 16:33
Re: Memory growth observed with C++ application consuming libpq.dll on Windows Rajesh Kokkonda 16:49
Re: On disable_cost Tom Lane 16:51
Re: On disable_cost Robert Haas 16:53
Re: [BUG?] check_exclusion_or_unique_constraint false negative 📎 Michail Nikolaev 17:08
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 17:13
Re: New compiler warnings in buildfarm Peter Eisentraut 17:22
Re: can we mark upper/lower/textlike functions leakproof? Robert Haas 17:39
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 17:51
Re: can we mark upper/lower/textlike functions leakproof? Jacob Champion 18:18
pgsql: Implement pg_wal_replay_wait() stored procedure Alexander Korotkov 18:22
Re: Official devcontainer config Peter Eisentraut 18:45
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 18:48
Re: New compiler warnings in buildfarm Tom Lane 19:00
Fix memory counter update in reorderbuffer 📎 Masahiko Sawada 19:50
Re: meson "experimental"? Noah Misch 19:52
Re: pg_dump: optimize dumpFunc() Nathan Bossart 20:00
Draft release notes for next week's releases are up Tom Lane 20:26
Re: Why is citext/regress failing on hamerkop? Thomas Munro 22:02

Aug. 3, 2024

Thread Author Time
Re: [HACKERS] make async slave to wait for lsn to be replayed Kevin Hale Boyes 00:44
Re: [HACKERS] make async slave to wait for lsn to be replayed Alexander Korotkov 03:07
Re: proposal: schema variables 📎 Pavel Stehule 05:40
Re: strange context message in spi.c? Umar Hayat 05:43
Re: WIP: parallel GiST index builds Andreas Karlsson 09:25
Fix inappropriate uses of atol() 📎 Peter Eisentraut 11:04
Re: Official devcontainer config Andrew Dunstan 11:30
Re: consider -Wmissing-variable-declarations Peter Eisentraut 12:15
Re: Fix inappropriate uses of atol() Heikki Linnakangas 14:07
Re: Speed up JSON escape processing with SIMD plus other optimisations 📎 David Rowley 14:11
Re: Draft release notes for next week's releases are up Melanie Plageman 15:14
Re: Fix inappropriate uses of atol() Tom Lane 15:20
Re: Fix inappropriate uses of atol() Heikki Linnakangas 15:27
Re: Draft release notes for next week's releases are up Tom Lane 15:27
Broken layout: CommitFest Add Review Form 📎 Umar Hayat 15:40
Re: Injection points: preloading and runtime arguments Michael Paquier 16:02
Re: Fix inappropriate uses of atol() Tom Lane 16:05
Re: pg_dump: optimize dumpFunc() Neil Conway 18:50
Re: Adding skip scan (including MDAM style range skip scan) to nbtree Dmitry Dolgov 19:34
Re: Casts from jsonb to other types should cope with json null 📎 Tom Lane 20:10
Re: consider -Wmissing-variable-declarations Tom Lane 20:46
Re: Adding skip scan (including MDAM style range skip scan) to nbtree Peter Geoghegan 22:14
Re: Adding skip scan (including MDAM style range skip scan) to nbtree Peter Geoghegan 22:21

Aug. 4, 2024

Thread Author Time
subquery and sub-SELECT Tatsuo Ishii 01:48
Re: Official devcontainer config Junwang Zhao 01:59
Re: Official devcontainer config Junwang Zhao 02:02
Re: Official devcontainer config Junwang Zhao 02:07
Re: Official devcontainer config Junwang Zhao 02:13
Re: subquery and sub-SELECT Tom Lane 02:22
Re: subquery and sub-SELECT Tatsuo Ishii 02:30
Re: PG 17 and GUC variables Robert Treat 03:29
Re: Statistics Import and Export Corey Huinker 05:09
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Imran Zaheer 07:02
RE: Conflict detection and logging in logical replication Zhijie Hou (Fujitsu) 07:34
RE: Conflict detection and logging in logical replication 📎 Zhijie Hou (Fujitsu) 07:52
Re: PG 17 and GUC variables 📎 Heikki Linnakangas 08:45
Re: UUID v7 📎 Andrey M. Borodin 10:50
Re: Official devcontainer config Andrew Dunstan 14:12
Re: PG 17 and GUC variables 📎 Robert Treat 14:28

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