pgsql-hackers since 2024-05-05 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)

Browse Archives

Prev | Next

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
Re: Documentation to upgrade logical replication cluster 📎 vignesh C 05:09
Re: psql: fix variable existence tab completion 📎 Anton A. Melnikov 06:05
Re: UniqueKey v2 Andy Fan 07:48
Test equivclass interferes with tests tsearch and advisory_lock 📎 Alexander Lakhin 09:00
Re: TerminateOtherDBBackends code comments inconsistency. Amit Kapila 09:23
Re: wrong comment in libpq.h Peter Eisentraut 09:48
Re: psql: fix variable existence tab completion Alexander Korotkov 10:19
Re: Extension for PostgreSQL cast jsonb to hstore WIP 📎 Антуан Виолин 10:39
Re: apply_scanjoin_target_to_paths and partitionwise join Jakub Wartak 10:55
Re: On disable_cost Robert Haas 12:27
Possible to include xid8 in logical replication Dave Cramer 12:34
Increase the length of identifers from 63 characters to 128 characters or more Peter Burbery 12:49
Re: Increase the length of identifers from 63 characters to 128 characters or more David G. Johnston 12:55
Re: apply_scanjoin_target_to_paths and partitionwise join Ashutosh Bapat 12:58
Re: partitioning and identity column Ashutosh Bapat 13:22
Re: Increase the length of identifers from 63 characters to 128 characters or more Alvaro Herrera 13:23
Re: On disable_cost Robert Haas 13:39
Re: partitioning and identity column Dmitry Dolgov 14:01
backend stuck in DataFileExtend Justin Pryzby 14:05
Re: AIX support Sriram RK 14:12
Re: Help update PostgreSQL 13.12 to 13.14 Bruce Momjian 14:22
Re: Removing unneeded self joins Robert Haas 14:44
Restrict EXPLAIN (ANALYZE) for RLS and security_barrier views 📎 Laurenz Albe 14:46
Re: Removing unneeded self joins Bruce Momjian 15:17
Re: Removing unneeded self joins Tom Lane 15:54
Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica 📎 m.litsarev 15:55
Re: pg17 issues with not-null contraints Alvaro Herrera 15:56
Re: Removing unneeded self joins Andrei Lepikhov 16:01
Re: pg17 issues with not-null contraints Justin Pryzby 16:12
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs Jelte Fennema-Nio 16:19
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs Jelte Fennema-Nio 16:22
Re: Removing unneeded self joins Robert Haas 16:24
Re: pg17 issues with not-null contraints Alvaro Herrera 16:34
Re: pg17 issues with not-null contraints Justin Pryzby 16:41
Re: backend stuck in DataFileExtend Andres Freund 17:04
Re: Removing unneeded self joins Bruce Momjian 17:08
Re: backend stuck in DataFileExtend Justin Pryzby 17:37
2024-05-09 release announcement draft 📎 Jonathan S. Katz 17:44
Re: backend stuck in DataFileExtend Andres Freund 17:51
Re: On disable_cost Robert Haas 17:51
Re: backend stuck in DataFileExtend Justin Pryzby 18:21
Re: Control flow in logical replication walsender Christophe Pettus 18:29
Re: On disable_cost Tom Lane 18:44
Use pgstat_kind_infos to read fixed shared stats structs 📎 Tristan Partin 19:07
Re: Removing unneeded self joins Alexander Korotkov 19:08
Re: On disable_cost Tom Lane 19:26
Re: Removing unneeded self joins Alexander Korotkov 19:27
Incorrect explain output for updates/delete operations with returning-list on partitioned tables SAIKIRAN AVULA 19:56
Re: On disable_cost Robert Haas 19:58
Re: Removing unneeded self joins Robert Haas 19:59
Re: On disable_cost Tom Lane 20:10
Re: On disable_cost Peter Geoghegan 20:30
Re: 2024-05-09 release announcement draft Erik Rijkers 20:59
Re: 2024-05-09 release announcement draft David Rowley 21:08
Re: Incorrect explain output for updates/delete operations with returning-list on partitioned tables Tom Lane 21:18
Re: Weird test mixup 📎 Noah Misch 21:23
[PATCH] pg_stat_activity: make slow/hanging authentication more visible 📎 Jacob Champion 21:23
Re: 2024-05-09 release announcement draft,2024-05-09 release announcement draft Sutou Kouhei 21:36
Re: Is it acceptable making COPY format extendable? Sutou Kouhei 21:40
Skip adding row-marks for non target tables when result relation is foreign table. 📎 SAIKIRAN AVULA 22:10
Re: backend stuck in DataFileExtend Thomas Munro 22:55
Re: Incorrect explain output for updates/delete operations with returning-list on partitioned tables David Rowley 22:58
WHERE CURRENT OF with RLS quals that are ctid conditions 📎 Tom Lane 23:31
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Michael Paquier 23:31

