pgsql-hackers since 2023-09-03 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

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
Re: brininsert optimization opportunity 📎 Soumyadeep Chakraborty 23:43
Re: Cleaning up array_in() 📎 jian he 23:53

Sept. 5, 2023

Thread Author Time
Re: pg_upgrade fails with in-place tablespace Rui Zhao 02:06
RE: persist logical slots to disk during shutdown checkpoint Zhijie Hou (Fujitsu) 02:24
Re: pg_upgrade fails with in-place tablespace[ Rui Zhao 02:28
RE: Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases Zhijie Hou (Fujitsu) 02:31
Re: Sync scan & regression tests Tom Lane 03:16
Re: Report planning memory in EXPLAIN ANALYZE Lepikhov Andrei 03:18
Re: persist logical slots to disk during shutdown checkpoint Amit Kapila 03:28
Re: Optionally using a better backtrace library? 📎 Noah Misch 03:36
Re: persist logical slots to disk during shutdown checkpoint Dilip Kumar 03:39
Re: proposal: psql: show current user in prompt 📎 Pavel Stehule 03:49
Re: Impact of checkpointer during pg_upgrade Amit Kapila 04:08
Re: persist logical slots to disk during shutdown checkpoint Amit Kapila 04:28
Re: Impact of checkpointer during pg_upgrade Dilip Kumar 04:39
Re: persist logical slots to disk during shutdown checkpoint Dilip Kumar 04:48
Re: Impact of checkpointer during pg_upgrade Amit Kapila 05:25
Re: Autogenerate some wait events code and documentation 📎 Michael Paquier 05:44
RE: [PoC] pg_upgrade: allow to upgrade publisher node Zhijie Hou (Fujitsu) 05:50
Re: pg_upgrade fails with in-place tablespace[ Michael Paquier 05:56
Re: Impact of checkpointer during pg_upgrade Dilip Kumar 07:00
Re: persist logical slots to disk during shutdown checkpoint 📎 vignesh C 07:01
Re: pg_basebackup: Always return valid temporary slot names Nishant Sharma 07:09
Re: generic plans and "initial" pruning 📎 Amit Langote 07:13
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 07:34
Re: Improve heapgetpage() performance, overhead from serializable John Naylor 07:42
Re: old_snapshot_threshold bottleneck on replica Thomas Munro 07:58
Re: persist logical slots to disk during shutdown checkpoint Dilip Kumar 08:15
Re: Improving the heapgetpage function improves performance in common scenarios John Naylor 08:15
Should consider materializing the cheapest inner path in consider_parallel_nestloop() 📎 tender wang 08:52
Re: Autogenerate some wait events code and documentation 📎 Drouvot, Bertrand 09:06
Re: Improving the heapgetpage function improves performance in common scenarios Quan Zongliang 09:27
Re: logfmt and application_context Daniel Gustafsson 09:35
Re: pg_basebackup: Always return valid temporary slot names Daniel Gustafsson 09:39
Re: Optionally using a better backtrace library? Alvaro Herrera 09:59
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() tender wang 10:10
Re: pg_basebackup: Always return valid temporary slot names Jelte Fennema 10:21
Remove unnecessary 'always:' from CompilerWarnings task 📎 Nazir Bilal Yavuz 10:25
whether to unlink the existing state.tmp file in SaveSlotToPath Sergei Kornilov 10:38
Re: Improving the heapgetpage function improves performance in common scenarios John Naylor 10:46
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop() Richard Guo 10:50
Re: pg_basebackup: Always return valid temporary slot names Jelte Fennema 11:10
Re: proposal: psql: show current user in prompt Jelte Fennema 11:29
Re: cataloguing NOT NULL constraints Peter Eisentraut 11:29
RE: persist logical slots to disk during shutdown checkpoint Zhijie Hou (Fujitsu) 11:34
Re: Autogenerate some wait events code and documentation Michael Paquier 11:50
Re: Commitfest 2023-09 starts soon Aleksander Alekseev 11:55
Re: pg_basebackup: Always return valid temporary slot names Daniel Gustafsson 12:06
Re: GUC for temporarily disabling event triggers 📎 Daniel Gustafsson 12:12
Re: persist logical slots to disk during shutdown checkpoint Dilip Kumar 12:30
Re: Extract numeric filed in JSONB more effectively jian he 12:51
Re: XLog size reductions: smaller XLRec block header for PG17 Aleksander Alekseev 13:04
Re: RFC: Logging plan of the running query torikoshia 13:58
Re: Initdb-time block size specification Robert Haas 14:04
How to add a new pg oid? jacktby jacktby 14:29
Re: Initdb-time block size specification David Christensen 14:31
Re: [RFC] Add jit deform_counter Daniel Gustafsson 14:37
Re: generic plans and "initial" pruning Robert Haas 14:41
Re: trying again to get incremental backup Robert Haas 15:05
Re: How to add a new pg oid? jacktby jacktby 15:09
Re: A minor adjustment to get_cheapest_path_for_pathkeys Robert Haas 15:09
Re: SLRUs in the main buffer pool - Page Header definitions Robert Haas 15:20
Re: GUC for temporarily disabling event triggers Robert Haas 15:29
Re: cataloguing NOT NULL constraints Alvaro Herrera 15:29
Re: Make psql's qeury canceling test simple by using signal() routine of IPC::Run 📎 Yugo NAGATA 15:45
Re: A minor adjustment to get_cheapest_path_for_pathkeys Aleksander Alekseev 16:01
Re: A minor adjustment to get_cheapest_path_for_pathkeys Aleksander Alekseev 16:05
Re: information_schema and not-null constraints Alvaro Herrera 16:24
Re: sandboxing untrusted code Robert Haas 16:25
Re: How to add a new pg oid? Matthias van de Meent 16:46
Re: PATCH: document for regression test forgets libpq test 📎 Bruce Momjian 17:06
Re: A minor adjustment to get_cheapest_path_for_pathkeys Robert Haas 17:14
Re: information_schema and not-null constraints Alvaro Herrera 17:15
Re: Create shorthand for including all extra tests 📎 Nazir Bilal Yavuz 17:26
Re: Opportunistically pruning page before update Melanie Plageman 17:40
missing privilege check after not-null constraint rework Alvaro Herrera 17:44
Re: missing privilege check after not-null constraint rework 📎 Alvaro Herrera 17:45
Re: How to add a new pg oid? David G. Johnston 17:47
Re: Unlogged relation copy is not fsync'd Robert Haas 18:20
Re: How to add a new pg oid? David G. Johnston 18:32
Re: Improve heapgetpage() performance, overhead from serializable Andres Freund 18:38
Re: [17] CREATE SUBSCRIPTION ... SERVER Jeff Davis 19:08
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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30