pgsql-hackers - December 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

Dec. 1, 2022

Thread	Author	Time
Re: Strange failure on mamba	Andres Freund	00:19
Re: Strange failure on mamba	Tom Lane	00:36
Re: Allow round() function to accept float and double precision	David Rowley	01:30
Re: Allow round() function to accept float and double precision	Tom Lane	01:45
Re: Add LZ4 compression in pg_dump 📎	Michael Paquier	02:05
RE: Partial aggregates pushdown 📎	[email protected]	02:23
Re: Allow round() function to accept float and double precision	David G. Johnston	02:41
Re: Allow round() function to accept float and double precision	David Rowley	02:58
Re: Allow placeholders in ALTER ROLE w/o superuser 📎	Alexander Korotkov	03:14
Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas	Robert Haas	04:32
Re: Prefetch the next tuple's memory during seqscans	John Naylor	05:17
Re: Improve performance of pg_strtointNN functions	John Naylor	05:27
Re: Improve performance of pg_strtointNN functions	David Rowley	05:38
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	06:13
Re: SI-read predicate locks on materialized views	Michael Paquier	06:48
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	07:00
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	07:06
Re: psql - factor out echo code	Pavel Stehule	07:27
Re: [PATCH] Add native windows on arm64 support	Michael Paquier	07:42
Re: meson PGXS compatibility	Peter Eisentraut	07:43
Re: WIN32 pg_import_system_collations	Peter Eisentraut	07:46
Re: SI-read predicate locks on materialized views	Yugo NAGATA	07:53
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	07:57
Re: generic plans and "initial" pruning 📎	Amit Langote	07:59
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	08:02
Re: Bug in row_number() optimization	Richard Guo	08:18
Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas	Noah Misch	08:25
File API cleanup 📎	Peter Eisentraut	08:25
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	08:46
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	08:49
Re: File API cleanup	Bharath Rupireddy	08:55
Re: Allow round() function to accept float and double precision	Dean Rasheed	08:55
Re: [DOCS] Stats views and functions not in order?	Peter Eisentraut	09:20
Re: pg_upgrade allows itself to be run twice	Peter Eisentraut	09:30
Re: Improve performance of pg_strtointNN functions	Dean Rasheed	09:55
initdb: Refactor PG_CMD_PUTS loops 📎	Peter Eisentraut	10:02
RE: Perform streaming logical transactions by background workers and parallel apply	[email protected]	10:16
Re: ExecRTCheckPerms() and many prunable partitions 📎	Alvaro Herrera	10:49
Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas	Alvaro Herrera	11:16
Re: generic plans and "initial" pruning	Alvaro Herrera	11:21
Re: Bug in row_number() optimization	Sergey Shinderuk	11:21
Re: Perform streaming logical transactions by background workers and parallel apply 📎	Amit Kapila	12:39
Re: generic plans and "initial" pruning 📎	Amit Langote	12:43
Optimizing Node Files Support 📎	Ranier Vilela	13:02
Re: Support logical replication of DDLs	li jie	13:03
Re: Asynchronous execution support for Custom Scan 📎	Kazutaka Onishi	13:13
Re: Collation version tracking for macOS	Dagfinn Ilmari Mannsåker	13:22
Re: Asynchronous execution support for Custom Scan	Ronan Dunklau	13:27
Warning When Creating FOR EACH STATEMENT Trigger On Logical Replication Subscriber Side	Avi Weinberg	13:58
Re: pgsql: Revoke PUBLIC CREATE from public schema, now owned by pg_databas	Tom Lane	14:24
Re: [DOCS] Stats views and functions not in order?	David G. Johnston	14:35
Re: Allow round() function to accept float and double precision	Tom Lane	14:39
Re: Add LZ4 compression in pg_dump 📎	gkokolatos	14:58
Re: Documentation for building with meson	Peter Eisentraut	14:58
Re: File API cleanup	Peter Eisentraut	15:10
pg_upgrade: Make testing different transfer modes easier 📎	Peter Eisentraut	15:18
Re: New docs chapter on Transaction Management and related changes	Bruce Momjian	15:48
Re: Temporary tables versus wraparound... again	Greg Stark	16:13
Re: Partial aggregates pushdown 📎	Alexander Pyhalov	16:36
Re: [PATCH] Add native windows on arm64 support	Niyas Sait	17:17
Re: [PATCH] Add native windows on arm64 support	Niyas Sait	17:20
Re: Documentation for building with meson	Andres Freund	17:21
Re: Error-safe user functions 📎	Andrew Dunstan	17:46
Re: [PATCH] Add native windows on arm64 support 📎	Niyas Sait	17:53
Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE))	Justin Pryzby	18:08
Re: Error-safe user functions	Tom Lane	18:14
Re: New docs chapter on Transaction Management and related changes	Alvaro Herrera	18:21
Re: Error-safe user functions	Robert Haas	19:04
Re: Questions regarding distinct operation implementation	Ankit Kumar Pandey	19:10
Re: Temporary tables versus wraparound... again	Andres Freund	19:17
Re: Allow round() function to accept float and double precision	David G. Johnston	19:30
Re: Error-safe user functions	Tom Lane	19:41
Re: Allow round() function to accept float and double precision	David Rowley	19:57
Re: Allow round() function to accept float and double precision	Tom Lane	20:02
Re: Error-safe user functions	Robert Haas	20:12
Re: meson PGXS compatibility 📎	Andres Freund	20:17
Re: Error-safe user functions	Tom Lane	20:49
Using WaitEventSet in the postmaster 📎	Thomas Munro	21:12
Re: Lazy JIT IR code generation to increase JIT speed with partitions	Dmitry Dolgov	21:12
Re: Error-safe user functions	Robert Haas	21:15
Re: Allow round() function to accept float and double precision	David Rowley	21:21
Re: Questions regarding distinct operation implementation	David Rowley	21:37
Re: O(n) tasks cause lengthy startups and checkpoints 📎	Nathan Bossart	21:40
Re: Allow round() function to accept float and double precision	David G. Johnston	21:40
Re: Questions regarding distinct operation implementation	David G. Johnston	21:51
Re: Error-safe user functions	Tom Lane	22:33
Re: Asynchronous execution support for Custom Scan	Kohei KaiGai	23:35

