pgsql-hackers since 2023-09-08 04:22

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. 8, 2023

Thread	Author	Time
Re: old_snapshot_threshold bottleneck on replica	Peter Geoghegan	04:22
Suspicious redundant assignment in COPY FROM 📎	Jingtang Zhang	04:23
Re: persist logical slots to disk during shutdown checkpoint	Michael Paquier	04:38
Re: Impact of checkpointer during pg_upgrade	Michael Paquier	04:40
Re: Eager page freeze criteria clarification	Andres Freund	04:45
Re: Optimize planner memory consumption for huge arrays 📎	Lepikhov Andrei	05:11
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎	Kyotaro Horiguchi	05:17
Re: old_snapshot_threshold bottleneck on replica	Thomas Munro	05:21
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎	Kyotaro Horiguchi	05:22
Re: Correct the documentation for work_mem	David Rowley	05:23
Re: Eager page freeze criteria clarification	Andres Freund	05:26
Re: Eager page freeze criteria clarification	Peter Geoghegan	05:29
Re: Eager page freeze criteria clarification	Andres Freund	05:36
Re: Suspicious redundant assignment in COPY FROM	Michael Paquier	05:41
Re: Eager page freeze criteria clarification	Andres Freund	05:45
Re: Suspicious redundant assignment in COPY FROM 📎	Jingtang Zhang	05:54
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()	Richard Guo	06:06
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Richard Guo	06:08
Re: Eager page freeze criteria clarification	Peter Geoghegan	06:18
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	06:20
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c) 📎	Michael Paquier	06:24
Re: Impact of checkpointer during pg_upgrade	Amit Kapila	06:29
Re: Impact of checkpointer during pg_upgrade	Michael Paquier	06:38
Re: WL_SOCKET_ACCEPT fairness on Windows	Thomas Munro	06:59
Re: Oversight in reparameterize_path_by_child leading to executor crash	Ashutosh Bapat	07:04
Using non-grouping-keys at HAVING clause	Kohei KaiGai	07:42
Re: CHECK Constraint Deferrable	Dilip Kumar	07:52
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows	Hayato Kuroda (Fujitsu)	08:02
Re: Build the docs if there are changes in docs and don't run other tasks if the changes are only in docs	Daniel Gustafsson	08:05
Re: Synchronizing slots from primary to standby 📎	shveta malik	08:24
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	08:42
Re: SQL:2011 application time	jian he	09:35
Re: Add resource intensiveness as a reason to not running tests by default	Daniel Gustafsson	09:39
Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)	Ashutosh Bapat	09:52
Re: Support prepared statement invalidation when result types change 📎	Jelte Fennema	09:54
Re: Using non-grouping-keys at HAVING clause	Vik Fearing	10:07
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	10:28
RE: Synchronizing slots from primary to standby	Hayato Kuroda (Fujitsu)	11:10
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	11:23
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	11:31
Re: Using non-grouping-keys at HAVING clause	Kohei KaiGai	12:25
Re: SLRUs in the main buffer pool - Page Header definitions	Stephen Frost	12:56
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	13:01
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:03
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:05
Re: [RFC] Add jit deform_counter	Daniel Gustafsson	13:34
Re: [RFC] Add jit deform_counter	Dmitry Dolgov	13:45
Re: Possibility to disable `ALTER SYSTEM`	Isaac Morland	14:11
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	14:17
FDW pushdown of non-collated functions 📎	Jean-Christophe Arnu	14:41
Re: Document that server will start even if it's unable to open some TCP/IP ports 📎	Bruce Momjian	14:52
Re: Possibility to disable `ALTER SYSTEM`	Alvaro Herrera	14:55
Re: Adding a pg_get_owned_sequence function?	Stephen Frost	14:56
Re: Eliminate redundant tuple visibility check in vacuum	Robert Haas	15:06
Re: BUG #18097: Immutable expression not allowed in generated at	David G. Johnston	15:11
Re: BUG #18097: Immutable expression not allowed in generated at	James Keener	15:22
Re: Possibility to disable `ALTER SYSTEM`	Tom Lane	15:31
Re: BUG #18097: Immutable expression not allowed in generated at	Tom Lane	16:08
Re: SQL:2011 application time	Paul A Jungwirth	17:26
Re: Adding a pg_get_owned_sequence function?	Nathan Bossart	17:53
Re: Document that server will start even if it's unable to open some TCP/IP ports	Nathan Bossart	17:54
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) 📎	Alexander Lakhin	19:00
Re: proposal: psql: show current user in prompt 📎	Pavel Stehule	19:07
Re: proposal: psql: show current user in prompt	Pavel Stehule	19:07
Re: Row pattern recognition	Jacob Champion	19:27
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Thomas Munro	19:39
Re: About #13489, array dimensions and CREATE TABLE ... LIKE 📎	Bruce Momjian	21:10
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Jeff Davis	21:24
Re: Possibility to disable `ALTER SYSTEM` 📎	Gabriele Bartolini	21:31
Re: Possibility to disable `ALTER SYSTEM`	Magnus Hagander	21:43
Re: Row pattern recognition	Vik Fearing	21:43
Re: Possibility to disable `ALTER SYSTEM`	Álvaro Hernández	23:24
Re: [PATCH] Add inline comments to the pg_hba_file_rules view	David Zhang	23:52

