pgsql-hackers - November 2022

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

Nov. 1, 2022

Thread	Author	Time
Re: ResourceOwner refactoring	Andres Freund	00:15
Re: resowner "cold start" overhead	Andres Freund	00:16
Re: heavily contended lwlocks with long wait queues scale badly	Zhihong Yu	00:17
Re: Making Vars outer-join aware 📎	Tom Lane	00:19
Re: heavily contended lwlocks with long wait queues scale badly	Andres Freund	00:19
Re: Split index and table statistics into different types of stats	Andres Freund	00:30
Re: Simplifying our Trap/Assert infrastructure	Michael Paquier	00:30
Re: User functions for building SCRAM secrets	Michael Paquier	00:56
Re: heavily contended lwlocks with long wait queues scale badly	Zhihong Yu	01:00
Re: Commit fest 2022-11	Ian Lawrence Barwick	01:01
Re: heapgettup refactoring	Andres Freund	01:09
Re: Reusing return value from planner_rt_fetch	Tom Lane	01:47
Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes? 📎	Bharath Rupireddy	03:02
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock	Amit Kapila	03:49
Re: Commit fest 2022-11	jian he	04:26
Re: Commit fest 2022-11	Michael Paquier	04:35
Re: Commit fest 2022-11	Michael Paquier	04:40
Re: Check return value of pclose() correctly	Michael Paquier	05:35
Re: Lock on ShmemVariableCache fields?	Michael Paquier	05:43
Re: Check return value of pclose() correctly	Tom Lane	05:52
Re: [patch] Have psql's \d+ indicate foreign partitions	Michael Paquier	05:55
Re: ICU for global collation	Michael Paquier	07:03
Re: heavily contended lwlocks with long wait queues scale badly	Bharath Rupireddy	07:16
Re: Improve description of XLOG_RUNNING_XACTS	Michael Paquier	07:22
Direct I/O 📎	Thomas Munro	07:36
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Michael Paquier	07:41
Re: Adding doubly linked list type which stores the number of items in the list	Bharath Rupireddy	07:55
Re: SUBTRANS: Minimizing calls to SubTransSetParent()	Dilip Kumar	08:38
Re: Lockless queue of waiters in LWLock	Alexander Korotkov	08:39
Re: SUBTRANS: Minimizing calls to SubTransSetParent() 📎	Julien Tachoires	08:55
Re: Commit fest 2022-11	Simon Riggs	08:59
Re: psql: Add command to use extended query protocol	Simon Riggs	09:10
Re: pg15 inherited stats expressions: cache lookup failed for statistics object 📎	Richard Guo	09:33
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Richard Guo	09:51
Re: Pluggable toaster	Aleksander Alekseev	10:05
Re: Commit fest 2022-11	Ian Lawrence Barwick	10:10
Re: Commit fest 2022-11	Ian Lawrence Barwick	10:15
Re: Adding doubly linked list type which stores the number of items in the list	David Rowley	10:19
Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit 📎	Etsuro Fujita	10:24
Re: Collation version tracking for macOS	Peter Eisentraut	10:33
Re: [PATCH] Backport perl tests for pg_upgrade from 322becb60 📎	Anton A. Melnikov	10:36
Re: ResourceOwner refactoring	Heikki Linnakangas	10:39
Re: real/float example for testlibpq3	Peter Eisentraut	10:39
Re: Commit fest 2022-11	Michael Paquier	10:55
Re: Commit fest 2022-11	Michael Paquier	10:59
Re: Improve description of XLOG_RUNNING_XACTS	Amit Kapila	11:03
Re: Prefetch the next tuple's memory during seqscans	Andy Fan	11:08
Re: Latches vs lwlock contention 📎	Thomas Munro	11:09
Re: [PATCH] Improve tab completion for ALTER TABLE on identity columns	Peter Eisentraut	11:19
Re: [PATCH] Improve tab completion for ALTER TABLE on identity columns	Peter Eisentraut	11:20
Add palloc_aligned() to allow arbitrary power of 2 memory alignment 📎	David Rowley	11:28
Re: [PATCH] Improve tab completion for ALTER TABLE on identity columns	Dagfinn Ilmari Mannsåker	11:29
Re: Prefetch the next tuple's memory during seqscans	Thomas Munro	11:42
Tests for psql \g and \o 📎	Daniel Verite	11:42
Re: Prefetch the next tuple's memory during seqscans	David Rowley	11:50
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	thomas	12:30
Re: Refactor to introduce pg_strcoll().	Peter Eisentraut	12:36
Re: heavily contended lwlocks with long wait queues scale badly	Robert Haas	12:37
Re: Collation version tracking for macOS	Thomas Munro	12:42
Re: [patch] \g with multiple result sets and \watch with copy queries	Daniel Verite	12:43
Re: ResourceOwner refactoring	Robert Haas	12:43
Re: pg_upgrade allows itself to be run twice	Peter Eisentraut	12:54
BUG #17663:Connect to the database through jdbc, call the stored procedure containing the rollback statement,the database triggers an assertion, and the database is in recovery mode. 📎	赵其桂	12:57
Re: pg_upgrade allows itself to be run twice	Justin Pryzby	13:07
Re: pg15 inherited stats expressions: cache lookup failed for statistics object	Justin Pryzby	13:12
Re: real/float example for testlibpq3	Tom Lane	13:15
Re: Privileges on PUBLICATION	Peter Eisentraut	13:23
Re: Direct I/O	Justin Pryzby	13:33
Re: heavily contended lwlocks with long wait queues scale badly	Jonathan S. Katz	15:19
Re: ResourceOwner refactoring	Andres Freund	15:42
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Mingli Zhang	15:45
Re: heavily contended lwlocks with long wait queues scale badly	Andres Freund	15:59
Re: BUG #17663:Connect to the database through jdbc, call the stored procedure containing the rollback statement,the database triggers an assertion, and the database is in recovery mode.	Tom Lane	16:01
Re: Commit fest 2022-11	Magnus Hagander	16:36
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jacob Champion	17:03
Re: heavily contended lwlocks with long wait queues scale badly	Andres Freund	17:41
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jacob Champion	17:55
Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands	Corey Huinker	17:59
perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local	Andres Freund	18:01
Re: pg15 inherited stats expressions: cache lookup failed for statistics object	Tom Lane	18:35
Re: Lockless queue of waiters in LWLock 📎	Pavel Borisov	18:52
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local	Dagfinn Ilmari Mannsåker	18:55
Re: Segfault on logical replication to partitioned table with foreign children 📎	Tom Lane	19:10
Re: Check return value of pclose() correctly	Peter Eisentraut	20:30
Re: Check return value of pclose() correctly	Peter Eisentraut	20:41
Re: Direct I/O	Thomas Munro	20:44
Re: psql: Add command to use extended query protocol	Peter Eisentraut	20:47
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local	Peter Eisentraut	21:00
Re: Pluggable toaster 📎	Aleksander Alekseev	21:15
Re: doc: Fix description of how the default user name is chosen 📎	David G. Johnston	21:31
Re: warn if GUC set to an invalid shared library 📎	Justin Pryzby	22:26
Glossary and initdb definition work for "superuser" and database/cluster 📎	David G. Johnston	22:47
Re: Direct I/O	Andres Freund	22:54
Re: psql: Add command to use extended query protocol	Simon Riggs	22:58
Re: User functions for building SCRAM secrets	Jacob Champion	23:02
Re: Commit fest 2022-11	Ian Lawrence Barwick	23:21
PL/pgSQL cursors should get generated portal names by default 📎	Tom Lane	23:39
Re: Support logical replication of DDLs	vignesh C	23:43
Re: Allow single table VACUUM in transaction block	Simon Riggs	23:56
Re: Collation version tracking for macOS	Thomas Munro	23:57
Re: Error for WITH options on partitioned tables	Simon Riggs	23:58

