pgsql-hackers since 2023-12-21 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. 21, 2023

Thread	Author	Time
Re: Add isCatalogRel in rmgrdesc	Michael Paquier	00:04
Re: Built-in CTYPE provider	Jeremy Schneider	00:04
Track in pg_replication_slots the reason why slots conflict?	Michael Paquier	00:21
Re: Built-in CTYPE provider	Jeremy Schneider	00:29
Re: libpq compression (part 3)	Jelte Fennema-Nio	00:30
Re: "pgoutput" options missing on documentation	Peter Smith	00:33
Re: Built-in CTYPE provider	Robert Haas	00:38
Re: Add isCatalogRel in rmgrdesc	Masahiko Sawada	01:13
Re: Add isCatalogRel in rmgrdesc	Masahiko Sawada	01:18
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	01:19
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	01:21
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	01:32
Re: broken master regress tests 📎	Jeff Davis	01:48
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	02:23
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	02:50
Re: Track in pg_replication_slots the reason why slots conflict?	Michael Paquier	03:07
Re: pg_upgrade failing for 200+ million Large Objects	Nathan Bossart	03:16
Re: Function to get invalidation cause of a replication slot.	Michael Paquier	03:17
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer	Nathan Bossart	03:25
Re: trying again to get incremental backup	Alexander Lakhin	04:00
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	04:03
Re: Function to get invalidation cause of a replication slot.	Amit Kapila	04:07
Re: Synchronizing slots from primary to standby	Peter Smith	04:24
Re: WAL Insertion Lock Improvements	Michael Paquier	05:38
Re: Function to get invalidation cause of a replication slot.	Michael Paquier	05:47
Re: Add isCatalogRel in rmgrdesc	Bertrand Drouvot	05:56
Re: Fixing backslash dot for COPY FROM...CSV	vignesh C	05:59
RE: Synchronizing slots from primary to standby	Zhijie Hou (Fujitsu)	05:59
Re: speed up a logical replica setup	Amit Kapila	06:16
Re: Function to get invalidation cause of a replication slot.	Amit Kapila	06:23
Re: GUC names in messages	Peter Smith	06:24
Re: Remove MSVC scripts from the tree	vignesh C	06:35
Re: Function to get invalidation cause of a replication slot.	Michael Paquier	06:37
Re: index prefetching	Dilip Kumar	06:49
Re: introduce dynamic shared memory registry	Andrei Lepikhov	06:50
Re: Remove MSVC scripts from the tree	Peter Eisentraut	07:31
Re: Remove MSVC scripts from the tree	Peter Eisentraut	07:37
Re: Remove MSVC scripts from the tree	Andres Freund	07:39
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	John Naylor	07:41
Re: Remove MSVC scripts from the tree	Michael Paquier	08:01
Re: Postgres picks suboptimal index after building of an extended statistics	Andrei Lepikhov	08:41
Re: Stack overflow issue	Egor Chindyaskin	08:45
Re: Remove MSVC scripts from the tree	Peter Eisentraut	09:12
Re: ci: Build standalone INSTALL file	Andres Freund	09:14
Re: ci: Build standalone INSTALL file	Andres Freund	09:16
Re: ci: Build standalone INSTALL file	Andres Freund	09:17
Re: Function to get invalidation cause of a replication slot.	Amit Kapila	09:29
Re: Synchronizing slots from primary to standby 📎	shveta malik	09:31
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Sutou Kouhei	09:35
Re: Autonomous transactions 2023, WIP	Pavel Stehule	09:35
Re: Synchronizing slots from primary to standby	shveta malik	09:36
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	09:39
Re: Track in pg_replication_slots the reason why slots conflict?	Andres Freund	09:40
Re: brininsert optimization opportunity	James Wang	10:05
Re: Postgres picks suboptimal index after building of an extended statistics	Alexander Korotkov	10:10
Re: speed up a logical replica setup	Amit Kapila	10:15
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Peter Eisentraut	10:18
Re: Track in pg_replication_slots the reason why slots conflict?	shveta malik	10:38
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Pavel Stehule	10:46
Re: ci: Build standalone INSTALL file	Daniel Gustafsson	10:53
Re: POC: GROUP BY optimization	Alexander Korotkov	10:53
int4->bool test coverage 📎	Christoph Berg	10:56
Re: Add --check option to pgindent	Jelte Fennema-Nio	10:58
Re: partitioning and identity column	Peter Eisentraut	11:02
Re: Track in pg_replication_slots the reason why slots conflict?	Andres Freund	11:25
Re: Autonomous transactions 2023, WIP	Andrey M. Borodin	11:26
Re: [PoC] Improve dead tuple storage for lazy vacuum	Andres Freund	11:27
Re: Detecting some cases of missing backup_label	Andres Freund	11:37
Re: trying again to get incremental backup	Robert Haas	12:07
Re: Track in pg_replication_slots the reason why slots conflict?	shveta malik	12:08
Re: Detecting some cases of missing backup_label	David Steele	12:26
Re: Building PosgresSQL with LLVM fails on Solaris 11.4	Andres Freund	12:27
Re: index prefetching	Tomas Vondra	12:30
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Ishaan Adarsh	12:37
Re: index prefetching	Tomas Vondra	12:48
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Pavel Stehule	13:03
RE: Synchronizing slots from primary to standby	Hayato Kuroda (Fujitsu)	13:07
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	13:14
Re: logical decoding and replication of sequences, take 2	Tomas Vondra	13:17
Re: GUC names in messages	Peter Eisentraut	13:24
Re: index prefetching	Andres Freund	13:27
Set log_lock_waits=on by default 📎	Laurenz Albe	13:29
Re: index prefetching	Andres Freund	13:43
Re: "pgoutput" options missing on documentation 📎	Emre Hasegeli	13:45
Re: logical decoding and replication of sequences, take 2	Tomas Vondra	14:04
Re: Set log_lock_waits=on by default	Robert Haas	14:14
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	14:25
Re: GIN-Indexable JSON Patterns	David E. Wheeler	14:45
Re: Track in pg_replication_slots the reason why slots conflict?	Bertrand Drouvot	14:51
Re: Set log_lock_waits=on by default	Nikolay Samokhvalov	14:58
Re: trying again to get incremental backup 📎	Alexander Lakhin	15:00
Re: index prefetching	Tomas Vondra	15:20
Re: Set log_lock_waits=on by default	Frédéric Yhuel	15:21
Re: ci: Build standalone INSTALL file	Tom Lane	15:22
Re: Track in pg_replication_slots the reason why slots conflict?	Andres Freund	15:26
Re: ci: Build standalone INSTALL file	Andres Freund	15:30
Re: index prefetching	Tomas Vondra	15:32
Re: index prefetching	Andres Freund	15:43
Re: ci: Build standalone INSTALL file	Tom Lane	15:46
Re: Eager page freeze criteria clarification	Melanie Plageman	15:56
Re: ci: Build standalone INSTALL file	Andres Freund	15:57
Re: index prefetching	Robert Haas	16:00
Re: index prefetching	Andres Freund	16:07
Re: Eager page freeze criteria clarification	Joe Conway	16:36
Functions to return random numbers in a given range 📎	Dean Rasheed	17:06
Re: index prefetching	Robert Haas	17:14
Re: Functions to return random numbers in a given range	Pavel Stehule	17:43
authentication/t/001_password.pl trashes ~/.psql_history	Tom Lane	18:21
Avoid computing ORDER BY junk columns unnecessarily 📎	Heikki Linnakangas	18:38
Re: index prefetching	Tomas Vondra	19:05
Re: ci: Build standalone INSTALL file 📎	Tom Lane	19:22
Re: Fixing backslash dot for COPY FROM...CSV	Daniel Verite	19:47
Re: trying again to get incremental backup 📎	Robert Haas	20:43
Re: Remove MSVC scripts from the tree	Andrew Dunstan	20:43
Re: Eager page freeze criteria clarification	Melanie Plageman	20:58
Re: Eager page freeze criteria clarification	Robert Haas	21:07
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	21:36
Re: pg_serial bloat	Thomas Munro	22:05
Re: Built-in CTYPE provider	Jeff Davis	22:24
Re: Built-in CTYPE provider	Jeff Davis	23:00
Re: broken master regress tests	Jeff Davis	23:17
Re: Remove MSVC scripts from the tree	Michael Paquier	23:20
Re: Track in pg_replication_slots the reason why slots conflict?	Michael Paquier	23:29

