pgsql-hackers since 2025-05-13 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

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

May 13, 2025

Thread Author Time
RE: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎 Aya Iwata (Fujitsu) 01:08
Re: Useless LEFT JOIN breaks MIN/MAX optimization 📎 Alena Rybakina 01:47
fix: propagate M4 env variable to flex subprocess 📎 J. Javier Maestro 03:14
make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock 📎 jian he 03:26
Re: PG 18 release notes draft committed David G. Johnston 03:27
Re: Suggestion to add --continue-client-on-abort option to pgbench 📎 Rintaro.Ikeda 03:49
RE: Changing shared_buffers without restart 📎 Jack Ng 05:03
Re: Why our Valgrind reports suck Yasir 05:28
Re: Suggestion to add --continue-client-on-abort option to pgbench Dilip Kumar 05:56
Re: PG 18 release notes draft committed Laurenz Albe 06:05
Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock Dilip Kumar 06:22
Add explicit initialization for all PlannerGlobal fields 📎 Richard Guo 08:02
Re: make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiveLock wenhui qiu 09:34
Re: Vacuum statistics Alena Rybakina 09:49
Backward movement of confirmed_flush resulting in data duplication. 📎 shveta malik 10:17
Re: Backward movement of confirmed_flush resulting in data duplication. Dilip Kumar 10:52
Re: Improve monitoring of shared memory allocations Amit Kapila 11:04
Re: Allow reading LSN written by walreciever, but not flushed yet Fujii Masao 11:13
Re: Add explicit initialization for all PlannerGlobal fields David Rowley 11:26
Re: Add an option to skip loading missing publication to avoid logical replication failure Amit Kapila 11:33
Re: Fix incorrect order of params in comment Daniel Gustafsson 11:38
Re: using index to speedup add not null constraints to a table Andres Freund 13:37
Re: Test mail for pgsql-hackers Andres Freund 13:40
Re: Serverside SNI support in libpq Andres Freund 13:46
Re: Memoize ANTI and SEMI JOIN inner Andres Freund 13:51
Re: Add partial :-variable expansion to psql \copy Andres Freund 13:57
spurious pg_amcheck test failure Andres Freund 15:25
Re: fix: propagate M4 env variable to flex subprocess Andres Freund 15:54
ARM/ARM64 SpinLockAcquire and SpinLockRelease are not full barriers 📎 Yura Sokolov 16:22
Re: queryId constant squashing does not support prepared statements Dmitry Dolgov 16:57
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part David E. Wheeler 18:07
Re: Remove Instruction Synchronization Barrier in spin_delay() for ARM64 architecture Salvatore Dipietro 18:37
Re: Allow reading LSN written by walreciever, but not flushed yet Mihail Nikalayeu 20:11
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Florents Tselai 20:24
Disable parallel query by default 📎 Scott Mead 20:36
Re: Small fixes needed by high-availability tools Mihail Nikalayeu 20:44
Re: Disable parallel query by default Lukas Fittl 21:05
Re: Disable parallel query by default Greg Sabino Mullane 21:07
Re: Batch TIDs lookup in ambulkdelete Matheus Alcantara 21:25
Re: Disable parallel query by default Scott Mead 21:53

May 14, 2025

