pgsql-hackers before 2023-01-09 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

Jan. 6, 2023

Thread	Author	Time
pg_ftruncate hardcodes length=0 but only under windows	Justin Pryzby	03:16
Re: Minimal logical decoding on standbys	Andres Freund	03:40
Notify downstream to discard the streamed transaction which was aborted due to crash. 📎	[email protected]	03:54
Re: pg_ftruncate hardcodes length=0 but only under windows	Thomas Munro	04:07
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	04:07
Re: Schema variables - new implementation for Postgres 15 (typo)	Julien Rouhaud	04:10
Re: Infinite Interval	jian he	04:29
Re: wake up logical workers after ALTER SUBSCRIPTION	Amit Kapila	05:00
Re: Notify downstream to discard the streamed transaction which was aborted due to crash.	Amit Kapila	05:14
Re: Logical replication - schema change not invalidating the relation cache 📎	vignesh C	05:17
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Andrey Borodin	05:30
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Nathan Bossart	05:40
RE: Notify downstream to discard the streamed transaction which was aborted due to crash.	[email protected]	05:44
Re: Notify downstream to discard the streamed transaction which was aborted due to crash.	Dilip Kumar	05:48
Re: TAP output format in pg_regress 📎	vignesh C	05:50
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	05:54
Re: Add a new pg_walinspect function to extract FPIs from WAL records	vignesh C	05:54
Re: [PATCH] Expand character set for ltree labels	vignesh C	06:00
Re: Force streaming every change in logical decoding	vignesh C	06:03
Re: Generating code for query jumbling through gen_node_support.pl	vignesh C	06:07
Re: making relfilenodes 56 bits	Dilip Kumar	06:13
Re: A new strategy for pull-up correlated ANY_SUBLINK	vignesh C	06:16
RE: Force streaming every change in logical decoding	[email protected]	06:17
Re: Add a new pg_walinspect function to extract FPIs from WAL records 📎	Bharath Rupireddy	06:17
Re: refactoring relation extension and BufferAlloc(), faster COPY	vignesh C	06:22
Re: Moving forward with TDE	vignesh C	06:27
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)	Amit Langote	06:29
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)	Tom Lane	06:33
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	06:35
Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)	Amit Langote	06:45
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Japin Li	06:51
Re: Rework of collation code, extensibility	Jeff Davis	07:04
Re: Logical replication timeout problem	Ashutosh Bapat	07:05
Add progress reporting to pg_verifybackup 📎	Masahiko Sawada	07:28
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	07:29
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	07:31
Re: Add index scan progress to pg_stat_progress_vacuum	Masahiko Sawada	07:55
Re: ATTACH PARTITION seems to ignore column generation status 📎	Amit Langote	08:26
Postgres Partitions Limitations (5.11.2.3)	PG Doc comments form	08:28
Re: Authentication fails for md5 connections if ~/.postgresql/postgresql.{crt and key} exist	Jelte Fennema	08:37
Re: Generate pg_stat_get_xact*() functions with Macros	Drouvot, Bertrand	08:40
Re: [RFC] Add jit deform_counter	Pavel Stehule	08:42
Re: Generate pg_stat_get_xact*() functions with Macros	Drouvot, Bertrand	08:44
Re: Sampling-based timing for EXPLAIN ANALYZE	Jelte Fennema	09:19
convey privileges -> confer privileges 📎	Erik Rijkers	09:24
Re: Minimal logical decoding on standbys	Drouvot, Bertrand	09:52
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE	Dean Rasheed	10:03
Fix comments in gistxlogDelete, xl_heap_freeze_page and xl_btree_delete 📎	Drouvot, Bertrand	10:05
Issue attaching a table to a partitioned table with an auto-referenced foreign key 📎	Guillaume Lelarge	10:07
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	10:07
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jelte Fennema	10:17
Re: Getting an error if we provide --enable-tap-tests switch on SLES 12	tushar	10:41
Re: [PATCH] pgbench: add multiconnect option	Jelte Fennema	10:44
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE	Dean Rasheed	11:28
Re: Cygwin cleanup	Thomas Munro	11:39
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Michail Nikolaev	11:45
Re: [PATCH] psql: Add tab-complete for optional view parameters	vignesh C	11:51
Re: Fix showing XID of a spectoken lock in an incorrect field of pg_locks view.	Amit Kapila	11:59
Re: [PATCH] psql: Add tab-complete for optional view parameters	Dean Rasheed	12:18
Re: Fix showing XID of a spectoken lock in an incorrect field of pg_locks view.	Masahiko Sawada	12:30
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Pavel Borisov	12:45
Re: Add BufFileRead variants with short read and EOF detection 📎	Peter Eisentraut	12:48
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	Ankit Kumar Pandey	13:11
Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	Ashutosh Bapat	13:21
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Andrew Dunstan	13:49
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jelte Fennema	14:28
Re: Cygwin cleanup	Andrew Dunstan	14:40
Re: postgres_fdw: using TABLESAMPLE to collect remote sample 📎	Tomas Vondra	14:40
Re: Optimizing Node Files Support 📎	Ranier Vilela	14:49
Re: Resolve UNKNOWN type to relevant type instead of text type while bulk update using values	Tom Lane	14:58
Re: Optimizing Node Files Support	Tom Lane	15:18
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Andrew Dunstan	15:18
Re: [PATCH] Expand character set for ltree labels	Andrew Dunstan	15:59
Re: Logical replication - schema change not invalidating the relation cache	Tom Lane	16:21
Re: [PATCH] Expand character set for ltree labels	Tom Lane	16:29
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tom Lane	16:58
Re: Support load balancing in libpq	Michael Banck	17:21
Re: ATTACH PARTITION seems to ignore column generation status	Tom Lane	17:32
Re: Add a new pg_walinspect function to extract FPIs from WAL records 📎	Bharath Rupireddy	17:41
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue)	Tom Lane	17:53
Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert	Jacob Champion	18:20
Re: add \dpS to psql 📎	Dean Rasheed	18:52
Re: Schema variables - new implementation for Postgres 15 (typo) 📎	Pavel Stehule	19:02
Re: Authentication fails for md5 connections if ~/.postgresql/postgresql.{crt and key} exist	Jim Jones	19:04
Re: pgsql: Delay commit status checks until freezing executes. 📎	Peter Geoghegan	19:16
Re: Introduce "log_connection_stages" setting.	Jacob Champion	19:56
Re: Cygwin cleanup	Thomas Munro	20:16
Re: [PATCH] Expand character set for ltree labels	Andrew Dunstan	21:08
Permute underscore separated components of columns before fuzzy matching 📎	Arne Roland	21:29
Re: RFC: logical publication via inheritance root?	Jacob Champion	21:55
Re: GROUP BY ALL	Bruce Momjian	21:56
Re: Using WaitEventSet in the postmaster 📎	Thomas Munro	22:08
Re: daitch_mokotoff module	Dag Lem	22:27
Re: wake up logical workers after ALTER SUBSCRIPTION 📎	Tom Lane	22:31
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tomas Vondra	22:41
Re: New strategies for freezing, advancing relfrozenxid early	Peter Geoghegan	23:07
Re: Using WaitEventSet in the postmaster	Andres Freund	23:25
Re: New strategies for freezing, advancing relfrozenxid early	Peter Geoghegan	23:28

