pgsql-hackers since 2022-03-28 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

March 28, 2022

Thread	Author	Time
Re: SQL/JSON: functions	Andrew Dunstan	00:21
Re: SQL/JSON: functions	Andres Freund	00:50
Re: [PATCH] Accept IP addresses in server certificate SANs	Andres Freund	00:54
Re: Corruption during WAL replay	Kyotaro Horiguchi	00:59
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	01:01
Re: SQL/JSON: functions	Andrew Dunstan	01:32
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Thomas Munro	01:34
RE: Logical replication timeout problem	[email protected]	01:55
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors 📎	Yugo NAGATA	02:29
Re: pg_stat_get_replication_slot() marked not strict, crashes	Amit Kapila	02:58
Fix pg_waldump documentation about block option 📎	Japin Li	03:02
Re: A test for replay of regression tests	Thomas Munro	03:11
Re: Document atthasmissing default optimization avoids verification table scan	David G. Johnston	03:12
Re: Add a pg_get_query_def function (was Re: Deparsing rewritten query) 📎	Julien Rouhaud	03:12
Re: Add pg_freespacemap extension sql test	Michael Paquier	03:12
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	03:17
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations 📎	Peter Geoghegan	03:24
Re: Fix pg_waldump documentation about block option	Thomas Munro	03:28
Re: Invalid comment in ParallelQueryMain	Julien Rouhaud	03:31
Re: pgbench: using prepared BEGIN statement in a pipeline could cause an error 📎	Yugo NAGATA	03:33
Re: Assert in pageinspect with NULL pages	Michael Paquier	03:39
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors 📎	Yugo NAGATA	03:48
Re: pg_stat_get_replication_slot() marked not strict, crashes	Andres Freund	04:09
Re: pg_stat_get_replication_slot() marked not strict, crashes	Tom Lane	04:17
Re: Preventing indirection for IndexPageGetOpaque for known-size page special areas	Michael Paquier	04:31
Re: pg_stat_get_replication_slot() marked not strict, crashes	Masahiko Sawada	04:42
Re: pg_stat_get_replication_slot() marked not strict, crashes	Andres Freund	04:54
Re: logical decoding and replication of sequences	Amit Kapila	05:29
Re: Race conditions in 019_replslot_limit.pl	Andres Freund	05:37
RE: Failed transaction statistics to measure the logical replication progress	[email protected]	06:10
RE: Logical replication timeout problem 📎	[email protected]	06:11
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎	Dilip Kumar	06:18
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	06:25
Re: Logical replication timeout problem	Amit Kapila	06:27
Re: pg_stat_get_replication_slot() marked not strict, crashes	Amit Kapila	06:34
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	06:50
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	06:53
Re: logical replication empty transactions	Amit Kapila	07:07
Re: DSA failed to allocate memory 📎	Dongming Liu	07:13
Re: generic plans and "initial" pruning 📎	Amit Langote	07:17
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	07:20
Re: Allow file inclusion in pg_hba and pg_ident files 📎	Michael Paquier	07:22
Re: generic plans and "initial" pruning 📎	Amit Langote	07:28
Re: Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	07:43
Re: DSA failed to allocate memory	Thomas Munro	07:53
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Alvaro Herrera	07:57
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	08:02
Re: Add 64-bit XIDs into PostgreSQL 15 📎	Maxim Orlov	08:15
Re: standby recovery fails (tablespace related) (tentative patch and discussion) 📎	Kyotaro Horiguchi	08:20
Re: Allow file inclusion in pg_hba and pg_ident files 📎	Julien Rouhaud	08:33
Re: [PATCH] Accept IP addresses in server certificate SANs 📎	Daniel Gustafsson	09:17
Re: [EXTERNAL] Re: Add non-blocking version of PQcancel	Jelte Fennema	09:28
Re: TRAP: FailedAssertion("HaveRegisteredOrActiveSnapshot()", File: "toast_internals.c", Line: 670, PID: 19403)	Kyotaro Horiguchi	09:36
Re: Summary Sort workers Stats in EXPLAIN ANALYZE 📎	Jian Guo	09:55
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Aleksander Alekseev	10:46
Re: support for MERGE 📎	Alvaro Herrera	11:00
Re: SQL/JSON: functions	Andrew Dunstan	11:04
RE: logical replication empty transactions 📎	[email protected]	12:21
Re: Add LZ4 compression in pg_dump	Robert Haas	12:36
Re: On login trigger: take three	a.sokolov	12:57
Re: document the need to analyze partitioned tables	Tomas Vondra	13:05
Re: Document atthasmissing default optimization avoids verification table scan	Robert Haas	13:29
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tom Lane	13:33
Re: SQL/JSON: functions	Tom Lane	13:35
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Peter Eisentraut	13:45
Re: Document atthasmissing default optimization avoids verification table scan	James Coleman	13:54
Re: identifying unrecognized node type errors	Ashutosh Bapat	14:17
Re: SQL/JSON: functions	Andrew Dunstan	14:30
Re: [WIP] Allow pg_upgrade to copy segments of the same relfilenode in parallel	Justin Pryzby	14:33
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Robert Haas	14:37
Re: role self-revocation	Stephen Frost	14:51
Re: SQL/JSON: functions	Nikola Ivanov	15:05
Re: support for MERGE	Alvaro Herrera	15:06
Re: Preventing indirection for IndexPageGetOpaque for known-size page special areas 📎	Matthias van de Meent	15:09
Re: Add a pg_get_query_def function (was Re: Deparsing rewritten query)	Tom Lane	15:20
Re: SQL/JSON: functions	Andrew Dunstan	15:25
Re: SQL/JSON: functions	Andres Freund	15:39
Re: Document atthasmissing default optimization avoids verification table scan	Robert Haas	15:44
Re: Add a pg_get_query_def function (was Re: Deparsing rewritten query)	Julien Rouhaud	15:48
Re: SQL/JSON: functions	Nikola Ivanov	15:50
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Robert Haas	16:17
Re: pgsql: Add 'basebackup_to_shell' contrib module.	Magnus Hagander	16:27
Re: fixing a few backup compression goofs	Robert Haas	16:28
Re: multithreaded zstd backup compression for client and server	Robert Haas	16:37
Re: multithreaded zstd backup compression for client and server	Dagfinn Ilmari Mannsåker	16:52
Re: multithreaded zstd backup compression for client and server	Robert Haas	16:55
Re: multithreaded zstd backup compression for client and server 📎	Robert Haas	16:57
Re: On login trigger: take three	Andres Freund	17:10
Re: Assert in pageinspect with NULL pages	Maxim Orlov	17:29
Re: multithreaded zstd backup compression for client and server 📎	Robert Haas	17:32
Re: Estimating HugePages Requirements? 📎	Nathan Bossart	17:35
Re: Extensible Rmgr for Table AMs	Andres Freund	18:00
Re: role self-revocation	Robert Haas	18:31
Re: SQL/JSON: functions 📎	Nikola Ivanov	18:31
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	18:31
Re: Proposal: Support custom authentication methods using hooks	Stephen Frost	18:38
Re: Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	18:42
Re: Patch: Code comments: why some text-handling functions are leakproof	Greg Stark	18:55
Re: SQL/JSON: functions	Andrew Dunstan	18:57
Re: Add psql command to list constraints	Greg Stark	18:59
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Robert Haas	19:08
Re: [PATCH] Add extra statistics to explain for Nested Loop	Greg Stark	19:09
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	19:11
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	19:14
Re: Accommodate startup process in a separate ProcState array slot instead of in MaxBackends slots. 📎	Robert Haas	19:16
Re: SQL/JSON: functions	Andres Freund	19:27
CFBot has failures on 027_stream_regress for a number of patches	Greg Stark	19:28
Re: [PATCH v2] use has_privs_for_role for predefined roles	Joe Conway	19:31
Re: Add checkpoint and redo LSN to LogCheckpointEnd log message	Greg Stark	19:31
Re: SQL/JSON: functions	Tom Lane	19:36
Re: [PATCH] Full support for index LP_DEAD hint bits on standby	Greg Stark	19:40
Re: [PATCH] Accept IP addresses in server certificate SANs	Greg Stark	19:43
Re: SQL/JSON: JSON_TABLE	Greg Stark	19:48
Re: CFBot has failures on 027_stream_regress for a number of patches	Andres Freund	19:49
Re: refactoring basebackup.c (zstd workers) 📎	Robert Haas	19:50
Re: [PATCH v2] use has_privs_for_role for predefined roles	Robert Haas	19:56
Re: [RFC] building postgres with meson -v8	Andres Freund	19:59
Re: [PATCH v2] use has_privs_for_role for predefined roles	Joe Conway	20:03
Re: Add parameter jit_warn_above_fraction 📎	Magnus Hagander	20:11
Re: Temporary tables versus wraparound... again 📎	Greg Stark	20:11
Re: range_agg with multirange inputs	Greg Stark	20:17
Re: [PATCH] Accept IP addresses in server certificate SANs 📎	Jacob Champion	20:21
Re: [PATCH] Full support for index LP_DEAD hint bits on standby	Peter Geoghegan	20:23
Re: Temporary tables versus wraparound... again	Andres Freund	20:30
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file	Stephen Frost	20:30
Re: jsonpath syntax extensions	Phil Krylov	20:33
Re: [PATCH] Enable SSL library detection via PQsslAttribute	Daniel Gustafsson	20:33
Re: refactoring basebackup.c (zstd workers)	Tom Lane	20:38
Re: refactoring basebackup.c (zstd workers) 📎	Justin Pryzby	20:53
Re: Granting SET and ALTER SYSTE privileges for GUCs 📎	Mark Dilger	20:57
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	21:16
Re: On login trigger: take three	Daniel Gustafsson	21:27
Re: On login trigger: take three	Andres Freund	21:31
Re: On login trigger: take three	Daniel Gustafsson	21:36
Re: refactoring basebackup.c (zstd workers)	Robert Haas	21:39
Re: Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	21:42
Re: [PATCH] Full support for index LP_DEAD hint bits on standby	Peter Geoghegan	21:46
Re: SSL/TLS instead of SSL in docs	Daniel Gustafsson	21:51
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	21:54
Re: Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	22:04
Re: SQL/JSON: JSON_TABLE	Andrew Dunstan	22:30
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	22:31
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	22:37
Re: On login trigger: take three	Tom Lane	22:40
Re: [RFC] building postgres with meson -v8	Andrew Dunstan	22:44
Re: [RFC] building postgres with meson -v8	Tom Lane	22:58
Re: [RFC] building postgres with meson -v8	Andres Freund	23:11
Re: SQL/JSON: functions	Tom Lane	23:25
Re: [PATCH] Add extra statistics to explain for Nested Loop	Justin Pryzby	23:28

