pgsql-hackers since 2024-01-04 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. 4, 2024

Thread	Author	Time
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	00:02
Re: Update for copyright messages to 2024 (Happy New Year!)	Bruce Momjian	01:49
Re: Transaction timeout	Japin Li	02:14
Re: speed up a logical replica setup	Euler Taveira	02:54
Re: Change GUC hashtable to use simplehash? 📎	jian he	03:01
Re: speed up a logical replica setup	Euler Taveira	03:21
Re: Synchronizing slots from primary to standby	shveta malik	03:48
Re: Synchronizing slots from primary to standby 📎	shveta malik	04:57
Re: speed up a logical replica setup	Amit Kapila	05:41
Re: speed up a logical replica setup	Amit Kapila	06:05
Re: Synchronizing slots from primary to standby	Dilip Kumar	06:18
Re: speed up a logical replica setup	Shlok Kyal	06:51
Re: GUC names in messages 📎	Peter Smith	06:53
the s_lock_stuck on perform_spin_delay 📎	Andy Fan	06:59
Re: speed up a logical replica setup	Ashutosh Bapat	07:00
Re: add function argument names to regex* functions. 📎	jian he	07:03
Re: [PATCH] Exponential backoff for auth_delay 📎	Michael Banck	07:30
Re: Transaction timeout 📎	Andrey M. Borodin	08:41
Documentation to upgrade logical replication cluster 📎	vignesh C	08:51
Re: Synchronizing slots from primary to standby	Amit Kapila	08:52
Re: pg_upgrade and logical replication	vignesh C	09:39
Re: pg_upgrade and logical replication	vignesh C	10:09
Re: the s_lock_stuck on perform_spin_delay	Matthias van de Meent	10:23
Re: speed up a logical replica setup	Amit Kapila	11:04
Re: speed up a logical replica setup	Amit Kapila	11:16
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Matthias van de Meent	11:24
Re: Random pg_upgrade test failure on drongo 📎	Alexander Lakhin	12:00
Re: speed up a logical replica setup	Ashutosh Bapat	12:21
Re: Adding facility for injection points (or probe points?) for more advanced tests	Ashutosh Bapat	12:34
Re: INFORMATION_SCHEMA note	Tatsuo Ishii	12:39
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	12:45
Re: Adding facility for injection points (or probe points?) for more advanced tests	Ashutosh Bapat	12:52
Re: Add a perl function in Cluster.pm to generate WAL	Alexander Lakhin	13:00
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	13:35
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	13:54
Re: the s_lock_stuck on perform_spin_delay 📎	Andy Fan	14:24
Re: index prefetching 📎	Tomas Vondra	14:55
Re: WIP Incremental JSON Parser	Robert Haas	15:06
Re: the s_lock_stuck on perform_spin_delay	Tom Lane	15:22
Re: POC: Extension for adding distributed tracing - pg_tracing	Anthonin Bonnefoy	15:36
Re: speed up a logical replica setup	Euler Taveira	15:48
Re: speed up a logical replica setup	Euler Taveira	15:57
Re: Proposal to add page headers to SLRU pages 📎	Li, Yong	15:57
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)	vignesh C	16:05
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	16:06
Re: the s_lock_stuck on perform_spin_delay	Tom Lane	16:33
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	17:04
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	17:31
Re: add AVX2 support to simd.h	Nathan Bossart	17:48
Re: UUID v7 📎	Andrey M. Borodin	18:20
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Peter Eisentraut	18:58
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Andres Freund	19:24
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Andres Freund	20:03
Re: Confine vacuum skip logic to lazy_scan_skip	Andres Freund	20:23
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 📎	Tom Lane	21:02
Re: SET ROLE x NO RESET 📎	Jim Nasby	22:08
Re: Add new for_each macros for iterating over a List that do not require ListCell pointer	Nathan Bossart	22:17
Re: Adding facility for injection points (or probe points?) for more advanced tests	Nathan Bossart	22:24
Re: Adding facility for injection points (or probe points?) for more advanced tests	Nathan Bossart	22:31
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	22:37
Re: doing also VM cache snapshot and restore with pg_prewarm, having more information of the VM inside PostgreSQL 📎	Jim Nasby	22:41
Re: Hide exposed impl detail of wchar.c	Nathan Bossart	22:43
Re: UUID v7	Jelte Fennema-Nio	22:44
Re: the s_lock_stuck on perform_spin_delay	Andres Freund	22:54
Re: the s_lock_stuck on perform_spin_delay 📎	Jim Nasby	23:03
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	23:03
Re: the s_lock_stuck on perform_spin_delay	Andres Freund	23:06
Re: Confine vacuum skip logic to lazy_scan_skip 📎	Jim Nasby	23:25
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	23:38
Re: Improve rowcount estimate for UNNEST(column)	Tom Lane	23:45
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	23:48

