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

Thread	Author	Time
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: remaining sql/json patches	jian he	00:00
Re: Extract numeric filed in JSONB more effectively 📎	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
Re: weird GROUPING SETS and ORDER BY behaviour	Geoff Winkless	11:53
Re: Escape output of pg_amcheck test	Aleksander Alekseev	12:45
Re: INFORMATION_SCHEMA note	Daniel Gustafsson	12:48
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Dilip Kumar	13:18
Re: Escape output of pg_amcheck test	Mark Dilger	13:41
Re: Escape output of pg_amcheck test	Mark Dilger	13:52
Re: weird GROUPING SETS and ORDER BY behaviour	David G. Johnston	14:01
Re: Escape output of pg_amcheck test	Aleksander Alekseev	14:04
Re: add function argument names to regex* functions.	jian he	14:26
Re: SQL:2011 application time	jian he	14:54
INSERT performance: less CPU when no indexes or triggers	Adam S	14:54
Re: Escape output of pg_amcheck test	Peter Eisentraut	15:06
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock	Alvaro Herrera	15:42
Re: brininsert optimization opportunity	Alvaro Herrera	15:51
Re: Random pg_upgrade test failure on drongo	Jim Nasby	16:06
Re: pg_stat_statements and "IN" conditions	Dmitry Dolgov	16:10
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Tom Lane	16:51
Re: Adding a pg_get_owned_sequence function? 📎	Dagfinn Ilmari Mannsåker	16:58
Re: Add a perl function in Cluster.pm to generate WAL 📎	Alexander Lakhin	17:00
Re: introduce dynamic shared memory registry	Nathan Bossart	17:16
Re: introduce dynamic shared memory registry	Nathan Bossart	17:18
Re: Commitfest 2024-01 first week update	Jelte Fennema-Nio	17:19
Re: Fix bogus Asserts in calc_non_nestloop_required_outer	Robert Haas	17:25
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Peter Geoghegan	17:27
Re: add AVX2 support to simd.h	Nathan Bossart	17:37
Re: psql JSON output format	Dean Rasheed	18:43
Re: SQL:2011 application time	Paul Jungwirth	18:54
Re: Emitting JSON to file using COPY TO	Dean Rasheed	19:36
Re: the s_lock_stuck on perform_spin_delay	Robert Haas	19:57
Re: Removing unneeded self joins	Alexander Lakhin	20:00
Re: printing raw parse tree	Rafsun Masud	20:06
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	20:10
Re: verify predefined LWLocks have entries in wait_event_names.txt 📎	Nathan Bossart	20:11
Re: Removing unneeded self joins	Alexander Korotkov	20:20
Re: Emitting JSON to file using COPY TO	Joe Conway	20:40
Make psql ignore trailing semicolons in \sf, \ef, etc 📎	Tom Lane	20:48
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Robert Haas	20:50
Re: Adding a pg_get_owned_sequence function?	Nathan Bossart	21:08
Re: verify predefined LWLocks have entries in wait_event_names.txt 📎	Nathan Bossart	22:02
Re: Removing unneeded self joins	Alexander Korotkov	22:09
Re: Fix bogus Asserts in calc_non_nestloop_required_outer 📎	Tom Lane	22:39
Re: Add new protocol message to change GUCs for usage with future protocol-only GUCs 📎	Jelte Fennema-Nio	22:51
Re: Add support for __attribute__((returns_nonnull))	Tristan Partin	23:04
Re: Make psql ignore trailing semicolons in \sf, \ef, etc	Tristan Partin	23:31
Re: INFORMATION_SCHEMA note 📎	Tatsuo Ishii	23:54

Jan. 9, 2024

Thread	Author	Time
Re: SQL:2011 application time 📎	jian he	00:00

Browse Archives

Prev | Next