Sept. 9, 2023

Thread	Author	Time
Re: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases	Masahiko Sawada	01:33
Re: Correct the documentation for work_mem	Imseih (AWS), Sami	02:25
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	03:24
Add pg_basetype() function to obtain a DOMAIN base type 📎	Steve Chavez	04:17
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	06:37
Re: SQL:2011 application time	jian he	07:54
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Alexander Lakhin	09:00
Re: Row pattern recognition	Tatsuo Ishii	11:21
Re: Suspicious redundant assignment in COPY FROM	Michael Paquier	12:13
Re: Row pattern recognition	Vik Fearing	13:32
Re: Possibility to disable `ALTER SYSTEM`	Alvaro Herrera	15:14
Re: BUG #18097: Immutable expression not allowed in generated at 📎	Tom Lane	19:18
Re: Add const qualifiers	David Steele	20:03
Re: [PATCH] Add inline comments to the pg_hba_file_rules view 📎	Jim Jones	20:36
Re: BUG #18097: Immutable expression not allowed in generated at	Tom Lane	22:56
Surely this code in setrefs.c is wrong?	Tom Lane	23:22

Sept. 10, 2023

Thread	Author	Time
Re: Surely this code in setrefs.c is wrong?	David Rowley	09:07
Re: Cleaning up array_in()	Alexander Lakhin	10:00
Re: Inefficiency in parallel pg_restore with many tables	Tom Lane	16:35
Re: proposal: psql: show current user in prompt 📎	Pavel Stehule	20:59
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c) 📎	Ranier Vilela	21:28
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Michael Paquier	22:24
Re: [PATCH] Add inline comments to the pg_hba_file_rules view	Michael Paquier	22:33

Sept. 11, 2023

Thread	Author	Time
Re: Oversight in reparameterize_path_by_child leading to executor crash	Richard Guo	02:05
Re: Synchronizing slots from primary to standby 📎	shveta malik	02:56
Re: Impact of checkpointer during pg_upgrade	Dilip Kumar	03:49
Re: pg_logical_emit_message() misses a XLogFlush()	Fujii Masao	03:54
Re: Synchronizing slots from primary to standby	shveta malik	04:19
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	04:34
Re: MergeJoin beats HashJoin in the case of multiple hash clauses	Andy Fan	04:51
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	04:57
Re: pg_logical_emit_message() misses a XLogFlush()	Michael Paquier	05:02
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	05:09
Re: Cleaning up array_in() 📎	jian he	05:26
Re: pg_logical_emit_message() misses a XLogFlush()	bt23nguyent	05:42
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	05:46
BufferUsage counters' values have changed	Karina Litskevich	06:08
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Dilip Kumar	06:18
Re: BufferUsage counters' values have changed 📎	Karina Litskevich	06:23
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	06:33
Re: persist logical slots to disk during shutdown checkpoint	Michael Paquier	06:38
Re: PSQL error: total cell count of XXX exceeded 📎	Hongxu Ma	06:50
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Amit Kapila	06:53
Re: PSQL error: total cell count of XXX exceeded	Jelte Fennema	07:04
Re: pg_logical_emit_message() misses a XLogFlush() 📎	Michael Paquier	07:24
Re: MergeJoin beats HashJoin in the case of multiple hash clauses 📎	Lepikhov Andrei	08:04
Re: pg_rewind with cascade standby doesn't work well 📎	Kuwamura Masaki	08:49
Re: persist logical slots to disk during shutdown checkpoint 📎	Amit Kapila	09:19
Re: Pgoutput not capturing the generated columns	Rajendra Kumar Dangwal	09:23
Re: Correct the documentation for work_mem	David Rowley	10:02
Re: pg_upgrade and logical replication 📎	vignesh C	10:31
Re: pg_upgrade and logical replication	vignesh C	10:36
Re: generate syscache info automatically	John Naylor	11:02
Re: Build the docs if there are changes in docs and don't run other tasks if the changes are only in docs	Nazir Bilal Yavuz	11:03
Re: proposal: psql: show current user in prompt	Jelte Fennema	11:23
Re: pg_upgrade and logical replication	vignesh C	11:49
Re: pg_upgrade and logical replication	vignesh C	11:50
Re: Possibility to disable `ALTER SYSTEM`	Martín Marqués	11:55
Re: proposal: psql: show current user in prompt	Jelte Fennema	11:59
Re: Cleaning up array_in()	Alexander Lakhin	12:00
Re: Speed up transaction completion faster after many relations are accessed in a transaction 📎	David Rowley	12:00
Re: proposal: psql: show current user in prompt	Jelte Fennema	12:03
Re: Eliminate redundant tuple visibility check in vacuum	Melanie Plageman	12:04
Re: Build the docs if there are changes in docs and don't run other tasks if the changes are only in docs	Daniel Gustafsson	12:11
Re: CHECK Constraint Deferrable	Himanshu Upadhyaya	12:15
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	13:21
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:21
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:22
Re: Possibility to disable `ALTER SYSTEM`	Magnus Hagander	13:50
Re: Possibility to disable `ALTER SYSTEM`	Magnus Hagander	14:04
How to add built-in func?	jacktby jacktby	14:52
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	14:59
Re: Correct the documentation for work_mem 📎	Bruce Momjian	15:03
Re: Possibility to disable `ALTER SYSTEM`	Stephen Frost	15:12
Re: How to add built-in func?	Aleksander Alekseev	15:51
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	15:56
Re: pg_rewind with cascade standby doesn't work well	Aleksander Alekseev	16:04
Re: Possibility to disable `ALTER SYSTEM`	Isaac Morland	16:15
Re: How to add built-in func?	Pavel Stehule	16:18
Re: How to add built-in func?	Pavel Stehule	16:19
Re: How to add built-in func?	jacktby jacktby	16:28
Re: How to add built-in func?	Chapman Flack	16:34
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Jeff Davis	19:15
Re: proposal: psql: show current user in prompt 📎	Pavel Stehule	19:30
Re: Query execution in Perl TAP tests needs work	Thomas Munro	20:52
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)	Thomas Munro	21:04
Re: Row pattern recognition	Jacob Champion	22:13
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	23:56

