pgsql-hackers since 2021-01-23 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)

Browse Archives

Prev | Next

Jan. 23, 2021

Thread Author Time
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tom Lane 00:10
Re: Single transaction in the tablesync worker? Peter Smith 00:16
Re: Single transaction in the tablesync worker? Peter Smith 00:25
Re: Some more hackery around cryptohashes (some fixes + SHA1) Michael Paquier 02:37
Re: WIP: BRIN multi-range indexes Tomas Vondra 02:59
Re: Single transaction in the tablesync worker? Ajin Cherian 03:07
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits Tomas Vondra 03:58
Re: Single transaction in the tablesync worker? Amit Kapila 04:15
Re: Is Recovery actually paused? Dilip Kumar 04:26
Re: Race condition in recovery? Dilip Kumar 04:36
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 04:40
Re: Refactoring HMAC in the core code 📎 Michael Paquier 04:43
Re: Is Recovery actually paused? Dilip Kumar 04:47
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. Sergey Shinderuk 05:02
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. Sergey Shinderuk 05:12
Re: doc review for v14 Michael Paquier 05:24
Re: Single transaction in the tablesync worker? Ajin Cherian 05:38
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION 📎 Amit Kapila 06:20
proposal - idea - enhancing plpgsql FOREACH for JSON, jsonb and hstore Pavel Stehule 06:46
Re: proposal - idea - enhancing plpgsql FOREACH for JSON, jsonb and hstore Julien Rouhaud 06:52
Re: simplifying foreign key/RI checks 📎 Amit Langote 07:10
Re: Is Recovery actually paused? 📎 Dilip Kumar 08:06
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION 📎 Bharath Rupireddy 08:14
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. Sergey Shinderuk 08:27
Re: POC: postgres_fdw insert batching 📎 Amit Langote 08:31
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. James Hilliard 09:22
Re: proposal: schema variables 📎 Pavel Stehule 09:50
Re: doc review for v14 Michael Paquier 10:15
Re: SQL/JSON: functions 📎 Erik Rijkers 10:37
Re: Is Recovery actually paused? Bharath Rupireddy 11:10
Re: Single transaction in the tablesync worker? Amit Kapila 12:26
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 12:34
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 12:38
Re: POC: postgres_fdw insert batching Zhihong Yu 14:58
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Zhihong Yu 16:40
Re: POC: postgres_fdw insert batching Tomas Vondra 17:16
Re: simplifying foreign key/RI checks Zhihong Yu 17:53
Re: a verbose option for autovacuum Stephen Frost 18:11
Re: proposal - idea - enhancing plpgsql FOREACH for JSON, jsonb and hstore Stephen Frost 18:21
Re: proposal - idea - enhancing plpgsql FOREACH for JSON, jsonb and hstore Pavel Stehule 18:50
Re: Git, diffs, and patches Bruce Momjian 20:16
Test coverage for contrib/auto_explain 📎 Tom Lane 22:41
Re: Single transaction in the tablesync worker? Peter Smith 23:40

Jan. 24, 2021

Thread Author Time
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade Andres Freund 00:36
Re: Use pg_pwrite() in pg_test_fsync 📎 Thomas Munro 00:50
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎 Tomas Vondra 00:54
Re: How to expose session vs txn lock info in pg_locks view? Andres Freund 01:12
Re: Is Recovery actually paused? Dilip Kumar 01:47
Re: simplifying foreign key/RI checks Corey Huinker 02:26
Re: Is Recovery actually paused? Dilip Kumar 05:59
Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination 📎 Julien Rouhaud 06:17
Re: Is Recovery actually paused? Bharath Rupireddy 06:46
Re: Is Recovery actually paused? Bharath Rupireddy 06:47
Re: Single transaction in the tablesync worker? Peter Smith 06:54
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 08:22
Re: pg_upgrade fails with non-standard ACL Noah Misch 08:39
Re: Is Recovery actually paused? Dilip Kumar 08:56
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 10:11
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 10:21
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 10:26
Extend more usecase for planning time partition pruning and init partition pruning. 📎 Andy Fan 10:34
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 11:00
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 11:40
Re: simplifying foreign key/RI checks 📎 Amit Langote 11:51
Re: POC: postgres_fdw insert batching 📎 Amit Langote 12:31
Re: mkid reference Magnus Hagander 13:20
Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination Alvaro Herrera 16:01
Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination Mahendra Singh Thalor 16:06
Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination Julien Rouhaud 17:04
Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination Julien Rouhaud 17:05
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Mark Rofail 18:24
Re: Stronger safeguard for archive recovery not to miss data Laurenz Albe 20:12
Re: [HACKERS] GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 20:46
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 23:23
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎 Masahiro Ikeda 23:33

