pgsql-hackers since 2024-07-27 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

July 27, 2024

Thread	Author	Time
Re: CREATE OR REPLACE MATERIALIZED VIEW 📎	Erik Wienhold	00:45
Re: add function argument names to regex* functions. 📎	jian he	00:56
Re: pg_upgrade failing for 200+ million Large Objects	Alexander Korotkov	03:00
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	03:08
pg_attribute.atttypmod for interval type	Greg Rychlewski	03:57
Re: pg_attribute.atttypmod for interval type	Tom Lane	04:32
Re: Protocol question regarding Portal vs Cursor	Tatsuo Ishii	05:55
Re: Things I don't like about \du's "Attributes" column	Pavel Luzanov	06:18
Help Needed with Including External SQL Script in Extension Script	Ayush Vatsa	06:24
Re: Help Needed with Including External SQL Script in Extension Script	David G. Johnston	06:39
Re: Incremental View Maintenance, take 2	Kirill Reshke	08:26
Re: POC, WIP: OR-clause support for indexes	Alexander Korotkov	10:56
Re: Building with meson on NixOS/nixpkgs	Heikki Linnakangas	11:17
Re: Speed up JSON escape processing with SIMD plus other optimisations 📎	David Rowley	12:51
why is pg_upgrade's regression run so slow?	Andrew Dunstan	13:08
Re: Pluggable cumulative statistics	Dmitry Dolgov	13:49
Re: proposal: schema variables 📎	Laurenz Albe	14:19
Re: why is pg_upgrade's regression run so slow?	Tom Lane	14:20
Re: [18] separate collation and ctype versions, and cleanup of pg_database locale fields 📎	Jeff Davis	15:34
Re: Protocol question regarding Portal vs Cursor	Dave Cramer	16:05
Unexpected Null Pointer For Static Shared Memory Segment	Aditya Gupta	16:58
Re: tiny step toward threading: reduce dependence on setlocale()	Andreas Karlsson	19:03
Fix overflow in pg_size_pretty 📎	Joseph Koshakow	19:18
Re: Protocol question regarding Portal vs Cursor	Tom Lane	19:18
Re: add function argument names to regex* functions.	Tom Lane	19:40
Re: xid_wraparound tests intermittent failure. 📎	Andrew Dunstan	20:05
Re: allow changing autovacuum_max_workers without restarting 📎	Nathan Bossart	20:32
Re: Fix overflow in pg_size_pretty 📎	Joseph Koshakow	21:16
Re: Speed up collation cache 📎	Andreas Karlsson	22:14
Re: Fix overflow in pg_size_pretty 📎	David Rowley	22:28
Re: why is pg_upgrade's regression run so slow?	Andrew Dunstan	22:43
Re: why is pg_upgrade's regression run so slow?	Tom Lane	22:48
Re: Protocol question regarding Portal vs Cursor	Tatsuo Ishii	23:06
Re: Fix overflow in pg_size_pretty	Joseph Koshakow	23:06

July 28, 2024

Thread	Author	Time
Re: Fix overflow in pg_size_pretty	David Rowley	00:00
Re: Statistics Import and Export 📎	Corey Huinker	01:08
Re: Fix overflow in pg_size_pretty	Joseph Koshakow	01:10
Re: why is pg_upgrade's regression run so slow?	Thomas Munro	01:19
Re: Vacuum ERRORs out considering freezing dead tuples from before OldestXmin	John Naylor	03:20
Re: Fix overflow in pg_size_pretty 📎	David Rowley	03:42
Re: Fix overflow in pg_size_pretty 📎	Joseph Koshakow	04:30
Re: improve ssl error code, 2147483650	Peter Eisentraut	08:36
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	09:59
Re: Protocol question regarding Portal vs Cursor	Dave Cramer	10:30
Re: Fix overflow in pg_size_pretty	David Rowley	10:34
Re: Pluggable cumulative statistics	Michael Paquier	13:20
Re: pg_attribute.atttypmod for interval type	Chapman Flack	14:34
Re: Vacuum ERRORs out considering freezing dead tuples from before OldestXmin	Masahiko Sawada	14:44
Re: Make COPY format extendable: Extract COPY TO format implementations	Junwang Zhao	14:49
Re: [PATCH] TODO “Allow LISTEN on patterns” 📎	Alexander Cheshev	15:17
Re: race condition in pg_class	Tom Lane	15:50
Re: Parent/child context relation in pg_get_backend_memory_contexts()	Tom Lane	16:31
Re: race condition in pg_class	Noah Misch	16:51
Re: race condition in pg_class	Tom Lane	16:59
Re: UUID v7 📎	Andrey M. Borodin	18:44
Re: Optimize mul_var() for var1ndigits >= 8 📎	Dean Rasheed	19:18
Re: why is pg_upgrade's regression run so slow?	Andrew Dunstan	19:43
Re: Speed up collation cache	Jeff Davis	20:02
Re: Pluggable cumulative statistics	Dmitry Dolgov	20:03
Re: Parent/child context relation in pg_get_backend_memory_contexts()	David Rowley	21:19
Re: pg_upgrade failing for 200+ million Large Objects 📎	Tom Lane	21:24

