pgsql-hackers since 2023-12-15 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

Dec. 15, 2023

Thread	Author	Time
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	00:53
Re: Change GUC hashtable to use simplehash? 📎	John Naylor	01:20
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	01:30
Re: Add 64-bit XIDs into PostgreSQL 15	wenhui qiu	01:51
Re: logical decoding and replication of sequences, take 2	Amit Kapila	02:33
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	02:55
Re: Make COPY format extendable: Extract COPY TO format implementations	Junwang Zhao	03:27
Re: Improve eviction algorithm in ReorderBuffer	Amit Kapila	03:36
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	03:48
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	04:45
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock 📎	Dilip Kumar	05:15
Re: Synchronizing slots from primary to standby	shveta malik	05:32
Re: Synchronizing slots from primary to standby 📎	shveta malik	05:33
Re: Synchronizing slots from primary to standby	shveta malik	05:39
Re: Synchronizing slots from primary to standby	shveta malik	05:42
Re: "pgoutput" options missing on documentation	Peter Smith	05:43
Re: Improve eviction algorithm in ReorderBuffer	Masahiko Sawada	05:59
Re: Make COPY format extendable: Extract COPY TO format implementations	Junwang Zhao	06:02
Re: Fix bug with indexes on whole-row expressions	Nikolay Samokhvalov	06:11
Support "Right Semi Join" plan shapes	wenhui qiu	06:40
Is a clearer memory lifespan for outerTuple and innerTuple useful? 📎	Andy Fan	07:35
Re: Is a clearer memory lifespan for outerTuple and innerTuple useful?	Andy Fan	07:51
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	08:15
Re: Statistics Import and Export	Andrei Lepikhov	08:36
Re: remaining sql/json patches 📎	jian he	08:36
Re: planner chooses incremental but not the best one 📎	Richard Guo	08:58
Re: Add 64-bit XIDs into PostgreSQL 15	Pavel Borisov	09:13
Re: Add 64-bit XIDs into PostgreSQL 15	wenhui qiu	09:24
Re: Transaction timeout 📎	Andrey M. Borodin	09:51
Re: Improve eviction algorithm in ReorderBuffer	Alvaro Herrera	10:10
Re: trying again to get incremental backup	Jakub Wartak	10:36
Autonomous transactions 2023, WIP 📎	Ivan Kush	11:28
Re: trying again to get incremental backup 📎	Peter Eisentraut	11:53
Re: trying again to get incremental backup	Peter Eisentraut	11:58
Re: Improve eviction algorithm in ReorderBuffer	Masahiko Sawada	12:11
Re: Improve eviction algorithm in ReorderBuffer	Masahiko Sawada	12:18
[PATCH] Add --syntax to postgres for SQL syntax checking 📎	Josef Šimánek	12:21
Re: Synchronizing slots from primary to standby	Nisha Moond	12:25
Re: optimize atomic exchanges	Andres Freund	12:56
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Laurenz Albe	13:09
Re: pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written}	hubert depesz lubaczewski	13:10
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Josef Šimánek	13:14
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Pavel Stehule	13:19
Re: "pgoutput" options missing on documentation 📎	Emre Hasegeli	13:35
Re: Clean up find_typedefs and add support for Mac 📎	Andrew Dunstan	13:42
Re: Add --check option to pgindent	Jelte Fennema-Nio	14:18
Re: [meson] expose buildtype debug/optimization info to pg_config	Andres Freund	14:20
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Tom Lane	14:50
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Josef Šimánek	15:05
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	David G. Johnston	15:16
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Josef Šimánek	15:20
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	David G. Johnston	15:31
Re: [PATCH] Add --syntax to postgres for SQL syntax checking	Josef Šimánek	15:38
Re: Add --check option to pgindent 📎	Tristan Partin	15:43
Re: Clean up find_typedefs and add support for Mac	Tom Lane	16:06
Re: Clean up find_typedefs and add support for Mac	Tristan Partin	16:08
Re: Clean up find_typedefs and add support for Mac	Tristan Partin	16:10
Re: Improve eviction algorithm in ReorderBuffer	Euler Taveira	16:36
Re: Clean up find_typedefs and add support for Mac	Andrew Dunstan	17:11
Re: LargeObjectRelationId vs LargeObjectMetadataRelationId, redux	Tom Lane	19:01
Re: POC: Extension for adding distributed tracing - pg_tracing	Nikita Malakhov	19:05
Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	19:07
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Matthias van de Meent	21:11

Dec. 16, 2023

