pgsql-hackers since 2025-02-07 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

Feb. 7, 2025

Thread	Author	Time
Re: Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures?	Tom Lane	00:15
FSM doesn't recover after zeroing damaged page. 📎	Anton A. Melnikov	00:15
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	00:47
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎	Sami Imseih	01:52
RE: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Hayato Kuroda (Fujitsu)	02:16
Re: Document NULL	jian he	02:28
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	02:29
Re: Document NULL	David G. Johnston	02:42
Re: Add isolation test template in injection_points for wait/wakeup/detach 📎	Michael Paquier	04:41
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Amit Kapila	05:30
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	05:47
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	05:48
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	05:52
Re: SLRU_PAGES_PER_SEGMENT as configure parameter 📎	Daniil Davydov	05:54
Fix for a crash caused by triggers in cross-partition updates 📎	Kyotaro Horiguchi	06:02
Re: Statistics Import and Export	Michael Paquier	06:07
DOCS - inactive_since field readability 📎	Peter Smith	06:34
Re: Trigger more frequent autovacuums of heavy insert tables	wenhui qiu	06:40
Re: Fix for a crash caused by triggers in cross-partition updates	Michael Paquier	06:47
[PATCH] Fix Potential Memory Leak in pg_amcheck Code 📎	Saladin	07:04
Re: Avoid updating inactive_since for invalid replication slots	Peter Smith	07:16
Re: Re: proposal: schema variables 📎	Pavel Stehule	07:24
Re: Better visualization of default values	Vladlen Popolitov	07:39
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Bertrand Drouvot	07:49
Re: Trigger more frequent autovacuums of heavy insert tables	Japin Li	07:54
Coverage with clang will now works	Nikolay Shaplov	08:00
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Bertrand Drouvot	08:05
Re: Modern SHA2- based password hashes for pgcrypto	Japin Li	08:17
Re: [PATCH] Fix Potential Memory Leak in pg_amcheck Code	Daniel Gustafsson	08:28
Re: SLRU_PAGES_PER_SEGMENT as configure parameter	Daniel Gustafsson	08:49
Re: Docs for pg_basebackup needs v17 note for incremental backup	Álvaro Herrera	09:22
Re: Modern SHA2- based password hashes for pgcrypto	Alvaro Herrera	09:31
Re: Increased work_mem for "logical replication tablesync worker" only?	vignesh C	10:31
Re: Using Expanded Objects other than Arrays from plpgsql	Andrey Borodin	10:40
Re: new commitfest transition guidance	Aleksander Alekseev	10:48
Re: Get rid of WALBufMappingLock 📎	Yura Sokolov	11:02
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	11:14
Re: Get rid of WALBufMappingLock 📎	Yura Sokolov	11:24
Re: Get rid of WALBufMappingLock	Alexander Korotkov	11:39
Re: Virtual generated columns	Peter Eisentraut	12:34
Re: Virtual generated columns	Peter Eisentraut	12:36
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Sutou Kouhei	13:01
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	13:05
Re: Re: proposal: schema variables	jian he	13:14
Re: add support for the old naming libs convention on windows (ssleay32.lib and libeay32.lib)	Daniel Gustafsson	14:14
Re: add support for the old naming libs convention on windows (ssleay32.lib and libeay32.lib)	Darek Ślusarczyk	14:20
Re: Proposal to CREATE FOREIGN TABLE LIKE	Zhang Mingli	14:24
Draft for basic NUMA observability 📎	Jakub Wartak	14:32
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	14:41
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	14:45
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	14:46
Re: Index AM API cleanup 📎	Peter Eisentraut	15:53
Re: Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures?	Tomas Vondra	16:24
RE: AIX support	Srirama Kucherlapati	16:50
Re: Proposal to CREATE FOREIGN TABLE LIKE 📎	Zhang Mingli	16:50
Re: Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures?	Tom Lane	16:58
Draft back-branch release notes are up	Tom Lane	17:01
Re: Fix for Extra Parenthesis in pgbench progress message	Andres Freund	17:28
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	17:37
Re: Fix for Extra Parenthesis in pgbench progress message	Nathan Bossart	17:57
Re: Fix for Extra Parenthesis in pgbench progress message	Tom Lane	17:58
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Masahiko Sawada	18:00
Re: Fix for Extra Parenthesis in pgbench progress message	Nathan Bossart	18:02
Re: Fix for Extra Parenthesis in pgbench progress message 📎	Tom Lane	18:10
Re: Fix for Extra Parenthesis in pgbench progress message	Andres Freund	18:11
Re: Fix for Extra Parenthesis in pgbench progress message	Nathan Bossart	18:13
Re: Fix for Extra Parenthesis in pgbench progress message	Tom Lane	18:14
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	18:44
Re: should we have a fast-path planning for OLTP starjoins?	James Hunter	19:11
Re: Collation & ctype method table, and extension hooks 📎	Jeff Davis	19:19
Re: Trigger more frequent autovacuums of heavy insert tables	Melanie Plageman	19:21
Re: [18] separate collation and ctype versions, and cleanup of pg_database locale fields	Jeff Davis	19:28
Re: explain analyze rows=%.0f	Matheus Alcantara	19:59
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎	Pavel Stehule	20:00
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	20:09
Re: [PoC] Federated Authn/z with OAUTHBEARER	Daniel Gustafsson	20:12
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	20:38
Re: explain analyze rows=%.0f	Ilia Evdokimov	20:41
Re: Trigger more frequent autovacuums of heavy insert tables	Melanie Plageman	20:57
Re: explain analyze rows=%.0f	Matheus Alcantara	21:01
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	21:05
Re: explain analyze rows=%.0f 📎	Ilia Evdokimov	21:28
Re: Adjusting hash join memory limit to handle batch explosion	Melanie Plageman	22:14
describe special values in GUC descriptions more consistently 📎	Nathan Bossart	22:27
Re: Cross-type index comparison support in contrib/btree_gin 📎	Tom Lane	22:41
Re: should we have a fast-path planning for OLTP starjoins?	James Hunter	22:43
Re: pgbench with partitioned tables	Melanie Plageman	23:15
Re: Fix for Extra Parenthesis in pgbench progress message	Tatsuo Ishii	23:26
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	23:29
Question about UpdateFullPageWrites() at the end of recovery.	Masahiko Sawada	23:44
Re: Adjusting hash join memory limit to handle batch explosion 📎	Tomas Vondra	23:54

