pgsql-hackers since 2023-09-07 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. 7, 2023

Thread	Author	Time
Re: Add 'worker_type' to pg_stat_subscription 📎	Peter Smith	00:36
Re: A minor adjustment to get_cheapest_path_for_pathkeys 📎	Richard Guo	02:21
Re: A failure in 031_recovery_conflict.pl on Debian/s390x	Thomas Munro	02:41
Re: Synchronizing slots from primary to standby	shveta malik	02:59
Re: A failure in 031_recovery_conflict.pl on Debian/s390x 📎	Thomas Munro	03:39
Re: pg_basebackup: Always return valid temporary slot names	Michael Paquier	04:23
Re: pg_basebackup: Always return valid temporary slot names	Michael Paquier	04:28
Re: Unlogged relation copy is not fsync'd	Michael Paquier	04:36
Re: persist logical slots to disk during shutdown checkpoint 📎	vignesh C	04:43
psql help message contains excessive indentations 📎	Kyotaro Horiguchi	05:29
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	05:38
Re: GUC for temporarily disabling event triggers	Michael Paquier	05:57
Re: psql help message contains excessive indentations	Yugo NAGATA	06:02
Re: RFC: Logging plan of the running query	torikoshia	06:09
Re: Improve heapgetpage() performance, overhead from serializable	John Naylor	06:14
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	06:26
pg_rewind with cascade standby doesn't work well	Kuwamura Masaki	06:33
Re: pg_upgrade and logical replication	Michael Paquier	06:33
Re: psql help message contains excessive indentations	Kyotaro Horiguchi	06:36
Re: [PoC] Reducing planning time when tables have many partitions	Ashutosh Bapat	06:43
Re: Transaction timeout	bt23nguyent	07:06
pg_ctl start may return 0 even if the postmaster has been already started on Windows	Hayato Kuroda (Fujitsu)	07:07
Re: psql help message contains excessive indentations 📎	Yugo NAGATA	07:08
Re: Impact of checkpointer during pg_upgrade	Michael Paquier	07:25
Re: Can a role have indirect ADMIN OPTION on another role?	Ashutosh Sharma	07:29
Re: Can a role have indirect ADMIN OPTION on another role?	Ashutosh Sharma	07:32
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows	Michael Paquier	07:37
Re: persist logical slots to disk during shutdown checkpoint	Michael Paquier	07:48
Re: [BackendXidGetPid] only access allProcs when xid matches	Ashutosh Bapat	07:52
Re: CHECK Constraint Deferrable 📎	Himanshu Upadhyaya	07:55
Re: SLRUs in the main buffer pool - Page Header definitions	Bagga, Rishu	08:03
Re: psql help message contains excessive indentations	Kyotaro Horiguchi	08:03
Re: [BackendXidGetPid] only access allProcs when xid matches	Michael Paquier	08:04
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	08:13
Re: [BackendXidGetPid] only access allProcs when xid matches 📎	Junwang Zhao	08:17
Re: A failure in 031_recovery_conflict.pl on Debian/s390x	Christoph Berg	08:19
Re: Obsolete reference to pg_relation in comment	Daniel Gustafsson	08:44
Re: psql - pager support - using invisible chars for signalling end of report	Daniel Gustafsson	08:57
Re: Create shorthand for including all extra tests	Daniel Gustafsson	09:01
Re: [BackendXidGetPid] only access allProcs when xid matches 📎	Ashutosh Bapat	09:07
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Jian Guo	09:26
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Aleksander Alekseev	09:32
Re: [BackendXidGetPid] only access allProcs when xid matches	Junwang Zhao	09:34
Re: information_schema and not-null constraints	Alvaro Herrera	09:40
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() 📎	tender wang	09:56
Re: Impact of checkpointer during pg_upgrade	Amit Kapila	10:03
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	10:08
Re: Impact of checkpointer during pg_upgrade	Dilip Kumar	10:12
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	10:41
RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎	Hayato Kuroda (Fujitsu)	10:53
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	11:00
Re: missing privilege check after not-null constraint rework	Alvaro Herrera	11:02
Re: [BackendXidGetPid] only access allProcs when xid matches	Ashutosh Bapat	11:04
Re: psql help message contains excessive indentations	Alvaro Herrera	11:06
Add resource intensiveness as a reason to not running tests by default 📎	Nazir Bilal Yavuz	11:09
Re: Add resource intensiveness as a reason to not running tests by default	Daniel Gustafsson	11:24
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Thomas Munro	11:30
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Daniel Gustafsson	11:44
Re: add (void) cast inside advance_aggregates for function ExecEvalExprSwitchContext	Daniel Gustafsson	12:14
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	12:24
Re: psql help message contains excessive indentations	Yugo NAGATA	12:56
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	13:11
Re: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases 📎	Masahiko Sawada	13:22
Re: Output affected rows in EXPLAIN 📎	Damir Belyalov	14:57
Re: Fix bogus Asserts in calc_non_nestloop_required_outer	Aleksander Alekseev	15:09
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	16:06
Re: Simple CustomScan example	Drouvot, Bertrand	16:29
Re: [PATCH] pgrowlocks: Make mode names consistent with docs 📎	Bruce Momjian	16:58
Re: Eliminate redundant tuple visibility check in vacuum	Robert Haas	17:37
Re: Wrong command name in writeable-CTE related error messages 📎	Markus Winand	17:51
Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption? 📎	Bruce Momjian	17:52
Re: MergeJoin beats HashJoin in the case of multiple hash clauses	Bruce Momjian	18:08
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Robert Haas	18:42
Re: GUC for temporarily disabling event triggers	Robert Haas	19:02
Re: Eliminate redundant tuple visibility check in vacuum	Melanie Plageman	19:09
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()	Robert Haas	19:14
Re: Eliminate redundant tuple visibility check in vacuum	Robert Haas	19:29
Re: Document that server will start even if it's unable to open some TCP/IP ports 📎	Bruce Momjian	19:33
Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	19:51
Re: Possibility to disable `ALTER SYSTEM`	Joe Conway	19:57
Re: Possibility to disable `ALTER SYSTEM`	Gabriele Bartolini	20:03
Re: Possibility to disable `ALTER SYSTEM`	Tom Lane	20:27
Re: Document that server will start even if it's unable to open some TCP/IP ports	Nathan Bossart	21:54
Re: Eliminate redundant tuple visibility check in vacuum 📎	Melanie Plageman	22:23
Re: Add 'worker_type' to pg_stat_subscription 📎	Nathan Bossart	22:28
Re: Document that server will start even if it's unable to open some TCP/IP ports 📎	Bruce Momjian	23:13
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Michael Paquier	23:48