Jan. 7, 2023

Thread	Author	Time
Re: Transparent column encryption 📎	Justin Pryzby	00:34
Re: add \dpS to psql	Nathan Bossart	00:36
Re: Missing update of all_hasnulls in BRIN opclasses	Justin Pryzby	00:37
Re: GROUP BY ALL	Andrey Borodin	00:40
Re: wake up logical workers after ALTER SUBSCRIPTION	Nathan Bossart	00:45
Re: Add index scan progress to pg_stat_progress_vacuum 📎	Imseih (AWS), Sami	01:59
Re: Is OpenSSL AES-NI not available in pgcrypto?	Bruce Momjian	02:13
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	02:29
Re: Support for dumping extended statistics	Bruce Momjian	02:39
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	David Rowley	04:28
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	04:50
Re: allowing for control over SET ROLE	Noah Misch	05:00
Re: add PROCESS_MAIN to VACUUM 📎	Nathan Bossart	05:07
Re: Using WaitEventSet in the postmaster 📎	Thomas Munro	05:08
Re: Schema variables - new implementation for Postgres 15 (typo)	Julien Rouhaud	05:37
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	05:42
Re: Is OpenSSL AES-NI not available in pgcrypto?	agharta agharta	05:59
Re: pglz compression performance, take two 📎	Andrey Borodin	06:02
Re: Generating code for query jumbling through gen_node_support.pl	Peter Eisentraut	06:37
Re: Schema variables - new implementation for Postgres 15 (typo) 📎	Pavel Stehule	07:09
Re: [PATCH] Const'ify the arguments of ilist.c/ilist.h functions	Peter Eisentraut	07:21
Re: Perform streaming logical transactions by background workers and parallel apply	Dilip Kumar	08:55
How to define template types in PostgreSQL	Esteban Zimanyi	09:31
Allow DISTINCT to use Incremental Sort 📎	David Rowley	09:46
Re: Notify downstream to discard the streamed transaction which was aborted due to crash.	Amit Kapila	10:30
Re: Generating code for query jumbling through gen_node_support.pl	Michael Paquier	10:47
Re: [PATCH] Add function to_oct	vignesh C	11:02
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	11:10
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	11:14
Re: add \dpS to psql	Dean Rasheed	11:18
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	11:58
Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE	vignesh C	12:26
Re: [BUG] Logical replica crash if there was an error in a function.	vignesh C	12:27
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	12:51
Re: MERGE ... WHEN NOT MATCHED BY SOURCE 📎	Dean Rasheed	12:54
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tomas Vondra	14:07
Re: postgres_fdw: using TABLESAMPLE to collect remote sample	Tom Lane	15:20
Re: Support logical replication of DDLs 📎	Zheng Li	15:28
Re: [PATCH] Add function to_oct	Tom Lane	15:29
Re: [RFC] Add jit deform_counter	Dmitry Dolgov	15:47
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	16:27
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	Ankit Kumar Pandey	16:45
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE 📎	Michail Nikolaev	18:06
Re: [RFC] Add jit deform_counter	Pavel Stehule	18:09
Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Tom Lane	18:50
Re: Infinite Interval	Joseph Koshakow	20:04
Re: Infinite Interval 📎	Joseph Koshakow	20:05
Re: Pluggable toaster 📎	Nikita Malakhov	20:10
Re: How to define template types in PostgreSQL	Nikita Malakhov	21:03
delayed initialization in worktable scan	Andres Freund	21:35
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	21:47
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	22:05
Re: delayed initialization in worktable scan	Tom Lane	22:17
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	22:26
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	22:36
Re: Infinite Interval 📎	Joseph Koshakow	22:52
Re: Using WaitEventSet in the postmaster	Andres Freund	22:55
Re: drop postmaster symlink	Karl O. Pinc	22:59
FYI: 2022-10 thorntail failures from coreutils FICLONE	Noah Misch	23:29
Re: drop postmaster symlink	Tom Lane	23:38
Re: pgsql: Delay commit status checks until freezing executes.	Peter Geoghegan	23:41