July 29, 2024

Thread	Author	Time
Re: Optimize mul_var() for var1ndigits >= 8	Joel Jacobson	00:23
Re: POC, WIP: OR-clause support for indexes 📎	Alexander Korotkov	02:36
Re: Maybe don't process multi xmax in FreezeMultiXactId() if it is already marked as invalid?	Anton A. Melnikov	02:48
Re: Simplify create_merge_append_path a bit for clarity	Richard Guo	03:03
Re: Allow logical failover slots to wait on synchronous replication	shveta malik	03:11
Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)	Richard Guo	03:26
Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)	Ashutosh Bapat	03:44
RE: [Proposal] Add foreign-server health checks infrastructure	Hayato Kuroda (Fujitsu)	03:54
RE: [Proposal] Add foreign-server health checks infrastructure 📎	Hayato Kuroda (Fujitsu)	03:58
dikkop failed the pg_combinebackupCheck/006_db_file_copy.pl test	Alexander Lakhin	04:00
Re: Conflict detection and logging in logical replication	Amit Kapila	04:01
Re: Flush pgstats file during checkpoints	Bertrand Drouvot	04:46
Re: Allow logical failover slots to wait on synchronous replication	Bertrand Drouvot	05:00
Re: Add mention of execution time memory for enable_partitionwise_* GUCs 📎	David Rowley	05:07
Re: Logical Replication of sequences 📎	vignesh C	05:49
Re: Logical Replication of sequences	vignesh C	05:52
Re: Logical Replication of sequences	vignesh C	05:54
RE: Conflict detection and logging in logical replication 📎	Zhijie Hou (Fujitsu)	06:14
Re: Use pgBufferUsage for block reporting in analyze 📎	Anthonin Bonnefoy	07:11
Re: Pgoutput not capturing the generated columns	Peter Smith	07:26
Re: Visibility bug with prepared transaction with subtransactions on standby	a.kozhemyakin	07:37
Re: why is pg_upgrade's regression run so slow?	Alexander Lakhin	08:00
Re: BUG #18545: \dt breaks transaction, calling error when executed in SET SESSION AUTHORIZATION	Андрей Рачицкий	08:24
Re: Conflict detection and logging in logical replication	Amit Kapila	09:24
Re: proposal: schema variables 📎	Laurenz Albe	09:56
Re: tls 1.3: sending multiple tickets 📎	Daniel Gustafsson	09:56
Detach shared memory in Postmaster child if not needed 📎	Rui Zhao	09:57
Re: Add ALL_CANDIDATES option to EXPLAIN	Ashutosh Bapat	09:58
Re: Adding OLD/NEW support to RETURNING 📎	Dean Rasheed	10:22
Re: Remove duplicate table scan in logical apply worker and code refactoring	Amit Kapila	10:46
Re: Logical Replication of sequences 📎	vignesh C	10:47
Re: Logical Replication of sequences	vignesh C	10:48
Fix smgrtruncate code comment. 📎	Kirill Reshke	10:50
Re: why is pg_upgrade's regression run so slow?	Andrew Dunstan	10:54
Re: [PATCH] Add crc32(text) & crc32(bytea) 📎	Aleksander Alekseev	10:55
Re: Conflict detection and logging in logical replication	Dilip Kumar	10:59
Remove dead code generation tools in src/backend/utils/mb/ 📎	Heikki Linnakangas	11:18
Re: Fix smgrtruncate code comment.	Heikki Linnakangas	11:27
Re: Remove duplicate table scan in logical apply worker and code refactoring	Amit Kapila	11:42
Re: Detach shared memory in Postmaster child if not needed	Aleksander Alekseev	11:44
Re: Conflict detection and logging in logical replication	shveta malik	11:55
Re: [PoC] Federated Authn/z with OAUTHBEARER	Peter Eisentraut	12:01
RE: Conflict detection and logging in logical replication	Zhijie Hou (Fujitsu)	12:14
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Tomas Vondra	12:17
Re: Make query cancellation keys longer	Heikki Linnakangas	13:19
Re: Remove dead code generation tools in src/backend/utils/mb/	Tom Lane	14:15
Re: Optimize mul_var() for var1ndigits >= 8	Joel Jacobson	14:42
Re: Virtual generated columns	Peter Eisentraut	14:59
Re: Remove dead code generation tools in src/backend/utils/mb/	Alexander Lakhin	15:00
Re: Remove dead code generation tools in src/backend/utils/mb/	Andreas Karlsson	15:06
pgsql: Fix double-release of spinlock	Heikki Linnakangas	15:24
Re: pgsql: Fix double-release of spinlock	Tom Lane	15:31
Re: tls 1.3: sending multiple tickets	Robert Haas	15:34
Re: pgsql: Fix double-release of spinlock	Andres Freund	16:18
Re: Assertion failure with summarize_wal enabled during pg_createsubscriber	Robert Haas	16:20
Re: Incremental backup from a streaming replication standby fails	Robert Haas	16:21
Re: pgsql: Fix double-release of spinlock	Tom Lane	16:33
Re: CREATE MATERIALIZED VIEW	Nathan Bossart	16:38
Re: pgsql: Fix double-release of spinlock	Andres Freund	16:40
Re: pgsql: Fix double-release of spinlock	Tom Lane	16:45
Detect double-release of spinlock 📎	Andres Freund	16:51
Re: CREATE MATERIALIZED VIEW	Dagfinn Ilmari Mannsåker	16:53
Re: Interrupts vs signals	Robert Haas	16:56
Re: Detect double-release of spinlock	Heikki Linnakangas	17:07
Re: Interrupts vs signals	Heikki Linnakangas	17:18
Re: Interrupts vs signals	Tom Lane	17:24
Re：Detach shared memory in Postmaster child if not needed 📎	Rui Zhao	17:25
Re: Detect double-release of spinlock	Tom Lane	17:25
Re: pgsql: Fix double-release of spinlock	Robert Haas	17:37
Re: Remove dead code generation tools in src/backend/utils/mb/	Heikki Linnakangas	17:41
Re: pgsql: Fix double-release of spinlock	Andres Freund	17:46
Re: Detect double-release of spinlock	Andres Freund	17:48
Re: pgsql: Fix double-release of spinlock	Tom Lane	17:56
Re: Detect double-release of spinlock	Tom Lane	17:57
Re: Optimize mul_var() for var1ndigits >= 8	Joel Jacobson	17:57
Re: Detect double-release of spinlock	Heikki Linnakangas	18:00
Re: Interrupts vs signals	Robert Haas	18:05
Re: Detach shared memory in Postmaster child if not needed	Robert Haas	18:10
Re: Detect double-release of spinlock	Andres Freund	18:12
Re: Detect double-release of spinlock 📎	Andres Freund	18:29
040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Robert Haas	19:34
Re: Detach shared memory in Postmaster child if not needed	Heikki Linnakangas	19:41
Re: tiny step toward threading: reduce dependence on setlocale()	Peter Eisentraut	19:45
Suboptimal spinlock code due to volatile	Andres Freund	19:59
Re: Optimize mul_var() for var1ndigits >= 8	Dean Rasheed	20:01
Re: tls 1.3: sending multiple tickets	Andres Freund	20:08
Re: Refactoring postmaster's code to cleanup after child exit 📎	Heikki Linnakangas	20:16
Re: 040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Tom Lane	20:18
Re: Optimize mul_var() for var1ndigits >= 8	Joel Jacobson	20:38
Is *fast* 32-bit support still important?	Joel Jacobson	20:40
Re: [PoC] Federated Authn/z with OAUTHBEARER	Daniel Gustafsson	20:51
Re: speed up a logical replica setup	Euler Taveira	21:11
Re: xid_wraparound tests intermittent failure.	Masahiko Sawada	21:25
Re: Remove last traces of HPPA support 📎	Thomas Munro	21:50
Re: Optimize mul_var() for var1ndigits >= 8	Dean Rasheed	21:59
Speeding up ruleutils' name de-duplication code, redux 📎	Tom Lane	22:14
Re: ecdh support causes unnecessary roundtrips	Daniel Gustafsson	22:25
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	22:30
Re: Optimize mul_var() for var1ndigits >= 8	Tom Lane	22:31
Re: Incremental View Maintenance, take 2	Kirill Reshke	22:32
Re: Use pgBufferUsage for block reporting in analyze	Masahiko Sawada	23:13
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	23:15
Re: Restart pg_usleep when interrupted	Sami Imseih	23:15
Re: Remove last traces of HPPA support	Heikki Linnakangas	23:16
Re: psql: Add leakproof field to \dAo+ meta-command results	Erik Wienhold	23:36

