pgsql-hackers since 2024-01-05 04:49

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. 5, 2024

Thread	Author	Time
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
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	16:34
Re: introduce dynamic shared memory registry 📎	Nathan Bossart	16:35
Re: weird GROUPING SETS and ORDER BY behaviour	Zhang Mingli	16:48
Re: Password leakage avoidance	Joe Conway	16:53
Re: weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	16:57
Re: abi-compliance-checker	vignesh C	17:25
Re: Unified File API	vignesh C	17:28
Re: Password leakage avoidance 📎	Joe Conway	17:39
Re: Password leakage avoidance	Sehrope Sarkuni	18:00
Re: Password leakage avoidance	Sehrope Sarkuni	18:16
Re: Password leakage avoidance	Sehrope Sarkuni	18:18
Re: Password leakage avoidance	Joe Conway	18:31
Re: weird GROUPING SETS and ORDER BY behaviour	Tom Lane	19:49
Re: Password leakage avoidance	Tom Lane	20:10
Re: Wrong results with grouping sets	Tom Lane	20:59
Re: Fix bogus Asserts in calc_non_nestloop_required_outer	Tom Lane	21:08
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500 📎	Tom Lane	22:41
Re: weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	23:27
Re: POC: Extension for adding distributed tracing - pg_tracing	Jelte Fennema-Nio	23:48
Re: Multidimensional Histograms	Tomas Vondra	23:54

Jan. 7, 2024

Thread	Author	Time
Re: Shared detoast Datum proposal 📎	Andy Fan	01:10
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	01:20
Re: Support prepared statement invalidation when result types change	vignesh C	06:55
Re: Support "Right Semi Join" plan shapes	vignesh C	07:03
Re: [PATCH] Support % wildcard in extension upgrade filenames	vignesh C	07:06
Re: the s_lock_stuck on perform_spin_delay 📎	Andy Fan	07:09
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	07:10
Re: Extract numeric filed in JSONB more effectively	Andy Fan	07:17
Re: Support prepared statement invalidation when result types change	Shay Rojansky	08:16
Re: Multidimensional Histograms	Andrei Lepikhov	10:22
Re: Multidimensional Histograms	Tomas Vondra	10:51
Re: warn if GUC set to an invalid shared library 📎	Justin Pryzby	13:27
Re: cannot abort transaction 2737414167, it was already committed	Justin Pryzby	13:49
Re: Add a perl function in Cluster.pm to generate WAL	Alexander Lakhin	14:00
Re: Multidimensional Histograms	Andrei Lepikhov	17:26
Re: Multidimensional Histograms	Tomas Vondra	18:36
Re: Password leakage avoidance 📎	Joe Conway	18:51
Re: Multidimensional Histograms	Alexander Cheshev	22:55
Re: Multidimensional Histograms	Tomas Vondra	23:29
Re: Multidimensional Histograms	Alexander Cheshev	23:49

Jan. 8, 2024

Thread	Author	Time
Re: Extract numeric filed in JSONB more effectively 📎	jian he	00:00
Re: remaining sql/json patches	jian he	00:00
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	00:16
Re: add function argument names to regex* functions.	Dian Fay	00:44
Re: the s_lock_stuck on perform_spin_delay	Andy Fan	02:41
Re: Change GUC hashtable to use simplehash?	John Naylor	02:43
Re: Multidimensional Histograms	Andrei Lepikhov	03:12
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Amul Sul	03:38
Re: Forbid the use of invalidated physical slots in streaming replication.	vignesh C	04:55
Re: proposal: psql: show current user in prompt	vignesh C	05:08
Re: introduce dynamic shared memory registry	Bharath Rupireddy	05:23
Re: Adding a pg_get_owned_sequence function?	vignesh C	05:24
Re: speed up a logical replica setup	Amit Kapila	05:29
Re: introduce dynamic shared memory registry	Amul Sul	05:43
alter table add x wrong error position	jian he	05:59
Re: psql not responding to SIGINT upon db reconnection 📎	Tristan Partin	06:03
Re: Synchronizing slots from primary to standby	Dilip Kumar	06:09
Re: alter table add x wrong error position	David G. Johnston	06:17
Commitfest 2024-01 first week update	vignesh C	06:22
Re: More new SQL/JSON item methods	Jeevan Chalke	07:00
Re: add AVX2 support to simd.h	John Naylor	07:01
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	07:05
Re: Documentation to upgrade logical replication cluster	Bharath Rupireddy	07:21
Re: Change GUC hashtable to use simplehash?	Junwang Zhao	07:24
Escape output of pg_amcheck test 📎	Peter Eisentraut	07:27
Re: Add a perl function in Cluster.pm to generate WAL	Bertrand Drouvot	07:34
Re: verify predefined LWLocks have entries in wait_event_names.txt	Bertrand Drouvot	07:59
Changing a schema's name with function1 calling function2	Wilma Wantren	08:05
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Richard Guo	08:32
Re: add AVX2 support to simd.h	John Naylor	09:03
Change comments of removing useless joins. 📎	ywgrit	09:11
Re: Multidimensional Histograms	Alexander Cheshev	09:21
Re: Change GUC hashtable to use simplehash?	John Naylor	09:43
Re: Shared detoast Datum proposal 📎	Andy Fan	09:52
Re: weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	10:23
Re: weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	11:12
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Richard Guo	11:14
Re: postgres_fdw fails to see that array type belongs to extension 📎	David Geier	11:21
Re: brininsert optimization opportunity	Alvaro Herrera	11:23
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Alvaro Herrera	11:25
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	11:35

Browse Archives

Prev | Next