pgsql-hackers since 2023-12-26 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

Dec. 26, 2023

Thread	Author	Time
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	00:06
Re: pread, pwrite, etc return ssize_t not int	Thomas Munro	00:23
Re: Statistics Import and Export	Tomas Vondra	01:18
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	03:14
Re: Avoid computing ORDER BY junk columns unnecessarily	Richard Guo	03:18
Re: Some performance degradation in REL_16 vs REL_15 📎	Anton A. Melnikov	04:38
Re: Optimization outcome depends on the index order	Andrei Lepikhov	04:53
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	05:42
Re: Change GUC hashtable to use simplehash? 📎	John Naylor	08:00
Re: "pgoutput" options missing on documentation	Amit Kapila	08:06
Re: Track in pg_replication_slots the reason why slots conflict?	Michael Paquier	08:23
Re: Show WAL write and fsync stats in pg_stat_io	Nazir Bilal Yavuz	08:27
Re: Synchronizing slots from primary to standby	shveta malik	08:29
Re: Synchronizing slots from primary to standby	Amit Kapila	08:49
Re: Track in pg_replication_slots the reason why slots conflict?	Bertrand Drouvot	08:50
Re: planner chooses incremental but not the best one	ywgrit	09:25
RE: Synchronizing slots from primary to standby	Hayato Kuroda (Fujitsu)	09:30
Specify description of the SpecialJoinInfo structure 📎	Andrei Lepikhov	09:37
Re: pg_basebackup has an accidentaly separated help message	Michael Paquier	10:04
Re: Synchronizing slots from primary to standby	Amit Kapila	10:05
Re: Tab complete for CREATE SUBSCRIPTION ... CONECTION does not work	Shubham Khanna	10:10
Re: Show WAL write and fsync stats in pg_stat_io	Michael Paquier	10:10
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎	Anton A. Melnikov	10:49
RE: Synchronizing slots from primary to standby 📎	Zhijie Hou (Fujitsu)	11:09
An improvement on parallel DISTINCT 📎	Richard Guo	11:23
Re: POC: GROUP BY optimization	Andrei Lepikhov	11:37
Re: Intermittent failure with t/003_logical_slots.pl test on windows 📎	Shlok Kyal	12:09
Re: No LINGUAS file yet for pg_combinebackup	Michael Paquier	12:18
Re: Synchronizing slots from primary to standby	shveta malik	12:27
Re: Show WAL write and fsync stats in pg_stat_io	Nazir Bilal Yavuz	12:35
Re: Track in pg_replication_slots the reason why slots conflict?	Isaac Morland	14:05
Update docs for default value of fdw_tuple_cost 📎	Umair Shahid	15:29
Re: A tiny improvement of psql	Tom Lane	16:36
WIP Incremental JSON Parser 📎	Andrew Dunstan	16:48
Re: Add the ability to limit the amount of memory that can be allocated to backends.	Tomas Vondra	17:28
Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c) 📎	Ranier Vilela	18:10
Re: Statistics Import and Export	Bruce Momjian	18:15
Re: Moving forward with TDE	Bruce Momjian	18:55
Two small bugs in guc.c 📎	Tom Lane	19:02
Re: Statistics Import and Export	Tom Lane	19:19
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) 📎	Alexander Korotkov	19:35
Re: [meson] expose buildtype debug/optimization info to pg_config	Peter Eisentraut	19:58
Re: No LINGUAS file yet for pg_combinebackup	Peter Eisentraut	20:38
Re: pg_stat_statements: more test coverage	Peter Eisentraut	21:03
Re: A tiny improvement of psql	Vik Fearing	21:45
Re: Add the ability to limit the amount of memory that can be allocated to backends. 📎	Tomas Vondra	21:52
Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c)	Tomas Vondra	22:07
Re: A tiny improvement of psql	Jelte Fennema-Nio	23:33

Dec. 27, 2023