March 29, 2022

Thread	Author	Time
Re: refactoring basebackup.c (zstd workers)	Justin Pryzby	00:07
Re: refactoring basebackup.c (zstd workers)	Tom Lane	00:11
Re: MDAM techniques and Index Skip Scan patch	Peter Geoghegan	00:13
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	00:19
Re: MDAM techniques and Index Skip Scan patch	Tom Lane	00:21
Re: POC: GROUP BY optimization 📎	Tomas Vondra	00:48
Re: SQL/JSON: functions	Andrew Dunstan	01:03
Re: Allow file inclusion in pg_hba and pg_ident files	Michael Paquier	01:21
RE: Logical replication timeout problem	[email protected]	01:29
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	01:34
RE: Logical replication timeout problem 📎	[email protected]	01:44
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Michael Paquier	01:57
Re: MDAM techniques and Index Skip Scan patch	Peter Geoghegan	01:58
Re: POC: GROUP BY optimization	Zhihong Yu	02:02
Re: MDAM techniques and Index Skip Scan patch	Peter Geoghegan	02:03
Re: MDAM techniques and Index Skip Scan patch	Tom Lane	02:07
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file 📎	Nathan Bossart	02:09
Re: Window Function "Run Conditions" 📎	David Rowley	02:11
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)	Justin Pryzby	02:13
Re: [PATCH] Add extra statistics to explain for Nested Loop	Julien Rouhaud	02:53
Re: Add psql command to list constraints	Tatsuro Yamada	03:15
Re: MDAM techniques and Index Skip Scan patch	Peter Geoghegan	03:19
Re: SQL/JSON: functions	Andres Freund	03:41
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	04:02
Re: SQL/JSON: functions	Nikola Ivanov	04:09
Re: Support logical replication of DDLs	Dilip Kumar	04:17
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	04:55
Re: Add LZ4 compression in pg_dump	Michael Paquier	05:03
Re: Add pg_freespacemap extension sql test	Michael Paquier	05:05
Re: Logical replication timeout problem	Masahiko Sawada	05:07
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	05:13
Re: Add psql command to list constraints 📎	Tatsuro Yamada	05:21
Re: Identify missing publications from publisher while create/alter subscription.	Amit Kapila	05:31
Re: Make mesage at end-of-recovery less scary. 📎	Kyotaro Horiguchi	06:07
Enables to call Unregister*XactCallback() in Call*XactCallback() 📎	Hao Wu	06:48
Re: logical replication empty transactions	Masahiko Sawada	07:20
Re: Accommodate startup process in a separate ProcState array slot instead of in MaxBackends slots.	Bharath Rupireddy	07:21
Re: shared-memory based stats collector - v66	Andres Freund	07:24
Re: shared-memory based stats collector - v67	Andres Freund	07:26
Re: Add LZ4 compression in pg_dump	Michael Paquier	07:27
Re: TRAP: FailedAssertion("HaveRegisteredOrActiveSnapshot()", File: "toast_internals.c", Line: 670, PID: 19403) 📎	Kyotaro Horiguchi	08:06
Re: Allow file inclusion in pg_hba and pg_ident files 📎	Julien Rouhaud	08:14
RE: logical replication empty transactions 📎	[email protected]	08:35
Re: TRAP: FailedAssertion("HaveRegisteredOrActiveSnapshot()", File: "toast_internals.c", Line: 670, PID: 19403) 📎	Kyotaro Horiguchi	09:10
Re: logical replication empty transactions	Amit Kapila	09:11
RE: logical replication empty transactions 📎	[email protected]	09:15
RE: logical replication empty transactions 📎	[email protected]	09:35
Generic JSON API 📎	Nikita Malakhov	09:41
Re: Add LZ4 compression in pg_dump 📎	gkokolatos	09:46
Re: Column Filtering in Logical Replication	Amit Kapila	10:00
回复：POC: Cleaning up orphaned files using undo logs 📎	孔凡深 (云梳)	10:07

Browse Archives

Prev | Next