pgsql-hackers since 2024-01-06 09: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, 2024

Thread	Author	Time
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
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
Re: Make psql ignore trailing semicolons in \sf, \ef, etc	Tom Lane	00:08
Re: Add support for __attribute__((returns_nonnull))	Michael Paquier	00:14
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows	Michael Paquier	00:40
Re: add function argument names to regex* functions.	Dian Fay	00:51
Re: Adding facility for injection points (or probe points?) for more advanced tests	Michael Paquier	01:09
Re: Synchronizing slots from primary to standby	Peter Smith	01:17
Re: Built-in CTYPE provider	Jeremy Schneider	01:17
Re: the s_lock_stuck on perform_spin_delay	Andy Fan	02:01
Re: add AVX2 support to simd.h	John Naylor	02:20
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎	Masahiko Sawada	02:40
Re: Random pg_upgrade test failure on drongo	Amit Kapila	03:05
Re: introduce dynamic shared memory registry	Amul Sul	03:59
Re: Removing unneeded self joins	Alexander Lakhin	04:00
Re: Adding facility for injection points (or probe points?) for more advanced tests 📎	Michael Paquier	04:39
Re: verify predefined LWLocks have entries in wait_event_names.txt	Bertrand Drouvot	04:55
Re: Add a perl function in Cluster.pm to generate WAL	Michael Paquier	04:59
Re: speed up a logical replica setup	Amit Kapila	05:19
Re: Commitfest 2024-01 first week update	vignesh C	05:24
Re: verify predefined LWLocks have entries in wait_event_names.txt	Michael Paquier	05:26
Re: Add a perl function in Cluster.pm to generate WAL 📎	Bertrand Drouvot	05:29
Re: SQL:2011 application time	jian he	05:33
RE: Random pg_upgrade test failure on drongo 📎	Hayato Kuroda (Fujitsu)	05:49
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Michael Paquier	05:56
Re: Removing unneeded self joins	Alexander Korotkov	06:08
Re: Speed up transaction completion faster after many relations are accessed in a transaction	vignesh C	06:24
Re: Skipping schema changes in publication	vignesh C	06:32
Re: SQL:2011 application time	vignesh C	06:46
Re: Relation bulk write facility	vignesh C	06:50
RE: speed up a logical replica setup	Hayato Kuroda (Fujitsu)	07:01
Re: Parallelize correlated subqueries that execute within each worker	vignesh C	07:08
Re: INFORMATION_SCHEMA note	Daniel Gustafsson	07:26
Re: Make psql ignore trailing semicolons in \sf, \ef, etc	Laurenz Albe	07:27
pg_dump: Remove obsolete trigger support 📎	Peter Eisentraut	07:38
Re: Removing unneeded self joins	Alexander Korotkov	08:03
Re: Exposing the lock manager's WaitForLockers() to SQL	Will Mortensen	08:18
Re: psql JSON output format	Laurenz Albe	08:22
Re: Reducing output size of nodeToString	Peter Eisentraut	08:23
Re: Custom explain options	vignesh C	08:33
Re: [HACKERS] make async slave to wait for lsn to be replayed	vignesh C	08:40
Re: Random pg_upgrade test failure on drongo	Alexander Lakhin	09:00
Re: Add BF member koel-like indentation checks to SanityCheck CI	John Naylor	09:00
Re: POC: GROUP BY optimization 📎	Andrei Lepikhov	09:01
Re: collect_corrupt_items_vacuum.patch 📎	Alexander Korotkov	09:17
Re: speed up a logical replica setup	Amit Kapila	09:25
Re: Tidy fill hstv array (src/backend/access/heap/pruneheap.c)	John Naylor	09:31
Re: In-placre persistance change of a relation	vignesh C	09:37
Re: psql JSON output format	Christoph Berg	09:43
Re: POC: GROUP BY optimization	vignesh C	09:45
Re: Random pg_upgrade test failure on drongo	Amit Kapila	10:08
Re: [HACKERS] Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING	vignesh C	10:21
Re: brininsert optimization opportunity 📎	Alvaro Herrera	10:43
Re: Support "Right Semi Join" plan shapes 📎	Richard Guo	10:48
Re: Random pg_upgrade test failure on drongo	Alexander Lakhin	11:00
Re: POC: GROUP BY optimization 📎	Andrei Lepikhov	11:07
Re: INFORMATION_SCHEMA note	Tatsuo Ishii	11:08
Re: POC: GROUP BY optimization	Pavel Borisov	11:14

Browse Archives

Prev | Next