May 7, 2024

Thread Author Time
Re: Weird test mixup 📎 Michael Paquier 01:17
Re: Use pgstat_kind_infos to read fixed shared stats structs Michael Paquier 02:50
Re: 2024-05-09 release announcement draft Jonathan S. Katz 02:58
Re: 2024-05-09 release announcement draft,2024-05-09 release announcement draft Jonathan S. Katz 03:02
Re: 2024-05-09 release announcement draft Tom Lane 03:04
Re: 2024-05-09 release announcement draft David Rowley 03:05
Re: 2024-05-09 release announcement draft 📎 Jonathan S. Katz 03:09
Re: 2024-05-09 release announcement draft David Rowley 03:27
Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. jian he 03:34
Re: [PATCH] json_lex_string: don't overread on bad UTF8 Michael Paquier 03:42
Re: Statistics Import and Export 📎 Corey Huinker 03:43
Re: 2024-05-09 release announcement draft Tom Lane 03:48
Re: 2024-05-09 release announcement draft David Rowley 04:02
Re: 2024-05-09 release announcement draft Tom Lane 04:16
Re: Control flow in logical replication walsender Ashutosh Bapat 04:20
Re: [PATCH] Fix bug when calling strncmp in check_authmethod_valid Jingxian Li 04:46
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Richard Guo 04:47
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 05:00
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Tom Lane 05:01
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 05:11
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 05:15
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 05:21
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Tom Lane 05:28
Re: Use pgstat_kind_infos to read fixed shared stats structs Tristan Partin 05:44
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 05:46
Re: Use pgstat_kind_infos to read fixed shared stats structs Michael Paquier 06:01
Re: psql: fix variable existence tab completion Anton A. Melnikov 07:37
Re: elog/ereport VS misleading backtrace_function function address 📎 Jakub Wartak 07:43
Re: cataloguing NOT NULL constraints Kyotaro Horiguchi 08:17
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Richard Guo 10:05
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Richard Guo 10:18
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? 📎 Daniel Gustafsson 10:36
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Alexander Korotkov 11:42
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Alexander Korotkov 11:45
Re: CREATE DATABASE with filesystem cloning 📎 Nazir Bilal Yavuz 12:00
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Andrew Dunstan 12:00
Re: Control flow in logical replication walsender Amit Kapila 12:02
Re: Control flow in logical replication walsender Amit Kapila 12:16
Re: bug: copy progress reporting of backends which run multiple COPYs Justin Pryzby 12:27
pg_restore -N loses extension comment Justin Pryzby 12:28
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Michail Nikolaev 12:35
Re: CREATE DATABASE with filesystem cloning Ranier Vilela 13:28
Re: WHERE CURRENT OF with RLS quals that are ctid conditions Robert Haas 13:47
Re: pg_restore -N loses extension comment Tom Lane 13:52
Re: WHERE CURRENT OF with RLS quals that are ctid conditions Robert Haas 14:05
Re: WHERE CURRENT OF with RLS quals that are ctid conditions Tom Lane 14:05
Re: WHERE CURRENT OF with RLS quals that are ctid conditions Tom Lane 14:16
Re: New GUC autovacuum_max_threshold ? Robert Haas 14:31
Re: pg_restore -N loses extension comment 📎 Tom Lane 14:49
PERIOD foreign key feature Bruce Momjian 14:54
Re: PERIOD foreign key feature David G. Johnston 15:23
Re: allow changing autovacuum_max_workers without restarting 📎 Nathan Bossart 16:06
Re: PERIOD foreign key feature Paul Jungwirth 16:43
Re: pg_sequence_last_value() for unlogged sequences on standbys Nathan Bossart 17:10
Re: pg_sequence_last_value() for unlogged sequences on standbys Tom Lane 17:44
Re: Use pgstat_kind_infos to read fixed shared stats structs Tristan Partin 17:47
Re: Control flow in logical replication walsender Christophe Pettus 18:12
Re: 2024-05-09 release announcement draft Noah Misch 18:14
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. 📎 Tom Lane 18:20
Re: Use pgstat_kind_infos to read fixed shared stats structs Andres Freund 18:29
Re: pg_sequence_last_value() for unlogged sequences on standbys 📎 Nathan Bossart 18:40
Re: Weird test mixup 📎 Noah Misch 18:53
Re: backend stuck in DataFileExtend Justin Pryzby 18:54
Re: pg_sequence_last_value() for unlogged sequences on standbys Tom Lane 19:02
Re: Use pgstat_kind_infos to read fixed shared stats structs Tristan Partin 19:07
Re: pg_sequence_last_value() for unlogged sequences on standbys 📎 Nathan Bossart 19:39
Re: On disable_cost 📎 Robert Haas 20:19
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Michail Nikolaev 20:23
Re: partitioning and identity column Peter Eisentraut 21:04
Re: [PATCH] json_lex_string: don't overread on bad UTF8 Jacob Champion 21:06
Re: New GUC autovacuum_max_threshold ? Nathan Bossart 21:17
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); 📎 Tom Lane 21:27
Re: Weird test mixup Noah Misch 22:00
BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Wetmore, Matthew (CTR) 22:09
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 22:35
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 22:37
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Tom Lane 22:40
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 22:47
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Tom Lane 22:55
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. David Rowley 23:03
Re: Revert: Remove useless self-joins *and* -DREALLOCATE_BITMAPSETS make server crash, regress test fail. Tom Lane 23:18

