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

May 1, 2024

Thread	Author	Time
pg_sequence_last_value() for unlogged sequences on standbys	Nathan Bossart	00:57
Re: pg_sequence_last_value() for unlogged sequences on standbys	Tom Lane	01:06
Re: pg_sequence_last_value() for unlogged sequences on standbys	Nathan Bossart	01:13
Re: pg_sequence_last_value() for unlogged sequences on standbys 📎	Nathan Bossart	02:05
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.	Noah Misch	02:24
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.	Alexander Korotkov	02:26
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Masahiko Sawada	02:45
Re: Streaming I/O, vectored I/O (WIP)	David Rowley	02:50
Re: pgsql: Introduce "builtin" collation provider.	Jeff Davis	02:55
Re: add tab-complete for memory, serialize option and other minor issues.	Michael Paquier	03:01
Re: query_id, pg_stat_activity, extended query protocol 📎	Imseih (AWS), Sami	03:07
Re: Streaming I/O, vectored I/O (WIP)	Thomas Munro	03:12
Re: Fix parallel vacuum buffer usage reporting	Masahiko Sawada	03:36
Re: pg_sequence_last_value() for unlogged sequences on standbys	Michael Paquier	03:39
Re: Fix parallel vacuum buffer usage reporting	Alena Rybakina	03:51
Re: partitioning and identity column	Michael Paquier	03:53
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Michael Paquier	04:21
Re: [PATCH] json_lex_string: don't overread on bad UTF8	Michael Paquier	06:08
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	John Naylor	07:29
Re: Support tid range scan in parallel?	David Rowley	07:53
Re: Control flow in logical replication walsender	Ashutosh Bapat	09:18
Re: Removing unneeded self joins	Alexander Lakhin	11:00
Re: SQL:2011 application time	jian he	11:27
Re: Removing unneeded self joins 📎	Alexander Korotkov	11:59
Re: Refactoring backend fork+exec code	Anton A. Melnikov	13:32
Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing	Thomas Spear	13:48
Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing	Jacob Champion	14:23
Document NULL 📎	David G. Johnston	15:12
Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing	Thomas Spear	15:17
Re: Document NULL	Thom Brown	15:48
Proposal for Updating CRC32C with AVX-512 Algorithm.	Amonson, Paul D	15:56
Re: Support tid range scan in parallel?	Cary Huang	16:44
Re: Logging which interface was connected to in log_line_prefix 📎	Greg Sabino Mullane	17:04
Query Discrepancy in Postgres HLL Test	Ayush Vatsa	17:09
Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing	Jacob Champion	17:30
Re: cataloguing NOT NULL constraints 📎	Alvaro Herrera	17:49
Re: New GUC autovacuum_max_threshold ?	Imseih (AWS), Sami	18:19
Re: New GUC autovacuum_max_threshold ?	Robert Haas	18:50
Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing	Thomas Spear	18:56
Re: Query Discrepancy in Postgres HLL Test	Robert Haas	19:07
Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing	Jacob Champion	19:18
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Dmitry Koval	19:51
Re: Weird test mixup	Noah Misch	23:12
Re: [PATCH] json_lex_string: don't overread on bad UTF8 📎	Jacob Champion	23:22

May 2, 2024