Feb. 8, 2025

Thread	Author	Time
Re: should we have a fast-path planning for OLTP starjoins?	Tom Lane	00:23
BgBufferSync(): clarification about reusable_buffers variable	M vd H	00:53
Re: Reduce TupleHashEntryData struct size by half 📎	Jeff Davis	01:13
Re: Incorrect CHUNKHDRSZ in nodeAgg.c	Jeff Davis	01:15
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	01:49
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	01:56
Re: Add -k/--link option to pg_combinebackup 📎	Israel Barth Rubio	02:12
Re: Modern SHA2- based password hashes for pgcrypto	Japin Li	02:16
Re: Proposal to CREATE FOREIGN TABLE LIKE	Sami Imseih	04:55
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎	jian he	05:40
proposal - plpgsql - support standard syntax for named arguments for cursors 📎	Pavel Stehule	06:47
RE: Introduce XID age and inactive timeout based replication slot invalidation	Zhijie Hou (Fujitsu)	06:58
Re: proposal - plpgsql - support standard syntax for named arguments for cursors	Julien Rouhaud	08:34
Improve pgindent exclude handling: ignore empty lines 📎	Zsolt Parragi	09:39
Re: Get rid of WALBufMappingLock	Alexander Korotkov	10:07
Re: proposal - plpgsql - support standard syntax for named arguments for cursors	Japin Li	10:26
Re: pgbench with partitioned tables	Álvaro Herrera	10:32
Re: proposal - plpgsql - support standard syntax for named arguments for cursors 📎	Pavel Stehule	11:28
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎	Michail Nikolaev	13:46
Re: Showing applied extended statistics in explain Part 2	Tomas Vondra	13:50
Re: RFC: Allow EXPLAIN to Output Page Fault Information	Jelte Fennema-Nio	13:54
Re: proposal - plpgsql - support standard syntax for named arguments for cursors	Tom Lane	19:25
Re: proposal - plpgsql - support standard syntax for named arguments for cursors	Pavel Stehule	19:56
Re: Final result (display) collation?	Jeff Davis	20:23
Re: access numeric data in module 📎	Ed Behn	20:24
Re: proposal - plpgsql - support standard syntax for named arguments for cursors	Tom Lane	21:25
Re: UUID v7 📎	Sergey Prokhorenko	21:56

Feb. 9, 2025

