pgsql-hackers since 2025-02-03 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. 3, 2025

Thread	Author	Time
meson's in-tree libpq header search order vs -Dextra_include_dirs 📎	Thomas Munro	00:28
Re: Proposal to CREATE FOREIGN TABLE LIKE	Michael Paquier	00:29
Re: [PATCH] Fix incorrect range in pg_regress comment	Michael Paquier	00:34
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	00:46
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎	jian he	02:45
Re: pgbench with partitioned tables	Sami Imseih	02:58
Re: Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	03:02
Re: jsonlog missing from logging_collector description	Michael Paquier	03:04
Re: Increased work_mem for "logical replication tablesync worker" only?	Amit Kapila	03:09
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value.	Amit Kapila	03:30
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	03:33
Re: [PATCH] Fix incorrect range in pg_regress comment	Tom Lane	03:38
Re: Show WAL write and fsync stats in pg_stat_io 📎	Michael Paquier	04:07
Re: NOT ENFORCED constraint feature	Amul Sul	04:09
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Amit Kapila	04:11
Re: NOT ENFORCED constraint feature	Amul Sul	04:27
Re: pgbench with partitioned tables 📎	Sergey Tatarintsev	04:37
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	05:04
Re: NOT ENFORCED constraint feature	Ashutosh Bapat	05:19
Re: NOT ENFORCED constraint feature	Amul Sul	05:30
Re: Logging parallel worker draught 📎	Sami Imseih	05:36
Re: Logical Replication of sequences 📎	vignesh C	05:43
RE: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value.	Hayato Kuroda (Fujitsu)	05:50
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	05:50
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value.	Peter Smith	05:59
Re: POC, WIP: OR-clause support for indexes	Andrei Lepikhov	06:24
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	06:34
Re: Make COPY format extendable: Extract COPY TO format implementations	Vladlen Popolitov	06:38
Re: why there is not VACUUM FULL CONCURRENTLY?	Antonin Houska	07:01
Optimize scram_SaltedPassword performance 📎	Zixuan Fu	07:11
Re: SQL/JSON json_table plan clause	Vladlen Popolitov	07:15
Re: Optimize scram_SaltedPassword performance	Yura Sokolov	07:45
Re: NOT ENFORCED constraint feature	Alvaro Herrera	07:50
Re: pgbench with partitioned tables	Álvaro Herrera	07:57
Re: Optimize scram_SaltedPassword performance	Michael Paquier	08:16
Re: Show WAL write and fsync stats in pg_stat_io	Bertrand Drouvot	08:50
Re: Non-text mode for pg_dumpall	Srinath Reddy	08:53
Re: Non-text mode for pg_dumpall	Srinath Reddy	09:02
Re: Optimize scram_SaltedPassword performance	Fu Zixuan	09:07
Re: Non-text mode for pg_dumpall 📎	jian he	09:14
Re: Using Expanded Objects other than Arrays from plpgsql	Andrey Borodin	09:19
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	09:25
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	10:22
Re: Truncate logs by max_log_size	Jim Jones	10:31
Re: Show WAL write and fsync stats in pg_stat_io	Bertrand Drouvot	10:37
Re: Increased work_mem for "logical replication tablesync worker" only?	Dmitry Koterov	11:04
Re: Index AM API cleanup	Peter Eisentraut	11:08
Re: Optimize scram_SaltedPassword performance	Daniel Gustafsson	11:17
new commitfest transition guidance	Peter Eisentraut	11:22
Re: Extensible storage manager API - SMGR hook Redux 📎	Andreas Karlsson	11:27
Re: POC, WIP: OR-clause support for indexes 📎	Alexander Korotkov	11:32
Re: Show WAL write and fsync stats in pg_stat_io	Nazir Bilal Yavuz	11:34
RE: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎	Hayato Kuroda (Fujitsu)	11:40
Re: Using Expanded Objects other than Arrays from plpgsql	Pavel Borisov	11:42
Re: Optimize scram_SaltedPassword performance	Yura Sokolov	11:45
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options	Tatsuo Ishii	11:45
Re: NOT ENFORCED constraint feature	Ashutosh Bapat	11:46
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	11:54
Avoid updating inactive_since for invalid replication slots 📎	Nisha Moond	12:03
Re: Introduce XID age and inactive timeout based replication slot invalidation	Nisha Moond	12:05
sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum 📎	Yura Sokolov	12:05
Re: POC, WIP: OR-clause support for indexes	Pavel Borisov	12:16
Re: NOT ENFORCED constraint feature	Alvaro Herrera	12:19
Re: Increased work_mem for "logical replication tablesync worker" only?	Dmitry Koterov	12:21
Re: pgbench with partitioned tables 📎	Sergey Tatarintsev	12:23
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Yuki Seino	12:30
Re: SQLFunctionCache and generic plans	Pavel Stehule	12:39
Re: Extensible storage manager API - SMGR hook Redux	Andreas Karlsson	12:41
Re: RFC: Logging plan of the running query 📎	torikoshia	12:46
Re: Enhancing Memory Context Statistics Reporting 📎	Rahila Syed	12:47
Re: Non-text mode for pg_dumpall 📎	jian he	12:49
Re: Increased work_mem for "logical replication tablesync worker" only?	Dmitry Koterov	12:49
Re: new commitfest transition guidance	Aleksander Alekseev	12:53
Re: new commitfest transition guidance	Aleksander Alekseev	12:55
Re: Introduce XID age and inactive timeout based replication slot invalidation	Shlok Kyal	13:05
Re: why there is not VACUUM FULL CONCURRENTLY?	Antonin Houska	13:07
Change log level for notifying hot standby is waiting non-overflowed snapshot 📎	torikoshia	13:35
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Tender Wang	14:28
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	14:33
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	15:37
Re: SQLFunctionCache and generic plans	Tom Lane	16:00
Re: new commitfest transition guidance	Jelte Fennema-Nio	16:19
Re: SQLFunctionCache and generic plans	Pavel Stehule	16:32
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Álvaro Herrera	16:40
Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum	Heikki Linnakangas	16:49
Re: new commitfest transition guidance	Michail Nikolaev	16:57
Re: Doc fix of aggressive vacuum threshold for multixact members storage	Sami Imseih	16:59
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎	Melanie Plageman	17:19
Re: Doc fix of aggressive vacuum threshold for multixact members storage	Alex Friedman	17:29
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	17:36
Better title output for psql \dt \di etc. commands 📎	Greg Sabino Mullane	17:38
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	17:53
Re: SQLFunctionCache and generic plans	Pavel Stehule	17:55
Re: Using Expanded Objects other than Arrays from plpgsql 📎	Andrey Borodin	17:57
Re: SIGSEGV, FPE fix in pg_controldata 📎	Alexander Korotkov	17:59
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	18:04
Re: Better title output for psql \dt \di etc. commands	Tom Lane	18:07
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	18:18
Re: Skip collecting decoded changes of already-aborted transactions 📎	Masahiko Sawada	18:41
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	18:48
Re: Skip collecting decoded changes of already-aborted transactions	Masahiko Sawada	18:55
Re: Doc fix of aggressive vacuum threshold for multixact members storage	Sami Imseih	19:05
Re: Using Expanded Objects other than Arrays from plpgsql	Andrey Borodin	19:15
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value.	Masahiko Sawada	19:32
Re: Better title output for psql \dt \di etc. commands 📎	Greg Sabino Mullane	19:39
Re: New GUC autovacuum_max_threshold ? 📎	Nathan Bossart	19:51
Re: SQLFunctionCache and generic plans	Tom Lane	19:58
Re: Track the amount of time waiting due to cost_delay	Nathan Bossart	20:05
Re: Commitfest app release on Feb 17 with many improvements	Nathan Bossart	20:12
Re: Better title output for psql \dt \di etc. commands	Tom Lane	20:12
Prevent COPY FREEZE on Foreign tables 📎	Sami Imseih	20:18
Re: why there is not VACUUM FULL CONCURRENTLY?	Nathan Bossart	20:27
Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?	Sami Imseih	20:29
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value.	Masahiko Sawada	20:36
Re: RFC: Additional Directory for Extensions	David E. Wheeler	20:42
injection points for hash aggregation 📎	Jeff Davis	20:45
Re: Prevent COPY FREEZE on Foreign tables	Nathan Bossart	20:48
Re: Prevent COPY FREEZE on Foreign tables	Sami Imseih	21:05
Re: Better title output for psql \dt \di etc. commands	Nathan Bossart	21:08
Re: Better title output for psql \dt \di etc. commands 📎	Greg Sabino Mullane	21:22
Re: SQLFunctionCache and generic plans	Tom Lane	22:08
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	22:32
Re: Better title output for psql \dt \di etc. commands 📎	Tom Lane	22:38
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	23:38
Re: injection points for hash aggregation 📎	Jeff Davis	23:54