Sept. 12, 2023

Thread	Author	Time
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c) 📎	Michael Paquier	00:03
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c)	Ranier Vilela	00:06
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	02:06
Re: broken master regress tests	Andres Freund	02:23
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	02:33
Re: PSQL error: total cell count of XXX exceeded 📎	Hongxu Ma	02:39
Re: Add 'worker_type' to pg_stat_subscription	Peter Smith	03:07
Re: Add 'worker_type' to pg_stat_subscription	Michael Paquier	03:43
Re: PSQL error: total cell count of XXX exceeded	Michael Paquier	03:55
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Michael Paquier	03:57
Re: PSQL error: total cell count of XXX exceeded	Tom Lane	04:19
Re: How to add built-in func?	jacktby jacktby	05:11
Re: persist logical slots to disk during shutdown checkpoint 📎	Michael Paquier	05:25
Re: Make all Perl warnings fatal	Peter Eisentraut	05:42
Re: pg_rewind with cascade standby doesn't work well	Michael Paquier	06:10
Re: Make psql's qeury canceling test simple by using signal() routine of IPC::Run	Michael Paquier	06:18
Re: Row pattern recognition 📎	Tatsuo Ishii	06:18
Re: Make --help output fit within 80 columns per line	Peter Eisentraut	06:27
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	07:04
Re: [ psql - review request ] review request for \d+ tablename, \d+ indexname indenting 📎	쿼리트릭스	07:27
Re: Adding a pg_get_owned_sequence function?	Peter Eisentraut	07:33
Re: proposal: psql: show current user in prompt	Peter Eisentraut	07:46
Re: remaining sql/json patches	Peter Eisentraut	07:52
Re: psql - pager support - using invisible chars for signalling end of report	Peter Eisentraut	07:55
Re: Create shorthand for including all extra tests	Peter Eisentraut	08:00
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	08:10
Re: Row pattern recognition 📎	Tatsuo Ishii	08:44
Re: Cleaning up array_in() 📎	jian he	08:45
RE: pg_upgrade and logical replication 📎	Hayato Kuroda (Fujitsu)	08:55
Detoasting optionally to make Explain-Analyze less misleading 📎	stepan rutz	08:59
Re: Add 'worker_type' to pg_stat_subscription 📎	Peter Smith	09:00
Re: SQL:2011 application time	jian he	09:01
Re: Infinite Interval	Dean Rasheed	09:09
Re: CHECK Constraint Deferrable	vignesh C	09:25
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	09:45
Re: trying again to get incremental backup	Dilip Kumar	09:56
Server crash on RHEL 9/s390x platform against PG16	Suraj Kharage	09:57
Re: Removing unneeded self joins 📎	Andrey Lepikhov	11:49
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	11:50

Browse Archives

Prev | Next