Thread	Author	Time
Re: proposal - plpgsql - support standard syntax for named arguments for cursors	Pavel Stehule	05:22
Re: Expanding HOT updates for expression and partial indexes	Laurenz Albe	06:14
Fix punctuation errors in PostgreSQL documentation 📎	斉藤登	06:43
Re: On non-Windows, hard depend on uselocale(3) 📎	Peter Eisentraut	07:32
Re: Test to dump and restore objects left behind by regression	Michael Paquier	07:55
Re: Virtual generated columns	Alexander Lakhin	08:00
Re: Improve CRC32C performance on SSE4.2 📎	John Naylor	09:00
Re: Things I don't like about \du's "Attributes" column	Pavel Luzanov	09:11
Re: Virtual generated columns	Zhang Mingli	11:01
Re: Removing unneeded self joins 📎	Alexander Korotkov	11:41
Re: RFC: Allow EXPLAIN to Output Page Fault Information	Jelte Fennema-Nio	11:51
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alexander Korotkov	11:58
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE	Jelte Fennema-Nio	12:05
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Rushabh Lathia	12:25
Re: Remove useless casts to (char *) 📎	Peter Eisentraut	12:26
Re: Proposal to CREATE FOREIGN TABLE LIKE 📎	Zhang Mingli	13:16
Re: BitmapHeapScan streaming read user and prelim refactoring	Tomas Vondra	14:27
Re: Thread-safe nl_langinfo() and localeconv() 📎	Peter Eisentraut	14:52
Re: pull-up subquery if JOIN-ON contains refs to upper-query 📎	Alena Rybakina	15:14
Fix outdated code comments in nodeAgg.c 📎	Zhang Mingli	15:14
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alexander Korotkov	15:38
Re: UUID v7 📎	Andrey Borodin	17:07
Re: RFC: Allow EXPLAIN to Output Page Fault Information	Andres Freund	17:59
Re: RFC: Allow EXPLAIN to Output Page Fault Information	Tom Lane	18:05
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Rushabh Lathia	18:58
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alena Rybakina	19:47
Re: RFC: Allow EXPLAIN to Output Page Fault Information	Jelte Fennema-Nio	20:06
Re: Confusing variable naming in LWLockRelease	Jacob Brazeal	20:17
Re: MAX_BACKENDS size (comment accuracy)	Jacob Brazeal	20:41
Re: Re: proposal: schema variables 📎	Pavel Stehule	20:56
Re: describe special values in GUC descriptions more consistently	Peter Smith	22:13

Feb. 10, 2025

Thread	Author	Time
Re: Fix punctuation errors in PostgreSQL documentation	David G. Johnston	01:17
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Michael Paquier	01:25
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Hayato Kuroda (Fujitsu)	01:28
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	01:32
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Peter Smith	01:35
Re: Statistics Import and Export 📎	Corey Huinker	03:00
Uncached buffered IO	wenhui qiu	03:39
Re: Trying to build x86 version on windows using meson	Thomas Munro	03:42
Re: Virtual generated columns	Richard Guo	03:54
Re: Showing applied extended statistics in explain Part 2 📎	Tatsuro Yamada	04:40
Re: Virtual generated columns 📎	jian he	04:52
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	04:56
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints 📎	Suraj Kharage	05:13
Re: Virtual generated columns	Zhang Mingli	05:15
Re: Removing unneeded self joins 📎	Andrei Lepikhov	05:19
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Peter Smith	06:03
Re: NOT ENFORCED constraint feature 📎	Amul Sul	06:03
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	06:09
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	06:10
Re: SQL Property Graph Queries (SQL/PGQ)	Ashutosh Bapat	06:14
Re: should we have a fast-path planning for OLTP starjoins?	Richard Guo	07:29
Re: Sample rate added to pg_stat_statements 📎	Ilia Evdokimov	08:05
Re: branch-free tuplesort partitioning 📎	John Naylor	08:18
Re: Adjust tuples estimate for appendrels 📎	Richard Guo	08:22
Re: hash_search_with_hash_value is high in "perf top" on a replica	Jakub Wartak	08:45
Re: Fix outdated code comments in nodeAgg.c	Richard Guo	08:45
Re: Showing applied extended statistics in explain Part 2	Andrei Lepikhov	09:09
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	09:15
Re: outdated comment in table_tuple_update definition	Ashutosh Bapat	09:31
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	09:35
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	09:45
RE: Introduce XID age and inactive timeout based replication slot invalidation	Zhijie Hou (Fujitsu)	09:56
Re: Restrict publishing of partitioned table with a foreign table as partition	vignesh C	10:40
Re: Fix punctuation errors in PostgreSQL documentation	John Naylor	11:34
Re: Doc: Move standalone backup section, mention -X argument	Álvaro Herrera	11:54
Re: Expanding HOT updates for expression and partial indexes	Burd, Greg	12:02
Re: Enhancing Memory Context Statistics Reporting	torikoshia	12:02
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	12:03
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Amit Kapila	12:11
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	12:19
Re: Separate memory contexts for relcache and catcache 📎	Melih Mutlu	12:41
Re: Introduce XID age and inactive timeout based replication slot invalidation	vignesh C	12:42
Re: RFC: Allow EXPLAIN to Output Page Fault Information 📎	torikoshia	13:23
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	13:27
Re: RFC: Allow EXPLAIN to Output Page Fault Information	Andres Freund	13:31
support virtual generated column not null constraint 📎	jian he	13:33
Re: [RFC] Lock-free XLog Reservation from WAL	Zhou, Zhiguo	14:12
Fix 035_standby_logical_decoding.pl race conditions 📎	Bertrand Drouvot	14:42
Re: Doc: Move standalone backup section, mention -X argument	David G. Johnston	14:46
Re: BF member drongo doesn't like 035_standby_logical_decoding.pl	Bertrand Drouvot	14:47
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Junwang Zhao	15:00

Browse Archives

Prev | Next