Jan. 25, 2021

Thread Author Time
Re: simplifying foreign key/RI checks Corey Huinker 00:24
Re: Is Recovery actually paused? Masahiko Sawada 00:41
Re: Single transaction in the tablesync worker? Peter Smith 00:44
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Alvaro Herrera 00:46
RE: About to add WAL write/fsync statistics to pg_stat_wal view [email protected] 01:34
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada 01:36
Re: Extend more usecase for planning time partition pruning and init partition pruning. Andy Fan 02:21
Re: Single transaction in the tablesync worker? 📎 Peter Smith 02:32
Re: About to add WAL write/fsync statistics to pg_stat_wal view japin 02:47
Re: Single transaction in the tablesync worker? Amit Kapila 02:48
Re: Single transaction in the tablesync worker? Peter Smith 02:53
Re: [PoC] Non-volatile WAL buffer Masahiko Sawada 02:56
Re: Single transaction in the tablesync worker? Amit Kapila 02:58
RE: Parallel Inserts in CREATE TABLE AS Tang, Haiying 03:10
Re: Is Recovery actually paused? Kyotaro Horiguchi 03:12
Re: Single transaction in the tablesync worker? Amit Kapila 03:15
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Amit Kapila 03:17
RE: Parallel INSERT (INTO ... SELECT ...) Hou, Zhijie 03:22
Re: PG vs LLVM 12 on seawasp, next round Noah Misch 03:40
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 03:46
RE: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda 03:53
Re: Single transaction in the tablesync worker? Amit Kapila 03:54
Re: PG vs LLVM 12 on seawasp, next round Tom Lane 04:06
RE: About to add WAL write/fsync statistics to pg_stat_wal view [email protected] 04:09
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda 04:15
RE: POC: postgres_fdw insert batching [email protected] 04:21
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda 04:22
Re: Is Recovery actually paused? Dilip Kumar 04:23
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda 04:28
Re: Is Recovery actually paused? Dilip Kumar 04:35
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada 04:58
Re: Is it useful to record whether plans are generic or custom? Kyotaro Horiguchi 05:10
Re: Is Recovery actually paused? Kyotaro Horiguchi 05:23
Re: ModifyTable overheads in generic plans 📎 Amit Langote 05:23
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 05:37
Re: Single transaction in the tablesync worker? Amit Kapila 05:48
Re: Release SPI plans for referential integrity with DISCARD ALL yuzuko 06:10
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 06:47
The mysterious pg_proc.protrftypes Joel Jacobson 07:04
Re: Heap's backwards scan scans the incorrect pages with heap_setscanlimits() David Rowley 07:05
RE: libpq debug log [email protected] 07:12
Re: The mysterious pg_proc.protrftypes Pavel Stehule 07:14
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 07:40
Re: The mysterious pg_proc.protrftypes 📎 Joel Jacobson 07:46
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 07:50
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎 Masahiro Ikeda 07:51
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 07:51
[PATCH] Document the fact that pg_proc.protrftypes references pg_type.oid 📎 Joel Jacobson 07:57
Re: The mysterious pg_proc.protrftypes Pavel Stehule 08:01
RE: libpq debug log 📎 [email protected] 08:07
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 08:07
RE: libpq debug log 📎 [email protected] 08:09
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Joel Jacobson 08:14
Re: New IndexAM API controlling index vacuum strategies 📎 Masahiko Sawada 08:19
RE: Stronger safeguard for archive recovery not to miss data 📎 [email protected] 08:19
RE: libpq debug log [email protected] 08:22
Re: New IndexAM API controlling index vacuum strategies Masahiko Sawada 08:27
RE: libpq debug log [email protected] 08:33
Re: Phrase search vs. multi-lexeme tokens Neil Chen 08:44
Re: Stronger safeguard for archive recovery not to miss data Laurenz Albe 08:55
Re: a misbehavior of partition row movement (?) 📎 Amit Langote 09:06
Re: simplifying foreign key/RI checks Keisuke Kuroda 09:06
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 09:12
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 09:13
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 09:18
Re: simplifying foreign key/RI checks Amit Langote 09:19
RE: libpq debug log [email protected] 09:20
Re: Is Recovery actually paused? 📎 Dilip Kumar 09:23
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 09:37
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 09:47
Re: simplifying foreign key/RI checks Amit Langote 10:01
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 10:08
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 10:24
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 10:28
Re: Single transaction in the tablesync worker? 📎 Peter Smith 10:49
Re: simplifying foreign key/RI checks Amit Langote 11:04
Re: Single transaction in the tablesync worker? Peter Smith 11:15
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 11:39
Re: FETCH FIRST clause PERCENT option Kyotaro Horiguchi 11:39
RE: Parallel INSERT (INTO ... SELECT ...) Hou, Zhijie 11:39
Re: Single transaction in the tablesync worker? Peter Smith 11:39
Re: Single transaction in the tablesync worker? Peter Smith 11:41
Re: Single transaction in the tablesync worker? Peter Smith 11:47
Re: Identify missing publications from publisher while create/alter subscription. japin 11:48
Re: [PATCH] Automatic HASH and LIST partition creation 📎 Pavel Borisov 12:32
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Justin Pryzby 12:58
Re: Bug in error reporting for multi-line JSON Simon Riggs 13:08
Re: libpq debug log 'Alvaro Herrera' 13:11
Add SQL function for SHA1 📎 Michael Paquier 13:12
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 13:14
Re: Columns correlation and adaptive query optimization 📎 Konstantin Knizhnik 13:27
Re: Extensions not dumped when --schema is used 📎 Guillaume Lelarge 13:34
Re: New IndexAM API controlling index vacuum strategies 📎 Masahiko Sawada 13:35
Re: Is Recovery actually paused? Bharath Rupireddy 13:40
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 13:50
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 13:55
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 13:58
Re: Error on failed COMMIT 📎 Dave Cramer 14:09
Re: Re: parallel distinct union and aggregate support patch 📎 [email protected] 14:14
Re: adding wait_start column to pg_locks Fujii Masao 14:44
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada 15:03
Extensibility of the PostgreSQL wire protocol Jan Wieck 15:07
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 15:12
Re: Extensibility of the PostgreSQL wire protocol Jonah H. Harris 15:18
Re: Phrase search vs. multi-lexeme tokens Alexander Korotkov 15:24
Re: Jsonpath ** vs lax mode Alexander Korotkov 15:31
Re: Jsonpath ** vs lax mode Alexander Korotkov 15:33
Re: mkid reference Bruce Momjian 15:38
Re: mkid reference Bruce Momjian 15:40
Re: Is Recovery actually paused? Yugo NAGATA 15:57
Re: New IndexAM API controlling index vacuum strategies Zhihong Yu 16:05
Re: Error on failed COMMIT 📎 Dave Cramer 16:29
cleaning up a few CLOG-related things 📎 Robert Haas 16:56
Re: Is Recovery actually paused? Robert Haas 17:00
Re: Identify missing publications from publisher while create/alter subscription. vignesh C 17:01
Re: Identify missing publications from publisher while create/alter subscription. vignesh C 17:02
Re: Printing backtrace of postgres processes Robert Haas 17:05
Re: ResourceOwner refactoring Robert Haas 17:14
Re: Extensibility of the PostgreSQL wire protocol Jan Wieck 17:17
Snapbuild woes followup Heikki Linnakangas 17:28
Re: CheckpointLock needed in CreateCheckPoint()? Robert Haas 17:38
Re: a verbose option for autovacuum Tommy Li 17:46
Re: [Proposal] Global temporary tables Pavel Stehule 18:02
Re: The mysterious pg_proc.protrftypes Tom Lane 18:05
Fixing cache pollution in the Kerberos test suite 📎 Jacob Champion 18:33

Browse Archives

Prev | Next