pgsql-hackers since 2024-10-17 23:36

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

Oct. 17, 2024

Thread	Author	Time
Re: Considering fractional paths in Append node	Andy Fan	23:36

Oct. 18, 2024

Thread	Author	Time
Re: Add “FOR UPDATE NOWAIT” lock details to the log. 📎	Seino Yuki	00:37
Re: Statistics Import and Export	Corey Huinker	00:54
Re: Considering fractional paths in Append node	Andy Fan	00:54
Re: Statistics Import and Export	Jeff Davis	01:41
Re: Considering fractional paths in Append node	Andrei Lepikhov	01:42
Re: Add “FOR UPDATE NOWAIT” lock details to the log. 📎	Seino Yuki	01:45
Re: minor doc issue in 9.16.2.1.1. Boolean Predicate Check Expressions	jian he	02:00
plperl version on the meson setup summary screen 📎	Zharkov Roman	02:02
Re: Eager aggregation, take 3	jian he	03:44
Re: Enhance create subscription reference manual	Tatsuo Ishii	04:16
Re: Make default subscription streaming option as Parallel	Dilip Kumar	04:17
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Fujii Masao	04:58
Re: UUID v7	Andrey M. Borodin	05:35
Re: ECPG Refactor: move sqlca variable in ecpg_log() 📎	Fujii Masao	05:45
Re: Doc: shared_memory_size_in_huge_pages with the "SHOW" command.	Fujii Masao	05:47
Re: Wrong security context for deferred triggers?	Pavel Stehule	05:47
Re: [PoC] Federated Authn/z with OAUTHBEARER	Antonin Houska	05:51
Re: Fix for consume_xids advancing XIDs incorrectly 📎	Yushi Ogiwara	05:57
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Seino Yuki	06:00
Re: Set query_id for query contained in utility statement	Michael Paquier	06:21
Re: Set query_id for query contained in utility statement	Michael Paquier	06:27
Re: [BUG FIX] Fix validation of COPY options FORCE_NOT_NULL/FORCE_NULL	Joel Jacobson	06:27
Re: Syncrep and improving latency due to WAL throttling	Jakub Wartak	07:49
Re: allowing extensions to control planner behavior	Jakub Wartak	07:56
Re: Add isolation test template in injection_points for wait/wakeup/detach	Bertrand Drouvot	07:58
Re: Wrong security context for deferred triggers?	Laurenz Albe	08:20
Re: Remove unlogged materialized view persistence handling	Fujii Masao	08:24
Re: Recovery of .partial WAL segments	Stepan Neretin	09:07
Re: Add isolation test template in injection_points for wait/wakeup/detach	Michael Paquier	09:16
Re: Wrong security context for deferred triggers?	Pavel Stehule	09:32
Re: replace strtok()	Peter Eisentraut	09:41
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	09:44
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	09:46
Use more CppAsString2() in pg_amcheck.c 📎	Michael Paquier	09:50
Re: Use more CppAsString2() in pg_amcheck.c	Daniel Gustafsson	09:59
Re: Enhance create subscription reference manual	Amit Kapila	10:04
Re: Add “FOR UPDATE NOWAIT” lock details to the log. 📎	Seino Yuki	10:07
unicode test programs don't build with meson	Peter Eisentraut	10:11
Re: On disable_cost 📎	David Rowley	10:54
Re: DOCS - pg_replication_slot . Fix the 'inactive_since' description	Amit Kapila	10:55
RE: Conflict Detection and Resolution	Zhijie Hou (Fujitsu)	10:59
Re: replace strtok()	Ranier Vilela	11:11
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Daniel Gustafsson	11:38
Incorrect comment on pg_shadow view 📎	Antonin Houska	11:50
Re: Make default subscription streaming option as Parallel	Amit Kapila	11:54
Re: On disable_cost	Laurenz Albe	12:09
Re: Incorrect comment on pg_shadow view	Daniel Gustafsson	12:09
Re: Pgoutput not capturing the generated columns 📎	Shubham Khanna	12:12
Re: Pgoutput not capturing the generated columns	Shubham Khanna	12:15
Re: Recovery of .partial WAL segments	Stefan Fercot	12:39
Re: Amcheck verification of GiST and GIN 📎	Kirill Reshke	12:42
Re: unicode test programs don't build with meson	Aleksander Alekseev	13:17
Re: Use more CppAsString2() in pg_amcheck.c	Alvaro Herrera	13:18
Re: Use more CppAsString2() in pg_amcheck.c	Alvaro Herrera	13:20
Re: Eager aggregation, take 3	jian he	13:22
Re: Wrong security context for deferred triggers? 📎	Laurenz Albe	13:24
Re: New "raw" COPY format	jian he	13:52
Re: Recovery of .partial WAL segments	Matthias van de Meent	13:56
Re: [PATCH] Add get_bytes() and set_bytes() functions 📎	Aleksander Alekseev	14:20
Re: Incorrect comment on pg_shadow view	Tom Lane	14:22
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎	Alvaro Herrera	14:50
Re: Doc: shared_memory_size_in_huge_pages with the "SHOW" command.	Nathan Bossart	15:22
Re: Considering fractional paths in Append node	Nikita Malakhov	15:40
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	16:17
Re: Proposal for Updating CRC32C with AVX-512 Algorithm.	Nathan Bossart	16:31
Re: Use more CppAsString2() in pg_amcheck.c	Nathan Bossart	17:22
Re: New "raw" COPY format 📎	Joel Jacobson	17:24
Re: ECPG Refactor: move sqlca variable in ecpg_log()	Tom Lane	17:43
Inconsistent use of relpages = -1	Jeff Davis	18:56
Re: Inconsistent use of relpages = -1	Tom Lane	19:14
Changing shared_buffers without restart 📎	Dmitry Dolgov	19:21
msvc directory missing in PostgreSQL 17.0	Mark Hill	20:05
Re: msvc directory missing in PostgreSQL 17.0	Bill Smith	20:11
Re: [PATCH] Add some documentation on how to call internal functions 📎	Tom Lane	20:23
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	20:48
RE: Proposal for Updating CRC32C with AVX-512 Algorithm.	Devulapalli, Raghuveer	21:23
Re: Avoiding superfluous buffer locking during nbtree backwards scans	Peter Geoghegan	21:28
Re: Statistics Import and Export	Corey Huinker	23:14

