pgsql-hackers since 2023-01-04 00:37

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

Jan. 4, 2023

Thread	Author	Time
Re: Common function for percent placeholder replacement	Nathan Bossart	00:37
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	00:54
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	David Rowley	00:57
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	01:15
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	01:54
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	Vladimir Churyukin	03:15
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	David Rowley	03:41
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? 📎	Thomas Munro	03:46
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	03:56
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	04:02
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	04:11
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	04:29
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	Vladimir Churyukin	04:39
Re: [PATCH] CF app: add "Returned: Needs more interest"	vignesh C	04:56
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	David Rowley	05:06
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	05:27
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	05:31
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	05:50
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	Tom Lane	05:55
Re: Question regarding "Make archiver process an auxiliary process. commit"	Sravan Kumar	06:05
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	06:33
Re: Perform streaming logical transactions by background workers and parallel apply	Masahiko Sawada	06:39
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	06:41
Fix showing XID of a spectoken lock in an incorrect field of pg_locks view. 📎	Masahiko Sawada	06:45
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	06:47
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	06:52
Ignore dropped columns when checking the column list in logical replication 📎	[email protected]	06:58
Re: [DOCS] Stats views and functions not in order?	vignesh C	07:07
Re: Add SHELL_EXIT_CODE to psql 📎	Corey Huinker	07:09
Some compiling warnings 📎	Richard Guo	07:11
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	Ankit Kumar Pandey	08:21
Re: [PATCH] Improve ability to display optimizer analysis using OPTIMIZER_DEBUG	Vladimir Churyukin	08:52
Re: Underscores in numeric literals 📎	Dean Rasheed	09:28
Re: Underscores in numeric literals	Dean Rasheed	09:31
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	vignesh C	09:40
Re: Fix showing XID of a spectoken lock in an incorrect field of pg_locks view.	Amit Kapila	09:42
Re: Parallelize correlated subqueries that execute within each worker	vignesh C	09:49
Re: Add index scan progress to pg_stat_progress_vacuum	Drouvot, Bertrand	09:50
Re: Pluggable toaster	vignesh C	09:52
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Pavel Borisov	09:52
Re: Prefetch the next tuple's memory during seqscans	vignesh C	10:06
Re: WIP: Aggregation push-down - take2	vignesh C	10:12
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	vignesh C	10:15
Re: on placeholder entries in view rule action query's range table	vignesh C	10:17
grouping pushdown	Spring Zhong	10:21
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	10:55
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	11:22
Re: meson oddities	Peter Eisentraut	11:35
Getting an error if we provide --enable-tap-tests switch on SLES 12 📎	tushar	11:57
Re: MERGE ... WHEN NOT MATCHED BY SOURCE	Alvaro Herrera	11:57
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎	David Geier	12:02
Re: Understanding, testing and improving our Windows filesystem code	vignesh C	12:06
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	12:07
psql's FETCH_COUNT (cursor) is not being respected for CTEs 📎	Jakub Wartak	12:10
Re: Using AF_UNIX sockets always for tests on Windows	vignesh C	12:13
Re: making relfilenodes 56 bits	vignesh C	12:15
Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit	vignesh C	12:19
Re: [PoC] Implementation of distinct in Window Aggregates 📎	Ankit Kumar Pandey	12:40
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Pavel Borisov	12:42
Re: GSOC2023	Jesper Pedersen	13:02
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	13:10
Re: fix and document CLUSTER privileges	Gilles Darold	13:25
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	13:29
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION	Amit Kapila	13:46
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	14:05
Re: Add a new pg_walinspect function to extract FPIs from WAL records	Drouvot, Bertrand	14:49
Re: pgsql: Delay commit status checks until freezing executes.	Robert Haas	15:02
Re: explain analyze rows=%.0f	Ibrar Ahmed	15:04
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	Ankit Kumar Pandey	15:11
Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs	Daniel Verite	15:22
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	15:30
Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs	Robert Haas	15:57
Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs	Tom Lane	16:36
Re: Infinite Interval 📎	jian he	16:43
Re: wake up logical workers after ALTER SUBSCRIPTION	Nathan Bossart	17:33
Re: [PATCH] CF app: add "Returned: Needs more interest"	Jacob Champion	17:33
Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs	Robert Haas	17:38
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	17:59
pgbench - adding pl/pgsql versions of tests 📎	Hannu Krosing	18:06
Re: wake up logical workers after ALTER SUBSCRIPTION	Nathan Bossart	18:12
Re: fix and document CLUSTER privileges	Nathan Bossart	18:18
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	18:41
Re: Add index scan progress to pg_stat_progress_vacuum 📎	Imseih (AWS), Sami	19:24
Re: meson oddities	Andres Freund	19:35
Re: grouping pushdown	David Rowley	19:40
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable) 📎	Tom Lane	19:59
Re: allowing for control over SET ROLE	Robert Haas	20:56
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	21:05
Re: meson oddities	Robert Haas	21:06
Re: Getting an error if we provide --enable-tap-tests switch on SLES 12	Andres Freund	21:10
Re: meson oddities	Tom Lane	21:18
Re: verbose mode for pg_input_error_message? 📎	Andrew Dunstan	21:18
Re: Add a test to ldapbindpasswd 📎	Andrew Dunstan	21:26
Re: meson oddities	Andres Freund	21:29
Re: Support logical replication of DDLs 📎	Zheng Li	21:35
Re: Rework of collation code, extensibility	Peter Eisentraut	21:46
Re: Logical replication - schema change not invalidating the relation cache	Tom Lane	21:47
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Andres Freund	22:16
Re: meson oddities 📎	Peter Eisentraut	22:17
Re: An oversight in ExecInitAgg for grouping sets 📎	David Rowley	22:17
Re: fix and document CLUSTER privileges	Gilles Darold	22:27
Re: Add a test to ldapbindpasswd 📎	Andrew Dunstan	22:33
Re: Optimizing Node Files Support 📎	Tom Lane	22:39
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Andres Freund	22:47
Re: meson oddities	Andres Freund	22:53
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Tom Lane	22:55
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	22:56
Re: CI and test improvements	Justin Pryzby	23:19
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Andres Freund	23:33
Re: CI and test improvements 📎	Justin Pryzby	23:44
Re: Some compiling warnings	David Rowley	23:57