Feb. 4, 2025

Thread	Author	Time
Re: injection points for hash aggregation	Michael Paquier	00:21
Question -- why is there no errhint_internal function?	Peter Smith	00:33
Re: [PATCH] Fix incorrect range in pg_regress comment	Michael Paquier	00:35
Re: Optimize scram_SaltedPassword performance	Michael Paquier	00:47
Re: Better title output for psql \dt \di etc. commands	Greg Sabino Mullane	00:47
Re: Question -- why is there no errhint_internal function?	Tom Lane	00:54
Re: Better title output for psql \dt \di etc. commands	Tom Lane	00:58
Re: Prevent COPY FREEZE on Foreign tables	Zhang Mingli	01:31
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎	Michail Nikolaev	01:38
Re: New GUC autovacuum_max_threshold ?	wenhui qiu	01:41
Re: Non-text mode for pg_dumpall	jian he	02:04
Re: Eagerly scan all-visible pages to amortize aggressive vacuum	Andres Freund	02:09
Re: SQL/JSON json_table plan clause	Amit Langote	03:05
Re: Avoid updating inactive_since for invalid replication slots	Peter Smith	03:06
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	vignesh C	03:19
RE: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Zhijie Hou (Fujitsu)	03:32
Re: injection points for hash aggregation	Michael Paquier	03:50
Re: Avoid updating inactive_since for invalid replication slots	Amit Kapila	04:03
RE: Avoid updating inactive_since for invalid replication slots	Zhijie Hou (Fujitsu)	04:03
Re: [fixed] Trigger test 📎	Dmitrii Bondar	04:04
Re: NOT ENFORCED constraint feature	Ashutosh Bapat	04:39
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	05:08
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	05:15
Re: Adding facility for injection points (or probe points?) for more advanced tests	Jeff Davis	05:30
Re: injection points for hash aggregation	Jeff Davis	05:35
Re: new commitfest transition guidance	Tom Lane	05:50
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎	Chiranmoy.Bhattacharya@fujitsu.com	06:06
Re: Avoid updating inactive_since for invalid replication slots 📎	Nisha Moond	06:22
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	06:29
Re: Increased work_mem for "logical replication tablesync worker" only?	Amit Kapila	06:31
Re: Increased work_mem for "logical replication tablesync worker" only?	Amit Kapila	06:32
Re: Avoid updating inactive_since for invalid replication slots	vignesh C	06:35
Re: plperl version on the meson setup summary screen 📎	Zharkov Roman	06:37
Re: new commitfest transition guidance	Daniel Gustafsson	06:39
Re: Avoid updating inactive_since for invalid replication slots	Amit Kapila	06:50
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	07:03
Re: Non-text mode for pg_dumpall 📎	jian he	07:42
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	07:55
Re: Unsafe access BufferDescriptors array in BufferGetLSNAtomic()	Richard Guo	07:59
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	08:15
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	08:39
Re: per backend WAL statistics	Bertrand Drouvot	08:49
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Masahiko Sawada	08:59
Re: [PATCH] SVE popcount support 📎	Chiranmoy.Bhattacharya@fujitsu.com	09:01
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎	Shayon Mukherjee	09:44
Restrict copying of invalidated replication slots 📎	Shlok Kyal	09:56
Re: Introduce XID age and inactive timeout based replication slot invalidation	Shlok Kyal	09:58
Re: Track the amount of time waiting due to cost_delay 📎	Bertrand Drouvot	10:14
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	10:19
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning	Ashutosh Bapat	10:21
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	10:27
Re: NOT ENFORCED constraint feature 📎	Amul Sul	10:34
Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum 📎	Yura Sokolov	10:36
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning	Ashutosh Bapat	10:37
Re: Make COPY format extendable: Extract COPY TO format implementations	Vladlen Popolitov	10:46
Re: Introduce XID age and inactive timeout based replication slot invalidation	vignesh C	11:11
Re: SQL/JSON json_table plan clause	Nikita Malakhov	11:50
Re: Using Expanded Objects other than Arrays from plpgsql	Pavel Borisov	11:54
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Shlok Kyal	12:09
RE: Introduce XID age and inactive timeout based replication slot invalidation	Hayato Kuroda (Fujitsu)	12:16
Re: Restrict publishing of partitioned table with a foreign table as partition	vignesh C	12:46
Re: Restrict publishing of partitioned table with a foreign table as partition	vignesh C	13:01
Re: POC: track vacuum/analyze cumulative time per relation	Alena Rybakina	13:06
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	13:24
Re: Index AM API cleanup 📎	Peter Eisentraut	13:31
Re: NOT ENFORCED constraint feature	Peter Eisentraut	13:52
Re: NOT ENFORCED constraint feature	Peter Eisentraut	13:54
Re: NOT ENFORCED constraint feature	Peter Eisentraut	13:56
should we have a fast-path planning for OLTP starjoins? 📎	Tomas Vondra	14:00
Re: NOT ENFORCED constraint feature	Alvaro Herrera	14:22
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎	Nisha Moond	14:26
Re: Better title output for psql \dt \di etc. commands	Álvaro Herrera	14:27
Re: Show WAL write and fsync stats in pg_stat_io	Nazir Bilal Yavuz	14:29
Re: Show WAL write and fsync stats in pg_stat_io 📎	Nazir Bilal Yavuz	14:40
Re: Convert sepgsql tests to TAP	Peter Eisentraut	14:56

Browse Archives

Prev | Next