Thread	Author	Time
Re: New GUC autovacuum_max_threshold ?	David Rowley	02:02
Re: [PATCH] json_lex_string: don't overread on bad UTF8	Michael Paquier	02:23
Re: [PATCH] json_lex_string: don't overread on bad UTF8	Michael Paquier	03:39
Re: Document NULL	Kashif Zeeshan	03:42
Re: Document NULL	David Rowley	04:15
Re: Document NULL	Tom Lane	04:47
Re: Partitioned tables and [un]loggedness 📎	Michael Paquier	06:06
Limit index pages visited in planner's get_actual_variable_range 📎	Rian McGuire	06:12
Re: small documentation fixes related to collations/ICU	Peter Eisentraut	06:35
Re: New GUC autovacuum_max_threshold ?	Frédéric Yhuel	06:44
Re: Weird test mixup 📎	Michael Paquier	07:27
Re: [PoC] Reducing planning time when tables have many partitions	Yuya Watari	07:56
Re: Weird test mixup	Andrey M. Borodin	08:33
Re: Weird test mixup	Michael Paquier	08:43
Re: Weird test mixup	Andrey M. Borodin	08:52
Re: Extend ALTER DEFAULT PRIVILEGES for large objects	Yugo NAGATA	09:00
Re: Removing unneeded self joins 📎	Andrei Lepikhov	09:44
Re: Removing unneeded self joins	Alexander Korotkov	10:07
Re: Reducing the log spam	Laurenz Albe	10:47
Re: Reducing the log spam	Jelte Fennema-Nio	11:08
Re: Reducing the log spam	Jelte Fennema-Nio	11:11
Type and CAST error on lowest negative integer values for smallint, int and bigint	Hans Buschmann	11:25
Re: Type and CAST error on lowest negative integer values for smallint, int and bigint	David Rowley	11:33
Re: Typos in the code and README 📎	Alexander Lakhin	12:00
AW: Type and CAST error on lowest negative integer values for smallint, int and bigint	Hans Buschmann	12:14
Re: Removing unneeded self joins 📎	Richard Guo	13:14
EXPLAN redundant options	jian he	13:16
Re: EXPLAN redundant options	David G. Johnston	13:36
Re: Support LIKE with nondeterministic collations	Peter Eisentraut	13:38
Re: EXPLAN redundant options	Euler Taveira	13:58
Re: EXPLAN redundant options	Tom Lane	14:21
Re: Rename libpq trace internal functions	Peter Eisentraut	14:22
Re: [PoC] Reducing planning time when tables have many partitions	jian he	14:35
Re: Build with meson + clang + sanitizer resulted in undefined reference	Maxim Orlov	14:47
Re: cataloguing NOT NULL constraints	Alexander Lakhin	15:00
Re: Limit index pages visited in planner's get_actual_variable_range	Peter Geoghegan	15:05
Parallel CREATE INDEX for GIN indexes 📎	Tomas Vondra	15:19
Re: Document NULL 📎	David G. Johnston	15:23
Re: New GUC autovacuum_max_threshold ?	Imseih (AWS), Sami	16:01
Re: cataloguing NOT NULL constraints	Alvaro Herrera	16:21
Specify tranch name in error when not registered 📎	Tristan Partin	16:23
Why is FOR ORDER BY function getting called when the index is handling ordering?	Chris Cleveland	16:49
Re: Parallel CREATE INDEX for GIN indexes	Matthias van de Meent	17:12
Re: Why is FOR ORDER BY function getting called when the index is handling ordering?	Matthias van de Meent	17:20
Re: Why is FOR ORDER BY function getting called when the index is handling ordering?	Tom Lane	17:21
Re: Idea Feedback: psql \h misses -> Offers Links? 📎	Andrey M. Borodin	17:50
Re: Parallel CREATE INDEX for GIN indexes	Tomas Vondra	18:22
Re: Idea Feedback: psql \h misses -> Offers Links?	Pavel Stehule	18:24
Re: Weird test mixup	Noah Misch	19:35
Re: Why is FOR ORDER BY function getting called when the index is handling ordering?	Chris Cleveland	20:42
Re: BitmapHeapScan streaming read user and prelim refactoring	Tomas Vondra	21:31
Re: enhance the efficiency of migrating particularly large tables	David Zhang	21:33
Re: BitmapHeapScan streaming read user and prelim refactoring	Tomas Vondra	21:37
wrong comment in libpq.h 📎	David Zhang	22:37
Re: enhance the efficiency of migrating particularly large tables	David Rowley	22:55
Re: Removing unneeded self joins 📎	Alexander Korotkov	23:04
Re: Removing unneeded self joins	Tom Lane	23:19
Re: [PATCH] json_lex_string: don't overread on bad UTF8	Jacob Champion	23:29
Weird "null" errors during DROP TYPE (pg_upgrade)	Devrim Gündüz	23:36
Re: HEAD build error on Fedora 39	Devrim Gündüz	23:37
Re: Proposal: Early providing of PGDG repositories for the major Linux distributions like Fedora or Debian	Devrim Gündüz	23:44

May 3, 2024