Dec. 2, 2022

Thread	Author	Time
Using AF_UNIX sockets always for tests on Windows 📎	Thomas Munro	00:02
Re: HOT chain validation in verify_heapam()	Andres Freund	00:13
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	00:21
Re: Avoid LWLockWaitForVar() for currently held WAL insertion lock in WaitXLogInsertionsToFinish()	Andres Freund	00:40
Re: pg_upgrade: Make testing different transfer modes easier	Kyotaro Horiguchi	00:56
Re: Using AF_UNIX sockets always for tests on Windows	Tom Lane	01:30
Re: Using WaitEventSet in the postmaster	Andres Freund	01:40
Re: Using AF_UNIX sockets always for tests on Windows	Andres Freund	01:42
Re: Prefetch the next tuple's memory during seqscans	David Rowley	01:47
Re: Using AF_UNIX sockets always for tests on Windows	Tom Lane	01:56
Re: Add LZ4 compression in pg_dump	Michael Paquier	01:56
Re: Using AF_UNIX sockets always for tests on Windows	Andres Freund	02:10
Traversing targetlist to find accessed columns	Amin	02:17
Re: Using WaitEventSet in the postmaster	Thomas Munro	02:36
Re: Support logical replication of DDLs 📎	Zheng Li	02:46
Missing MaterialPath support in reparameterize_path_by_child 📎	Tom Lane	02:55
Re: Warning When Creating FOR EACH STATEMENT Trigger On Logical Replication Subscriber Side	Amit Kapila	02:55
Re: Failed Assert while pgstat_unlink_relation	Andres Freund	03:23
Re: Failed Assert in pgstat_assoc_relation 📎	Andres Freund	04:46
Re: [PATCH] Add native windows on arm64 support	Michael Paquier	05:02
Re: Failed Assert in pgstat_assoc_relation	Tom Lane	05:08
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Michael Paquier	05:15
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths	Michael Paquier	05:22
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Michael Paquier	05:26
Re: Failed Assert in pgstat_assoc_relation	Andres Freund	05:39
Re: [PATCH] Add native windows on arm64 support	John Naylor	05:41
Re: Failed Assert in pgstat_assoc_relation	Tom Lane	05:48
Re: Introduce a new view for checkpointer related stats 📎	Bharath Rupireddy	05:50
Re: Failed Assert in pgstat_assoc_relation	Andres Freund	05:57
Re: Failed Assert in pgstat_assoc_relation	Tom Lane	06:03
Re: O(n) tasks cause lengthy startups and checkpoints	Bharath Rupireddy	06:41
Re: initdb: Refactor PG_CMD_PUTS loops	John Naylor	07:03
Re: Time delayed LR (WAS Re: logical replication restrictions)	Amit Kapila	07:05
Re: pg_dump: Remove "blob" terminology 📎	Peter Eisentraut	07:09
Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures	Michael Paquier	07:20
Re: Introduce a new view for checkpointer related stats	sirisha chamarthi	07:24
Re: Missing MaterialPath support in reparameterize_path_by_child	Richard Guo	07:29
Re: Introduce a new view for checkpointer related stats	Bharath Rupireddy	07:30
refactor ExecGrant_*() functions 📎	Peter Eisentraut	07:30
Re: Improve performance of pg_strtointNN functions	Peter Eisentraut	07:35
Re: Introduce a new view for checkpointer related stats	Drouvot, Bertrand	07:36
Optimize common expressions in projection evaluation 📎	Peifeng Qiu	07:39
Re: ExecRTCheckPerms() and many prunable partitions	Amit Langote	07:41
Re: ExecRTCheckPerms() and many prunable partitions 📎	Amit Langote	07:44
Re: HOT chain validation in verify_heapam()	Himanshu Upadhyaya	07:50
Re: postgres_fdw: batch inserts vs. before row triggers 📎	Etsuro Fujita	07:54
Re: pg_dump: Remove "blob" terminology	Daniel Gustafsson	08:34
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	09:32
Re: [PATCH] Add native windows on arm64 support	Niyas Sait	09:37
Re: [PATCH] Add native windows on arm64 support	Niyas Sait	09:50
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	09:57
Re: ExecRTCheckPerms() and many prunable partitions	Alvaro Herrera	09:59
Re: Fix gin index cost estimation 📎	Ronan Dunklau	10:19
Re: generic plans and "initial" pruning 📎	Amit Langote	10:40
Re: Logical Replication Custom Column Expression	Ashutosh Bapat	10:57
WAL Insertion Lock Improvements (was: Re: Avoid LWLockWaitForVar() for currently held WAL insertion lock in WaitXLogInsertionsToFinish()) 📎	Bharath Rupireddy	11:02
Re: [PATCH] Add native windows on arm64 support 📎	Niyas Sait	11:09
Re: ExecRTCheckPerms() and many prunable partitions 📎	Amit Langote	11:13
Re: Missing MaterialPath support in reparameterize_path_by_child	Ashutosh Bapat	11:21
RE: Perform streaming logical transactions by background workers and parallel apply	Hayato Kuroda (Fujitsu)	11:27
Re: Avoid streaming the transaction which are skipped (in corner cases)	Ashutosh Bapat	11:28
Re: Fix gin index cost estimation	Alexander Korotkov	11:33
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	11:35
Re: pg_upgrade: Make testing different transfer modes easier	Daniel Gustafsson	12:04
Re: Optimizing Node Files Support	John Naylor	12:24
Re: Report roles in pg_upgrade pg_ prefix check	Daniel Gustafsson	12:27
Re: Using AF_UNIX sockets always for tests on Windows 📎	Andrew Dunstan	12:37
Re: Missing MaterialPath support in reparameterize_path_by_child	Richard Guo	12:49
Re: Fix gin index cost estimation	Ronan Dunklau	12:58
Re: Removing another gen_node_support.pl special case	Peter Eisentraut	13:00
Re: Missing MaterialPath support in reparameterize_path_by_child	Richard Guo	13:16
Re: Error-safe user functions	Robert Haas	13:27
Re: Optimize common expressions in projection evaluation	David G. Johnston	13:29
Re: Optimizing Node Files Support 📎	Ranier Vilela	13:35
Re: initdb: Refactor PG_CMD_PUTS loops	Andrew Dunstan	14:07
Re: Add support for DEFAULT specification in COPY FROM 📎	Israel Barth Rubio	14:11
Re: Error-safe user functions	Tom Lane	14:12
Re: pg_dump: Remove "blob" terminology	Tom Lane	14:18
Is this an oversight in reparameterizing Memoize path?	Richard Guo	14:29
Re: Error-safe user functions	Andrew Dunstan	14:34
Re: fixing CREATEROLE 📎	Robert Haas	14:47
Re: pg_dump: Remove "blob" terminology	Daniel Gustafsson	14:53
Re: [PATCH] Allow specification of custom slot for custom nodes	Alexander Korotkov	15:12
Re: Is this an oversight in reparameterizing Memoize path?	Tom Lane	15:13
Re: [PATCH] Check snapshot argument of index_beginscan and family	Alexander Korotkov	15:18
Re: Missing MaterialPath support in reparameterize_path_by_child	Tom Lane	15:43
Re: Add tracking of backend memory allocated to pg_stat_activity	Reid Thompson	16:09
Re: Add LZ4 compression in pg_dump 📎	gkokolatos	16:15
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	Masahiko Sawada	16:41
Re: Failed Assert in pgstat_assoc_relation	Andres Freund	16:42
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths	Andres Freund	16:57
Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths	Andres Freund	17:09
Re: Failed Assert in pgstat_assoc_relation	Tom Lane	17:15
Re: Add tracking of backend memory allocated to pg_stat_activity	Andres Freund	17:18
Re: pg_dump: Remove "blob" terminology	Andrew Dunstan	17:26
Re: refactor ExecGrant_*() functions	Andres Freund	17:28
Bogus rte->relkind for EXCLUDED pseudo-relation 📎	Tom Lane	17:34
Re: pg_dump: Remove "blob" terminology	Tom Lane	17:40
Re: [RFC] building postgres with meson - v13	Andres Freund	17:40
Re: Bogus rte->relkind for EXCLUDED pseudo-relation	Andres Freund	17:50
Re: Failed Assert in pgstat_assoc_relation	Andres Freund	17:51
Re: Error-safe user functions	Corey Huinker	17:53
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jacob Champion	17:58
Re: Error-safe user functions	Corey Huinker	18:15
Re: Error-safe user functions	Tom Lane	18:46
Re: Error-safe user functions	Corey Huinker	19:06
Re: O(n) tasks cause lengthy startups and checkpoints	Nathan Bossart	19:15
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	19:21
suppressing useless wakeups in logical/worker.c 📎	Nathan Bossart	19:55
Re: Schema variables - new implementation for Postgres 15 📎	Pavel Stehule	20:08
Re: Questions regarding distinct operation implementation	Ankit Kumar Pandey	20:10
Re: Removing another gen_node_support.pl special case	Tom Lane	20:25
Re: Questions regarding distinct operation implementation	Ankit Kumar Pandey	20:33

Browse Archives

Prev | Next