pgsql-hackers since 2025-01-01 22:12

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

Jan. 1, 2025

Thread Author Time
Re: POC: make mxidoff 64 bits Heikki Linnakangas 22:12
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 22:50
Incorrect CHUNKHDRSZ in nodeAgg.c 📎 David Rowley 22:55
Re: Incorrect CHUNKHDRSZ in nodeAgg.c Tom Lane 23:18
Re: Typos in the code and README David Rowley 23:22

Jan. 2, 2025

Thread Author Time
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 00:13
Re: Incorrect CHUNKHDRSZ in nodeAgg.c David Rowley 00:23
Re: Incorrect CHUNKHDRSZ in nodeAgg.c Tom Lane 00:33
Re: Incorrect CHUNKHDRSZ in nodeAgg.c David Rowley 00:38
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Roberto C. Sánchez 01:43
Re: Backport of CVE-2024-10978 fix to older pgsql versions (11, 9.6, and 9.4) Bruce Momjian 02:03
Re: System views for versions reporting jian he 02:36
Re: System views for versions reporting Andres Freund 02:45
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 02:46
Re: Windows UTF8 system locale Noah Misch 04:26
Re: Document How Commit Handles Aborted Transactions Gurjeet Singh 06:16
Re: Conflict detection for update_deleted in logical replication Amit Kapila 06:30
Re: Re: proposal: schema variables 📎 Pavel Stehule 06:46
[RFC] Lock-free XLog Reservation from WAL 📎 Zhou, Zhiguo 07:05
[RFC] Lock-free XLog Reservation from WAL 📎 Zhou, Zhiguo 07:20
Re: Avoid orphaned objects dependencies, take 3 📎 Bertrand Drouvot 08:15
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Thomas Munro 08:26
Re: Proposal: Progressive explain jian he 08:52
RFC: Lock-free XLog Reservation from WAL 📎 Zhou, Zhiguo 09:14
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 09:21
Re: Conflict detection for update_deleted in logical replication vignesh C 09:27
Re: ERROR: corrupt MVNDistinct entry Richard Guo 09:30
Re: apply_scanjoin_target_to_paths and partitionwise join Ashutosh Bapat 09:41
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 10:11
Re: Introduce XID age and inactive timeout based replication slot invalidation Nisha Moond 10:26
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 10:27
Re: Conflict detection for update_deleted in logical replication vignesh C 10:34
Re: FileFallocate misbehaving on XFS Andrea Gelmini 10:41
RE: [RFC] Lock-free XLog Reservation from WAL Zhou, Zhiguo 12:16
RE: RFC: Lock-free XLog Reservation from WAL Zhou, Zhiguo 12:19
Re: IWYU annotations Peter Eisentraut 14:03
Re: FileFallocate misbehaving on XFS Andres Freund 14:38
Re: FileFallocate misbehaving on XFS Andres Freund 14:40
Re: Modern SHA2- based password hashes for pgcrypto Daniel Gustafsson 14:57
Re: Modern SHA2- based password hashes for pgcrypto Bernd Helmle 15:17
Re: Modern SHA2- based password hashes for pgcrypto Daniel Gustafsson 15:28
read stream on amcheck 📎 Matheus Alcantara 15:29
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Tom Lane 15:38
Re: IWYU annotations Tom Lane 16:15
Re: read stream on amcheck Kirill Reshke 16:16
Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN 📎 Robert Treat 16:25
Further _bt_first simplifications for parallel index scans 📎 Peter Geoghegan 16:37
Allow NOT VALID foreign key constraints on partitioned tables. 📎 Amul Sul 16:49
Re: read stream on amcheck 📎 Matheus Alcantara 17:53
Re: Switching XLog source from archive to streaming when primary available Andrey M. Borodin 18:12
POC: track vacuum/analyze cumulative time per relation 📎 Sami Imseih 18:24
Re: Allow NOT VALID foreign key constraints on partitioned tables. Álvaro Herrera 18:40
Re: magical eref alias names Robert Haas 19:24
Re: Alias of VALUES RTE in explain plan Robert Haas 19:51
Re: Vacuum statistics Sami Imseih 20:12
Re: Strange issue with NFS mounted PGDATA on ugreen NAS Tom Lane 20:14
Fwd: Re: A new look at old NFS readdir() problems? Larry Rosenman 20:26
Re: magical eref alias names Tom Lane 20:27
Re: apply_scanjoin_target_to_paths and partitionwise join Robert Haas 20:43
[PATCH] Optionally record Plan IDs to track plan changes for a query 📎 Lukas Fittl 20:46
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 20:48
Re: Fwd: Re: A new look at old NFS readdir() problems? Bruce Momjian 20:50
Re: apply_scanjoin_target_to_paths and partitionwise join Tom Lane 20:58
Re: Add the ability to limit the amount of memory that can be allocated to backends. Jim Nasby 21:09
Re: Vacuum statistics Jim Nasby 21:14
Re: Fwd: Re: A new look at old NFS readdir() problems? Larry Rosenman 21:16
Re: magical eref alias names Robert Haas 21:19
Re: apply_scanjoin_target_to_paths and partitionwise join Robert Haas 21:32
Re: Fwd: Re: A new look at old NFS readdir() problems? Robert Haas 21:35
Re: Alias of VALUES RTE in explain plan Tom Lane 21:41
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 21:52
Re: magical eref alias names 📎 Tom Lane 22:11
Re: Vacuum statistics Sami Imseih 22:33
Re: Fwd: Re: A new look at old NFS readdir() problems? Larry Rosenman 22:50
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 22:56
Re: Fwd: Re: A new look at old NFS readdir() problems? Larry Rosenman 22:58
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 23:05
Re: Fwd: Re: A new look at old NFS readdir() problems? Thomas Munro 23:08
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 23:20

