pgsql-hackers since 2025-02-04 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. 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. 📎	[email protected]	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 📎	[email protected]	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
Re: Should heapam_estimate_rel_size consider fillfactor?	Tomas Vondra	15:02
Re: Vacuum statistics 📎	Alena Rybakina	15:22
Re: Vacuum statistics 📎	Alena Rybakina	15:49
Re: Restrict publishing of partitioned table with a foreign table as partition	Álvaro Herrera	15:51
Re: Better title output for psql \dt \di etc. commands	Tom Lane	16:13
Re: Commitfest app release on Feb 17 with many improvements	Álvaro Herrera	16:27
add missing PQfinish() calls to vacuumdb 📎	Nathan Bossart	16:30
RE: SIGSEGV, FPE fix in pg_controldata	Ilyasov Ian	16:36
Re: Add a warning message when using unencrypted passwords 📎	Guillaume Lelarge	16:46
Re: Doc fix of aggressive vacuum threshold for multixact members storage 📎	Alex Friedman	16:48
Re: add missing PQfinish() calls to vacuumdb	Daniel Gustafsson	16:51
Re: Should heapam_estimate_rel_size consider fillfactor? 📎	Tomas Vondra	16:54
Re: Add a warning message when using unencrypted passwords	Tom Lane	16:59
Re: RFC: Packing the buffer lookup table	Matthias van de Meent	17:15
Re: Eagerly scan all-visible pages to amortize aggressive vacuum	Robert Haas	17:17
Re: Orphaned users in PG16 and above can only be managed by Superusers	Robert Haas	17:23
Re: Eagerly scan all-visible pages to amortize aggressive vacuum 📎	Melanie Plageman	17:44
Re: Windows CFBot is broken because ecpg dec_test.c error	Andres Freund	17:46
Re: RFC: Packing the buffer lookup table	Matthias van de Meent	17:46
Re: Sample rate added to pg_stat_statements	Sami Imseih	17:59
Re: Add a warning message when using unencrypted passwords	Guillaume Lelarge	18:14
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Masahiko Sawada	18:20
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints	Alvaro Herrera	18:41
Re: RFC: Packing the buffer lookup table 📎	Matthias van de Meent	18:58
Re: hash_search_with_hash_value is high in "perf top" on a replica	Matthias van de Meent	19:03
Re: Better title output for psql \dt \di etc. commands	Álvaro Herrera	19:03
Re: Doc fix of aggressive vacuum threshold for multixact members storage 📎	Sami Imseih	19:23
Re: add missing PQfinish() calls to vacuumdb	Nathan Bossart	19:30
Re: should we have a fast-path planning for OLTP starjoins?	Jeff Davis	19:43
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	19:55
Re: Better title output for psql \dt \di etc. commands	Tom Lane	19:56
Re: Eagerly scan all-visible pages to amortize aggressive vacuum	Robert Treat	19:57
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	20:06
Re: new commitfest transition guidance	Jeff Davis	20:11
Re: Optimization for lower(), upper(), casefold() functions. 📎	Alexander Borisov	20:19
Re: should we have a fast-path planning for OLTP starjoins?	Tom Lane	20:23
Re: should we have a fast-path planning for OLTP starjoins?	Joe Conway	20:34
Re: RFC: Additional Directory for Extensions	Andrew Dunstan	20:34
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary 📎	Masahiko Sawada	20:35
Re: Add -k/--link option to pg_combinebackup	Robert Haas	20:45
Re: Eagerly scan all-visible pages to amortize aggressive vacuum	Robert Haas	20:55
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	20:56
Re: SIGSEGV, FPE fix in pg_controldata	Alexander Korotkov	21:14
Re: hash_search_with_hash_value is high in "perf top" on a replica	Thomas Munro	21:22
Re: hash_search_with_hash_value is high in "perf top" on a replica	Thomas Munro	21:25
Re: doc: explain pgstatindex fragmentation	Frédéric Yhuel	21:41
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	21:42
Re: vacuumdb changes for stats import/export 📎	Nathan Bossart	21:43
Re: should we have a fast-path planning for OLTP starjoins?	Tom Lane	21:55
Re: UUID v7	Masahiko Sawada	22:02
Re: UUID v7	Masahiko Sawada	22:06
Re: should we have a fast-path planning for OLTP starjoins?	Jim Nasby	22:28
Re: Eagerly scan all-visible pages to amortize aggressive vacuum	Melanie Plageman	22:34
Re: Virtual generated columns 📎	Peter Eisentraut	22:36
Re: Virtual generated columns	Peter Eisentraut	22:36
Re: should we have a fast-path planning for OLTP starjoins?	Tom Lane	22:49
Re: Commitfest app release on Feb 17 with many improvements	Jelte Fennema-Nio	22:52
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Sami Imseih	23:14
Re: Windows CFBot is broken because ecpg dec_test.c error	Andres Freund	23:22

