pgsql-hackers before 2025-05-20 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)

Advanced Search

Browse Archives

Prev | Next

May 14, 2025

Thread	Author	Time
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
Ge Yuxiang added you to the postgresql group	Ge Yuxiang	05:03
Re: Suggestion: Update Copyright Year to 2025 in Recently Added Files	Michael Paquier	06:36
Re: Make wal_receiver_timeout configurable per subscription	Amit Kapila	06:48
Re: support fast default for domain with constraints 📎	jian he	07:05
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables 📎	Masahiro Ikeda	08:17
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Amit Kapila	09:05
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Amit Kapila	09:15
Re: Backward movement of confirmed_flush resulting in data duplication.	Amit Kapila	09:43
Re: Should we optimize the `ORDER BY random() LIMIT x` case?	Aleksander Alekseev	10:25
Re: Violation of principle that plan trees are read-only	Robert Haas	12:35
Re: Violation of principle that plan trees are read-only	Isaac Morland	12:41
Re: Consider explicit incremental sort for Append and MergeAppend	Robert Haas	13:21
Re: Proposal: Make cfbot fail on patches not created by "git format-patch"	Aleksander Alekseev	13:22
Re: [PoC] XMLCast (SQL/XML X025) 📎	Jim Jones	13:23
Re: [PoC] XMLCast (SQL/XML X025)	Robert Haas	14:26
Regression in statement locations	David Steele	14:31
Re: Violation of principle that plan trees are read-only	Tom Lane	14:35
Re: Violation of principle that plan trees are read-only	Robert Haas	14:39
Re: Violation of principle that plan trees are read-only	Tom Lane	14:45
Re: wrong query results on bf leafhopper	Andres Freund	14:51
Re: Add comment explaining why queryid is int64 in pg_stat_statements	Peter Eisentraut	15:05
Re: Proposal: Make cfbot fail on patches not created by "git format-patch"	Jacob Champion	15:10
Re: Make wal_receiver_timeout configurable per subscription	Robert Haas	15:19
Re: Proposal: Make cfbot fail on patches not created by "git format-patch"	Florents Tselai	15:29
Re: Should we optimize the `ORDER BY random() LIMIT x` case?	Nico Williams	15:38
Re: Violation of principle that plan trees are read-only	Jose Luis Tallon	15:49
Re: Add comment explaining why queryid is int64 in pg_stat_statements	Sami Imseih	16:11
Re: strange perf regression with data checksums 📎	Tomas Vondra	16:13
Re: Restrict publishing of partitioned table with a foreign table as partition 📎	Shlok Kyal	16:32
Re: Remove Instruction Synchronization Barrier in spin_delay() for ARM64 architecture	Nathan Bossart	16:38
Re: strange perf regression with data checksums	Peter Geoghegan	16:42
Re: Statistics Import and Export	Nathan Bossart	16:51
Re: Avoid orphaned objects dependencies, take 3	Jeff Davis	17:02
Re: strange perf regression with data checksums 📎	Peter Geoghegan	17:20
Re: strange perf regression with data checksums	Tomas Vondra	18:01
plan shape work 📎	Robert Haas	18:01
Re: Should we optimize the `ORDER BY random() LIMIT x` case?	Andrei Lepikhov	18:04
Re: Avoid orphaned objects dependencies, take 3	Robert Haas	18:07
Re: strange perf regression with data checksums	Peter Geoghegan	18:19
Re: strange perf regression with data checksums 📎	Peter Geoghegan	18:44
Re: Should we optimize the `ORDER BY random() LIMIT x` case?	Vik Fearing	19:01
Re: strange perf regression with data checksums	Andres Freund	19:37
Re: strange perf regression with data checksums	Peter Geoghegan	19:45
Re: strange perf regression with data checksums	Tomas Vondra	20:17
Thread-safe getopt() (was: report on not thread-safe functions) 📎	Heikki Linnakangas	20:22
Re: strange perf regression with data checksums	Peter Geoghegan	20:29
Re: Should we optimize the `ORDER BY random() LIMIT x` case?	Nico Williams	20:53
Re: Statistics Import and Export	Hari Krishna Sunder	21:13
Re: regdatabase	Nathan Bossart	21:17
Re: Regression in statement locations	Michael Paquier	21:18
Re: queryId constant squashing does not support prepared statements	Michael Paquier	21:30
Re: Statistics Import and Export	Nathan Bossart	21:31
Re: Make wal_receiver_timeout configurable per subscription	Michael Paquier	21:46
Re: Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. 📎	Daniel Gustafsson	21:52
Re: Remove Instruction Synchronization Barrier in spin_delay() for ARM64 architecture	Nathan Bossart	22:07
Re: Regression in statement locations	Sami Imseih	22:10
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	22:35
Re: [PoC] XMLCast (SQL/XML X025) 📎	Jim Jones	23:11
Re: Regression in statement locations	Michael Paquier	23:38
Re: Proposal for enabling auto-vectorization for checksum calculations 📎	Matthew Sterrett	23:54

Browse Archives

Prev | Next