pgsql-hackers before 2023-09-08 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. 5, 2023

Thread	Author	Time
Re: Initdb-time block size specification	Hannu Krosing	19:52
Re: pg_upgrade fails with in-place tablespace[	Robert Haas	20:08
Re: Initdb-time block size specification	Andres Freund	20:23
Fix some wording in WAL docs 📎	Tristan Partin	20:38
Re: Initdb-time block size specification	David Christensen	20:57
Re: Add 'worker_type' to pg_stat_subscription 📎	Peter Smith	21:02
Re: Replace known_assigned_xids_lck by memory barrier	Nathan Bossart	21:08
Re: Initdb-time block size specification	Hannu Krosing	21:38
Re: Add 'worker_type' to pg_stat_subscription	Nathan Bossart	21:49
Re: information_schema and not-null constraints	Vik Fearing	21:50
Re: information_schema and not-null constraints	David G. Johnston	22:14
Re: sandboxing untrusted code	Jeff Davis	22:20
Re: information_schema and not-null constraints	Vik Fearing	23:35
Re: Replace known_assigned_xids_lck by memory barrier	Michail Nikolaev	23:56

Sept. 6, 2023

Thread	Author	Time
Re: should frontend tools use syncfs() ?	Nathan Bossart	00:08
Re: information_schema and not-null constraints	Tom Lane	00:53
Re: RFC: Logging plan of the running query	James Coleman	02:17
Re: Autogenerate some wait events code and documentation	Erik Wienhold	02:20
Re: information_schema and not-null constraints	Vik Fearing	02:31
Re: psql - pager support - using invisible chars for signalling end of report	Thomas Munro	03:07
Re: Improve heapgetpage() performance, overhead from serializable	John Naylor	03:14
Re: Disabling Heap-Only Tuples	Laurenz Albe	03:15
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Zhijie Hou (Fujitsu)	03:17
Re: information_schema and not-null constraints	Tom Lane	03:40
Re: Autogenerate some wait events code and documentation	Michael Paquier	03:42
Re: Autogenerate some wait events code and documentation	Michael Paquier	03:44
Re: document the need to analyze partitioned tables 📎	Laurenz Albe	03:53
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	04:16
Re: persist logical slots to disk during shutdown checkpoint	Dilip Kumar	04:27
Re: Autogenerate some wait events code and documentation	Drouvot, Bertrand	04:43
Re: Eager page freeze criteria clarification	Andres Freund	05:09
[Regression] Incorrect filename in test case comment 📎	Suraj Kharage	05:18
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	05:25
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	05:30
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	05:39
Re: pg_basebackup: Always return valid temporary slot names	Nishant Sharma	05:55
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500 📎	jian he	06:00
Re: [PoC] Improve dead tuple storage for lazy vacuum	John Naylor	06:23
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	06:31
Re: persist logical slots to disk during shutdown checkpoint	Dilip Kumar	06:38
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Andy Fan	06:45
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Andy Fan	06:46
Re: [PATCH] psql: Add tab-complete for optional view parameters	Peter Eisentraut	06:52
Re: Extract numeric filed in JSONB more effectively	Andy Fan	07:00
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Andy Fan	07:13
Re: Improving the heapgetpage function improves performance in common scenarios 📎	Quan Zongliang	07:50
Re: Improving the heapgetpage function improves performance in common scenarios	Quan Zongliang	07:55
Re: Transaction timeout	Fujii Masao	08:16
Re: [Regression] Incorrect filename in test case comment	Michael Paquier	08:19
Re: [Regression] Incorrect filename in test case comment	Daniel Gustafsson	08:21
Re: [Regression] Incorrect filename in test case comment	Daniel Gustafsson	08:22
Re: Synchronizing slots from primary to standby 📎	shveta malik	08:37
Re: Synchronizing slots from primary to standby	shveta malik	08:48
Re: GUC for temporarily disabling event triggers 📎	Daniel Gustafsson	08:50
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	08:55
Re: Improving the heapgetpage function improves performance in common scenarios	John Naylor	09:07
Re: Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid	Richard Guo	09:10
Re: generic plans and "initial" pruning 📎	Amit Langote	09:12
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	09:26
Can a role have indirect ADMIN OPTION on another role?	Ashutosh Sharma	09:27
Re: Improving the heapgetpage function improves performance in common scenarios	Quan Zongliang	09:56
Re: pg_stats and range statistics	jian he	09:56
Re: [Regression] Incorrect filename in test case comment	Suraj Kharage	10:00
Re: How to add a new pg oid?	jacktby jacktby	10:19
Re: Vectorization of some functions and improving pg_list interface	Yura Sokolov	10:24
Re: Vectorization of some functions and improving pg_list interface	Yura Sokolov	10:40
Re: How to add a new pg oid?	jacktby jacktby	10:50
Re: Avoid a possible null pointer (src/backend/utils/adt/pg_locale.c) 📎	Ranier Vilela	10:57
Re: pg_upgrade and logical replication 📎	vignesh C	10:58
Re: information_schema and not-null constraints	Peter Eisentraut	11:02
Re: pgbnech: allow to cancel queries during benchmark 📎	Yugo NAGATA	11:13
Re: Transaction timeout	Andrey M. Borodin	11:32
Re: How to add a new pg oid?	jacktby jacktby	11:46
make add_paths_to_append_rel aware of startup cost 📎	Andy Fan	12:39
Output affected rows in EXPLAIN 📎	Damir Belyalov	12:49
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Robert Haas	12:50
Re: [PoC] Improve dead tuple storage for lazy vacuum	Masahiko Sawada	12:54
Re: A minor adjustment to get_cheapest_path_for_pathkeys	Andy Fan	13:00
Re: Optimize planner memory consumption for huge arrays	Ashutosh Bapat	13:09
Re: Output affected rows in EXPLAIN	Daniel Gustafsson	13:20
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	13:35
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:36
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:36
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:36
Re: POC: Extension for adding distributed tracing - pg_tracing 📎	Anthonin Bonnefoy	13:43
Re: Output affected rows in EXPLAIN	Tom Lane	14:00
Re: generic plans and "initial" pruning	Robert Haas	14:20
Re: GUC for temporarily disabling event triggers	Robert Haas	14:22
Re: Eager page freeze criteria clarification	Robert Haas	14:35
Re: Eager page freeze criteria clarification	Robert Haas	14:46
Re: remaining sql/json patches	Alvaro Herrera	15:01
Re: Can a role have indirect ADMIN OPTION on another role?	Robert Haas	15:33
Re: Eager page freeze criteria clarification	Peter Geoghegan	16:20
Re: Debian 12 gcc warning	Bruce Momjian	16:33
Re: Eliminate redundant tuple visibility check in vacuum	Robert Haas	17:04
Re: Can a role have indirect ADMIN OPTION on another role?	Ashutosh Sharma	17:33
Re: information_schema and not-null constraints 📎	Alvaro Herrera	17:52
Re: Can a role have indirect ADMIN OPTION on another role?	Robert Haas	18:50
Re: Configurable FP_LOCK_SLOTS_PER_BACKEND	Jeremy Schneider	19:09
Re: information_schema and not-null constraints	Vik Fearing	19:09
Re: Obsolete reference to pg_relation in comment 📎	Bruce Momjian	19:13
Release notes wording about logical replication as table owner	Magnus Hagander	19:29
Simple CustomScan example	Chris Cleveland	19:32
Re: Release notes wording about logical replication as table owner 📎	Bruce Momjian	19:36
Re: Eager page freeze criteria clarification	Robert Haas	20:21
Re: GUC for temporarily disabling event triggers 📎	Daniel Gustafsson	20:23
Re: Eliminate redundant tuple visibility check in vacuum 📎	Melanie Plageman	21:21
Re: Performance degradation on concurrent COPY into a single relation in PG16.	Tom Lane	22:01
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎	Jacob Champion	22:11
Re: Can a role have indirect ADMIN OPTION on another role?	David G. Johnston	22:13
pgsql: Allow using syncfs() in frontend utilities.	Nathan Bossart	23:28
Re: should frontend tools use syncfs() ?	Nathan Bossart	23:29
Re: A failure in 031_recovery_conflict.pl on Debian/s390x	Thomas Munro	23:57

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

Browse Archives

Prev | Next