July 30, 2024

Thread	Author	Time
Re: speed up a logical replica setup 📎	Euler Taveira	00:05
Re: Remove last traces of HPPA support 📎	Thomas Munro	00:39
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	02:58
COPY FROM crash 📎	Zhang Mingli	03:50
Re: 040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Amit Kapila	03:54
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	03:56
Re: Conflict Detection and Resolution	shveta malik	04:19
Re: 040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Tom Lane	04:26
Re: 040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Amit Kapila	04:46
Re: pgsql: Add more SQL/JSON constructor functions	Amit Langote	04:59
Re: Incremental View Maintenance, take 2	Yugo NAGATA	05:24
Re: speed up a logical replica setup	Amit Kapila	05:31
Re: COPY FROM crash	David Rowley	05:35
Re: COPY FROM crash	Kirill Reshke	05:37
Re: Separate HEAP WAL replay logic into its own file	Sutou Kouhei	05:47
Re: 040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Ashutosh Bapat	05:58
Re: 040_pg_createsubscriber.pl is slow and unstable (was Re: speed up a logical replica setup)	Amit Kapila	06:22
Re: Flush pgstats file during checkpoints 📎	Michael Paquier	06:25
Re: psql: Add leakproof field to \dAo+ meta-command results 📎	Yugo NAGATA	06:30
Re: Restart pg_usleep when interrupted	Bertrand Drouvot	06:31
Re: Separate HEAP WAL replay logic into its own file	Li, Yong	06:48
Re: COPY FROM crash 📎	Zhang Mingli	07:06
Re: COPY FROM crash	Zhang Mingli	07:07
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Sutou Kouhei	07:13
Re: Use pgBufferUsage for block reporting in analyze 📎	Anthonin Bonnefoy	07:21
Re: Is *fast* 32-bit support still important?	Heikki Linnakangas	07:25
Re: A problem about partitionwise join	Richard Guo	07:36
Re: Trivial revise for the check of parameterized partial paths	Richard Guo	07:42
Re: Suboptimal spinlock code due to volatile	Heikki Linnakangas	07:45
Re: Short-circuit sort_inner_and_outer if there are no mergejoin clauses	Richard Guo	07:46
RE: Conflict detection and logging in logical replication	Zhijie Hou (Fujitsu)	08:19
Re: COPY FROM crash	David Rowley	08:22
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	08:37
Re: Conflict detection and logging in logical replication	Dilip Kumar	08:41

Browse Archives

Prev | Next