Oct. 19, 2024

Thread	Author	Time
Re: Considering fractional paths in Append node	Andy Fan	00:03
Re: Statistics Import and Export 📎	Corey Huinker	01:00
Re: Use more CppAsString2() in pg_amcheck.c 📎	Michael Paquier	01:16
Re: [BUG FIX] Fix validation of COPY options FORCE_NOT_NULL/FORCE_NULL	Michael Paquier	01:32
Re: allowing extensions to control planner behavior	Andrei Lepikhov	03:00
Re: Wrong security context for deferred triggers?	Pavel Stehule	04:17
Re: Logging parallel worker draught 📎	Benoit Lobréau	04:46
Re: [PATCH] Add some documentation on how to call internal functions	Pavel Stehule	05:05
Re: [BUG FIX] Fix validation of COPY options FORCE_NOT_NULL/FORCE_NULL 📎	Joel Jacobson	06:52
Re: New "raw" COPY format	Joel Jacobson	07:55
Using read_stream in index vacuum 📎	Andrey M. Borodin	08:41
Re: New "raw" COPY format	jian he	10:13
Re: Wrong security context for deferred triggers? 📎	Laurenz Albe	11:02
Re: Make default subscription streaming option as Parallel	Dilip Kumar	11:55
Re: New "raw" COPY format 📎	Joel Jacobson	15:32
Re: Using read_stream in index vacuum	Junwang Zhao	15:41
Re: Wrong security context for deferred triggers?	Pavel Stehule	17:13
Re: System views for versions reporting 📎	Dmitry Dolgov	17:31
Improve documentation regarding custom settings, placeholders, and the administrative functions	David G. Johnston	20:11
Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION 📎	Noah Misch	23:28
Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION	Tom Lane	23:48