Jan. 3, 2025

Thread Author Time
Re: WAL-logging facility for pgstats kinds Andres Freund 01:08
Re: Logical Replication of sequences Peter Smith 01:22
Re: SQL:2011 application time 📎 Paul Jungwirth 01:47
Re: Fwd: Re: A new look at old NFS readdir() problems? 📎 Tom Lane 01:58
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 02:36
Re: Add the ability to limit the amount of memory that can be allocated to backends. Tomas Vondra 03:21
Re: Logical Replication of sequences Peter Smith 03:37
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:52
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 06:35
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Shubham Khanna 06:54
Re: Re: proposal: schema variables 📎 jian he 07:18
Re: Conflict detection for update_deleted in logical replication vignesh C 09:03
Re: Conflict detection for update_deleted in logical replication Amit Kapila 09:46
Re: Logging parallel worker draught Benoit Lobréau 10:25
Re: Conflict detection for update_deleted in logical replication Amit Kapila 10:47
Re: per backend I/O statistics Bertrand Drouvot 10:48
Re: Conflict detection for update_deleted in logical replication Amit Kapila 11:00
Re: [RFC] Lock-free XLog Reservation from WAL Yura Sokolov 12:36
Re: [RFC] Lock-free XLog Reservation from WAL wenhui qiu 13:01
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Bertrand Drouvot 13:14
Re: Fwd: Re: A new look at old NFS readdir() problems? Robert Haas 13:33
Parameter NOT NULL to CREATE DOMAIN not the same as CHECK (VALUE IS NOT NULL) PG Doc comments form 13:39
Re: magical eref alias names Robert Haas 13:44
Re: Define STATS_MIN_ROWS for minimum rows of stats in ANALYZE 📎 Ilia Evdokimov 13:45
Remove unused rel parameter in lookup_var_attr_stats 📎 Ilia Evdokimov 14:09
Re: Vacuum statistics Greg Sabino Mullane 14:15
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Euler Taveira 14:31
Re: Autovacuum giving up on tables after crash because of lack of stats Andres Freund 14:46
Re: Fwd: Re: A new look at old NFS readdir() problems? Greg Sabino Mullane 14:47
Re: Autovacuum giving up on tables after crash because of lack of stats Andres Freund 14:47
Re: Remove unused rel parameter in lookup_var_attr_stats Fabrízio de Royes Mello 15:42
Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays Andrew Dunstan 15:44
Re: Modern SHA2- based password hashes for pgcrypto Japin Li 15:58
Re: Exporting float_to_shortest_decimal_buf(n) with Postgres 17 on Windows Regina Obe 16:08
Re: Autovacuum giving up on tables after crash because of lack of stats Bertrand Drouvot 16:10
Re: relfilenode statistics Bertrand Drouvot 16:18
Re: Logging parallel worker draught Sami Imseih 16:24
Re: Fwd: Re: A new look at old NFS readdir() problems? David Steele 16:48
Re: Modern SHA2- based password hashes for pgcrypto Bernd Helmle 16:55
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 📎 Robert Treat 17:23
Re: Fwd: Re: A new look at old NFS readdir() problems? Peter Eisentraut 17:31
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 18:12
improve DEBUG1 logging of parallel workers for CREATE INDEX? 📎 Sami Imseih 18:30
Re: Vacuum statistics Jim Nasby 19:08
Re: Adding OLD/NEW support to RETURNING Robert Treat 19:39
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎 Peter Geoghegan 19:43
Re: Vacuum statistics Sami Imseih 19:46
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 20:15
Re: pg_attribute_noreturn(), MSVC, C11 Dagfinn Ilmari Mannsåker 20:51
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Sami Imseih 21:09
Re: Add the ability to limit the amount of memory that can be allocated to backends. James Hunter 21:16
Re: Proposal: add new API to stringinfo Andrew Dunstan 22:16
Re: Proposal: add new API to stringinfo Gurjeet Singh 22:55
Re: Re: proposal: schema variables 📎 Pavel Stehule 22:59
Re: Parallel heap vacuum 📎 Masahiko Sawada 23:38
Re: Fwd: Re: A new look at old NFS readdir() problems? Thomas Munro 23:39

Jan. 4, 2025