Jan. 5, 2023

Thread	Author	Time
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Thomas Munro	00:21
Re: Split index and table statistics into different types of stats	Andres Freund	00:27
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Andres Freund	00:31
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Thomas Munro	00:43
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	00:49
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?	Tom Lane	01:14
Re: [PATCH] Simple code cleanup in tuplesort.c.	John Naylor	01:18
Re: New strategies for freezing, advancing relfrozenxid early	Matthias van de Meent	01:21
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Vik Fearing	02:18
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	02:30
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Tom Lane	02:48
Re: pg_upgrade test failure 📎	Thomas Munro	03:11
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Tom Lane	03:12
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	03:37
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	03:39
Re: wake up logical workers after ALTER SUBSCRIPTION	Nathan Bossart	04:12
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	04:46
Re: fix and document CLUSTER privileges 📎	Nathan Bossart	05:12
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	05:27
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	06:04
Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	Sayyid Ali Sajjad Rizavi	06:10
Re: Fix showing XID of a spectoken lock in an incorrect field of pg_locks view. 📎	Masahiko Sawada	06:15
Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	David G. Johnston	06:23
Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	Sayyid Ali Sajjad Rizavi	06:30
Re: on placeholder entries in view rule action query's range table 📎	Amit Langote	06:47
Re: pgsql: Delay commit status checks until freezing executes.	Amit Kapila	06:58
Re: An oversight in ExecInitAgg for grouping sets	Richard Guo	07:06
Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	David G. Johnston	07:12
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	07:14
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	07:23
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	07:46
Re: grouping pushdown	Antonin Houska	07:51
Re: WIP: Aggregation push-down - take2 📎	Antonin Houska	07:59
Re: Add index scan progress to pg_stat_progress_vacuum	Masahiko Sawada	08:11
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	08:21
Re: daitch_mokotoff module	Dag Lem	09:43
Re: Split index and table statistics into different types of stats	Drouvot, Bertrand	10:03
Re: Allow placeholders in ALTER ROLE w/o superuser	Alexander Korotkov	10:14
Re: Infinite Interval 📎	jian he	10:20
Issue in MERGE with concurrent UPDATE and MERGE	Shruthi Gowda	10:36
How to generate the new expected out file.	jian he	10:42
Re: Ignore dropped columns when checking the column list in logical replication	Amit Kapila	10:48
Re: How to generate the new expected out file.	Amit Kapila	10:52
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	11:33
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	11:53
Re: Logical replication - schema change not invalidating the relation cache 📎	vignesh C	12:02
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Alexander Korotkov	12:11
Re: Cygwin cleanup	Thomas Munro	12:22
Re: Using AF_UNIX sockets always for tests on Windows	Andrew Dunstan	12:31
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE 📎	Dean Rasheed	12:52
BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Michail Nikolaev	13:12
Re: MERGE ... WHEN NOT MATCHED BY SOURCE	Dean Rasheed	13:21
Re: Add a new pg_walinspect function to extract FPIs from WAL records 📎	Bharath Rupireddy	13:21
Re: Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Bharath Rupireddy	13:24
Re: fix and document CLUSTER privileges	Gilles Darold	13:38
Generate pg_stat_get_xact*() functions with Macros 📎	Drouvot, Bertrand	13:48
Re: heapgettup refactoring	Peter Eisentraut	13:52
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)	Amit Langote	13:53
Re: Allow tailoring of ICU locales with custom rules 📎	Peter Eisentraut	15:15
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)	Tom Lane	15:28
Re: Infinite Interval	Joseph Koshakow	15:39
Re: fix and document CLUSTER privileges	Nathan Bossart	17:11
Re: wake up logical workers after ALTER SUBSCRIPTION	Nathan Bossart	17:19
Re: wake up logical workers after ALTER SUBSCRIPTION	Nathan Bossart	17:29
Re: daitch_mokotoff module	Alvaro Herrera	18:16
Re: New strategies for freezing, advancing relfrozenxid early	Matthias van de Meent	18:19
Support for dumping extended statistics	Hari krishna Maddileti	18:29
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎	Reid Thompson	18:44
ATTACH PARTITION seems to ignore column generation status	Tom Lane	18:53
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	18:57
Re: Add tracking of backend memory allocated to pg_stat_activity	Reid Thompson	18:58
Re: fixing CREATEROLE 📎	Robert Haas	19:53
Re: Add tracking of backend memory allocated to pg_stat_activity	Justin Pryzby	20:13
Re: Generate pg_stat_get_xact*() functions with Macros	Corey Huinker	20:19
Re: postgres_fdw: using TABLESAMPLE to collect remote sample 📎	Tomas Vondra	20:43
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tom Lane	21:05
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser)	Justin Pryzby	21:12
Re: Minimal logical decoding on standbys	Robert Haas	21:15
Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser)	Tom Lane	21:25
Re: Add tracking of backend memory allocated to pg_stat_activity	Reid Thompson	21:33
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Michail Nikolaev	21:39
Re: Cygwin cleanup	Thomas Munro	21:39
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tomas Vondra	21:47
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Matthias van de Meent	21:49
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tom Lane	21:56
Re: Logical replication - schema change not invalidating the relation cache 📎	Tom Lane	23:02
Re: [PATCH] Enable using llvm jitlink as an alternative llvm jit linker of old Rtdyld. 📎	Alex Fan	23:19
Re: Generate pg_stat_get_xact*() functions with Macros	Andres Freund	23:21
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Peter Geoghegan	23:27

Browse Archives

Prev | Next