pgsql-hackers since 2025-03-31 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

March 31, 2025

Thread Author Time
Re: Proposal: Progressive explain torikoshia 00:23
Re: Memoize ANTI and SEMI JOIN inner 📎 Alena Rybakina 02:33
Re: Memoize ANTI and SEMI JOIN inner 📎 Alena Rybakina 02:50
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning David Rowley 02:56
Re: Memoize ANTI and SEMI JOIN inner David Rowley 03:04
Re: Commit fest 2025-03 vignesh C 03:04
Re: Memoize ANTI and SEMI JOIN inner Alena Rybakina 03:21
Re: Memoize ANTI and SEMI JOIN inner David Rowley 03:33
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot 📎 Fujii Masao 03:51
Re: Extended Statistics set/restore/clear functions. 📎 Corey Huinker 05:10
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 05:40
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 05:45
Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari 05:47
Improve coments on structures in trigger.c 📎 Yugo Nagata 06:24
Re: Proposal: Progressive explain Andrei Lepikhov 06:24
PRI?64 vs Visual Studio (2022) Kyotaro Horiguchi 06:28
Re: Memoize ANTI and SEMI JOIN inner 📎 Alena Rybakina 06:34
ICU warnings during make installcheck and text_extensions test 📎 Oleg Tselebrovskiy 06:48
Re: Prune partitions by ScalarArrayOpExpr with an array parameter (partkey = ANY($1)) Andrei Lepikhov 07:01
Re: support virtual generated column not null constraint 📎 jian he 07:26
Re: per backend WAL statistics 📎 Bertrand Drouvot 07:42
Re: Memoize ANTI and SEMI JOIN inner Andrei Lepikhov 07:45
Re: speedup COPY TO for partitioned table. Kirill Reshke 08:05
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints jian he 08:45
Re: Thread-safe nl_langinfo() and localeconv() Peter Eisentraut 08:47
Re: Partition pruning on parameters grouped into an array does not prune properly Andrei Lepikhov 08:53
Re: Memoize ANTI and SEMI JOIN inner Richard Guo 09:03
Re: Fix 035_standby_logical_decoding.pl race conditions Bertrand Drouvot 09:23
Re: Draft for basic NUMA observability Jakub Wartak 09:27
Re: Draft for basic NUMA observability 📎 Jakub Wartak 09:27
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 09:34
Re: Memoize ANTI and SEMI JOIN inner David Rowley 09:39
Re: Memoize ANTI and SEMI JOIN inner Andrei Lepikhov 09:46
Re: Memoize ANTI and SEMI JOIN inner Richard Guo 09:50
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎 Ashutosh Bapat 10:00
Re: Assertion with aborted UPDATE in subtransaction Jasper Smit 10:01
Re: Memoize ANTI and SEMI JOIN inner Richard Guo 10:18
Re: SQLFunctionCache and generic plans Alexander Pyhalov 10:31
Re: Memoize ANTI and SEMI JOIN inner Andrei Lepikhov 10:33
Re: Windows: openssl & gssapi dislike each other Dave Page 10:38
Re: Get rid of WALBufMappingLock 📎 Yura Sokolov 10:42
Re: [PATCH] Automatic client certificate selection support for libpq v1 Robin Haberkorn 10:57
Prevent internal error at concurrent CREATE OR REPLACE FUNCTION 📎 Yugo Nagata 11:00
Re: general purpose array_sort Junwang Zhao 11:02
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION 📎 Yugo Nagata 11:22
RE: Fix slot synchronization with two_phase decoding enabled 📎 Zhijie Hou (Fujitsu) 11:34
Re: Test to dump and restore objects left behind by regression Ashutosh Bapat 11:37
Re: per backend WAL statistics Michael Paquier 11:43
Question about comments on simple_heap_update 📎 Yugo Nagata 11:44
Add partial :-variable expansion to psql \copy Fabien COELHO 11:48
RE: Add partial :-variable expansion to psql \copy 📎 Fabien COELHO 11:51
Re: Test to dump and restore objects left behind by regression 📎 Ashutosh Bapat 11:54
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints jian he 12:25
Add comments about fire_triggers argument in ri_triggers.c 📎 Yugo Nagata 12:26
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits 📎 Bertrand Drouvot 13:05
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Alvaro Herrera 13:10
Re: Proposal: Progressive explain Robert Haas 13:30
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Aidar Imamov 13:37
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot torikoshia 13:44
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot Yugo Nagata 13:45
Re: Thread-safe nl_langinfo() and localeconv() Tom Lane 13:52
Re: Add a function to get the version of installed extension Yugo NAGATA 13:55
Re: Non-text mode for pg_dumpall Andrew Dunstan 13:57
Deadlock detected while executing concurrent insert queries on same table Sri Keerthi 14:03
Re: [PoC] Federated Authn/z with OAUTHBEARER Christoph Berg 14:06
Re: Allow ILIKE forward matching to use btree index Yugo NAGATA 14:09
Re: Improve monitoring of shared memory allocations 📎 Tomas Vondra 14:11
Re: why there is not VACUUM FULL CONCURRENTLY? 📎 Antonin Houska 14:26
Re: encode/decode support for base64url Aleksander Alekseev 14:37
Re: Using read stream in autoprewarm Melanie Plageman 14:42
Re: Proposal: Progressive explain Rafael Thofehrn Castro 14:43
Re: SQLFunctionCache and generic plans Tom Lane 14:50
Re: [PATCH] Automatic client certificate selection support for libpq v1 Seth Robertson 14:56
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback Peter Eisentraut 14:58
Re: Draft for basic NUMA observability Bertrand Drouvot 14:59
Re: Add partial :-variable expansion to psql \copy Tom Lane 15:09
Re: Statistics Import and Export 📎 Corey Huinker 15:11
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). Fujii Masao 15:26
Re: [PATCH] Split varlena.c into varlena.c and bytea.c 📎 Aleksander Alekseev 15:29
Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2 📎 Dean Rasheed 15:33
Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. Christoph Berg 15:40
Re: Add partial :-variable expansion to psql \copy Corey Huinker 15:53
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot 📎 Fujii Masao 16:10
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot Fujii Masao 16:12
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 16:16
Re: Using read stream in autoprewarm 📎 Nazir Bilal Yavuz 16:27
Re: Orphaned users in PG16 and above can only be managed by Superusers Robert Haas 16:45
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions 📎 Nazir Bilal Yavuz 16:49
Re: [PATCH] Automatic client certificate selection support for libpq v1 Jacob Champion 16:52
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Robert Haas 16:55
Re: Make COPY format extendable: Extract COPY TO format implementations David G. Johnston 17:05
Re: general purpose array_sort 📎 Tom Lane 17:11
Re: Non-text mode for pg_dumpall Andrew Dunstan 17:16
Re: Non-text mode for pg_dumpall 📎 Andrew Dunstan 17:20
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Robert Haas 17:21
Re: explain analyze rows=%.0f Robert Haas 17:35
Re: Statistics Import and Export Robert Haas 17:39
Re: explain analyze rows=%.0f Tom Lane 17:49
Re: Non-text mode for pg_dumpall Álvaro Herrera 18:12
Re: Using read stream in autoprewarm Melanie Plageman 18:15
Re: Get rid of WALBufMappingLock Alexander Korotkov 18:18
Re: Truncate logs by max_log_size Fujii Masao 18:20
Re: Proposal - Allow extensions to set a Plan Identifier 📎 Lukas Fittl 18:27
Re: RFC: Logging plan of the running query Sadeq Dousti 18:51
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 18:51
Re: Using read stream in autoprewarm 📎 Nazir Bilal Yavuz 18:58
Re: explain analyze rows=%.0f Robert Haas 19:09
Re: RFC: Logging plan of the running query Robert Haas 19:24
Re: Using read stream in autoprewarm Melanie Plageman 19:27
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 19:35
Re: Using read stream in autoprewarm Melanie Plageman 19:45
Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. David Rowley 20:11
[PATCH] Fix potential overflow in binary search mid calculation 📎 Jianghua Yang 20:28
Re: [PATCH] Automatic client certificate selection support for libpq v1 Seth Robertson 20:29
Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. Christoph Berg 20:40
Re: Make COPY format extendable: Extract COPY TO format implementations David G. Johnston 20:42
Re: explain analyze rows=%.0f Ilia Evdokimov 20:59
Re: Parallel heap vacuum 📎 Masahiko Sawada 21:05
Re: Test to dump and restore objects left behind by regression Daniel Gustafsson 21:17
Re: [PATCH] PGSERVICEFILE as part of a normal connection string 📎 Andrew Jackson 21:26
Re: CSN snapshots in hot standby 📎 Heikki Linnakangas 21:31
Re: pgsql: Add support for OAUTHBEARER SASL mechanism Christoph Berg 21:54
Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. Masahiko Sawada 22:02
Re: Statistics Import and Export Jeff Davis 22:04
Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. David Rowley 22:09
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. Melanie Plageman 22:12
Re: pgsql: Add support for OAUTHBEARER SASL mechanism Christoph Berg 22:17
Re: add function argument name to substring and substr 📎 David G. Johnston 22:22
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. 📎 Masahiko Sawada 22:29
tzdata 2025b Masahiko Sawada 22:33
Re: tzdata 2025b Tom Lane 22:46
Re: pgsql: Add support for OAUTHBEARER SASL mechanism Jacob Champion 23:09
Re: tzdata 2025b Masahiko Sawada 23:09
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Alena Rybakina 23:10
Re: SQLFunctionCache and generic plans 📎 Tom Lane 23:29
Re: Adding comments to help understand psql hidden queries Maiquel Grassi 23:51