Thread Author Time
Re: Statistics Import and Export 📎 Hari Krishna Sunder 00:01
Re: Add explicit initialization for all PlannerGlobal fields Richard Guo 01:05
Re: Memoize ANTI and SEMI JOIN inner 📎 Richard Guo 02:13
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part David E. Wheeler 03:00
Re: Backward movement of confirmed_flush resulting in data duplication. Amit Kapila 03:45
Re: Logical Replication of sequences Nisha Moond 04:25
Re: Logical Replication of sequences 📎 vignesh C 04:56
Re: Logical Replication of sequences vignesh C 04:59
Re: Backward movement of confirmed_flush resulting in data duplication. Dilip Kumar 06:29
Re: Limiting overshoot in nbtree's parallel SAOP index scans Amit Kapila 06:35
Re: Backward movement of confirmed_flush resulting in data duplication. Alexander Kukushkin 06:42
Re: Backward movement of confirmed_flush resulting in data duplication. Amit Kapila 06:45
Re: Allow reading LSN written by walreciever, but not flushed yet Alexander Kukushkin 06:54
Re: Allow reading LSN written by walreciever, but not flushed yet Alexander Kukushkin 07:02
Re: Assert failure in base_yyparse 📎 Richard Guo 07:06
Re: Disable parallel query by default Laurenz Albe 08:06
Re: Vacuum statistics Amit Kapila 08:55
Re: Suggestion to add --continue-client-on-abort option to pgbench Srinath Reddy Sadipiralla 09:08
Re: Backward movement of confirmed_flush resulting in data duplication. Dilip Kumar 09:15
Re: using index to speedup add not null constraints to a table 📎 jian he 09:16
Re: Small fixes needed by high-availability tools Amit Kapila 09:33
vectorized CRC on ARM64 📎 John Naylor 10:36
Re: Incremental Sort Cost Estimation Instability 📎 Andrei Lepikhov 10:50
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 📎 Florents Tselai 15:33
PostgreSQL 18 Beta 1 io_max_concurrency Jafri, Nazneen 15:38
Re: Disable parallel query by default Álvaro Herrera 15:51
Re: Statistics Import and Export Nathan Bossart 15:53
Re: Assert failure in base_yyparse Alvaro Herrera 16:20
Re: Small fixes needed by high-availability tools Andrey Borodin 18:13
Re: PostgreSQL 18 Beta 1 io_max_concurrency Tom Lane 19:25
Re: Small fixes needed by high-availability tools Mihail Nikalayeu 19:34
Re: Statistics Import and Export 📎 Hari Krishna Sunder 20:30
Re: Better visualization of default values 📎 Marcos Pegoraro 20:40
Should we optimize the `ORDER BY random() LIMIT x` case? Aleksander Alekseev 23:41

May 15, 2025

Thread Author Time
Re: Should we optimize the `ORDER BY random() LIMIT x` case? wenhui qiu 02:06
[BUG] Skipped initialization of some xl_xact_parsed_prepare fields 📎 Daniil Davydov 05:39
Re: Re: proposal: schema variables 📎 Pavel Stehule 06:48
Re: Logical Replication of sequences Peter Smith 06:57
Add comment explaining why queryid is int64 in pg_stat_statements 📎 Shaik Mohammad Mujeeb 07:08
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Andrei Lepikhov 07:54
xlogrecovery.c:WaitForWALToBecomeAvailable() - make "switched WAL source" visible by default? Jakub Wartak 07:57
Assertion failure in smgr.c when using pg_prewarm with partitioned tables 📎 Masahiro Ikeda 08:52
Re: Assert failure in base_yyparse Richard Guo 08:55
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Aleksander Alekseev 09:17
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables Dilip Kumar 09:20
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Andrei Lepikhov 09:32
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables Fujii Masao 09:44
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables Dilip Kumar 09:50
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables Richard Guo 10:57
Re: [BUG] Skipped initialization of some xl_xact_parsed_prepare fields Fujii Masao 11:30
Re: Conflict detection for update_deleted in logical replication Amit Kapila 12:32
Re: Restrict publishing of partitioned table with a foreign table as partition Amit Kapila 12:48
Re: Update LDAP Protocol in fe-connect.c to v3 Pavel Seleznev 12:54
Re: Consider explicit incremental sort for Append and MergeAppend Andrei Lepikhov 13:03
Binary operators for cubes 📎 Kirill Panin 13:26
Re: PG 18 release notes draft committed Álvaro Herrera 18:02
Re: POC: Parallel processing of indexes in autovacuum Matheus Alcantara 21:06
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Peter Smith 23:59

May 16, 2025