Dec. 22, 2023

Thread	Author	Time
Re: Make COPY format extendable: Extract COPY TO format implementations	Michael Paquier	01:00
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	01:23
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	01:48
Re: ci: Build standalone INSTALL file	Michael Paquier	02:41
Re: int4->bool test coverage	Michael Paquier	02:48
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	02:50
Re: Make COPY format extendable: Extract COPY TO format implementations	Junwang Zhao	02:58
Re: trying again to get incremental backup	Alexander Lakhin	05:00
Re: Transaction timeout 📎	Japin Li	05:39
A typo in a messsage?	Kyotaro Horiguchi	06:49
Optimization outcome depends on the index order 📎	Andrei Lepikhov	06:53
Re: [PATCH]: Not to invaldiate CatalogSnapshot for local invalidation messages 📎	Xiaoran Wang	07:34
Re: Trigger violates foreign key constraint	Pavel Luzanov	07:59
Re: planner chooses incremental but not the best one	ywgrit	08:20
Re: Trigger violates foreign key constraint	Pavel Luzanov	09:01
Re: Avoid computing ORDER BY junk columns unnecessarily	Xiaoran Wang	09:05
Re: Set all variable-length fields of pg_attribute to null on column drop	Alvaro Herrera	09:05
Re: planner chooses incremental but not the best one	Sébastien Lardière	09:17
RE: Synchronizing slots from primary to standby	Zhijie Hou (Fujitsu)	09:41
Re: [meson] expose buildtype debug/optimization info to pg_config 📎	Junwang Zhao	09:44
Re: Optimization outcome depends on the index order	Alexander Korotkov	09:48
Re: Synchronizing slots from primary to standby 📎	shveta malik	10:32
Re: Set log_lock_waits=on by default	Christoph Berg	10:33
Re: Synchronizing slots from primary to standby	shveta malik	10:48
Re: Avoid computing ORDER BY junk columns unnecessarily	Heikki Linnakangas	10:48
Re: Set log_lock_waits=on by default	Laurenz Albe	11:00
Re: Built-in CTYPE provider	Daniel Verite	11:26
Re: Trigger violates foreign key constraint 📎	Laurenz Albe	11:39
Re: Transaction timeout	Junwang Zhao	12:29
Re: remaining sql/json patches 📎	jian he	13:01
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Andrey M. Borodin	13:14
Re: Remove MSVC scripts from the tree	Andrew Dunstan	14:07
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	14:09
Re: Transaction timeout	Japin Li	14:25
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	14:29
Re: Transaction timeout	Junwang Zhao	14:37
Re: Transaction timeout	Japin Li	14:44
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Japin Li	14:50
Re: Teach predtest about IS [NOT] <boolean> proofs 📎	James Coleman	15:00
Re: Avoid computing ORDER BY junk columns unnecessarily	Tom Lane	15:24
Re: Transaction timeout 📎	Junwang Zhao	15:30
Re: Avoid computing ORDER BY junk columns unnecessarily	Heikki Linnakangas	16:55
Re: [DOC] Introducing Quick Start Guide to PL/pgSQL and PL/Python Documentation	Pavel Stehule	17:03
Re: Optimization outcome depends on the index order 📎	Andrei Lepikhov	17:24
Re: Avoid computing ORDER BY junk columns unnecessarily	Tom Lane	17:31
Re: ci: Build standalone INSTALL file	Tom Lane	18:33
date_trunc function in interval version 📎	Przemysław Sztoch	19:26
Re: date_trunc function in interval version	Pavel Stehule	19:43
Re: Teach predtest about IS [NOT] <boolean> proofs 📎	Tom Lane	19:48
Re: pg_upgrade --copy-file-range	Peter Eisentraut	20:40
Re: pg_upgrade --copy-file-range	Thomas Munro	20:52
Re: Set all variable-length fields of pg_attribute to null on column drop	Peter Eisentraut	21:01
Re: [PATCHES] Post-special page storage TDE support 📎	David Christensen	21:24
Re: Make all Perl warnings fatal 📎	Peter Eisentraut	21:33
Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. 📎	Alexander Korotkov	22:04
Re: authentication/t/001_password.pl trashes ~/.psql_history 📎	Tom Lane	22:11
Re: date_trunc function in interval version	Przemysław Sztoch	22:25
Fixing pgbench init overflow 📎	Chen Hao Hsu	23:18