April 1, 2025

Thread Author Time
Re: Adding comments to help understand psql hidden queries Maiquel Grassi 00:02
Re: pgsql: Add support for OAUTHBEARER SASL mechanism 📎 Jacob Champion 00:06
Re: AIO v2.5 📎 Andres Freund 00:41
Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN. Tatsuo Ishii 00:48
Re: speedup COPY TO for partitioned table. 📎 jian he 01:01
RE: Fix 035_standby_logical_decoding.pl race conditions 📎 Hayato Kuroda (Fujitsu) 01:22
Re: [PATCH] Fix potential overflow in binary search mid calculation Tender Wang 01:42
Re: RFC: Logging plan of the running query torikoshia 01:43
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎 Peter Geoghegan 02:02
Re: Using read stream in autoprewarm 📎 Melanie Plageman 02:14
Re: general purpose array_sort Junwang Zhao 02:27
Re: Statistics Import and Export 📎 Nathan Bossart 02:33
Re: Statistics Import and Export Robert Treat 03:02
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). 📎 jian he 03:12
Re: Fix slot synchronization with two_phase decoding enabled Amit Kapila 03:20
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). David G. Johnston 03:50
Re: add function argument name to substring and substr jian he 04:11
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Alexander Korotkov 04:14
Re: add function argument name to substring and substr 📎 David G. Johnston 04:59
Re: explain analyze rows=%.0f Andrei Lepikhov 05:20
Re: speedup COPY TO for partitioned table. vignesh C 05:38
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 05:59
Re: Fix slot synchronization with two_phase decoding enabled 📎 Amit Kapila 06:09
Re: Test to dump and restore objects left behind by regression Alvaro Herrera 06:22
Re: Proposal: Progressive explain 📎 Rafael Thofehrn Castro 06:23
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo 06:34
Re: Memoize ANTI and SEMI JOIN inner Richard Guo 07:18
statistics import and export: another difference in dump/restore Ashutosh Bapat 07:24
Re: Test to dump and restore objects left behind by regression 📎 Ashutosh Bapat 07:43
Re: Improve monitoring of shared memory allocations 📎 Rahila Syed 07:43
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment Ilia Evdokimov 07:52
pg_recvlogical cannot create slots with failover=true 📎 Hayato Kuroda (Fujitsu) 08:01
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎 Amit Langote 08:01
Re: pg_recvlogical cannot create slots with failover=true Michael Banck 08:18
Re: Fix 035_standby_logical_decoding.pl race conditions Bertrand Drouvot 08:32
Re: Add partial :-variable expansion to psql \copy Fabien Coelho 08:58
Self referential foreign keys in partitioned table not working as expected Luca Vallisa 09:06
Re: [PATCH] Fix build on MINGW on ARM64 vignesh C 09:16
Re: Add partial :-variable expansion to psql \copy Fabien Coelho 09:30
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). vignesh C 09:45
Re: Add partial :-variable expansion to psql \copy Christoph Berg 10:00
Re: Add partial :-variable expansion to psql \copy Pavel Stehule 10:15
Re: Self referential foreign keys in partitioned table not working as expected Christoph Berg 10:18
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). Kirill Reshke 10:18
Re: Self referential foreign keys in partitioned table not working as expected Luca Vallisa 10:24
Re: [PATCH] Fix build on MINGW on ARM64 Andrew Dunstan 10:32
Re: Improve CRC32C performance on SSE4.2 📎 John Naylor 10:33
Re: AIO writes vs hint bits vs checksums 📎 Heikki Linnakangas 10:34
Re: Self referential foreign keys in partitioned table not working as expected Christoph Berg 10:46
Re: Draft for basic NUMA observability 📎 Jakub Wartak 10:56
RE: Fix slot synchronization with two_phase decoding enabled 📎 Zhijie Hou (Fujitsu) 10:58
Re: Better HINT message for "unexpected data beyond EOF" Jakub Wartak 11:13
Re: Using read stream in autoprewarm Nazir Bilal Yavuz 11:20
Re: Fix 035_standby_logical_decoding.pl race conditions Amit Kapila 11:25
Re: Fix 035_standby_logical_decoding.pl race conditions Amit Kapila 11:44
Hashed IN only applied to first encountered IN 📎 David Geier 11:51
RE: Fix 035_standby_logical_decoding.pl race conditions Hayato Kuroda (Fujitsu) 11:52
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot torikoshia 11:54
Re: AIO v2.5 Aleksander Alekseev 11:56
Re: Add partial :-variable expansion to psql \copy Daniel Verite 12:06
Re: Replace IN VALUES with ANY in WHERE clauses during optimization 📎 Alexander Korotkov 12:07
Re: Hashed IN only applied to first encountered IN David Rowley 12:31
Re: RFC: Logging plan of the running query Robert Haas 12:32
Re: [PATCH] Fix build on MINGW on ARM64 vignesh C 12:47

Browse Archives

Prev | Next