pgsql-hackers since 2023-08-20 22:26

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

Thread	Author	Time
Re: POC, WIP: OR-clause support for indexes	Peter Geoghegan	22:26
Re: POC, WIP: OR-clause support for indexes	Peter Geoghegan	22:42
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue 📎	Michael Paquier	23:57

Aug. 21, 2023

Thread	Author	Time
Re: Adding a LogicalRepWorker type field 📎	Peter Smith	00:04
Re: PostgreSQL 16 RC1 + GA release dates	Jonathan S. Katz	01:09
Re: Extract numeric filed in JSONB more effectively 📎	Andy Fan	01:31
Re: Rethink the wait event names for postgres_fdw, dblink and etc 📎	Masahiro Ikeda	02:04
Re: Fix pg_stat_reset_single_table_counters function	Kyotaro Horiguchi	02:33
Re: Extract numeric filed in JSONB more effectively	Chapman Flack	03:19
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	03:20
Support run-time partition pruning for hash join 📎	Richard Guo	03:48
Re: Make --help output fit within 80 columns per line	Masahiro Ikeda	04:08
Re: Fix pg_stat_reset_single_table_counters function 📎	Masahiro Ikeda	04:32
Re: Fix pg_stat_reset_single_table_counters function	Michael Paquier	04:34
Re: Fix pg_stat_reset_single_table_counters function	Masahiro Ikeda	04:38
Re: Make all Perl warnings fatal 📎	Peter Eisentraut	06:20
Re: Doc limitation update proposal: include out-of-line OID usage per TOAST-ed columns 📎	Gurjeet Singh	06:32
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	07:16
Re: Remove distprep	Michael Paquier	07:24
Re: dubious warning: FORMAT JSON has no effect for json and jsonb types	Amit Langote	07:33
Re: WIP: new system catalog pg_wait_event	Drouvot, Bertrand	07:33
Re: Pgoutput not capturing the generated columns	Rajendra Kumar Dangwal	07:45
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication	Peter Smith	07:56
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎	Peter Smith	07:58
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500 📎	Jian Guo	08:16
Re: pg_upgrade - typo in verbose log	Daniel Gustafsson	08:21
Re: [PATCH] Add function to_oct	Dean Rasheed	08:31
Re: UUID v7 📎	Andrey M. Borodin	08:42
Re: [dsm] comment typo	Daniel Gustafsson	09:16
Optimize Arm64 crc32 implementation in PostgreSQL	Xiang Gao	09:32
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	09:45
Re: Fix typo in src/interfaces/libpq/po/zh_CN.po	Daniel Gustafsson	09:59
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Zhijie Hou (Fujitsu)	10:12
Re: [dsm] comment typo	Junwang Zhao	10:15
Re: Adding a LogicalRepWorker type field	Amit Kapila	10:18
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Richard Guo	10:39
Re: Fix typo in src/interfaces/libpq/po/zh_CN.po	Zhang Mingli	10:54
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Tomas Vondra	10:56
Re: Extract numeric filed in JSONB more effectively	Andy Fan	10:58
Re: postgres_fdw: wrong results with self join + enable_nestloop off	Etsuro Fujita	11:16
Re: postgres_fdw: wrong results with self join + enable_nestloop off	Etsuro Fujita	11:27
Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) 📎	torikoshia	12:04
Re: Oversight in reparameterize_path_by_child leading to executor crash	Ashutosh Bapat	12:23
Reproducibility (Re: Remove distprep)	Christoph Berg	12:23
Re: Support run-time partition pruning for hash join	Andy Fan	12:34
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	13:02
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:04
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	13:05
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	13:06
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue	Robert Haas	13:27
Re: BUG #18059: Unexpected error 25001 in stored procedure	Robert Haas	13:32
Re: postgres_fdw: wrong results with self join + enable_nestloop off	Önder Kalacı	13:34
Re: meson: pgxs Makefile.global differences	Andrew Dunstan	15:33
Re: meson: pgxs Makefile.global differences	Peter Eisentraut	15:43
Re: meson: pgxs Makefile.global differences	Tristan Partin	15:48
Re: Make all Perl warnings fatal	Andrew Dunstan	15:51
Re: [17] Special search_path names "!pg_temp" and "!pg_catalog"	Jeff Davis	16:08
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue	Jacob Champion	17:49
Re: cataloguing NOT NULL constraints 📎	Alvaro Herrera	18:01
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Robert Haas	19:14
Re: [PATCH] Add function to_oct 📎	Nathan Bossart	19:15
C function to return double precision[][]	Markur Sens	19:31
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Jeff Davis	19:44
Re: Optimize Arm64 crc32 implementation in PostgreSQL	Nathan Bossart	20:04
Re: C function to return double precision[][]	Joe Conway	20:04
Re: should frontend tools use syncfs() ?	Robert Haas	20:08
Re: [PATCH] Add function to_oct	Dean Rasheed	20:10
Re: SLRUs in the main buffer pool - Page Header definitions	Robert Haas	20:23
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Tom Lane	20:48
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }	Jeff Davis	21:32
Re: PG 16 draft release notes ready 📎	Bruce Momjian	21:58
Re: PG 16 draft release notes ready	Bruce Momjian	22:07
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue	Michael Paquier	23:04
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue 📎	Michael Paquier	23:22
Re: should frontend tools use syncfs() ?	Michael Paquier	23:25
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue	Isaac Morland	23:43
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue	Jacob Champion	23:44
Re: should frontend tools use syncfs() ?	Michael Paquier	23:56
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue	Michael Paquier	23:58