Thread	Author	Time
Re: Support LIKE with nondeterministic collations	Robert Haas	00:11
Re: Weird "null" errors during DROP TYPE (pg_upgrade)	Tom Lane	00:18
Re: allow changing autovacuum_max_workers without restarting	Nathan Bossart	01:04
improve performance of pg_dump with many sequences 📎	Nathan Bossart	02:51
Re: Removing unneeded self joins	Andrei Lepikhov	03:19
Re: cataloguing NOT NULL constraints	Alexander Lakhin	04:00
Incorrect Assert in BufFileSize()?	David Rowley	04:03
Re: Document NULL	Kashif Zeeshan	05:20
Re: UUID v7	Andrey M. Borodin	06:18
AW: Proposal: Early providing of PGDG repositories for the major Linux distributions like Fedora or Debian	Hans Buschmann	06:22
Re: Fix parallel vacuum buffer usage reporting 📎	Anthonin Bonnefoy	06:41
Re: Document NULL	Laurenz Albe	06:47
different engine for JIT	Pavel Stehule	08:07
Re: Document NULL	jian he	08:14
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Daniel Gustafsson	08:39
Re: Support LIKE with nondeterministic collations	Peter Eisentraut	08:52
Re: Removing unneeded self joins	Alexander Korotkov	08:56
Re: tablecmds.c/MergeAttributes() cleanup	Peter Eisentraut	09:17
Re: different engine for JIT	Adrien Nayrat	09:21
Re: tablecmds.c/MergeAttributes() cleanup	Ashutosh Bapat	09:32
Re: A problem about partitionwise join	Richard Guo	11:47
Re: wrong comment in libpq.h	Peter Eisentraut	11:48
Re: wrong comment in libpq.h	Daniel Gustafsson	11:53
Re: [PATCH] json_lex_string: don't overread on bad UTF8	Peter Eisentraut	11:54
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Peter Eisentraut	12:20
Re: A failure in prepared_xacts test	Peter Eisentraut	12:27
Re: Reducing the log spam 📎	Laurenz Albe	12:49
Re: allow changing autovacuum_max_workers without restarting	Imseih (AWS), Sami	12:57
Re: Support LIKE with nondeterministic collations	Robert Haas	13:20
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Justin Pryzby	13:23
Re: A problem about partitionwise join	Robert Haas	13:31
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	13:32
Use generation memory context for tuplestore.c 📎	David Rowley	13:55
Re: Removing unneeded self joins	Robert Haas	13:55
Re: Tarball builds in the new world order	Peter Eisentraut	13:57
Re: Document NULL	David G. Johnston	13:58
Re: pg17 issues with not-null contraints	Justin Pryzby	14:05
Re: [PATCH] json_lex_string: don't overread on bad UTF8	Jacob Champion	14:05
Re: Document NULL	Peter Eisentraut	14:09
Re: Support LIKE with nondeterministic collations	Peter Eisentraut	14:12
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Tom Lane	14:13
Re: Typos in the code and README	David Rowley	14:36
Re: Support LIKE with nondeterministic collations	Daniel Verite	14:58
Re: Tarball builds in the new world order	Tom Lane	15:09
Re: Document NULL	David G. Johnston	15:16
Re: Document NULL	Tom Lane	15:44
Re: Support LIKE with nondeterministic collations	Daniel Verite	15:47
Re: Use generation memory context for tuplestore.c	Matthias van de Meent	15:51
Re: Document NULL	David G. Johnston	16:00
add --no-sync to pg_upgrade's calls to pg_dump and pg_dumpall 📎	Nathan Bossart	17:13
Re: Add minimal C example and SQL registration example for custom table access methods. 📎	Phil Eaton	17:35
First-draft release notes for back branches are done	Tom Lane	18:12
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Peter Eisentraut	18:44
Re: Support LIKE with nondeterministic collations	Peter Eisentraut	18:53
Re: Support tid range scan in parallel? 📎	Cary Huang	18:55
Re: Support LIKE with nondeterministic collations	Peter Eisentraut	18:58
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Peter Eisentraut	19:02
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Tom Lane	19:21
Re: On disable_cost	Robert Haas	20:33
Re: pg_sequence_last_value() for unlogged sequences on standbys	Nathan Bossart	20:49
Re: pg_sequence_last_value() for unlogged sequences on standbys	Tom Lane	21:22
Re: wrong comment in libpq.h	David Zhang	22:29
Re: pg_trgm comparison bug on cross-architecture replication due to different char implementation	Joe Conway	22:36

May 4, 2024

Thread	Author	Time
Re: Support tid range scan in parallel?	David Rowley	01:14
Proposal for CREATE OR REPLACE EVENT TRIGGER in PostgreSQL	Peter Burbery	01:49
Re: Use generation memory context for tuplestore.c	David Rowley	02:01
Re: Proposal for CREATE OR REPLACE EVENT TRIGGER in PostgreSQL	David G. Johnston	02:22
Re: UUID v7	Andrey M. Borodin	06:09
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Daniel Gustafsson	08:08
Re: pg17 issues with not-null contraints	Alvaro Herrera	09:20
Re: pg_sequence_last_value() for unlogged sequences on standbys	Michael Paquier	09:45
Re: pg_sequence_last_value() for unlogged sequences on standbys	Michael Paquier	09:47
Re: Weird test mixup	Michael Paquier	09:49
Re: On disable_cost	David Rowley	13:16
drop column name conflict 📎	Joseph Koshakow	14:37
Re: drop column name conflict	Tom Lane	15:29
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	15:51
Re: AIX support	Sriram RK	16:01
Re: On disable_cost	Tom Lane	16:57
Re: drop column name conflict 📎	Joseph Koshakow	19:38
Re: partitioning and identity column	Dmitry Dolgov	20:13
Fix for recursive plpython triggers 📎	Tom Lane	20:16

May 5, 2024

Thread	Author	Time
Re: On disable_cost	David Rowley	00:07
Re: Removing unneeded self joins	Andrei Lepikhov	02:45
Help regarding figuring out routes in pgAdmin4	Ahmad Mehmood	05:09
Re: Asymmetric partition-wise JOIN 📎	Andrei Lepikhov	14:55
'trusted'/'untrusted' PL in DoD/DISA PostgreSQL STIGs	Chapman Flack	17:53
Re: Parallel CREATE INDEX for GIN indexes 📎	Tomas Vondra	18:49
Re: 'trusted'/'untrusted' PL in DoD/DISA PostgreSQL STIGs	Joe Conway	23:22
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎	Michail Nikolaev	23:37

May 6, 2024

Thread	Author	Time
Re: Weird test mixup	Michael Paquier	01:03
Re: 039_end_of_wal: error in "xl_tot_len zero" test	Thomas Munro	02:51
Re: SQL:2011 application time 📎	jian he	03:01
Re: 039_end_of_wal: error in "xl_tot_len zero" test	Tom Lane	03:05
Re: Help update PostgreSQL 13.12 to 13.14	Kashif Zeeshan	03:53

Browse Archives

Prev | Next