Sept. 8, 2023

Thread	Author	Time
Re: Row pattern recognition 📎	Jacob Champion	00:00
Re: Impact of checkpointer during pg_upgrade	Michael Paquier	00:07
Re: Correct the documentation for work_mem 📎	Bruce Momjian	00:16
Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Thomas Munro	00:19
Re: psql help message contains excessive indentations	Kyotaro Horiguchi	00:55
Re: [BackendXidGetPid] only access allProcs when xid matches	Michael Paquier	01:05
Re: Simple CustomScan example	Michael Paquier	01:08
Re: SQL:2011 application time	jian he	01:24
Re: old_snapshot_threshold bottleneck on replica	Peter Geoghegan	01:53
Re: old_snapshot_threshold bottleneck on replica	Thomas Munro	02:00
Re: Impact of checkpointer during pg_upgrade	Amit Kapila	02:48
Re: Impact of checkpointer during pg_upgrade	Michael Paquier	02:58
RE: Impact of checkpointer during pg_upgrade	Zhijie Hou (Fujitsu)	03:30
Re: persist logical slots to disk during shutdown checkpoint 📎	Amit Kapila	03:34
Re: Impact of checkpointer during pg_upgrade	Michael Paquier	03:42
Re: Impact of checkpointer during pg_upgrade	Amit Kapila	03:44
BUG #18097: Immutable expression not allowed in generated at	PG Bug reporting form	03:47
Re: old_snapshot_threshold bottleneck on replica 📎	Thomas Munro	03:48
Re: Row pattern recognition	Tatsuo Ishii	03:54
Re: Eager page freeze criteria clarification	Andres Freund	04:07
Re: Document that server will start even if it's unable to open some TCP/IP ports	Nathan Bossart	04:21
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

Browse Archives

Prev | Next