pgsql-hackers since 2023-08-15 22:49

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)

Browse Archives

Prev | Next

Aug. 15, 2023

Thread Author Time
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Michael Paquier 22:49
Re: Avoid a potential unstable test case: xmlmap.sql Andy Fan 23:03
Re: should frontend tools use syncfs() ? Michael Paquier 23:10
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication Peter Smith 23:18

Aug. 16, 2023

Thread Author Time
Re: pg_logical_emit_message() misses a XLogFlush() Andres Freund 00:33
Re: Test case for parameterized remote path in postgres_fdw Richard Guo 00:41
Re: pg_logical_emit_message() misses a XLogFlush() Tomas Vondra 01:20
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 03:07
Re: [PATCH] Add function to_oct John Naylor 03:35
Re: pg_logical_emit_message() misses a XLogFlush() Michael Paquier 03:37
Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication 📎 Peter Smith 03:53
Re: pg_logical_emit_message() misses a XLogFlush() Andres Freund 04:13
Re: pg_logical_emit_message() misses a XLogFlush() Andres Freund 04:16
Re: remaining sql/json patches Amit Langote 04:27
Re: WIP: new system catalog pg_wait_event Drouvot, Bertrand 05:04
Re: Memory consumed by child SpecialJoinInfo in partitionwise join planning 📎 Ashutosh Bapat 05:28
Re: Synchronizing slots from primary to standby 📎 Ajin Cherian 05:34
some code cleanup in index.c and indexcmds.c 📎 Peter Eisentraut 06:04
Re: Extract numeric filed in JSONB more effectively 📎 Andy Fan 06:12
Re: WIP: new system catalog pg_wait_event Michael Paquier 06:22
Re: Remove distprep Peter Eisentraut 06:25
Re: Extract numeric filed in JSONB more effectively 📎 Andy Fan 06:27
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Peter Eisentraut 06:51
Re: Should the archiver process always make sure that the timeline history files exist in the archive? 📎 Jimmy Yih 07:33
Fix typo in src/interfaces/libpq/po/zh_CN.po Zhang Mingli 07:34
Re: pg_logical_emit_message() misses a XLogFlush() 📎 Michael Paquier 07:51
Re: Return value of pg_promote() Michael Paquier 08:02
Re: cataloguing NOT NULL constraints Peter Eisentraut 08:02
Re: pgbench - adding pl/pgsql versions of tests Fabien COELHO 08:06
regexp_replace weirdness amounts to a bug? Erik Rijkers 09:09
Re: regexp_replace weirdness amounts to a bug? Malthe 09:09
Re: Normalization of utility queries in pg_stat_statements jian he 09:11
Add 'worker_type' to pg_stat_subscription 📎 Peter Smith 09:14
Re: Allow parallel plan for referential integrity checks? 📎 Juan José Santamaría Flecha 09:18
Re: postgres_fdw: wrong results with self join + enable_nestloop off Etsuro Fujita 09:22
Re: Test case for parameterized remote path in postgres_fdw Etsuro Fujita 09:45
Re: pg_logical_emit_message() misses a XLogFlush() Tomas Vondra 10:01
Re: regexp_replace weirdness amounts to a bug? Alvaro Herrera 10:07
Re: cataloguing NOT NULL constraints 📎 Peter Eisentraut 10:09
Re: Todo: Teach planner to evaluate multiple windows in the optimal order John Naylor 10:24
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 10:25
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 John Naylor 11:04
Re: Performance degradation on concurrent COPY into a single relation in PG16. Alvaro Herrera 11:15
Re: walsender "wakeup storm" on PG16, likely because of bc971f4025c (Optimize walsender wake up logic using condition variables) Antonin Houska 11:20
RE: [PoC] pg_upgrade: allow to upgrade publisher node Zhijie Hou (Fujitsu) 11:21
Re: WIP: new system catalog pg_wait_event 📎 Drouvot, Bertrand 11:43
Re: WIP: new system catalog pg_wait_event Michael Paquier 12:08
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Shaun Thomas 13:26
Re: Handle infinite recursion in logical replication setup Peter Eisentraut 13:50
dubious warning: FORMAT JSON has no effect for json and jsonb types Peter Eisentraut 13:54
Re: postgres_fdw: wrong results with self join + enable_nestloop off Önder Kalacı 13:58
Re: [PATCH] Add function to_oct 📎 Nathan Bossart 14:24
Re: Fix typo in src/interfaces/libpq/po/zh_CN.po Peter Eisentraut 14:24
Re: logical decoding and replication of sequences, take 2 📎 Tomas Vondra 14:26
Re: dubious warning: FORMAT JSON has no effect for json and jsonb types Merlin Moncure 14:59
Re: should frontend tools use syncfs() ? Nathan Bossart 15:17
Re: should frontend tools use syncfs() ? Nathan Bossart 15:23
Re: Replace known_assigned_xids_lck by memory barrier 📎 Michail Nikolaev 15:30
Re: Extract numeric filed in JSONB more effectively jian he 16:32
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Jeff Davis 17:44
Re: Replace known_assigned_xids_lck by memory barrier 📎 Nathan Bossart 18:32
Re: Replace known_assigned_xids_lck by memory barrier Michail Nikolaev 19:29
Re: Using defines for protocol characters 📎 Nathan Bossart 19:29
PostgreSQL 16 RC1 + GA release dates Jonathan S. Katz 19:48
Re: Replace known_assigned_xids_lck by memory barrier 📎 Nathan Bossart 20:07
Re: run pgindent on a regular basis / scripted manner Peter Geoghegan 20:15
Re: Faster "SET search_path" Jeff Davis 22:09
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue 📎 Jacob Champion 22:11
Re: Rename ExtendedBufferWhat in 16? Andres Freund 22:49
Re: Performance degradation on concurrent COPY into a single relation in PG16. Andres Freund 22:54
Re: walsender "wakeup storm" on PG16, likely because of bc971f4025c (Optimize walsender wake up logic using condition variables) Thomas Munro 22:58
Re: Would it be possible to backpatch Close support in libpq (28b5726) to PG16? Joe Conway 23:20
Re: Rename ExtendedBufferWhat in 16? Thomas Munro 23:31
Re: Rename ExtendedBufferWhat in 16? Peter Geoghegan 23:33