Thread Author Time
Re: Modern SHA2- based password hashes for pgcrypto Japin Li 00:19
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 00:32
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎 Matthias van de Meent 01:00
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 01:01
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Matthias van de Meent 01:12
Re: Incorrect CHUNKHDRSZ in nodeAgg.c John Naylor 02:24
Re: POC: track vacuum/analyze cumulative time per relation wenhui qiu 03:41
Re: Logical Replication of sequences 📎 vignesh C 04:31
Re: Logical Replication of sequences vignesh C 04:33
Re: FileFallocate misbehaving on XFS Michael Harris 04:34
Re: Proposal: add new API to stringinfo 📎 Tatsuo Ishii 04:54
Re: Sort functions with specialized comparators John Naylor 05:24
Re: Re: proposal: schema variables 📎 Pavel Stehule 05:36
Re: Fwd: Re: A new look at old NFS readdir() problems? Tom Lane 08:15
Re: Fwd: Re: A new look at old NFS readdir() problems? Thomas Munro 16:07
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 16:37
Re: Parallel CREATE INDEX for GIN indexes 📎 Tomas Vondra 16:58
Re: Sort functions with specialized comparators 📎 Andrey M. Borodin 18:15
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 19:35
Re: Converting contrib SQL functions to new style 📎 Tom Lane 20:14
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 20:34
Re: Vacuum statistics Alena Rybakina 20:37
Re: SQL:2011 application time 📎 Paul Jungwirth 21:39
Re: Proposal: Adding compression of temporary files 📎 Filip Janus 22:40
Avoid possible deference NULL pointer (src/backend/optimizer/path/allpaths.c) 📎 Ranier Vilela 23:29
Re: Proposal: Adding compression of temporary files 📎 Filip Janus 23:43

Jan. 5, 2025

Thread Author Time
Re: Proposal: add new API to stringinfo 📎 Tatsuo Ishii 01:51
Re: Proposal: add new API to stringinfo Gurjeet Singh 04:37
Re: Re: proposal: schema variables jian he 04:52
Re: Proposal: add new API to stringinfo Tatsuo Ishii 06:33
Re: Proposal: add new API to stringinfo 📎 Tatsuo Ishii 08:03
Re: Proposal: add new API to stringinfo David Rowley 08:55
Re: meson: Fix missing name arguments of cc.compiles() calls Peter Eisentraut 10:59
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker 📎 vignesh C 12:38
Re: Re: proposal: schema variables jian he 16:10
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size 📎 Peter Smith 21:52
Re: Index AM API cleanup Paul Jungwirth 23:20

Jan. 6, 2025

Thread Author Time
Re: Proposal: add new API to stringinfo 📎 Tatsuo Ishii 01:57
Re: Vacuum statistics Sami Imseih 02:00
RE: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Hayato Kuroda (Fujitsu) 02:29
Re: Adjusting hash join memory limit to handle batch explosion 📎 Tomas Vondra 02:59
Re: Conflict detection for update_deleted in logical replication Amit Kapila 03:15
Re: Documentation update of wal_retrieve_retry_interval to mention table sync worker 📎 Peter Smith 03:17
Re: RFC: Lock-free XLog Reservation from WAL Japin Li 03:32
Re: Allow NOT VALID foreign key constraints on partitioned tables. Amul Sul 04:23
Re: Logical Replication of sequences Peter Smith 05:15
Re: Conflict detection for update_deleted in logical replication 📎 Nisha Moond 05:26
Re: apply_scanjoin_target_to_paths and partitionwise join Ashutosh Bapat 06:07
Re: Fix crash when non-creator being an iteration on shared radix tree John Naylor 06:40
Re: [RFC] Lock-free XLog Reservation from WAL Zhou, Zhiguo 06:46
stats.sql might fail due to shared buffers also used by parallel tests 📎 Alexander Lakhin 07:00
Re: RFC: Lock-free XLog Reservation from WAL Zhou, Zhiguo 07:05
Re: Doc: clarify the log message level of the VERBOSE option Masahiro Ikeda 07:17
Refactor WinGetFuncArgInFrame 📎 Tatsuo Ishii 07:31
Re: Re: proposal: schema variables 📎 jian he 07:58
Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN Masahiro Ikeda 08:18
Re: Doc: clarify the log message level of the VERBOSE option Fujii Masao 08:28
Re: [RFC] Lock-free XLog Reservation from WAL wenhui qiu 08:35
Re: Re: proposal: schema variables Pavel Stehule 08:39
Re: [RFC] Lock-free XLog Reservation from WAL Zhou, Zhiguo 08:49
Bypassing cursors in postgres_fdw to enable parallel plans 📎 Rafia Sabih 08:52
Re: [RFC] Lock-free XLog Reservation from WAL wenhui qiu 08:53
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). jian he 09:34
Temporary Views Cleanup Issue 📎 赵宇鹏 (宇彭) 09:41
Re: RFC: Allow EXPLAIN to Output Page Fault Information 📎 torikoshia 09:49

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