Thread Author Time
Re: doc: Make logical replication examples executable in bulk and legal sgml. Peter Smith 01:28
Re: doc: Make logical replication examples executable in bulk and legal sgml. David G. Johnston 01:40
Re: Virtual generated columns Alexander Lakhin 04:00
Re: POC: Parallel processing of indexes in autovacuum 📎 Daniil Davydov 05:10
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:45
Re: Conflict detection for update_deleted in logical replication shveta malik 05:45
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables 📎 Masahiro Ikeda 06:21
Re: Conflict detection for update_deleted in logical replication shveta malik 06:30
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables Dilip Kumar 06:33
Re: Conflict detection for update_deleted in logical replication Amit Kapila 06:47
Re: Virtual generated columns Richard Guo 07:26
Re: Add pg_buffercache_mark_dirty[_all] functions to the pg_buffercache Xuneng Zhou 07:58
Re: Virtual generated columns jian he 08:34
Re: Logical Replication of sequences 📎 vignesh C 08:46
Re: Conflict detection for update_deleted in logical replication Amit Kapila 09:10
Re: Add comment explaining why queryid is int64 in pg_stat_statements Ilia Evdokimov 09:42
Re: Conflict detection for update_deleted in logical replication shveta malik 10:12
Re: Conflict detection for update_deleted in logical replication Amit Kapila 10:13
Re: Add comment explaining why queryid is int64 in pg_stat_statements Shaik Mohammad Mujeeb 10:35
Re: Conflict detection for update_deleted in logical replication Amit Kapila 11:31
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Aleksander Alekseev 12:01
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables Fujii Masao 12:01
Re: Backward movement of confirmed_flush resulting in data duplication. 📎 Nisha Moond 12:08
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Tom Lane 13:01
Align wording on copyright organization 📎 Daniel Gustafsson 13:12
wrong query results on bf leafhopper Andres Freund 13:19
C extension compilation failed while using PG 17.2 on mac m1 Lakshmi Narayana Velayudam 13:30
Re: Align wording on copyright organization Dave Page 13:31
PG 17.2 compilation fails with -std=c11 on mac Lakshmi Narayana Velayudam 13:44
Re: Align wording on copyright organization Tom Lane 14:00
Re: Align wording on copyright organization Daniel Gustafsson 14:40
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Maxim Orlov 14:54
Document default values for pgoutput options + fix missing initialization for "origin" 📎 Fujii Masao 15:06
Make wal_receiver_timeout configurable per subscription Fujii Masao 15:40
Re: PG 17.2 compilation fails with -std=c11 on mac Tom Lane 15:42
Re: Align wording on copyright organization Daniel Gustafsson 15:50
Proposal: Make cfbot fail on patches not created by "git format-patch" Jelte Fennema-Nio 15:52
Re: Align wording on copyright organization Dave Page 15:54
Re: C extension compilation failed while using PG 17.2 on mac m1 Tom Lane 16:05
Re: Proposal: Make cfbot fail on patches not created by "git format-patch" Daniel Gustafsson 16:05
Re: wrong query results on bf leafhopper Alena Rybakina 16:12
Re: Proposal: Make cfbot fail on patches not created by "git format-patch" Tom Lane 16:12
Re: Proposal: Make cfbot fail on patches not created by "git format-patch" Jacob Champion 16:24
Re: Make wal_receiver_timeout configurable per subscription Srinath Reddy Sadipiralla 16:47
Re: Proposal: Make cfbot fail on patches not created by "git format-patch" Jelte Fennema-Nio 17:45
Re: Proposal: Make cfbot fail on patches not created by "git format-patch" Jelte Fennema-Nio 17:55
Re: Proposal: Make cfbot fail on patches not created by "git format-patch" Tom Lane 17:55
Re: Statistics Import and Export Hari Krishna Sunder 18:47
Re: PG 17.2 compilation fails with -std=c11 on mac 📎 Tom Lane 20:58
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Vik Fearing 21:10
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Tom Lane 21:21
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Vik Fearing 21:42
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Nico Williams 21:50
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Nico Williams 21:53
Foreign key isolation tests 📎 Paul A Jungwirth 21:57
Re: Should we optimize the `ORDER BY random() LIMIT x` case? Nico Williams 22:06
pg_upgrade ability to create extension from scripts Regina Obe 22:18