Aug. 17, 2023

Thread Author Time
Re: Using defines for protocol characters Michael Paquier 00:31
Re: Return value of pg_promote() Michael Paquier 00:37
Re: Rename ExtendedBufferWhat in 16? Andres Freund 00:42
Re: pg_logical_emit_message() misses a XLogFlush() Michael Paquier 01:15
Re: pgbench: allow to exit immediately when any client is aborted Tatsuo Ishii 01:37
Re: WIP: new system catalog pg_wait_event Masahiro Ikeda 01:53
Re: WIP: new system catalog pg_wait_event Michael Paquier 01:57
Re: should frontend tools use syncfs() ? Michael Paquier 02:15
Re: WIP: new system catalog pg_wait_event Masahiro Ikeda 02:35
Re: PG 16 draft release notes ready Bruce Momjian 02:36
Re: PG 16 draft release notes ready Bruce Momjian 02:36
Re: Rename ExtendedBufferWhat in 16? 📎 Thomas Munro 03:35
Re: should frontend tools use syncfs() ? Michael Paquier 03:50
Re: Minor configure/meson cleanup Thomas Munro 04:23
Re: Extending SMgrRelation lifetimes 📎 Thomas Munro 05:10
Query regarding sharing data directory Harsh N Bhatt 05:21
Re: New WAL record to detect the checkpoint redo location Michael Paquier 05:22
Re: [PATCH] Add function to_oct John Naylor 05:35
Re: PG 16 draft release notes ready Pavel Luzanov 05:37
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 05:43
Fix an entry in wait_event_names.txt 📎 Drouvot, Bertrand 05:49
Re: WIP: new system catalog pg_wait_event 📎 Drouvot, Bertrand 05:51
Re: WIP: new system catalog pg_wait_event Drouvot, Bertrand 05:53
Re: WIP: new system catalog pg_wait_event Drouvot, Bertrand 05:57
Re: Synchronizing slots from primary to standby Drouvot, Bertrand 06:14
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 06:18
Re: Fix an entry in wait_event_names.txt Masahiro Ikeda 06:25
Re: Synchronizing slots from primary to standby shveta malik 06:25
Re: Allow parallel plan for referential integrity checks? Frédéric Yhuel 07:32
Re: WIP: new system catalog pg_wait_event Masahiro Ikeda 07:37
Re: New WAL record to detect the checkpoint redo location Dilip Kumar 07:41
Re: pg_upgrade - typo in verbose log Peter Smith 08:09
Re: [PoC] pg_upgrade: allow to upgrade publisher node Peter Smith 08:39
Re: [PATCH] Add native windows on arm64 support Anthony Roberts 08:41
Re: Extract numeric filed in JSONB more effectively 📎 Andy Fan 09:07
Re: POC, WIP: OR-clause support for indexes 📎 a.rybakina 10:08
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 10:18
Re: POC, WIP: OR-clause support for indexes 📎 a.rybakina 10:20
Re: Synchronizing slots from primary to standby 📎 shveta malik 10:39
Re: meson: Non-feature feature options 📎 Nazir Bilal Yavuz 11:18
Re: Allow parallel plan for referential integrity checks? 📎 Frédéric Yhuel 12:00
Re: walsender "wakeup storm" on PG16, likely because of bc971f4025c (Optimize walsender wake up logic using condition variables) Antonin Houska 12:25
Re: [PoC] pg_upgrade: allow to upgrade publisher node Masahiko Sawada 12:36
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 13:31
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 13:35
Re: logical decoding and replication of sequences, take 2 Ashutosh Bapat 13:43
Re: Allow parallel plan for referential integrity checks? Frédéric Yhuel 13:50
Re: RFC: Logging plan of the running query 📎 torikoshia 14:02
Allow Index AM scan API to access information about LIMIT clause Peifeng Qiu 14:11
Re: Extending SMgrRelation lifetimes Robert Haas 14:30
BUG #18059: Unexpected error 25001 in stored procedure PG Bug reporting form 14:35
Re: run pgindent on a regular basis / scripted manner Nathan Bossart 14:40
Re: PG 16 draft release notes ready Bruce Momjian 14:59
Re: [PATCH] Add function to_oct 📎 Nathan Bossart 15:26
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Stephen Frost 16:01
Re: Using defines for protocol characters 📎 Nathan Bossart 16:13
Re: Using defines for protocol characters Robert Haas 16:22
Re: Using defines for protocol characters Dave Cramer 16:34
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Jacob Champion 16:42
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Stephen Frost 16:46
Re: Using defines for protocol characters Nathan Bossart 16:52
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue 📎 Jacob Champion 16:53
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Robert Haas 19:23
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Stephen Frost 19:29
meson: pgxs Makefile.global differences Andrew Dunstan 19:32
Re: meson: pgxs Makefile.global differences Tristan Partin 19:45
Re: Extract numeric filed in JSONB more effectively Chapman Flack 20:30
Re: meson: pgxs Makefile.global differences Andres Freund 20:51
Re: meson: pgxs Makefile.global differences Andrew Dunstan 20:56
Re: meson: pgxs Makefile.global differences Tristan Partin 20:56
Re: [PATCH] Add native windows on arm64 support Michael Paquier 22:28
Re: WIP: new system catalog pg_wait_event Michael Paquier 22:37
Re: Fix an entry in wait_event_names.txt Michael Paquier 23:19
Re: Use of additional index columns in rows filtering Jeff Davis 23:29
Re: Normalization of utility queries in pg_stat_statements Michael Paquier 23:31
Re: Logging of matching pg_hba.conf entry during auth skips trust auth, potential security issue Michael Paquier 23:49
Re: New WAL record to detect the checkpoint redo location Michael Paquier 23:54