Jan. 5, 2024

Thread	Author	Time
Re: Build versionless .so for Android 📎	Matthias Kuhn	00:00
Re: [17] CREATE SUBSCRIPTION ... SERVER 📎	Jeff Davis	00:56
Re: Improve WALRead() to suck data directly from WAL buffers when possible	Jeff Davis	01:50
Re: add AVX2 support to simd.h	John Naylor	02:03
Re: the s_lock_stuck on perform_spin_delay	Andy Fan	02:20
Re: the s_lock_stuck on perform_spin_delay	Andres Freund	02:21
Re: Synchronizing slots from primary to standby	shveta malik	03:29
RE: Documentation to upgrade logical replication cluster	Hayato Kuroda (Fujitsu)	03:38
Re: Random pg_upgrade test failure on drongo	Amit Kapila	04:19
Re: Synchronizing slots from primary to standby	Amit Kapila	04:30
Re: pg_upgrade test failure	vignesh C	04:49
Re: speed up a logical replica setup	Amit Kapila	04:53
Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]	Pavel Stehule	04:57
Re: speed up a logical replica setup	Amit Kapila	05:04
Re: SQL:2011 application time	jian he	05:06
Re: Documentation to upgrade logical replication cluster	Peter Smith	05:18
Re: Documentation to upgrade logical replication cluster	Peter Smith	05:25
Re: SET ROLE x NO RESET	Michał Kłeczek	06:10
Re: verify predefined LWLocks have entries in wait_event_names.txt 📎	Nathan Bossart	06:11
Re: verify predefined LWLocks have entries in wait_event_names.txt	Nathan Bossart	06:14
Re: speed up a logical replica setup	Shlok Kyal	06:49
Re: Adding facility for injection points (or probe points?) for more advanced tests	Ashutosh Bapat	07:11
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	07:18
Re: [17] CREATE SUBSCRIPTION ... SERVER	Ashutosh Bapat	07:19
Re: Adding facility for injection points (or probe points?) for more advanced tests	Ashutosh Bapat	07:25
Re: verify predefined LWLocks have entries in wait_event_names.txt	Bertrand Drouvot	07:39
Re: [17] CREATE SUBSCRIPTION ... SERVER	Jeff Davis	08:04
Re: Synchronizing slots from primary to standby	Bertrand Drouvot	08:15
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	jian he	08:37
Re: UUID v7	Przemysław Sztoch	08:52
Re: Adding facility for injection points (or probe points?) for more advanced tests	Dilip Kumar	09:30
Re: doing also VM cache snapshot and restore with pg_prewarm, having more information of the VM inside PostgreSQL	Cédric Villemain	09:32
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	10:06
Re: Make mesage at end-of-recovery less scary.	vignesh C	10:32
Re: Implement missing join selectivity estimation for range types	vignesh C	10:37
Re: [17] CREATE SUBSCRIPTION ... SERVER	Ashutosh Bapat	10:41
Re: generic plans and "initial" pruning	vignesh C	10:46
Re: Confine vacuum skip logic to lazy_scan_skip	Nazir Bilal Yavuz	10:51
Re: Change GUC hashtable to use simplehash? 📎	John Naylor	10:54
Re: Synchronizing slots from primary to standby	Dilip Kumar	10:55
Re: UUID v7	Sergey Prokhorenko	10:57
Re: Assorted typo fixes	Michael Paquier	11:13
Re: Change GUC hashtable to use simplehash?	jian he	11:58
Re: Synchronizing slots from primary to standby	Amit Kapila	12:15
Re: pg_upgrade --copy-file-range 📎	Jakub Wartak	12:40
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	13:51
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	13:59
cleanup patches for incremental backup 📎	Robert Haas	14:37
Re: Build versionless .so for Android	Robert Haas	14:44
Re: Build versionless .so for Android	Peter Eisentraut	14:57
Re: Build versionless .so for Android	Peter Eisentraut	15:00
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs 📎	Jelte Fennema-Nio	15:13
Re: POC: Extension for adding distributed tracing - pg_tracing	Nikita Malakhov	15:48
Re: Assertion failure in SnapBuildInitialSnapshot()	Robert Haas	15:57
Re: Adding facility for injection points (or probe points?) for more advanced tests	Nathan Bossart	16:27
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	16:28
Re: Adding facility for injection points (or probe points?) for more advanced tests	Nathan Bossart	16:28
Re: verify predefined LWLocks have entries in wait_event_names.txt	Nathan Bossart	16:42
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Tom Lane	16:53
Re: add AVX2 support to simd.h	Nathan Bossart	17:04
Re: Why is src/test/modules/committs/t/002_standby.pl flaky?	Robert Haas	17:04
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	17:08
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	17:20
Re: Stack overflow issue	Robert Haas	17:23
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	17:26
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Jelte Fennema-Nio	17:31
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Tom Lane	17:35
weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	17:38
Re: Implement missing join selectivity estimation for range types 📎	Schoemans Maxime	17:39
Re: Issue in postgres_fdw causing unnecessary wait for cancel request reply	Robert Haas	17:41
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs	Robert Haas	17:41
Re: verify predefined LWLocks have entries in wait_event_names.txt 📎	Nathan Bossart	17:46
Re: SET ROLE x NO RESET	Eric Hanson	17:48
Re: pg_get_indexdef() modification to use TxnSnapshot	Robert Haas	17:49
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG	Robert Haas	17:56
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	17:59
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG	Joe Conway	18:19
Re: psql not responding to SIGINT upon db reconnection	Robert Haas	18:24
Re: weird GROUPING SETS and ORDER BY behaviour	Zhang Mingli	18:34
Re: Oversight in reparameterize_path_by_child leading to executor crash	Robert Haas	18:36
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	18:47
Re: Oversight in reparameterize_path_by_child leading to executor crash	Tom Lane	18:55
Re: the s_lock_stuck on perform_spin_delay	Andres Freund	19:11
Re: Fix bogus Asserts in calc_non_nestloop_required_outer	Robert Haas	19:14
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	19:19
Re: the s_lock_stuck on perform_spin_delay	Andres Freund	19:27
Re: the s_lock_stuck on perform_spin_delay	Andres Freund	19:33
Re: Should the archiver process always make sure that the timeline history files exist in the archive?	Robert Haas	19:35
Re: Unlogged relation copy is not fsync'd	Robert Haas	19:40
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Andres Freund	19:47
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows	Robert Haas	19:58
Re: Add a perl function in Cluster.pm to generate WAL	Alexander Lakhin	20:00
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	20:02
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Andres Freund	20:05
Re: Stack overflow issue	Andres Freund	20:16
Re: Error "initial slot snapshot too large" in create replication slot	Robert Haas	20:17
Re: Stack overflow issue	Robert Haas	20:19
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	20:23
Re: Build versionless .so for Android 📎	Andres Freund	20:34
Re: Emit fewer vacuum records by reaping removable tuples during pruning 📎	Melanie Plageman	20:34
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Andres Freund	20:57
Re: Fix bogus Asserts in calc_non_nestloop_required_outer	Tom Lane	21:36
Re: Build versionless .so for Android	Andres Freund	21:46
Re: Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set 📎	Nathan Bossart	23:03
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	23:57