Aug. 22, 2023

Thread	Author	Time
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	00:31
Re: should frontend tools use syncfs() ?	Nathan Bossart	01:44
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	01:49
Re: should frontend tools use syncfs() ?	Michael Paquier	01:50
Re: should frontend tools use syncfs() ? 📎	Nathan Bossart	02:06
Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500	Jian Guo	02:35
Re: Oversight in reparameterize_path_by_child leading to executor crash	Richard Guo	03:12
Re: Extract numeric filed in JSONB more effectively 📎	Andy Fan	03:14
Re: [PATCH] Add function to_oct	John Naylor	03:17
Re: should frontend tools use syncfs() ?	Michael Paquier	03:53
Re: Make all Perl warnings fatal	Michael Paquier	04:05
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	04:18
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	04:45
Re: pg_rewind WAL segments deletion pitfall	Michael Paquier	05:32
Re: PG 16 draft release notes ready	David Rowley	05:36
Re: DecodeInterval fixes	Michael Paquier	05:39
Re: Testing autovacuum wraparound (including failsafe)	Michael Paquier	05:49
Re: Extract numeric filed in JSONB more effectively	Andy Fan	05:54
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:01
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	06:01
Re: Support run-time partition pruning for hash join	David Rowley	06:38
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Amit Kapila	06:48
Re: PG 16 draft release notes ready	Pavel Luzanov	07:02
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	ajitpostgres awekar	07:14
Re: Report planning memory in EXPLAIN ANALYZE	jian he	07:46
Convert encrypted SSL test keys to PKCS#8 format 📎	Peter Eisentraut	08:07
Re: Adding a LogicalRepWorker type field	Amit Kapila	08:24
Re: [PoC] pg_upgrade: allow to upgrade publisher node	Peter Smith	08:52
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	09:26
list of acknowledgments for PG16	Peter Eisentraut	09:33
Re: Support run-time partition pruning for hash join	Richard Guo	09:43
Re: add timing information to pg_upgrade	Peter Eisentraut	09:49
Re: Support run-time partition pruning for hash join	Richard Guo	09:51
Re: persist logical slots to disk during shutdown checkpoint	Amit Kapila	10:12
Re: list of acknowledgments for PG16	Alvaro Herrera	10:41
Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression	Vik Fearing	11:01
Re: list of acknowledgments for PG16	Vik Fearing	12:01
Re: Direct I/O 📎	Peter Eisentraut	12:15
Re: Extract numeric filed in JSONB more effectively	Chapman Flack	12:16
Fix the error message when failing to restore the snapshot 📎	Zhijie Hou (Fujitsu)	12:39
Re: list of acknowledgments for PG16	Alvaro Herrera	13:05
Re: Fix the error message when failing to restore the snapshot	Amit Kapila	13:07
Re: Make all Perl warnings fatal	Andrew Dunstan	13:11
Re: Make all Perl warnings fatal	Alvaro Herrera	13:20
Re: list of acknowledgments for PG16	Tom Lane	13:29
Re: list of acknowledgments for PG16	Vik Fearing	13:40
Make error messages about WAL segment size more consistent 📎	Peter Eisentraut	13:44
Re: list of acknowledgments for PG16	Tom Lane	13:44
Re: list of acknowledgments for PG16	Vik Fearing	13:48
Re: Make --help output fit within 80 columns per line	torikoshia	13:57
Re: list of acknowledgments for PG16	Joe Conway	14:03
Re: add timing information to pg_upgrade	Nathan Bossart	14:06
Re: [PATCH] Add function to_oct	Peter Eisentraut	14:20
Re: list of acknowledgments for PG16	Peter Eisentraut	14:24
Re: Make error messages about WAL segment size more consistent	Aleksander Alekseev	14:26
Re: [PATCH] Add function to_oct	Nathan Bossart	14:26
Re: Oversight in reparameterize_path_by_child leading to executor crash	Tom Lane	14:39
Re: persist logical slots to disk during shutdown checkpoint	Ashutosh Bapat	14:53
Re: [PATCH] Add function to_oct	Peter Eisentraut	14:57
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Tom Lane	15:43
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Ashutosh Bapat	16:07
Re: DecodeInterval fixes	Jacob Champion	16:58
Re: should frontend tools use syncfs() ? 📎	Nathan Bossart	17:11
Re: pgsql: Allow tailoring of ICU locales with custom rules	Jeff Davis	17:25
Re: Make all Perl warnings fatal	Andrew Dunstan	18:46
Re: Convert encrypted SSL test keys to PKCS#8 format	Jacob Champion	19:02
Re: PG 16 draft release notes ready 📎	Bruce Momjian	19:14
Re: list of acknowledgments for PG16	Bruce Momjian	19:26
subscription/015_stream sometimes breaks	Thomas Munro	20:21
Re: PG 16 draft release notes ready	Jeff Davis	20:42
Re: Direct I/O	Peter Geoghegan	20:48
Re: subscription/015_stream sometimes breaks	Thomas Munro	20:54
Re: Prevent psql \watch from running queries that return no rows 📎	Greg Sabino Mullane	21:23
Re: BUG #18059: Unexpected error 25001 in stored procedure	Tom Lane	21:29
Re: [17] collation provider "builtin" 📎	Jeff Davis	21:32
Re: Faster "SET search_path"	Jeff Davis	21:45
Re: initdb caching during tests	Daniel Gustafsson	21:47
Re: Prevent psql \watch from running queries that return no rows	Daniel Gustafsson	21:49
Re: Adding a LogicalRepWorker type field	Peter Smith	23:10