Thread	Author	Time
Multidimensional Histograms	Alexander Cheshev	00:13
Re: Update docs for default value of fdw_tuple_cost	Richard Guo	00:48
Re: [HACKERS] Changing references of password encryption to hashing 📎	Bruce Momjian	01:04
Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)'	Alexander Korotkov	02:00
Re: POC: GROUP BY optimization	Alexander Korotkov	02:48
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	03:07
Re: POC: GROUP BY optimization	Tom Lane	03:23
Re: POC: GROUP BY optimization	Alexander Korotkov	04:15
Re: POC: GROUP BY optimization	Tom Lane	04:27
Re: POC: GROUP BY optimization	Andrei Lepikhov	04:35
[PATCH] pg_dump: Do not dump statistics for excluded tables 📎	Rian McGuire	04:44
Re: POC: GROUP BY optimization	Tom Lane	05:07
Re: Synchronizing slots from primary to standby	Masahiko Sawada	06:06
Re: Tab complete for CREATE SUBSCRIPTION ... CONECTION does not work	Japin Li	06:31
Re: A typo in a messsage?	John Naylor	06:34
Re: Should "CRC" be in uppercase?	John Naylor	06:35
Re: A tiny improvement of psql	Deepak M	06:35
Re: A tiny improvement of psql	Kirk Wolak	07:00
Re: Intermittent failure with t/003_logical_slots.pl test on windows	Nisha Moond	07:35
Re: pg_stat_statements: more test coverage	Julien Rouhaud	08:08
Revise the Asserts added to bimapset manipulation functions 📎	Richard Guo	09:30
Re: Track in pg_replication_slots the reason why slots conflict? 📎	shveta malik	09:38
PostgreSQL 16.1 dict_snowball.so: undefined symbol: CurrentMemoryContext	Vitalijus Jefišovas	09:44
Re: Function to get invalidation cause of a replication slot.	shveta malik	09:44
Re: Synchronizing slots from primary to standby	shveta malik	10:13
Re: Synchronizing slots from primary to standby	Amit Kapila	10:42
Shared detoast Datum proposal 📎	Andy Fan	10:45
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	10:46
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)	Pavel Borisov	11:18
Re: Removing const-false IS NULL quals and redundant IS NOT NULL quals	Andy Fan	11:20
Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c)	Ranier Vilela	11:37
Should we remove -Wdeclaration-after-statement?	Jelte Fennema-Nio	11:48
Failed assertion in joininfo.c, remove_join_clause_from_rels	Andreas Seltenreich	11:54
Re: Removing const-false IS NULL quals and redundant IS NOT NULL quals	Richard Guo	11:58
Re: Failed assertion in joininfo.c, remove_join_clause_from_rels	Alexander Korotkov	12:00
Re: Failed assertion in joininfo.c, remove_join_clause_from_rels	Richard Guo	12:03
Re: Statistics Import and Export	Tomas Vondra	12:08
Re: Failed assertion in joininfo.c, remove_join_clause_from_rels	Alexander Korotkov	12:21
Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)	Alexander Korotkov	12:36
Re: Add support for __attribute__((returns_nonnull))	Peter Eisentraut	12:42
Re: pg_stat_statements: more test coverage 📎	Peter Eisentraut	12:53
Re: pg_upgrade failing for 200+ million Large Objects 📎	Robins Tharakan	13:28
Re: trying again to get incremental backup	Robert Haas	14:11
cannot abort transaction 2737414167, it was already committed	Justin Pryzby	15:02
Re: Should we remove -Wdeclaration-after-statement?	Tom Lane	15:05
Re: pg_upgrade failing for 200+ million Large Objects	Tom Lane	15:18
Re: Statistics Import and Export	Bruce Momjian	15:29
Re: trying again to get incremental backup	Nathan Bossart	15:36
change regexp_substr first argument make tests more easier to understand.	jian he	16:13
[PATCH] Exponential backoff for auth_delay 📎	Michael Banck	16:19
Re: Emit fewer vacuum records by reaping removable tuples during pruning	Melanie Plageman	16:26
postgres_fdw fails to see that array type belongs to extension	David Geier	16:43
add function argument names to regex* functions. 📎	jian he	16:53
Re: [PATCH] pg_dump: Do not dump statistics for excluded tables 📎	Tom Lane	17:01
Re: postgres_fdw fails to see that array type belongs to extension	Tom Lane	17:38
Re: Should we remove -Wdeclaration-after-statement?	Jelte Fennema-Nio	17:59
Re: Add support for __attribute__((returns_nonnull)) 📎	Tristan Partin	18:20
Re: Two small bugs in guc.c	Tristan Partin	18:26
Re: introduce dynamic shared memory registry 📎	Nathan Bossart	19:53
Re: Password leakage avoidance	Peter Eisentraut	20:39
Re: Password leakage avoidance	Joe Conway	20:53
Re: Password leakage avoidance	Tom Lane	21:09
Re: Password leakage avoidance	Dave Cramer	21:11
Re: Multidimensional Histograms	Tomas Vondra	21:19
Re: Password leakage avoidance	Joe Conway	21:26
Re: Password leakage avoidance	Jonathan S. Katz	21:31
Assorted typo fixes 📎	Dagfinn Ilmari Mannsåker	21:51
Re: [HACKERS] Changing references of password encryption to hashing	Peter Eisentraut	21:52
Add LSN <-> time conversion functionality 📎	Melanie Plageman	22:16
Re: add function argument names to regex* functions.	Peter Eisentraut	22:25
Re: cannot abort transaction 2737414167, it was already committed	Thomas Munro	22:33
Re: cannot abort transaction 2737414167, it was already committed	Tom Lane	22:42
Re: cannot abort transaction 2737414167, it was already committed	Justin Pryzby	22:55

