pgsql-hackers since 2023-09-01 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

Sept. 1, 2023

Thread	Author	Time
Re: More new SQL/JSON item methods	Vik Fearing	00:50
Re: sandboxing untrusted code	Jeff Davis	00:57
Re: Show inline comments from pg_hba lines in the pg_hba_file_rules view	Michael Paquier	01:18
Re: Eliminate redundant tuple visibility check in vacuum	Peter Geoghegan	01:25
Re: should frontend tools use syncfs() ?	Michael Paquier	01:40
Re: More new SQL/JSON item methods	Chapman Flack	01:41
Re: should frontend tools use syncfs() ? 📎	Nathan Bossart	02:17
Re: Should we use MemSet or {0} for struct initialization?	Richard Guo	03:03
Re: Extract numeric filed in JSONB more effectively 📎	Andy Fan	03:09
Re: SQL:2011 application time	Corey Huinker	04:02
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	04:17
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	04:36
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	04:46
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	04:47
Re: remaining sql/json patches 📎	Amit Langote	04:52
Re: pg_upgrade fails with in-place tablespace[	Michael Paquier	04:58
Re: persist logical slots to disk during shutdown checkpoint 📎	vignesh C	05:20
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	05:30
Buildfarm failures on urocryon	vignesh C	05:57
Re: Improve heapgetpage() performance, overhead from serializable	tender wang	06:07
Re: [17] CREATE SUBSCRIPTION ... SERVER	Ashutosh Bapat	06:58
Assert failure in ATPrepAddPrimaryKey	Richard Guo	07:13
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	07:21
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	07:41
Re: Incremental View Maintenance, take 2 📎	jian he	07:42
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	07:49
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Alexander Lakhin	08:00
Move bki file pre-processing from initdb to bootstrap 📎	Krishnakumar R	08:01
PATCH: document for regression test forgets libpq test 📎	Ryo Matsumura (Fujitsu)	08:01
Re: Synchronizing slots from primary to standby	Peter Smith	08:29
Re: Eliminate redundant tuple visibility check in vacuum	David Geier	08:47
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	09:15
Re: PATCH: Add REINDEX tag to event triggers 📎	jian he	09:23
Re: SQL:2011 application time	Peter Eisentraut	09:30
Re: Show inline comments from pg_hba lines in the pg_hba_file_rules view	Jim Jones	09:32
Fix a typo in decode.c 📎	Zhijie Hou (Fujitsu)	09:36
Re: PATCH: Add REINDEX tag to event triggers	Jim Jones	10:40
Re: Show inline comments from pg_hba lines in the pg_hba_file_rules view	Michael Paquier	10:44
Re: SQL:2011 application time	Vik Fearing	10:50
Re: Show inline comments from pg_hba lines in the pg_hba_file_rules view	Jim Jones	11:16
Re: generate syscache info automatically 📎	John Naylor	11:31
Re: Assert failure in ATPrepAddPrimaryKey 📎	Alvaro Herrera	11:48
Re: Move bki file pre-processing from initdb to bootstrap	Tom Lane	12:37
Re: Should we use MemSet or {0} for struct initialization?	Jelte Fennema	12:47
Re: Unlogged relations and WAL-logging	Peter Eisentraut	12:49
Re: Commitfest 2023-09 starts soon	Peter Eisentraut	12:55
Re: Move bki file pre-processing from initdb to bootstrap	Peter Eisentraut	12:59
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) 📎	Tomas Vondra	13:00
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	13:04
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:05
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:06
Re: sandboxing untrusted code	Robert Haas	13:12
Re: Fix a typo in decode.c	Amit Kapila	13:16
Re: Should we use MemSet or {0} for struct initialization?	John Naylor	13:25
Re: Should we use MemSet or {0} for struct initialization?	Chapman Flack	14:03
Re: Should we use MemSet or {0} for struct initialization?	Jelte Fennema	14:04
Re: trying again to get incremental backup	Robert Haas	14:30
Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c) 📎	Ranier Vilela	14:38
Re: Buildfarm failures on urocryon	Mark Wong	14:50
Re: Initdb-time block size specification	Robert Haas	14:57
Add const qualifiers 📎	David Steele	15:39
Re: PATCH: Add REINDEX tag to event triggers 📎	jian he	16:10
Casual Meson fixups 📎	Tristan Partin	16:31
Is there a complete doc to describe pg's traction implementation in detail?	jacktby jacktby	16:41
Re: Adding a pg_get_owned_sequence function?	Nathan Bossart	16:42
Re: Fwd: BUG #18016: REINDEX TABLE failure	Nathan Bossart	16:55
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	17:05
GenBKI emits useless open;close for catalogs without rows 📎	Matthias van de Meent	17:26
Re: Adding a pg_get_owned_sequence function?	Tom Lane	17:31
Re: Inefficiency in parallel pg_restore with many tables	Tom Lane	17:41
Re: GenBKI emits useless open;close for catalogs without rows	Alvaro Herrera	17:43
Re: GenBKI emits useless open;close for catalogs without rows	Matthias van de Meent	17:50
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	17:51
Re: GenBKI emits useless open;close for catalogs without rows	Tom Lane	17:52
Re: Adding a pg_get_owned_sequence function?	Nathan Bossart	17:55
Re: cataloguing NOT NULL constraints	Alvaro Herrera	17:55
Re: should frontend tools use syncfs() ?	Justin Pryzby	17:58
Re: should frontend tools use syncfs() ?	Nathan Bossart	18:08
Re: should frontend tools use syncfs() ?	Justin Pryzby	18:19
Re: should frontend tools use syncfs() ?	Nathan Bossart	18:31
Re: Replace known_assigned_xids_lck by memory barrier	Nathan Bossart	18:40
Re: [17] CREATE SUBSCRIPTION ... SERVER	Jeff Davis	18:54
Re: [17] CREATE SUBSCRIPTION ... SERVER	Jeff Davis	18:57
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Alexander Lakhin	19:00
Speaker Bureau	Dave Cramer	19:00
Re: Eager page freeze criteria clarification	Robert Haas	19:34
Why doesn't Vacuum FULL update the VM	Melanie Plageman	19:34
Re: Add 'worker_type' to pg_stat_subscription	Nathan Bossart	19:41
Re: Replace known_assigned_xids_lck by memory barrier	Robert Haas	19:53
Re: SQL:2011 application time	Paul Jungwirth	19:56
Re: Inefficiency in parallel pg_restore with many tables	Robert Haas	20:00
Re: [17] CREATE SUBSCRIPTION ... SERVER	Robert Haas	20:11
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Robert Haas	20:16
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Robert Haas	20:21
Re: Transaction timeout	Peter Eisentraut	20:23
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	20:52
Re: sandboxing untrusted code	Jeff Davis	21:27
Re: Why doesn't Vacuum FULL update the VM	Vik Fearing	21:48
Re: SQL:2011 application time	Vik Fearing	22:41