Feb. 5, 2025

Thread	Author	Time
Re: meson missing test dependencies	Andres Freund	00:04
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Michael Paquier	00:12
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	00:19
Re: Avoid updating inactive_since for invalid replication slots	Peter Smith	00:23
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	00:29
Re: add missing PQfinish() calls to vacuumdb	Michael Paquier	00:36
Re: new commitfest transition guidance	Tomas Vondra	00:38
Re: new commitfest transition guidance	Tom Lane	01:10
Re: RFC: Packing the buffer lookup table	Andres Freund	01:14
Re: RFC: Packing the buffer lookup table	Andres Freund	01:22
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Sami Imseih	01:31
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	01:32
Re: new commitfest transition guidance	Jeff Davis	01:33
Re: new commitfest transition guidance	Jeff Davis	01:40
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎	Lukas Fittl	02:09
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Lukas Fittl	02:16
Re: per backend WAL statistics	Michael Paquier	02:16
Re: Make COPY format extendable: Extract COPY TO format implementations	Vladlen Popolitov	02:19
RE: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Hayato Kuroda (Fujitsu)	02:19
Re: Separate GUC for replication origins 📎	Euler Taveira	02:46
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	03:13
Re: Avoid updating inactive_since for invalid replication slots	Amit Kapila	03:29
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query	Andrei Lepikhov	04:03
Re: Increased work_mem for "logical replication tablesync worker" only?	Dmitry Koterov	04:20
Re: Separate GUC for replication origins	Amit Kapila	04:56
Re: Introduce XID age and inactive timeout based replication slot invalidation	vignesh C	04:59
Re: Make COPY format extendable: Extract COPY TO format implementations	Michael Paquier	05:10
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Shlok Kyal	05:22
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	05:24
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	05:30
Re: Increased work_mem for "logical replication tablesync worker" only?	Amit Kapila	05:56
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	06:10
Re: Add isolation test template in injection_points for wait/wakeup/detach 📎	Michael Paquier	06:12
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	06:20
Re: Test to dump and restore objects left behind by regression	Michael Paquier	06:28
Re: Showing applied extended statistics in explain Part 2	Tatsuro Yamada	06:28
Re: EDB Installer initcluster script changes - review requested	Sandeep Thakkar	06:30
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	06:30
Recheck if ANALYZE is needed after VACUUM finishes by autovacuum 📎	Masahiro Ikeda	06:31
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Amit Kapila	06:38
Re: Restrict publishing of partitioned table with a foreign table as partition	vignesh C	06:42
Re: Vacuum statistics	Alexander Korotkov	06:59
Re: SQL:2023 JSON simplified accessor support 📎	Alexandra Wang	07:20
Re: Introduce XID age and inactive timeout based replication slot invalidation	Peter Smith	07:28
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	07:31
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	07:37
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	07:44
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary	Bertrand Drouvot	07:48
Re: should we have a fast-path planning for OLTP starjoins?	Richard Guo	08:23
Re: using index to speedup add not null constraints to a table 📎	jian he	08:24
Re: should we have a fast-path planning for OLTP starjoins?	Richard Guo	08:27
Re: Logging parallel worker draught	Benoit Lobréau	08:31
Re: [RFC] Lock-free XLog Reservation from WAL	Japin Li	08:32
Re: Restrict publishing of partitioned table with a foreign table as partition	Álvaro Herrera	08:44
Re: Commitfest app release on Feb 17 with many improvements	Álvaro Herrera	08:46
Re: Introduce XID age and inactive timeout based replication slot invalidation	Amit Kapila	09:12
Re: Better title output for psql \dt \di etc. commands	Álvaro Herrera	09:27
Re: Special-case executor expression steps for common combinations 📎	Daniel Gustafsson	10:00
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎	Michail Nikolaev	10:04
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎	Michail Nikolaev	10:11
Re: Sample rate added to pg_stat_statements	Ilia Evdokimov	10:15
Re: per backend WAL statistics	Bertrand Drouvot	10:22
Re: per backend WAL statistics	Michael Paquier	10:31
Re: Add isolation test template in injection_points for wait/wakeup/detach	Bertrand Drouvot	11:03
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	11:07
Re: Make COPY format extendable: Extract COPY TO format implementations	Álvaro Herrera	11:49

Browse Archives

Prev | Next