Dec. 28, 2023

Thread	Author	Time
Re: Built-in CTYPE provider 📎	Jeff Davis	01:26
Re: Statistics Import and Export	Corey Huinker	02:41
Re: Statistics Import and Export	Corey Huinker	02:44
Re: Statistics Import and Export	Corey Huinker	02:49
Re: Support "Right Semi Join" plan shapes	wenhui qiu	03:02
RE: Random pg_upgrade test failure on drongo	Hayato Kuroda (Fujitsu)	03:08
Re: Statistics Import and Export	Tom Lane	03:10
Re: Statistics Import and Export	Bruce Momjian	03:11
Re: add function argument names to regex* functions.	jian he	03:28
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	jian he	03:57
Re: Track in pg_replication_slots the reason why slots conflict?	shveta malik	04:46
Re: doc patch: note AttributeRelationId passed to FDW validator function	Ian Lawrence Barwick	04:55
Re: warn if GUC set to an invalid shared library	Shubham Khanna	05:26
Re: doc patch: note AttributeRelationId passed to FDW validator function	Michael Paquier	06:37
Re: change regexp_substr first argument make tests more easier to understand. 📎	jian he	07:17
Re: Functions to return random numbers in a given range	jian he	07:34
Re: Intermittent failure with t/003_logical_slots.pl test on windows 📎	Shlok Kyal	07:55
Pdadmin open on Macbook issue	Anita	08:12
Re: POC: GROUP BY optimization 📎	Andrei Lepikhov	08:22
Re: Track in pg_replication_slots the reason why slots conflict? 📎	shveta malik	09:28
Re: Revise the Asserts added to bimapset manipulation functions	David Rowley	10:21
Re: pg_upgrade and logical replication 📎	Amit Kapila	10:29
Re: Some revises in adding sorting path	Shubham Khanna	10:31
Re: Synchronizing slots from primary to standby 📎	shveta malik	10:33
Re: Some revises in adding sorting path	Shubham Khanna	11:07
Re: Set log_lock_waits=on by default	Shinya Kato	11:28
Re: POC: GROUP BY optimization	Alexander Korotkov	11:29
Re: pg_upgrade failing for 200+ million Large Objects 📎	Robins Tharakan	11:38
Re: Switching XLog source from archive to streaming when primary available 📎	Bharath Rupireddy	11:56
Re: doc patch: note AttributeRelationId passed to FDW validator function	Ian Lawrence Barwick	12:46
Tidy fill hstv array (src/backend/access/heap/pruneheap.c) 📎	Ranier Vilela	12:57
Re: Multidimensional Histograms	Tomas Vondra	14:24
Re: broken master regress tests	Alexander Lakhin	15:00
Re: introduce dynamic shared memory registry 📎	Nathan Bossart	15:34
Re: Transaction timeout	Junwang Zhao	16:02
Re: Statistics Import and Export	Corey Huinker	17:28
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 📎	Peter Geoghegan	17:28
Re: broken master regress tests	Jeff Davis	17:36
Re: Statistics Import and Export	Bruce Momjian	17:37
Windows sockets (select missing events?) 📎	Ranier Vilela	17:45
Re: broken master regress tests 📎	Alexander Lakhin	19:00
The segmentation fault of Postgresql 9.6.24	Kevin Wang	20:09
Re: Pdadmin open on Macbook issue	Bruce Momjian	22:07
Re: The segmentation fault of Postgresql 9.6.24	Tomas Vondra	22:20
Re: The segmentation fault of Postgresql 9.6.24	Bruce Momjian	22:40
Re: Avoid computing ORDER BY junk columns unnecessarily	Tom Lane	23:42
Re: Statistics Import and Export	Tomas Vondra	23:55

