pgsql-hackers since 2021-01-22 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. 22, 2021

Thread Author Time
Re: PATCH: Batch/pipelining support for libpq Zhihong Yu 00:14
Re: [PATCH] Full support for index LP_DEAD hint bits on standby Michail Nikolaev 00:56
Re: WIP: BRIN multi-range indexes 📎 Tomas Vondra 01:05
RE: Parallel INSERT (INTO ... SELECT ...) Hou, Zhijie 01:08
Re: vacuum_cost_page_miss default value and modern hardware Peter Geoghegan 01:12
Re: Support for NSS as a libpq TLS backend Jacob Champion 01:14
Re: PoC/WIP: Extended statistics on expressions 📎 Tomas Vondra 01:26
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 01:42
Re: OpenSSL connection setup debug callback issue Michael Paquier 01:54
RE: Parallel INSERT (INTO ... SELECT ...) Hou, Zhijie 02:15
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 02:29
Re: [PoC] Non-volatile WAL buffer Tomas Vondra 02:32
Re: Single transaction in the tablesync worker? Amit Kapila 02:43
Re: pglz compression performance, take two 📎 Justin Pryzby 02:48
RE: About to add WAL write/fsync statistics to pg_stat_wal view [email protected] 02:54
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 02:58
Re: [PoC] Non-volatile WAL buffer 📎 Tomas Vondra 03:27
RE: libpq debug log [email protected] 03:34
Re: PoC/WIP: Extended statistics on expressions 📎 Tomas Vondra 03:49
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 04:01
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 04:11
Re: Added schema level support for publication. vignesh C 04:31
Re: Identify missing publications from publisher while create/alter subscription. japin 04:44
Re: PoC/WIP: Extended statistics on expressions Justin Pryzby 04:46
Re: New IndexAM API controlling index vacuum strategies 📎 Peter Geoghegan 05:00
Re: Deleting older versions in unique indexes to avoid page splits Amit Kapila 05:23
Re: adding wait_start column to pg_locks 📎 torikoshia 05:37
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 05:48
Re: About to add WAL write/fsync statistics to pg_stat_wal view Masahiko Sawada 05:50
Re: POC: postgres_fdw insert batching 📎 Ian Lawrence Barwick 05:50
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 06:02
Re: simplifying foreign key/RI checks Corey Huinker 06:22
Re: Very misleading documentation for PQreset() Noah Misch 06:32
Re: [PATCH] More docs on what to do and not do in extension code Craig Ringer 06:36
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 06:42
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 07:16
RE: Parallel INSERT (INTO ... SELECT ...) Hou, Zhijie 07:21
Re: Why does creating logical replication subscriptions require superuser? Andrey Borodin 07:32
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 07:59
Re: Preventing hangups in bgworker start/stop during DB shutdown Craig Ringer 08:13
Re: Why does creating logical replication subscriptions require superuser? Thomas Kellerer 08:16
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 08:19
plpgsql variable assignment not supporting distinct anymore easteregg 08:21
Re: Why does creating logical replication subscriptions require superuser? Andrey Borodin 08:25
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Amit Kapila 08:30
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 08:33
Re: plpgsql variable assignment not supporting distinct anymore Pavel Stehule 08:43
Re: Add primary keys to system catalogs Joel Jacobson 08:47
RE: Parallel INSERT (INTO ... SELECT ...) [email protected] 08:52
Re: PoC/WIP: Extended statistics on expressions Dean Rasheed 09:00
Re: adding wait_start column to pg_locks Fujii Masao 09:11
Re: Additional Chapter for Tutorial - arch-dev.sgml Heikki Linnakangas 09:15
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 09:29
Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION Bharath Rupireddy 09:38
Re: [PATCH] Identify LWLocks in tracepoints Peter Eisentraut 11:02
Re: Is it useful to record whether plans are generic or custom? Chengxi Sun 11:25
RE: Parallel Inserts in CREATE TABLE AS Tang, Haiying 11:46
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 11:49
Re: Online checksums patch - once again Heikki Linnakangas 11:55
mkid reference Magnus Hagander 11:56
RE: About to add WAL write/fsync statistics to pg_stat_wal view Masahiro Ikeda 12:14
Re: Online checksums patch - once again Heikki Linnakangas 12:21
Re: mkid reference Daniel Gustafsson 12:32
Re: Identify missing publications from publisher while create/alter subscription. vignesh C 12:37
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 12:38
Re: Identify missing publications from publisher while create/alter subscription. vignesh C 12:39
Re: doc review for v14 Masahiko Sawada 12:53
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎 Masahiro Ikeda 13:05
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 13:06
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 13:09
Re: PoC Refactor AM analyse API Heikki Linnakangas 13:12
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 13:13
CTAS command tags Vik Fearing 13:14
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Masahiko Sawada 13:14
Re: CTAS command tags Darafei Komяpa Praliaskouski 13:19
Re: LogwrtResult contended spinlock Masahiko Sawada 13:23
Re: pg_rewind copies 📎 Heikki Linnakangas 13:26
Re: libpq debug log 'Alvaro Herrera' 13:38
Re: LogwrtResult contended spinlock Alvaro Herrera 13:39
Re: plpgsql variable assignment not supporting distinct anymore easteregg 13:41
Re: Some more hackery around cryptohashes (some fixes + SHA1) Heikki Linnakangas 13:50
Re: plpgsql variable assignment not supporting distinct anymore Pavel Stehule 13:58
Re: mkid reference Julien Rouhaud 14:06
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 14:07
Re: plpgsql variable assignment not supporting distinct anymore easteregg 14:10
Re: plpgsql variable assignment not supporting distinct anymore Pavel Stehule 14:27
Re: Error on failed COMMIT Masahiko Sawada 14:27
Re: LogwrtResult contended spinlock Masahiko Sawada 14:28
Re: Commitfest 2021-01 Now in Progress Masahiko Sawada 14:42
Re: CTAS command tags Andreas Karlsson 15:40
Re: Add primary keys to system catalogs Tom Lane 15:42
Re: CTAS command tags Tom Lane 15:52
Re: [PoC] Non-volatile WAL buffer Konstantin Knizhnik 16:04
Re: About to add WAL write/fsync statistics to pg_stat_wal view japin 16:46
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. Tom Lane 17:12
Re: macOS SIP, next try Tom Lane 17:32
Re: mkid reference Tom Lane 18:07
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. Tom Lane 18:38
Re: plpgsql variable assignment not supporting distinct anymore Tom Lane 18:59
[PATCH v3 1/1] Fix detection of preadv/pwritev support for OSX. James Hilliard 19:32
Re: [PATCH 1/1] Fix detection of pwritev support for OSX. James Hilliard 20:53
GSoC 2021 Stephen Frost 21:40
a verbose option for autovacuum Tommy Li 22:06
Re: Why does creating logical replication subscriptions require superuser? Paul Martinez 22:08
Re: Polyphase merge is obsolete 📎 Heikki Linnakangas 22:19
Re: a verbose option for autovacuum Tom Lane 22:33
Re: Challenges preventing us moving to 64 bit transaction id (XID)? Jim Finnerty 22:39
Re: a verbose option for autovacuum Tommy Li 22:55
Re: Single transaction in the tablesync worker? 📎 Peter Smith 23:25
Re: WIP: BRIN multi-range indexes John Naylor 23:27
Re: [UNVERIFIED SENDER] Re: Challenges preventing us moving to 64 bit transaction id (XID)? 📎 Finnerty, Jim 23:46
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 23:57

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

Browse Archives

Prev | Next