Sept. 2, 2023

Thread	Author	Time
Re: Why doesn't Vacuum FULL update the VM	Peter Geoghegan	00:38
Re: Eager page freeze criteria clarification	Peter Geoghegan	01:07
Re: Extract numeric filed in JSONB more effectively	jian he	01:25
Impact of checkpointer during pg_upgrade	Amit Kapila	04:38
Re: Row pattern recognition 📎	Tatsuo Ishii	06:52
Re: generate syscache info automatically 📎	John Naylor	10:37
Re: Incremental View Maintenance, take 2	Tatsuo Ishii	11:46
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Ranier Vilela	12:13
Re: Impact of checkpointer during pg_upgrade	Dilip Kumar	12:42
Re: Add tracking of backend memory allocated to pg_stat_activity	Ted Yu	15:13
Re: Row pattern recognition	Erik Rijkers	18:04
Re: Query execution in Perl TAP tests needs work 📎	Andrew Dunstan	18:42
Re: Inefficiency in parallel pg_restore with many tables 📎	Nathan Bossart	18:55
Re: Initdb-time block size specification	Tomas Vondra	19:09
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Alexander Lakhin	21:00
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Thomas Munro	23:06

Sept. 3, 2023

Thread	Author	Time
Re: Row pattern recognition	Tatsuo Ishii	00:03
Re: Query execution in Perl TAP tests needs work	Thomas Munro	00:17
add (void) cast inside advance_aggregates for function ExecEvalExprSwitchContext	jian he	03:16
Re: Testing autovacuum wraparound (including failsafe)	Noah Misch	05:48
Re: proposal: psql: show current user in prompt	Pavel Stehule	06:23
Re: proposal: psql: show current user in prompt	Jelte Fennema	07:59
Re: Inefficiency in parallel pg_restore with many tables	Alvaro Herrera	10:04
Re: Buildfarm failures on urocryon	vignesh C	13:48
Re: Inefficiency in parallel pg_restore with many tables	Nathan Bossart	15:11
Re: proposal: psql: show current user in prompt 📎	Pavel Stehule	18:58
Re: Why doesn't Vacuum FULL update the VM 📎	Melanie Plageman	20:48

Sept. 4, 2023