Dec. 29, 2023

Thread	Author	Time
Re: Revise the Asserts added to bimapset manipulation functions 📎	David Rowley	01:15
Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c) 📎	Tomas Vondra	01:16
Re: Removing const-false IS NULL quals and redundant IS NOT NULL quals	Andy Fan	01:25
Re: Synchronizing slots from primary to standby	Masahiko Sawada	01:29
Re: Synchronizing slots from primary to standby	Masahiko Sawada	01:47
Re: Built-in CTYPE provider 📎	Jeff Davis	02:57
Re: POC: GROUP BY optimization	Andrei Lepikhov	03:23
Re: Track in pg_replication_slots the reason why slots conflict?	Amit Kapila	03:50
Re: Synchronizing slots from primary to standby	Amit Kapila	04:55
Re: Removing unneeded self joins	Alexander Lakhin	05:00
Re: Pdadmin open on Macbook issue	Maciek Sakrejda	05:02
Re: pg_stat_statements: more test coverage	Julien Rouhaud	05:14
Re: Synchronizing slots from primary to standby	Amit Kapila	07:02
autoprewarm main function not tested background worker not listed in pg_stat_activity	jian he	07:21
Re: Revise the Asserts added to bimapset manipulation functions	Richard Guo	08:06
Re: pg_upgrade and logical replication	vignesh C	08:56
Commitfest 2024-01 starting in 3 days!	vignesh C	09:11
Re: Revise the Asserts added to bimapset manipulation functions	David Rowley	09:22
Re: Removing unneeded self joins 📎	Andrei Lepikhov	09:58
Re: Transaction timeout 📎	Andrey M. Borodin	10:00
Re: libpq compression (part 3)	Andrey M. Borodin	10:02
Re: Track in pg_replication_slots the reason why slots conflict?	Michael Paquier	10:05
Re: Revise the Asserts added to bimapset manipulation functions	Richard Guo	10:38
Re: Removing unneeded self joins	Alexander Lakhin	11:00
Re: Transaction timeout 📎	Junwang Zhao	11:00
Re: Transaction timeout	Andrey M. Borodin	11:15
Re: Add PQsendSyncMessage() to libpq	Jelte Fennema-Nio	11:49
Re: Add PQsendSyncMessage() to libpq	Jelte Fennema-Nio	11:52
Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c) 📎	Ranier Vilela	11:53
Next step towards 64bit XIDs: Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid 📎	Maxim Orlov	12:48
Add Index-level REINDEX with multiple jobs 📎	Maxim Orlov	13:15
Re: Fix Brin Private Spool Initialization (src/backend/access/brin/brin.c)	Tomas Vondra	13:33

Browse Archives

Prev | Next