Oct. 20, 2024

Thread	Author	Time
report a typo in WaitReadBuffers	Junwang Zhao	03:20
Add pg_ownerships and pg_privileges system views 📎	Joel Jacobson	06:19
Re: report a typo in WaitReadBuffers	Michael Paquier	07:06
Fix C23 compiler warning 📎	Peter Eisentraut	07:07
Re: Using read_stream in index vacuum	Andrey M. Borodin	07:19
further #include cleanup (IWYU) 📎	Peter Eisentraut	07:50
Re: further #include cleanup (IWYU)	Alvaro Herrera	09:37
Re: further #include cleanup (IWYU)	Alvaro Herrera	09:53
Re: Add pg_ownerships and pg_privileges system views	Alvaro Herrera	10:14
Re: Using read_stream in index vacuum 📎	Junwang Zhao	10:16
Re: Inval reliability, especially for inplace updates	Nitin Motiani	13:11
Re: Using read_stream in index vacuum	Andrey M. Borodin	14:18
Re: Add pg_ownerships and pg_privileges system views 📎	Joel Jacobson	14:52
Re: Fix C23 compiler warning	Tom Lane	15:56
Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	16:32
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	17:13
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎	Alexander Korotkov	17:21
Re: type cache cleanup improvements 📎	Alexander Korotkov	17:36
Re: type cache cleanup improvements	Alexander Korotkov	17:47
Re: type cache cleanup improvements	Alexander Korotkov	18:00
Re: Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	18:25
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	19:19
Re: Add pg_ownerships and pg_privileges system views 📎	Joel Jacobson	21:03
Re: Add pg_ownerships and pg_privileges system views 📎	Joel Jacobson	21:09
Re: type cache cleanup improvements 📎	Alexander Korotkov	22:09
Re: type cache cleanup improvements	Dagfinn Ilmari Mannsåker	23:32

Oct. 21, 2024

