pgsql-hackers before 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

Aug. 31, 2023

Thread Author Time
Re: New WAL record to detect the checkpoint redo location Dilip Kumar 04:25
Re: New WAL record to detect the checkpoint redo location Michael Paquier 04:33
Re: [PATCH] Add native windows on arm64 support Tom Lane 04:44
Re: [PATCH] Add native windows on arm64 support Thomas Munro 04:57
Re: [PATCH] Add native windows on arm64 support Tom Lane 05:06
Re: [17] CREATE SUBSCRIPTION ... SERVER Ashutosh Bapat 05:29
Re: should frontend tools use syncfs() ? Michael Paquier 05:30
Re: [PATCH] Add native windows on arm64 support Michael Paquier 05:33
Re: persist logical slots to disk during shutdown checkpoint Amit Kapila 06:39
Statistics Import and Export 📎 Corey Huinker 06:47
Re: persist logical slots to disk during shutdown checkpoint Ashutosh Bapat 06:55
Re: Statistics Import and Export Ashutosh Bapat 07:07
Re: Make --help output fit within 80 columns per line 📎 torikoshia 07:47
Should we use MemSet or {0} for struct initialization? 📎 Richard Guo 08:32
Commitfest 2023-09 starts soon Peter Eisentraut 08:36
Re: Allow specifying a dbname in pg_basebackup connection string 📎 Jelte Fennema 09:01
Re: Extract numeric filed in JSONB more effectively 📎 Andy Fan 09:10
pg_basebackup: Always return valid temporary slot names 📎 Jelte Fennema 09:13
Re: persist logical slots to disk during shutdown checkpoint Amit Kapila 09:22
Re: Eliminate redundant tuple visibility check in vacuum David Geier 09:39
Re: Sync scan & regression tests Heikki Linnakangas 09:45
Re: Should we use MemSet or {0} for struct initialization? Junwang Zhao 09:56
Re: cataloguing NOT NULL constraints Alexander Lakhin 10:00
Re: cataloguing NOT NULL constraints Alvaro Herrera 10:02
Re: Sync scan & regression tests Heikki Linnakangas 10:12
Re: cataloguing NOT NULL constraints 📎 Alvaro Herrera 10:26
Re: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Amit Kapila 10:34
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 10:47
RE: Initial Schema Sync for Logical Replication 📎 Kumar, Sachin 10:48
Re: cataloguing NOT NULL constraints Alexander Lakhin 11:00
Re: Replace some cstring_to_text to cstring_to_text_with_len Ranier Vilela 11:06
Re: Should we use MemSet or {0} for struct initialization? John Naylor 11:07
Re: lockup in parallel hash join on dikkop (freebsd 14.0-current) Thomas Munro 11:15
Re: pg_stat_get_backend_subxact() and backend IDs? Dilip Kumar 11:17
Re: Commitfest 2023-09 starts soon Aleksander Alekseev 11:18
Re: generate syscache info automatically 📎 Peter Eisentraut 11:23
Re: Commitfest 2023-09 starts soon Aleksander Alekseev 11:34
Re: Should we use MemSet or {0} for struct initialization? Junwang Zhao 11:35
Re: Replace some cstring_to_text to cstring_to_text_with_len John Naylor 11:41
Re: [17] CREATE SUBSCRIPTION ... SERVER Robert Haas 12:37
Re: persist logical slots to disk during shutdown checkpoint Ashutosh Bapat 12:42
Re: Replace some cstring_to_text to cstring_to_text_with_len Andrew Dunstan 12:51
Re: remaining sql/json patches 📎 Amit Langote 12:57
Re: Initdb-time block size specification 📎 David Christensen 13:07
Re: Replace some cstring_to_text to cstring_to_text_with_len Dagfinn Ilmari Mannsåker 13:12
Re: [PoC] pg_upgrade: allow to upgrade publisher node Dilip Kumar 13:22
Re: Adding a pg_get_owned_sequence function? Dagfinn Ilmari Mannsåker 13:24
Re: remaining sql/json patches Erik Rijkers 13:51
Re: persist logical slots to disk during shutdown checkpoint Amit Kapila 13:58
Re: Replace some cstring_to_text to cstring_to_text_with_len Ranier Vilela 14:09
Re: Replace some cstring_to_text to cstring_to_text_with_len 📎 Ranier Vilela 14:10
Re: Replace some cstring_to_text to cstring_to_text_with_len Ranier Vilela 14:11
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 14:26
Re: Replace some cstring_to_text to cstring_to_text_with_len Dagfinn Ilmari Mannsåker 15:12
sandboxing untrusted code Robert Haas 15:25
Re: Replace some cstring_to_text to cstring_to_text_with_len Peter Eisentraut 15:28
Re: UUID v7 Mat Arye 15:32
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 15:48
Re: Initdb-time block size specification John Naylor 15:54
Re: Initdb-time block size specification David Christensen 16:01
Re: Initdb-time block size specification 📎 David Christensen 16:13
Re: Add tracking of backend memory allocated to pg_stat_activity 📎 John Morris 16:18
Re: [17] CREATE SUBSCRIPTION ... SERVER Jeff Davis 16:50
Re: [17] CREATE SUBSCRIPTION ... SERVER Jeff Davis 16:52
Re: Replace some cstring_to_text to cstring_to_text_with_len Ranier Vilela 16:57
Re: Use virtual tuple slot for Unique node Denis Smirnov 17:12
Re: Replace some cstring_to_text to cstring_to_text_with_len Dagfinn Ilmari Mannsåker 17:23
Re: [17] CREATE SUBSCRIPTION ... SERVER Jeff Davis 17:28
Re: Use virtual tuple slot for Unique node 📎 Денис Смирнов 17:44
Re: Eliminate redundant tuple visibility check in vacuum Robert Haas 18:03
Re: Improve heapgetpage() performance, overhead from serializable Muhammad Malik 18:12
Re: RFC: logical publication via inheritance root? 📎 Jacob Champion 18:16
Re: Replace some cstring_to_text to cstring_to_text_with_len 📎 Dagfinn Ilmari Mannsåker 18:28
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 18:50
Re: UUID v7 Andrey M. Borodin 18:51
Suppressing compiler warning on Debian 12/gcc 12.2.0 Bruce Momjian 19:25
Re: Document efficient self-joins / UPDATE LIMIT techniques. Corey Huinker 19:30
Re: [17] CREATE SUBSCRIPTION ... SERVER Joe Conway 21:17
Re: Statistics Import and Export Corey Huinker 21:18
Re: SQL:2011 application time 📎 Paul Jungwirth 21:26
Re: Reducing connection overhead in pg_upgrade compat check phase 📎 Daniel Gustafsson 21:34
Show inline comments from pg_hba lines in the pg_hba_file_rules view 📎 Jim Jones 22:01
Re: Eliminate redundant tuple visibility check in vacuum 📎 Melanie Plageman 22:29
Re: Eliminate redundant tuple visibility check in vacuum Melanie Plageman 22:35
Re: trying again to get incremental backup David Steele 22:50

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

Browse Archives

Prev | Next