May 8, 2024

Thread Author Time
Re: Slow catchup of 2PC (twophase) transactions on replica in LR Peter Smith 00:07
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? Michael Paquier 00:45
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); jian he 01:03
Re: bug: copy progress reporting of backends which run multiple COPYs Michael Paquier 01:12
Re: backend stuck in DataFileExtend Thomas Munro 01:13
Re: Use pgstat_kind_infos to read fixed shared stats structs Michael Paquier 01:21
Re: pg_sequence_last_value() for unlogged sequences on standbys Michael Paquier 02:01
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 Masahiko Sawada 02:53
Re: Use WALReadFromBuffers in more places Jingtang Zhang 04:20
Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica Michael Paquier 04:24
Re: [PATCH] json_lex_string: don't overread on bad UTF8 Michael Paquier 05:30
Re: Fix for recursive plpython triggers Andreas Karlsson 07:03
Re: Pgoutput not capturing the generated columns 📎 Shubham Khanna 07:13
Re: CREATE DATABASE with filesystem cloning Nazir Bilal Yavuz 07:37
Re: add --no-sync to pg_upgrade's calls to pg_dump and pg_dumpall Peter Eisentraut 08:09
RE: Slow catchup of 2PC (twophase) transactions on replica in LR 📎 Hayato Kuroda (Fujitsu) 08:26
Re: A problem about partitionwise join Richard Guo 09:01
Re: Synchronizing slots from primary to standby Bertrand Drouvot 09:20
Expand applicability of aggregate's sortop optimization 📎 Matthias van de Meent 10:13
Re: Expand applicability of aggregate's sortop optimization Dagfinn Ilmari Mannsåker 10:58
Re: CREATE DATABASE with filesystem cloning Ranier Vilela 11:16
Re: AIX support Sriram RK 11:39
Re: CREATE DATABASE with filesystem cloning Nazir Bilal Yavuz 11:42
RE: Pgoutput not capturing the generated columns Hayato Kuroda (Fujitsu) 12:07
Re: CREATE DATABASE with filesystem cloning Ranier Vilela 12:23
Re: PERIOD foreign key feature Peter Eisentraut 12:29
Re: CREATE DATABASE with filesystem cloning Nazir Bilal Yavuz 13:06
Re: CREATE DATABASE with filesystem cloning Ranier Vilela 13:20
Re: AIX support Peter Eisentraut 13:44
Re: Fix parallel vacuum buffer usage reporting Masahiko Sawada 13:46
Re: SQL:2011 application time Peter Eisentraut 13:51
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Tom Lane 13:55
Re: CREATE DATABASE with filesystem cloning Robert Haas 13:57
Re: [PATCH] json_lex_string: don't overread on bad UTF8 Jacob Champion 14:01
Re: AIX support Bruce Momjian 14:06
Re: bug: copy progress reporting of backends which run multiple COPYs Robert Haas 14:07
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Tom Lane 14:10
Re: CREATE DATABASE with filesystem cloning Nazir Bilal Yavuz 14:34
Re: PERIOD foreign key feature Bruce Momjian 14:44
Re: Trigger violates foreign key constraint Tom Lane 15:14
Re: UUID v7 Andrey M. Borodin 15:37
Re: Fix for recursive plpython triggers 📎 Tom Lane 15:51

Browse Archives

Prev | Next