Thread	Author	Time
commitfest.postgresql.org Specify thread msgid does not work for pgsql-bugs(at)lists(dot)postgresql(dot)org 📎	jian he	00:00
comment invalid link reference in Macros IF_NEED_REFILL_AND_NOT_EOF_CONTINUE copyfromparse.c	jian he	00:00
Refactor GetLockStatusData() by skipping unused backends and groups 📎	Fujii Masao	00:19
Re: Conflict Detection and Resolution 📎	Ajin Cherian	00:45
Re: Conflict Detection and Resolution 📎	Michail Nikolaev	01:14
Re: Add isolation test template in injection_points for wait/wakeup/detach	Michael Paquier	02:13
Re: commitfest.postgresql.org Specify thread msgid does not work for pgsql-bugs(at)lists(dot)postgresql(dot)org	Michael Paquier	02:19
Re: report a typo in WaitReadBuffers	Michael Paquier	02:32
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	03:09
Re: Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	03:29
Re: Pgoutput not capturing the generated columns	vignesh C	03:37
Re: Using Expanded Objects other than Arrays from plpgsql	Tom Lane	03:46
Re: Conflict Detection and Resolution	shveta malik	05:03
Re: Pgoutput not capturing the generated columns	vignesh C	05:21
Re: type cache cleanup improvements	Andrei Lepikhov	05:36
Re: type cache cleanup improvements	Andrei Lepikhov	05:40
Re: simplify regular expression locale global variables 📎	Peter Eisentraut	05:50
Re: Make default subscription streaming option as Parallel	Amit Kapila	06:09
Re: Refactor GetLockStatusData() by skipping unused backends and groups	Bertrand Drouvot	07:32
Re: type cache cleanup improvements	jian he	07:51
Re: type cache cleanup improvements	Alexander Korotkov	08:10
Re: type cache cleanup improvements 📎	Alexander Korotkov	08:11
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Tender Wang	08:30
Re: Set query_id for query contained in utility statement 📎	Anthonin Bonnefoy	08:35
[PATCH] Add array_reverse() function 📎	Aleksander Alekseev	09:06
Re: Make default subscription streaming option as Parallel	Amit Kapila	09:06
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row 📎	Kirill Reshke	09:30
Re: Add pg_ownerships and pg_privileges system views	Alvaro Herrera	09:42
Re: commitfest.postgresql.org Specify thread msgid does not work for pgsql-bugs(at)lists(dot)postgresql(dot)org	Alvaro Herrera	09:49
Re: Make default subscription streaming option as Parallel	Peter Smith	09:57
Re: type cache cleanup improvements	Dagfinn Ilmari Mannsåker	10:16
Re: Pgoutput not capturing the generated columns	Amit Kapila	11:19
Re: type cache cleanup improvements 📎	Alexander Korotkov	11:30
Re: Add pg_ownerships and pg_privileges system views 📎	Joel Jacobson	11:31
Question about VACUUM behavior with sub-transactions in stored procedures	Кириллов Вячеслав	12:00
Re: Misleading error "permission denied for table" 📎	Ashutosh Bapat	12:12
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row	Fujii Masao	12:39
Re: Question about VACUUM behavior with sub-transactions in stored procedures	David G. Johnston	13:55
Re: [PATCH] Add array_reverse() function	Ashutosh Bapat	14:11
Re: ECPG Refactor: move sqlca variable in ecpg_log() 📎	Fujii Masao	14:25
Re: New "raw" COPY format 📎	jian he	14:35
Re: [PATCH] Add array_reverse() function	Joel Jacobson	14:37
Re: Make default subscription streaming option as Parallel 📎	vignesh C	15:09
Re: New "raw" COPY format	Joel Jacobson	15:11
Re: [PATCH] Add array_reverse() function	Tom Lane	16:00
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Michail Nikolaev	17:06
Re: Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	17:23
Re: CSN snapshots in hot standby 📎	Heikki Linnakangas	17:32
Enhancing Memory Context Statistics Reporting 📎	Rahila Syed	18:24
Re: race condition in pg_class 📎	Alexander Lakhin	19:00
Re: Using read_stream in index vacuum	Melanie Plageman	19:34
Re: Using read_stream in index vacuum	Melanie Plageman	19:56
RE: msvc directory missing in PostgreSQL 17.0	Mark Hill	20:12
Re: Using read_stream in index vacuum 📎	Andrei Borodin	20:49
Re: Using read_stream in index vacuum	Melanie Plageman	21:05
Re: SQL:2011 application time 📎	Paul Jungwirth	21:46
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails 📎	Alvaro Herrera	21:52

Oct. 22, 2024

Thread	Author	Time
EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	Melanie Plageman	00:45
More CppAsString2() in psql's describe.c 📎	Michael Paquier	00:49
RE: Statistics Import and Export 📎	Shinoda, Noriyoshi (SXD Japan FSIP)	00:50
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	01:02
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David Rowley	01:32
EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David G. Johnston	01:46
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David Rowley	02:20
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David G. Johnston	02:40
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR)	Pavel Stehule	02:54
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Tender Wang	02:56
Re: race condition in pg_class 📎	Noah Misch	03:52
Re: cost delay brainstorming	Jay	04:32
Re: Row pattern recognition	Tatsuo Ishii	04:53
Re: Set query_id for query contained in utility statement	Michael Paquier	05:06
Re: Set query_id for query contained in utility statement 📎	Michael Paquier	05:09
Row pattern recognition	David G. Johnston	05:29
Re: Using read_stream in index vacuum	Andrey M. Borodin	06:29

Browse Archives

Prev | Next