Thread	Author	Time
Re: Cleaning up array_in() 📎	jian he	00:00
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Michael Paquier	01:01
Re: Assert failure in ATPrepAddPrimaryKey	Richard Guo	03:05
Re: Impact of checkpointer during pg_upgrade	Amit Kapila	03:10
REL_15_STABLE: pgbench tests randomly failing on CI, Windows only	Thomas Munro	03:18
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	04:03
Re: Impact of checkpointer during pg_upgrade	Dilip Kumar	05:03
Optimize planner memory consumption for huge arrays 📎	Lepikhov Andrei	05:25
Re: Impact of checkpointer during pg_upgrade	Amit Kapila	05:48
Re: Exposing the lock manager's WaitForLockers() to SQL	Will Mortensen	06:16
Re: pg_upgrade and logical replication	Amit Kapila	06:21
Re: pg_upgrade and logical replication	Amit Kapila	06:26
Re: pg_upgrade and logical replication	Michael Paquier	06:44
Re: pg_upgrade and logical replication	Amit Kapila	06:49
Re: Missing free_var() at end of accum_sum_final()?	Peter Eisentraut	06:55
Re: Unlogged relation copy is not fsync'd	Michael Paquier	07:12
Re: Impact of checkpointer during pg_upgrade	Dilip Kumar	08:11
Re: Optimize planner memory consumption for huge arrays	Dilip Kumar	08:37
Re: In-placre persistance change of a relation 📎	Kyotaro Horiguchi	08:37
Re: pg_upgrade and logical replication	Amit Kapila	08:42
Re: Incremental View Maintenance, take 2	jian he	08:48
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	09:50
Re: persist logical slots to disk during shutdown checkpoint	vignesh C	10:15
Re: Optimize planner memory consumption for huge arrays	Lepikhov Andrei	10:19
Re: More new SQL/JSON item methods	Jeevan Chalke	10:21
Re: Impact of checkpointer during pg_upgrade	Dilip Kumar	10:48
[PATCH] Add inline comments to the pg_hba_file_rules view 📎	Jim Jones	10:54
Re: Optimize planner memory consumption for huge arrays	Dilip Kumar	10:59
Re: cataloguing NOT NULL constraints	Alvaro Herrera	11:00
Re: Extract numeric filed in JSONB more effectively	Andy Fan	11:43
Re: Autogenerate some wait events code and documentation	Drouvot, Bertrand	12:14
Re: proposal: psql: show current user in prompt	Jelte Fennema	12:24
Re: Flush SLRU counters in checkpointer process	Aleksander Alekseev	12:24
Re: [PATCH] Infinite loop while acquiring new TOAST Oid	Aleksander Alekseev	12:27
Re: SLRUs in the main buffer pool, redux	Aleksander Alekseev	12:31
Re: [17] CREATE SUBSCRIPTION ... SERVER	Ashutosh Bapat	12:31
Re: Avoid unncessary always true test (src/backend/storage/buffer/bufmgr.c)	Peter Eisentraut	12:32
Re: [17] CREATE SUBSCRIPTION ... SERVER	Ashutosh Bapat	12:34
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Aleksander Alekseev	12:35
RE: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases	Zhijie Hou (Fujitsu)	12:38
Re: trying again to get incremental backup	Dilip Kumar	12:41
Re: Speaker Bureau	Ashutosh Bapat	12:57
Re: pgsql: Allow tailoring of ICU locales with custom rules	Amit Kapila	13:05
Re: Commitfest 2023-09 starts soon	Aleksander Alekseev	13:22
Re: Unlogged relation copy is not fsync'd	Melanie Plageman	13:59
Re: Commitfest 2023-09 starts soon	Peter Eisentraut	14:19
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Ranier Vilela	14:27
Re: Commitfest 2023-09 starts soon	Peter Eisentraut	14:29
Re: Extract numeric filed in JSONB more effectively 📎	Andy Fan	14:35
Re: Commitfest 2023-09 starts soon	Aleksander Alekseev	14:36
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Aleksander Alekseev	14:41
Re: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases 📎	Masahiko Sawada	14:42
Create shorthand for including all extra tests 📎	Nazir Bilal Yavuz	14:43
Re: Create shorthand for including all extra tests	Tom Lane	15:01
Re: Suppressing compiler warning on Debian 12/gcc 12.2.0	Bruce Momjian	15:12
Re: Query execution in Perl TAP tests needs work	Andrew Dunstan	15:25
Re: Commitfest 2023-09 starts soon	Matthias van de Meent	15:55
Re: SLRUs in the main buffer pool - Page Header definitions	Aleksander Alekseev	15:57
Re: SLRUs in the main buffer pool, redux	Aleksander Alekseev	16:02
Re: Commitfest 2023-09 starts soon	Aleksander Alekseev	16:18
information_schema and not-null constraints 📎	Alvaro Herrera	17:10
Re: PATCH: Add REINDEX tag to event triggers	Jim Jones	18:00
Re: proposal: psql: show current user in prompt	Pavel Stehule	18:03
Re: Commitfest 2023-09 starts soon	Matthias van de Meent	18:10
Re: Create shorthand for including all extra tests	Daniel Gustafsson	18:16
Re: Create shorthand for including all extra tests	Noah Misch	18:41
Re: Commitfest 2023-09 starts soon	Melanie Plageman	19:38
Re: Show various offset arrays for heap WAL records	Melanie Plageman	20:02
Re: Create shorthand for including all extra tests	Tom Lane	20:30
backtrace_functions emits trace for any elog 📎	Ilya Gladyshev	20:30
Re: information_schema and not-null constraints	Tom Lane	20:43
Re: Create shorthand for including all extra tests	Noah Misch	21:09
Re: backtrace_functions emits trace for any elog	Noah Misch	21:13
Re: Inefficiency in parallel pg_restore with many tables 📎	Nathan Bossart	23:08

Browse Archives

Prev | Next