Jan. 6, 2024

Thread	Author	Time
Re: Multidimensional Histograms	Alexander Cheshev	00:00
Re: Fix bogus Asserts in calc_non_nestloop_required_outer	Robert Haas	00:03
Re: SQL:2011 application time 📎	Paul Jungwirth	00:19
Re: remaining sql/json patches	jian he	00:44
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	jian he	00:50
Re: Change GUC hashtable to use simplehash?	John Naylor	01:03
Re: Change GUC hashtable to use simplehash?	jian he	02:01
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Alexander Lakhin	09:00
Re: verify predefined LWLocks have entries in wait_event_names.txt	Bertrand Drouvot	09:03
Re: Multidimensional Histograms	Alexander Cheshev	09:08
Re: Exposing the lock manager's WaitForLockers() to SQL 📎	Will Mortensen	10:57
Re: Exposing the lock manager's WaitForLockers() to SQL	Laurenz Albe	12:00
Re: introduce dynamic shared memory registry	Bharath Rupireddy	14:04
Re: Shared detoast Datum proposal	vignesh C	15:12
Re: [PATCH] pgbench log file headers	vignesh C	15:20
Re: POC: Extension for adding distributed tracing - pg_tracing	vignesh C	15:30
Re: pg_stat_statements and "IN" conditions	vignesh C	15:34
Re: Emit fewer vacuum records by reaping removable tuples during pruning 📎	Melanie Plageman	15:34
Re: weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	15:38
Re: btree: downlink right separator/HIKEY optimization	vignesh C	15:39
Re: Bytea PL/Perl transform	vignesh C	15:51
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	16:03
Re: verify predefined LWLocks have entries in wait_event_names.txt 📎	Nathan Bossart	16:18
Re: weird GROUPING SETS and ORDER BY behaviour	David G. Johnston	16:22

Browse Archives

Prev | Next