Nov. 2, 2022

Thread	Author	Time
Re: Glossary and initdb definition work for "superuser" and database/cluster	Justin Pryzby	00:20
Re: Direct I/O	Andres Freund	00:21
Re: Adding doubly linked list type which stores the number of items in the list	David Rowley	01:08
Re: [Refactor]Avoid to handle FORCE_NOT_NULL/FORCE_NULL options when COPY TO	Michael Paquier	01:15
Re: missing indexes in indexlist with partitioned tables 📎	Arne Roland	01:50
Re: Glossary and initdb definition work for "superuser" and database/cluster	David G. Johnston	01:59
RE: [Proposal] Add foreign-server health checks infrastructure 📎	Hayato Kuroda (Fujitsu)	02:43
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	02:50
Re: PL/pgSQL cursors should get generated portal names by default	Pavel Stehule	02:51
Re: Prefetch the next tuple's memory during seqscans	Andres Freund	03:00
A new strategy for pull-up correlated ANY_SUBLINK 📎	Andy Fan	03:02
Re: A new strategy for pull-up correlated ANY_SUBLINK	Andrey Lepikhov	03:42
Re: Code checks for App Devs, using new options for transaction behavior	Dilip Kumar	03:52
Re: psql: Add command to use extended query protocol	Corey Huinker	05:18
Incorrect include file order in guc-file.l 📎	Michael Paquier	05:29
Re: A new strategy for pull-up correlated ANY_SUBLINK	Andy Fan	05:34
spinlock support on loongarch64 📎	吴亚飞	05:56
Re: Incorrect include file order in guc-file.l	Julien Rouhaud	06:01
Re: Improve description of XLOG_RUNNING_XACTS	Amit Kapila	06:24
remap the .text segment into huge pages at run time 📎	John Naylor	06:32
Re: Incorrect include file order in guc-file.l	John Naylor	06:53
Re: Code checks for App Devs, using new options for transaction behavior	Simon Riggs	07:40
Re: Allow file inclusion in pg_hba and pg_ident files 📎	Michael Paquier	07:46
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	Damir Belyalov	08:46
Re: Adding doubly linked list type which stores the number of items in the list 📎	Aleksander Alekseev	08:53
Re: Split index and table statistics into different types of stats 📎	Drouvot, Bertrand	08:58
Re: [PoC] Reducing planning time when tables have many partitions 📎	Yuya Watari	09:27
Re: create subscription - improved warning message	Amit Kapila	10:02
Re: Commit fest 2022-11	Greg Stark	10:10
Re: Make ON_ERROR_STOP stop on shell script failure	Justin Pryzby	11:58
Re: psql: Add command to use extended query protocol	Jehan-Guillaume de Rorthais	12:43
Re: psql: Add command to use extended query protocol	Pavel Stehule	12:55
Re: Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	13:06
Re: Add LZ4 compression in pg_dump	Justin Pryzby	13:28
Re: Temporary tables versus wraparound... again	Greg Stark	13:54
restoring user id and SecContext before logging error in ri_PlanCheck	Zhihong Yu	14:04
Re: restoring user id and SecContext before logging error in ri_PlanCheck 📎	Zhihong Yu	15:00
Re: psql: Add command to use extended query protocol	Daniel Verite	15:04
Re: Check return value of pclose() correctly	Ankit Kumar Pandey	15:26
Re: spinlock support on loongarch64	Tom Lane	15:37
Re: psql: Add command to use extended query protocol	Jehan-Guillaume de Rorthais	16:24
Re: Segfault on logical replication to partitioned table with foreign children	Tom Lane	16:37
Re: Add index scan progress to pg_stat_progress_vacuum 📎	Imseih (AWS), Sami	16:52
Re: Error for row-level triggers with transition tables on partitioned tables	Tom Lane	17:20
Re: Prefetch the next tuple's memory during seqscans 📎	Andres Freund	17:25
Re: spinlock support on loongarch64	Andres Freund	17:27
Re: Glossary and initdb definition work for "superuser" and database/cluster 📎	David G. Johnston	17:48
Re: [BUG] Logical replica crash if there was an error in a function. 📎	Tom Lane	18:02
Re: pg15 inherited stats expressions: cache lookup failed for statistics object	Justin Pryzby	18:10
Re: spinlock support on loongarch64 📎	Tom Lane	18:29
Re: spinlock support on loongarch64 📎	Tom Lane	18:55
Re: libpq support for NegotiateProtocolVersion	Jacob Champion	19:02
Re: ssl tests aren't concurrency safe due to get_free_port() 📎	Andrew Dunstan	19:09
Version 14/15 documentation Section "Alter Default Privileges"	David Burns	19:29
Re: Check SubPlan clause for nonnullable rels/Vars	Tom Lane	20:26
Re: pg_basebackup's --gzip switch misbehaves 📎	Daniel Gustafsson	20:42
Re: Prefetch the next tuple's memory during seqscans	Andres Freund	20:53
Re: create subscription - improved warning message	Peter Smith	21:01
Re: spinlock support on loongarch64	Andres Freund	21:04
Re: pg_dump: Refactor code that constructs ALTER ... OWNER TO commands	Peter Eisentraut	21:30
Re: spinlock support on loongarch64	Tom Lane	21:37
Re: spinlock support on loongarch64	Andres Freund	23:22
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local	Andres Freund	23:43
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local	Tom Lane	23:57