Aug. 18, 2023

Thread Author Time
Re: Ignore 2PC transaction GIDs in query jumbling 📎 Michael Paquier 00:18
Re: pg_upgrade - typo in verbose log Michael Paquier 00:47
Re: Query regarding sharing data directory Michael Paquier 01:03
Re: Remove distprep Michael Paquier 01:11
Re: Extract numeric filed in JSONB more effectively Andy Fan 01:14
Re: pg_upgrade - typo in verbose log Peter Smith 01:22
Re: Remove distprep Andres Freund 02:39
Re: [PoC] pg_upgrade: allow to upgrade publisher node Amit Kapila 02:47
Re: Extract numeric filed in JSONB more effectively Chapman Flack 02:55
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 03:12
Re: Adding a LogicalRepWorker type field Amit Kapila 03:20
Rethink the wait event names for postgres_fdw, dblink and etc 📎 Masahiro Ikeda 03:27
Re: Adding a LogicalRepWorker type field shveta malik 03:49
Re: [PoC] pg_upgrade: allow to upgrade publisher node Peter Smith 03:51
Re: New WAL record to detect the checkpoint redo location Dilip Kumar 04:42
Re: Extract numeric filed in JSONB more effectively jian he 05:02
Re: logical decoding and replication of sequences, take 2 Amit Kapila 05:07
Re: Rethink the wait event names for postgres_fdw, dblink and etc Michael Paquier 05:11
Re: dubious warning: FORMAT JSON has no effect for json and jsonb types Peter Eisentraut 05:59
Re: pg_rewind WAL segments deletion pitfall torikoshia 06:40
Re: [PoC] pg_upgrade: allow to upgrade publisher node Peter Smith 07:02
Re: Extract numeric filed in JSONB more effectively 📎 Andy Fan 07:41
Re: SLRUs in the main buffer pool - Page Header definitions 📎 Bagga, Rishu 08:12
RE: Adding a LogicalRepWorker type field Zhijie Hou (Fujitsu) 08:16
Re: Remove distprep Christoph Berg 08:22
Re: WIP: new system catalog pg_wait_event 📎 Drouvot, Bertrand 08:56
Re: WIP: new system catalog pg_wait_event Drouvot, Bertrand 08:57
[dsm] comment typo Junwang Zhao 09:10
PostgreSQL 17 alpha RPMs Devrim Gündüz 09:46
Re: WIP: new system catalog pg_wait_event Michael Paquier 10:28
Re: Ignore 2PC transaction GIDs in query jumbling Dagfinn Ilmari Mannsåker 10:31
Re: WIP: new system catalog pg_wait_event Michael Paquier 10:31
Re: logical decoding and replication of sequences, take 2 Amit Kapila 10:58
Re: Allow parallel plan for referential integrity checks? Juan José Santamaría Flecha 10:58
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Peter Eisentraut 12:25
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 13:32
RE: [PoC] pg_upgrade: allow to upgrade publisher node Hayato Kuroda (Fujitsu) 13:34
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:43
RE: [PoC] pg_upgrade: allow to upgrade publisher node 📎 Hayato Kuroda (Fujitsu) 13:51
Re: pg_upgrade fails with in-place tablespace 📎 Rui Zhao 14:47
Re: should frontend tools use syncfs() ? 📎 Nathan Bossart 16:01
Re: SLRUs in the main buffer pool - Page Header definitions Nathan Bossart 16:15
Re: pgbench - adding pl/pgsql versions of tests Hannu Krosing 17:34
Re: Extract numeric filed in JSONB more effectively Chapman Flack 18:50
Re: Extract numeric filed in JSONB more effectively Chapman Flack 19:08
Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } Jeff Davis 20:11
Re: Extract numeric filed in JSONB more effectively Chapman Flack 21:02
[17] Special search_path names "!pg_temp" and "!pg_catalog" 📎 Jeff Davis 21:44

Browse Archives

Prev | Next