Thread	Author	Time
Re: Built-in CTYPE provider	Jeremy Schneider	00:30
Re: encoding affects ICU regex character classification	Jeremy Schneider	00:48
Re: Transaction timeout	Japin Li	00:58
Re: encoding affects ICU regex character classification	Thomas Munro	01:23
Clang optimiser vs preproc.c	Thomas Munro	02:25
Re: Clang optimiser vs preproc.c	Tom Lane	02:44
Re: Clang optimiser vs preproc.c	Thomas Munro	03:04
Re: Clang optimiser vs preproc.c	Tom Lane	03:19
Re: Statistics Import and Export	Corey Huinker	04:30
Re: Clang optimiser vs preproc.c	Thomas Munro	05:32
Re: Remove MSVC scripts from the tree	Michael Paquier	09:07
Re: GUC names in messages	Michael Paquier	09:33
[DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation 📎	Ishaan Adarsh	10:49
Re: Improve eviction algorithm in ReorderBuffer	Masahiko Sawada	12:13
Re: Clang optimiser vs preproc.c	Andres Freund	12:29
Re: Adding OLD/NEW support to RETURNING	jian he	13:03
Re: [PATCH] Add support function for containment operators 📎	jian he	13:03
Re: [PoC] Reducing planning time when tables have many partitions	Alena Rybakina	15:41
Re: useless LIMIT_OPTION_DEFAULT	Alvaro Herrera	16:42
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	19:20
Re: XID formatting and SLRU refactorings	Thomas Munro	23:48

Dec. 17, 2023

Thread	Author	Time
Re: Improve eviction algorithm in ReorderBuffer	Amit Kapila	02:40
Re: Synchronizing slots from primary to standby	Amit Kapila	02:51
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Thomas Munro	04:02
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Alexander Lakhin	05:00
Re: Moving forward with TDE	Chris Travers	06:30
Re: Is a clearer memory lifespan for outerTuple and innerTuple useful? 📎	Andy Fan	13:46
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	15:03
How to get started with contribution	Sukhbir Singh	15:09
Re: XID formatting and SLRU refactorings 📎	Alexander Korotkov	15:22
Re: Report planning memory in EXPLAIN ANALYZE 📎	Alvaro Herrera	16:27
Re: How to get started with contribution	Julien Rouhaud	16:34
Re: How to get started with contribution	Sukhbir Singh	16:42
Re: How to get started with contribution	Tomas Vondra	17:16
Re: JSON Path and GIN Questions	David E. Wheeler	17:55
GIN-Indexable JSON Patterns	David E. Wheeler	18:10
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	20:14
Re: JSON Path and GIN Questions	Tom Lane	21:08
Re: XID formatting and SLRU refactorings	Thomas Munro	21:14
Re: Is a clearer memory lifespan for outerTuple and innerTuple useful?	Nikita Malakhov	21:20
Re: brininsert optimization opportunity	Tomas Vondra	21:27
Re: planner chooses incremental but not the best one	Tomas Vondra	22:18
Re: planner chooses incremental but not the best one	Tom Lane	22:33
Re: Is a clearer memory lifespan for outerTuple and innerTuple useful?	Andy Fan	23:22
Re: JSON Path and GIN Questions	David E. Wheeler	23:30
Re: planner chooses incremental but not the best one	Tomas Vondra	23:31
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Matthias van de Meent	23:53

Dec. 18, 2023

Thread	Author	Time
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	jian he	00:15
Re: [PATCH]: Not to invaldiate CatalogSnapshot for local invalidation messages	jian he	00:19
Re: "pgoutput" options missing on documentation	Peter Smith	00:35
Re: "pgoutput" options missing on documentation	Peter Smith	01:15
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	torikoshia	02:41
Re: "pgoutput" options missing on documentation	Amit Kapila	03:30
Re: "pgoutput" options missing on documentation	Amit Kapila	04:27
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	torikoshia	05:09
Re: Add a perl function in Cluster.pm to generate WAL 📎	Bharath Rupireddy	05:39
Re: Transaction timeout 📎	Andrey M. Borodin	05:49
Re: Fix a comment in basic_archive about NO_INSTALLCHECK 📎	Bharath Rupireddy	05:58
Re: Change GUC hashtable to use simplehash? 📎	John Naylor	06:39
Re: introduce dynamic shared memory registry	Andrei Lepikhov	06:39
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	06:41
Re: meson: Stop using deprecated way getting path of files	John Naylor	06:43
Re: Fix bug with indexes on whole-row expressions	ywgrit	06:55
Re: [PATCH]: Not to invaldiate CatalogSnapshot for local invalidation messages	Xiaoran Wang	07:02
Re: Report planning memory in EXPLAIN ANALYZE	Ashutosh Bapat	07:25
Re: Report planning memory in EXPLAIN ANALYZE 📎	Ashutosh Bapat	07:27
Re: "pgoutput" options missing on documentation	Emre Hasegeli	07:38
Re: "pgoutput" options missing on documentation 📎	Emre Hasegeli	07:38
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	07:40
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	jian he	07:41
Re: introduce dynamic shared memory registry 📎	Andrei Lepikhov	08:32
Re: introduce dynamic shared memory registry	Nikita Malakhov	09:05
Re: trying again to get incremental backup	Peter Eisentraut	09:10
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Peter Eisentraut	09:31
Re: Transaction timeout	Japin Li	09:32
Re: Transaction timeout 📎	Andrey M. Borodin	09:40
Re: remaining sql/json patches	jian he	09:45
Re: Simplify newNode()	John Naylor	09:55
Re: Move walreceiver state assignment (to WALRCV_STREAMING) in WalReceiverMain()	Drouvot, Bertrand	10:18
Re: Move walreceiver state assignment (to WALRCV_STREAMING) in WalReceiverMain() 📎	Drouvot, Bertrand	10:36
Re: planner chooses incremental but not the best one	Richard Guo	10:40
Re: Remove MSVC scripts from the tree	vignesh C	10:49
Re: Synchronizing slots from primary to standby	Amit Kapila	10:52
Re: Add a perl function in Cluster.pm to generate WAL	Euler Taveira	11:48
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Euler Taveira	11:58
RE: Synchronizing slots from primary to standby	Zhijie Hou (Fujitsu)	12:11
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	12:12
Re: Add --check option to pgindent 📎	Daniel Gustafsson	12:41
Re: planner chooses incremental but not the best one	Tomas Vondra	12:53
Re: "pgoutput" options missing on documentation	Amit Kapila	13:04
Re: Postgres picks suboptimal index after building of an extended statistics	Alexander Korotkov	13:29
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer 📎	Jelte Fennema-Nio	13:30
Re: Remove MSVC scripts from the tree	Peter Eisentraut	13:52
Re: Add --check option to pgindent	Euler Taveira	13:56
Re: Simplify newNode()	Heikki Linnakangas	14:28
Re: "pgoutput" options missing on documentation	Emre Hasegeli	14:34
Re: Detecting some cases of missing backup_label	Stephen Frost	14:39
psql JSON output format 📎	Christoph Berg	14:56
Re: psql JSON output format	Christoph Berg	15:06
Re: psql JSON output format	Jelte Fennema-Nio	15:06
Re: A wrong comment about search_indexed_tlist_for_var	Matt Skelley	15:26
Re: psql JSON output format	Christoph Berg	15:38
Re: Add --check option to pgindent	Tristan Partin	15:45
Re: Add --check option to pgindent	Tristan Partin	15:45
Re: Add --check option to pgindent	Matthias van de Meent	15:59
Re: Add --check option to pgindent	Jelte Fennema-Nio	16:14
Re: Add --check option to pgindent	Jelte Fennema-Nio	16:15
Re: psql JSON output format	Jelte Fennema-Nio	16:33
Re: micro-optimizing json.c	Nathan Bossart	16:41
Re: Add --check option to pgindent	Tristan Partin	16:50
Re: optimize atomic exchanges	Nathan Bossart	16:57
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Robert Haas	17:04
Re: Add --check option to pgindent	Jelte Fennema-Nio	17:21
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Robert Haas	17:30
Re: common signal handler protection 📎	Nathan Bossart	17:32
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Andrey M. Borodin	17:53
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Robert Haas	18:18
Re: trying again to get incremental backup	Robert Haas	18:27
Re: trying again to get incremental backup	Robert Haas	18:39
Re: trying again to get incremental backup 📎	Robert Haas	18:58
Re: add non-option reordering to in-tree getopt_long	Tom Lane	19:41
Re: Built-in CTYPE provider	Jeff Davis	19:45
Fixing backslash dot for COPY FROM...CSV 📎	Daniel Verite	20:35
Re: encoding affects ICU regex character classification	Jeff Davis	20:39
Re: index prefetching	Robert Haas	21:00
Re: Add --check option to pgindent 📎	Tristan Partin	21:18
Re: Add --check option to pgindent	Tristan Partin	21:34
Re: add non-option reordering to in-tree getopt_long	Nathan Bossart	21:52
Re: Clang optimiser vs preproc.c	Thomas Munro	22:42
Re: Synchronizing slots from primary to standby	Peter Smith	23:20

Dec. 19, 2023

Thread	Author	Time
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	Masahiko Sawada	00:28
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	Masahiko Sawada	01:13
Re: Transaction timeout	Japin Li	01:25
Re: Synchronizing slots from primary to standby	Peter Smith	01:27
Re: Proposal to add page headers to SLRU pages	Bagga, Rishu	02:23
Re: add non-option reordering to in-tree getopt_long	Tom Lane	02:31
Re: Improve eviction algorithm in ReorderBuffer	Masahiko Sawada	03:00

Browse Archives

Prev | Next