Nov. 3, 2022

Thread	Author	Time
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local	Andres Freund	00:03
Re: Improve logging when using Huge Pages	Thomas Munro	01:10
Re: Commit fest 2022-11	Ian Lawrence Barwick	02:33
Re: proposal: possibility to read dumped table's name from file	Julien Rouhaud	04:09
Re: [BUG] Logical replica crash if there was an error in a function.	Amit Kapila	04:11
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	04:59
Re: Incorrect include file order in guc-file.l	John Naylor	05:40
Re: Privileges on PUBLICATION 📎	Antonin Houska	05:43
Re: Improve description of XLOG_RUNNING_XACTS	Ian Lawrence Barwick	07:37
Re: Support logical replication of DDLs	Peter Smith	07:40
Re: Adding doubly linked list type which stores the number of items in the list	Bharath Rupireddy	07:41
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Ian Lawrence Barwick	07:51
Re: Add 64-bit XIDs into PostgreSQL 15 📎	Maxim Orlov	08:11
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Maxim Orlov	08:15
Re: Add index scan progress to pg_stat_progress_vacuum	Ian Lawrence Barwick	08:16
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Dilip Kumar	08:20
Re: [PATCH] Add native windows on arm64 support	Ian Lawrence Barwick	08:38
Re: Segfault on logical replication to partitioned table with foreign children 📎	Ilya Gladyshev	08:45
Re: Prefetch the next tuple's memory during seqscans	John Naylor	09:09
Re: Check SubPlan clause for nonnullable rels/Vars 📎	Richard Guo	09:17
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Ian Lawrence Barwick	09:29
Re: Adding CommandID to heap xlog records	Ian Lawrence Barwick	09:36
Re: Commit fest 2022-11	Ian Lawrence Barwick	09:48
Re: Allow single table VACUUM in transaction block 📎	Simon Riggs	10:23
Re: Version 14/15 documentation Section "Alter Default Privileges"	Laurenz Albe	10:32
Re: Pluggable toaster	Aleksander Alekseev	10:38
Re: Lockless queue of waiters in LWLock 📎	Pavel Borisov	10:50
Fix comments atop ReorderBufferAddInvalidations 📎	Amit Kapila	10:53
Re: [PATCH] Add native windows on arm64 support 📎	Niyas Sait	11:06
Re: confirmed_flush_lsn shows LSN of the data that has not yet been received by the logical subscriber.	Amit Kapila	11:19
Re: Pluggable toaster	Nikita Malakhov	11:33
Add explicit casts in four places to simplehash.h 📎	David Geier	11:34
Re: Incorrect include file order in guc-file.l	Michael Paquier	11:40
Re: [PATCH] Add native windows on arm64 support	Michael Paquier	11:43
Re: pg_basebackup's --gzip switch misbehaves	Michael Paquier	11:49

Browse Archives

Prev | Next