pgsql-hackers before 2024-10-23 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

Oct. 18, 2024

Thread	Author	Time
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
comment invalid link reference in Macros IF_NEED_REFILL_AND_NOT_EOF_CONTINUE copyfromparse.c	jian he	00:00
commitfest.postgresql.org Specify thread msgid does not work for pgsql-bugs(at)lists(dot)postgresql(dot)org 📎	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
Re: Fix C23 compiler warning	Peter Eisentraut	06:35
Re: Fix C23 compiler warning	Tom Lane	06:41
Re: Enhancing Memory Context Statistics Reporting	Michael Paquier	06:48
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	07:28
Re: type cache cleanup improvements 📎	Alexander Korotkov	07:34
Support regular expressions with nondeterministic collations 📎	Peter Eisentraut	08:16
Re: Fix C23 compiler warning	Peter Eisentraut	08:32
Proposal for Integrating Data Masking and anonymization into PostgreSQL	Hosney Osman	08:35
Re: Make default subscription streaming option as Parallel 📎	Amit Kapila	09:16
Re: Make all Perl warnings fatal 📎	Anton Voloshin	09:25
Re: Set query_id for query contained in utility statement 📎	Anthonin Bonnefoy	09:34
Re: POC: make mxidoff 64 bits	Heikki Linnakangas	09:43
WaitEventSetWaitBlock() can still hang on Windows due to connection reset 📎	Alexander Lakhin	10:00
Re: Row pattern recognition	Tatsuo Ishii	10:19
Re: Make all Perl warnings fatal	Alexander Korotkov	10:26
Re: Pgoutput not capturing the generated columns	Amit Kapila	10:50
RE: Make default subscription streaming option as Parallel	Hayato Kuroda (Fujitsu)	10:54
Re: Statistics Import and Export	Corey Huinker	11:09
Re: Do not lock temp relations	Daniil Davydov	11:25
Re: Do not lock temp relations	Daniil Davydov	11:34
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	Melanie Plageman	13:08
Re: Row pattern recognition	Vik Fearing	13:12
Re: [PATCH] Add array_reverse() function 📎	Aleksander Alekseev	13:27
Re: pgsql: Implement pg_wal_replay_wait() stored procedure	Pavel Borisov	13:30
Re: pgsql: Implement pg_wal_replay_wait() stored procedure	Pavel Borisov	13:32
Re: Using read_stream in index vacuum	Melanie Plageman	13:42
Re: Row pattern recognition	David G. Johnston	14:19
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Jehan-Guillaume de Rorthais	14:23
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Alvaro Herrera	14:32
Re: Support regular expressions with nondeterministic collations	Tom Lane	14:40
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails	Jehan-Guillaume de Rorthais	14:54
Re: ECPG Refactor: move sqlca variable in ecpg_log()	Fujii Masao	15:02
Re: type cache cleanup improvements	Pavel Borisov	15:09
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR)	Tom Lane	15:37
Re: Make default subscription streaming option as Parallel 📎	vignesh C	15:56
Re: Pgoutput not capturing the generated columns	Masahiko Sawada	16:11
Re: Refactor GetLockStatusData() by skipping unused backends and groups 📎	Fujii Masao	16:19
Re: POC: make mxidoff 64 bits 📎	Maxim Orlov	16:33
Re: type cache cleanup improvements 📎	Alexander Korotkov	17:33
Re: Inconsistent use of relpages = -1 📎	Jeff Davis	17:41
Re: Better error reporting from extension scripts (Was: Extend ALTER OPERATOR)	Pavel Stehule	18:35
Trigger more frequent autovacuums of heavy insert tables 📎	Melanie Plageman	19:12
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	David Rowley	19:21
Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on	Melanie Plageman	19:28
Re: Vacuum statistics 📎	Alena Rybakina	19:30
Re: Using Expanded Objects other than Arrays from plpgsql 📎	Tom Lane	19:33
Re: Make default subscription streaming option as Parallel	Masahiko Sawada	19:50
use a non-locking initial test in TAS_SPIN on AArch64 📎	Nathan Bossart	19:54
Re: pgsql: Implement pg_wal_replay_wait() stored procedure 📎	Alexander Korotkov	20:12
Unexpected table size usage for small composite arrays	Erik Sjoblom	21:58
Re: Statistics Import and Export	Jeff Davis	22:27
Re: Unexpected table size usage for small composite arrays	Tom Lane	22:34
Re: Unexpected table size usage for small composite arrays	Erik Sjoblom	22:45
Re: Unexpected table size usage for small composite arrays	Tom Lane	22:50
Re: Unexpected table size usage for small composite arrays	Erik Sjoblom	23:40
Re: Unexpected table size usage for small composite arrays	David G. Johnston	23:41
Re: Unexpected table size usage for small composite arrays	David G. Johnston	23:42
Re: Unexpected table size usage for small composite arrays	David G. Johnston	23:49
Re: Parallel heap vacuum	Masahiko Sawada	23:54
RE: Statistics Import and Export 📎	Shinoda, Noriyoshi (SXD Japan FSIP)	23:58

Browse Archives

Prev | Next