May 17, 2025

Thread Author Time
Re: Add comment explaining why queryid is int64 in pg_stat_statements wenhui qiu 03:36
Re: Add comment explaining why queryid is int64 in pg_stat_statements Michael Paquier 12:49
Re: Add Option To Check All Addresses For Matching target_session_attr 📎 Andrew Jackson 13:41
Possible regression in PG18 beta1 Sadeq Dousti 15:45
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 Aya Iwata (Fujitsu) 16:31
Re: Possible regression in PG18 beta1 Sadeq Dousti 16:38
Re: Possible regression in PG18 beta1 Maciek Sakrejda 17:29
Re: Possible regression in PG18 beta1 Sami Imseih 17:29
Re: pg_upgrade ability to create extension from scripts Andreas Karlsson 17:46
Re: Possible regression in PG18 beta1 Sadeq Dousti 17:47
RE: pg_upgrade ability to create extension from scripts Regina Obe 17:58
Re: pg_upgrade ability to create extension from scripts Andreas Karlsson 18:09
Re: Add comment explaining why queryid is int64 in pg_stat_statements Shaik Mohammad Mujeeb 18:35
Re: Possible regression in PG18 beta1 Sami Imseih 18:39
Re: Possible regression in PG18 beta1 Sadeq Dousti 19:00
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 19:38
Re: Possible regression in PG18 beta1 Peter Geoghegan 23:00
Find comment on SearchSysCacheLockedCopy1 📎 Paul A Jungwirth 23:29

May 18, 2025

Thread Author Time
Re: fix: propagate M4 env variable to flex subprocess J. Javier Maestro 03:32
Suggestion: Update Copyright Year to 2025 in Recently Added Files Shaik Mohammad Mujeeb 06:39
Re: Find comment on SearchSysCacheLockedCopy1 Daniel Gustafsson 07:24
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Dilip Kumar 10:36
Re: Add comment explaining why queryid is int64 in pg_stat_statements Junwang Zhao 12:17
Re: Possible regression in PG18 beta1 Sami Imseih 12:58
To make pg_dump and pg_restore parallel in processing limited number of LOs 📎 fkfk000 13:04
Re: [BUG?] check_exclusion_or_unique_constraint false negative 📎 Mihail Nikalayeu 14:36
Re: Possible regression in PG18 beta1 Sadeq Dousti 14:44
Re: To make pg_dump and pg_restore parallel in processing limited number of LOs Tom Lane 14:46
Re: Possible regression in PG18 beta1 Sami Imseih 14:52
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Mihail Nikalayeu 15:09
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎 Mihail Nikalayeu 15:16
Re: Possible regression in PG18 beta1 Sadeq Dousti 15:56
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Álvaro Herrera 15:56
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Mihail Nikalayeu 16:09
Support for Physical Column Reordering in PG Srinath Reddy Sadipiralla 17:26
Re: PG 17.2 compilation fails with -std=c11 on mac Tom Lane 18:36
Re: Support for Physical Column Reordering in PG Tom Lane 18:42
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Alexander Korotkov 21:25
Violation of principle that plan trees are read-only Tom Lane 23:31
Re: Suggestion: Update Copyright Year to 2025 in Recently Added Files Michael Paquier 23:48

May 19, 2025

Thread Author Time
finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it 📎 jian he 01:09
Re: Statistics Import and Export Michael Paquier 01:52
Re: regdatabase jian he 02:37
Re: wrong query results on bf leafhopper Robins Tharakan 03:19
Re: Suggestion: Update Copyright Year to 2025 in Recently Added Files Tom Lane 03:34

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