Jan. 8, 2023

Thread	Author	Time
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Andres Freund	00:29
Re: drop postmaster symlink	Joe Conway	00:33
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Andres Freund	00:34
Re: drop postmaster symlink	Karl O. Pinc	01:56
Re: drop postmaster symlink	Karl O. Pinc	01:57
Re: Perform streaming logical transactions by background workers and parallel apply	Amit Kapila	02:14
Re: BUG: Postgres 14 + vacuum_defer_cleanup_age + FOR UPDATE + UPDATE	Andres Freund	03:09
Re: pgsql: Delay commit status checks until freezing executes.	Andres Freund	03:25
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	03:58
Re: drop postmaster symlink	Karl O. Pinc	04:29
Re: [BUG] Logical replica crash if there was an error in a function. 📎	Anton A. Melnikov	06:02
RE: Perform streaming logical transactions by background workers and parallel apply 📎	[email protected]	06:02
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	06:18
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	06:29
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	Ankit Kumar Pandey	10:21
Re: [RFC] Add jit deform_counter 📎	Dmitry Dolgov	10:56
Re: [RFC] Add jit deform_counter	Pavel Stehule	11:00
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	11:03
Re: Fix gin index cost estimation	Alexander Korotkov	11:45
MERGE ... RETURNING 📎	Dean Rasheed	12:28
Re: [Commitfest 2023-01] has started	vignesh C	15:30
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Vik Fearing	16:06
Re: Fix gin index cost estimation	Tom Lane	16:08
Re: Progress report of CREATE INDEX for nested partitioned tables	Justin Pryzby	16:48
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Ankit Kumar Pandey	17:05
Re: Todo: Teach planner to evaluate multiple windows in the optimal order 📎	Ankit Kumar Pandey	17:17
Re: POC: Lock updated tuples in tuple_update() and tuple_delete()	Mason Sharp	18:33
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	Vik Fearing	19:21
Re: Add LZ4 compression in pg_dump	Justin Pryzby	19:45
Re: Fix gin index cost estimation	Alexander Korotkov	19:53
Re: [RFC] Add jit deform_counter	Pavel Stehule	20:06
Re: MERGE ... RETURNING	Isaac Morland	20:09
Re: drop postmaster symlink	Karl O. Pinc	20:17
[PATCH] basebackup: support zstd long distance matching 📎	Justin Pryzby	20:27
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	20:52
Re: on placeholder entries in view rule action query's range table	Tom Lane	20:58
Re: POC: Lock updated tuples in tuple_update() and tuple_delete() 📎	Alexander Korotkov	22:07
Re: Todo: Teach planner to evaluate multiple windows in the optimal order	David Rowley	22:18
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits 📎	Peter Geoghegan	22:39
Re: Missing update of all_hasnulls in BRIN opclasses 📎	Tomas Vondra	23:34
Re: Fixing a couple of buglets in how VACUUM sets visibility map bits	Andres Freund	23:53

Browse Archives

Prev | Next