Aug. 23, 2023

Thread	Author	Time
Re: Make --help output fit within 80 columns per line	Masahiro Ikeda	00:45
False "pg_serial": apparent wraparound” in logs 📎	Imseih (AWS), Sami	00:55
Re: initdb caching during tests	Andres Freund	01:17
Re: Support run-time partition pruning for hash join	Andy Fan	01:19
pg_upgrade - a function parameter shadows global 'new_cluster' 📎	Peter Smith	01:28
Re: Support run-time partition pruning for hash join	Andy Fan	01:41
Re: PG 16 draft release notes ready	Bruce Momjian	02:23
Re: Using defines for protocol characters	Nathan Bossart	02:24
RE: subscription/015_stream sometimes breaks	Zhijie Hou (Fujitsu)	02:27
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:43
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:44
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:45
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	02:58
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎	Hayato Kuroda (Fujitsu)	02:59
RE: [PoC] pg_upgrade: allow to upgrade publisher node	Hayato Kuroda (Fujitsu)	03:00
Re: subscription/015_stream sometimes breaks	vignesh C	03:16
Re: Doc limitation update proposal: include out-of-line OID usage per TOAST-ed columns	John Naylor	04:02
Re: Extending SMgrRelation lifetimes 📎	Thomas Munro	04:54
Re: Direct I/O	Thomas Munro	04:57
RE: persist logical slots to disk during shutdown checkpoint 📎	Hayato Kuroda (Fujitsu)	05:10
Re: persist logical slots to disk during shutdown checkpoint 📎	vignesh C	05:30
Re: Oversight in reparameterize_path_by_child leading to executor crash 📎	Richard Guo	05:37
Re: Synchronizing slots from primary to standby	shveta malik	05:38
RE: subscription/015_stream sometimes breaks 📎	Zhijie Hou (Fujitsu)	05:56
Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc? 📎	Andres Freund	06:58
Re: list of acknowledgments for PG16 📎	Denis Laxalde	07:13
Re: pg_upgrade - a function parameter shadows global 'new_cluster'	Daniel Gustafsson	08:00
Re: subscription/015_stream sometimes breaks 📎	Alvaro Herrera	08:00
Re: initdb caching during tests	Daniel Gustafsson	08:10
Re: MERGE ... RETURNING 📎	Dean Rasheed	08:20
Re: [dsm] comment typo	Daniel Gustafsson	08:28
Re: subscription/015_stream sometimes breaks	Alvaro Herrera	08:44
RE: persist logical slots to disk during shutdown checkpoint 📎	Hayato Kuroda (Fujitsu)	08:51
Re: persist logical slots to disk during shutdown checkpoint	vignesh C	08:57
Re: pg_rewind WAL segments deletion pitfall	torikoshia	09:04
Re: EBCDIC sorting as a use case for ICU rules	Peter Eisentraut	09:30
Re: Synchronizing slots from primary to standby 📎	shveta malik	10:07
Re: PostgreSQL 16 release announcement draft	jian he	10:20
Re: Remove distprep 📎	Peter Eisentraut	10:46
Re: Synchronizing slots from primary to standby	Dilip Kumar	10:51
Re: MERGE ... RETURNING 📎	Dean Rasheed	10:58

Browse Archives

Prev | Next