Dec. 23, 2023

Thread	Author	Time
Re: Transaction timeout	Japin Li	00:32
Re: date_trunc function in interval version	John Naylor	00:32
Re: A typo in a messsage?	John Naylor	00:35
Re: Transaction timeout	Japin Li	02:40
Re: Transaction timeout	Junwang Zhao	03:08
Re: Transaction timeout 📎	Japin Li	03:17
Commitfest manager January 2024	vignesh C	03:22
Re: Fixing backslash dot for COPY FROM...CSV	vignesh C	03:32
Re: Transaction timeout	Junwang Zhao	03:35
Re: Fixing pgbench init overflow	Japin Li	05:23
Re: Transaction timeout	Li Japin	06:48
Re: Fixing pgbench init overflow	Tatsuo Ishii	07:22
Re: Fixing pgbench init overflow 📎	Japin Li	07:37
Re: Exposing the lock manager's WaitForLockers() to SQL 📎	Will Mortensen	09:47
Re: Exposing the lock manager's WaitForLockers() to SQL	Will Mortensen	09:56
Re: date_trunc function in interval version	Pavel Stehule	12:33
Re: date_trunc function in interval version	Pavel Stehule	12:36
Re: Make attstattarget nullable 📎	Peter Eisentraut	12:56
Re: authentication/t/001_password.pl trashes ~/.psql_history	Andrew Dunstan	13:20

Browse Archives

Prev | Next