pgsql-hackers since 2020-09-01 10:36

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

Sept. 1, 2020

Thread Author Time
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alexey Kondratov 10:36
Re: Reloptions for table access methods gkokolatos 10:36
Docs: inaccurate description about config settings Li Japin 10:37
Re: New default role- 'pg_read_all_data' Georgios Kokolatos 10:55
Re: [Patch] ALTER SYSTEM READ ONLY 📎 Amul Sul 11:13
Group by reordering optimization 📎 Dmitry Dolgov 11:15
Re: Docs: inaccurate description about config settings Ian Lawrence Barwick 12:20
Re: Evaluate expression at planning time for two more cases Surafel Temesgen 12:26
Re: v13: show extended stats target in \d Georgios Kokolatos 12:35
Re: Support for NSS as a libpq TLS backend 📎 Daniel Gustafsson 12:43
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 k.jamison@fujitsu.com 13:02
clarify "rewritten" in pg_checksums docs 📎 Michael Banck 13:13
Re: WIP: WAL prefetch (another approach) 📎 Tomas Vondra 13:14
Re: clarify "rewritten" in pg_checksums docs Daniel Gustafsson 13:29
Re: clarify "rewritten" in pg_checksums docs Michael Banck 13:34
Re: clarify "rewritten" in pg_checksums docs Daniel Gustafsson 13:44
Re: Online checksums patch - once again Daniel Gustafsson 13:50
Re: WIP: WAL prefetch (another approach) Thomas Munro 14:05
Re: WIP: WAL prefetch (another approach) Tomas Vondra 14:18
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 15:03
Re: Docs: inaccurate description about config settings 📎 Li Japin 15:06
Re: Remove line length restriction in passwordFromFile() Tom Lane 15:14
Kerberos support broken on MSVC builds for Windows x64? Dave Page 15:22
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alvaro Herrera 15:40
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Justin Pryzby 15:43
Re: "cert" + clientcert=verify-ca in pg_hba.conf? 📎 Bruce Momjian 15:47
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alvaro Herrera 15:48
Re: Is it possible to set end-of-data marker for COPY statement. Bruce Momjian 16:05
Re: Kerberos support broken on MSVC builds for Windows x64? 📎 Dave Page 16:12
Re: Reloptions for table access methods Alvaro Herrera 16:20
Re: Kerberos support broken on MSVC builds for Windows x64? Stephen Frost 16:29
Re: Is it possible to set end-of-data marker for COPY statement. David G. Johnston 16:30
Re: autovac issue with large number of tables Kasahara Tatsuhito 17:10
Re: Reloptions for table access methods Jeff Davis 17:21
Re: Is it possible to set end-of-data marker for COPY statement. Bruce Momjian 17:23
Re: Is it possible to set end-of-data marker for COPY statement. Bruce Momjian 17:25
Re: Is it possible to set end-of-data marker for COPY statement. Tom Lane 18:01
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Alvaro Herrera 18:15
Re: Maximum password length Tom Lane 18:36
Re: factorial function/phase out postfix operators? 📎 Mark Dilger 19:00
Re: Disk-based hash aggregate's cost model Jeff Davis 19:58
Re: Maximum password length Bossart, Nathan 20:15
Re: v13: show extended stats target in \d Alvaro Herrera 21:08
Re: Group by reordering optimization Tomas Vondra 21:08
Re: Maximum password length Peter Eisentraut 21:15
Re: Disk-based hash aggregate's cost model Tomas Vondra 21:19
Re: v13: show extended stats target in \d Tomas Vondra 21:22
Re: Additional Chapter for Tutorial Peter Eisentraut 21:30
Re: Disk-based hash aggregate's cost model Peter Geoghegan 21:48
Re: Maximum password length Tom Lane 21:58
Re: Group by reordering optimization Peter Geoghegan 22:09
Re: Problems with the FSM, heap fillfactor, and temporal locality Peter Geoghegan 22:56
Re: [HACKERS] Custom compression methods Mark Dilger 23:27
Re: logtape.c stats don't account for unused "prefetched" block numbers Alvaro Herrera 23:36

Sept. 2, 2020

Thread Author Time
Re: Manager for commit fest 2020-09 Michael Paquier 00:15
Re: REINDEX SCHEMA/DATABASE/SYSTEM weak with dropped relations Michael Paquier 00:20
Re: logtape.c stats don't account for unused "prefetched" block numbers Peter Geoghegan 00:24
Re: Manager for commit fest 2020-09 Ian Barwick 00:28
Re: Manager for commit fest 2020-09 Michael Paquier 00:30
Re: Dependencies for partitioned indexes are still a mess Alvaro Herrera 00:49
Re: Maximum password length 📎 Tom Lane 00:58
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 01:00
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alvaro Herrera 01:29
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 01:31
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 01:36
Re: 回复:how to create index concurrently on partitioned table 📎 Michael Paquier 01:39
Re: "cert" + clientcert=verify-ca in pg_hba.conf? Kyotaro Horiguchi 01:45
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 01:48
Re: SyncRepLock acquired exclusively in default configuration Fujii Masao 01:58
Re: SyncRepLock acquired exclusively in default configuration Andres Freund 02:12
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Justin Pryzby 02:24
Re: "cert" + clientcert=verify-ca in pg_hba.conf? Bruce Momjian 02:27
Re: REINDEX SCHEMA/DATABASE/SYSTEM weak with dropped relations Justin Pryzby 02:41
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 02:48
Re: [Patch] Optimize dropping of relation buffers using dlist Tom Lane 03:47
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 k.jamison@fujitsu.com 03:48
Re: More tests with USING INDEX replident and dropped indexes Rahila Syed 03:57
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 04:02
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Hao Wu 04:25
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 04:56
describe-config issue 📎 vignesh C 05:05
A micro-optimisation for walkdir() 📎 Thomas Munro 05:18
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 05:24
builtin functions, parameter names and psql's \df Andres Freund 05:35
Re: Parallel copy 📎 vignesh C 05:39
Re: REINDEX SCHEMA/DATABASE/SYSTEM weak with dropped relations Michael Paquier 05:58
Re: More tests with USING INDEX replident and dropped indexes Michael Paquier 06:00
Re: Additional Chapter for Tutorial Jürgen Purtz 07:04
Re: builtin functions, parameter names and psql's \df Oleksandr Shulgin 07:13
Re: builtin functions, parameter names and psql's \df Julien Rouhaud 07:15
Re: builtin functions, parameter names and psql's \df Gavin Flower 07:35
Re: Kerberos support broken on MSVC builds for Windows x64? Dave Page 08:05
Re: Include access method in listTables output Michael Paquier 08:06
Re: clarify "rewritten" in pg_checksums docs Michael Paquier 08:26
Re: factorial function/phase out postfix operators? John Naylor 08:33
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 08:49
Re: New statistics for tuning WAL buffer size 📎 Masahiro Ikeda 09:56
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 10:11
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 10:24
Re: [HACKERS] Custom compression methods Dilip Kumar 10:33
Re: Re: [HACKERS] Custom compression methods Dilip Kumar 10:39
Refactor ReindexStmt and its "concurrent" boolean 📎 Michael Paquier 11:03
Re: Refactor ReindexStmt and its "concurrent" boolean Julien Rouhaud 11:17
Re: [PATCH] Covering SPGiST index Andrey M. Borodin 12:18
Re: Online checksums patch - once again 📎 Daniel Gustafsson 12:22
Re: Kerberos support broken on MSVC builds for Windows x64? Stephen Frost 13:47
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 13:49
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Alvaro Herrera 13:49
Re: [patch] Fix checksum verification in base backups for zero page headers Anastasia Lubennikova 13:50
Re: Problems with the FSM, heap fillfactor, and temporal locality John Naylor 13:55
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 14:08
Re: A micro-optimisation for walkdir() Tom Lane 14:34
Re: describe-config issue Tom Lane 14:36
Re: builtin functions, parameter names and psql's \df 📎 Tom Lane 15:01
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 15:42
Re: A micro-optimisation for walkdir() 📎 Juan José Santamaría Flecha 15:51
Re: Group by reordering optimization Tomas Vondra 16:12
Re: Kerberos support broken on MSVC builds for Windows x64? 📎 Dave Page 16:20
Re: Kerberos support broken on MSVC builds for Windows x64? Dave Page 16:21
Re: builtin functions, parameter names and psql's \df Alvaro Herrera 17:56
Re: Kerberos support broken on MSVC builds for Windows x64? Stephen Frost 18:08
PostgreSQL 13 Release Timeline Jonathan S. Katz 18:13
Re: Kerberos support broken on MSVC builds for Windows x64? Dave Page 18:17
Re: Allow continuations in "pg_hba.conf" files 📎 Tom Lane 18:53
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Jesse Zhang 20:43
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 21:00
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Alvaro Herrera 21:18
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Jesse Zhang 21:32
[NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Ranier Vilela 21:39
Re: [NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Ranier Vilela 21:46
Re: [NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Peter Geoghegan 22:05
Re: [NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Ranier Vilela 22:14
Re: proposal - function string_to_table Tom Lane 22:30
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 23:07
Re: [NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Peter Geoghegan 23:16
Re: Two fsync related performance issues? Thomas Munro 23:30
Re: list of extended statistics on psql Tatsuro Yamada 23:45

Sept. 3, 2020

Thread Author Time
Re: Two fsync related performance issues? Thomas Munro 00:09
Re: Disk-based hash aggregate's cost model 📎 Jeff Davis 00:18
Re: Disk-based hash aggregate's cost model Peter Geoghegan 00:35
Re: describe-config issue vignesh C 01:52
Re: proposal - function string_to_table Peter Smith 01:52
Re: proposal - function string_to_table Tom Lane 01:59
Re: Refactor ReindexStmt and its "concurrent" boolean 📎 Michael Paquier 02:14
Re: proposal - function string_to_table Pavel Stehule 03:01
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Peter Eisentraut 04:57
Re: A micro-optimisation for walkdir() 📎 Thomas Munro 05:08
Re: Ideas about a better API for postgres_fdw remote estimates 📎 Andrey V. Lepikhov 05:14
Re: Switch to multi-inserts for pg_depend 📎 Michael Paquier 05:35
Re: A micro-optimisation for walkdir() Tom Lane 05:36
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Tom Lane 05:40
Re: A micro-optimisation for walkdir() Thomas Munro 06:38
Re: Get memory contexts of an arbitrary backend process torikoshia 06:38
Re: Get memory contexts of an arbitrary backend process torikoshia 06:40
Re: Parallel copy Greg Nancarrow 06:50
Re: New statistics for tuning WAL buffer size Fujii Masao 07:05
Re: extension patch of CREATE OR REPLACE TRIGGER Peter Smith 07:35
Re: Switch to multi-inserts for pg_depend Daniel Gustafsson 07:47
Making index_set_state_flags() transactional 📎 Michael Paquier 08:04
Re: Improving connection scalability: GetSnapshotData() Michael Paquier 08:18
default partition and concurrent attach partition 📎 Amit Langote 09:50
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Amit Langote 09:53
Re: default partition and concurrent attach partition Amit Langote 09:56
Re: Removal of currtid()/currtid2() and some table AM cleanup 📎 Michael Paquier 10:14
Re: Switch to multi-inserts for pg_depend Michael Paquier 10:19
Re: Switch to multi-inserts for pg_depend Daniel Gustafsson 10:47
[PATCH] Detect escape of ErrorContextCallback stack pointers (and from PG_TRY() ) 📎 Craig Ringer 11:21
Re: PoC: custom signal handler for extensions 📎 Pavel Borisov 11:25
Re: [PATCH] Missing links between system catalog documentation pages Peter Eisentraut 11:38
Re: Reloptions for table access methods gkokolatos 12:54
On login trigger: take three 📎 Konstantin Knizhnik 13:42
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 14:08
Re: On login trigger: take three Pavel Stehule 14:18
Re: [PATCH] Detect escape of ErrorContextCallback stack pointers (and from PG_TRY() ) Tom Lane 14:28
Re: [NBTREE] Possible NULL pointer dereference (backend/access/nbtree/nbutils.c) Ranier Vilela 14:39
Re: Switch to multi-inserts for pg_depend Alvaro Herrera 14:50
Re: Kerberos support broken on MSVC builds for Windows x64? Dave Page 15:15
Re: A micro-optimisation for walkdir() Tom Lane 15:31
Re: [PATCH] Missing links between system catalog documentation pages 📎 Dagfinn Ilmari Mannsåker 15:40
Re: factorial function/phase out postfix operators? 📎 Mark Dilger 15:49
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Jesse Zhang 15:52
Re: Kerberos support broken on MSVC builds for Windows x64? Dave Page 15:54
Re: INSERT ON CONFLICT and RETURNING 📎 Konstantin Knizhnik 16:16
Re: Allow continuations in "pg_hba.conf" files Tom Lane 16:17
Re: INSERT ON CONFLICT and RETURNING Marko Tiikkaja 16:30
Re: Disk-based hash aggregate's cost model Jeff Davis 16:38
Re: INSERT ON CONFLICT and RETURNING Konstantin Knizhnik 16:52
Re: INSERT ON CONFLICT and RETURNING Geoff Winkless 16:56
Re: shared-memory based stats collector Stephen Frost 17:16
Re: Get memory contexts of an arbitrary backend process Kasahara Tatsuhito 17:18
Re: Maximum password length 📎 Tom Lane 17:18
Re: Fix for configure error in 9.5/9.6 on macOS 11.0 Big Sur Tom Lane 17:36
Re: Get memory contexts of an arbitrary backend process Tom Lane 17:40
Re: INSERT ON CONFLICT and RETURNING Alexander Korotkov 17:59
Re: [PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers Surafel Temesgen 18:22
Re: LogwrtResult contended spinlock Alvaro Herrera 18:34
Re: Creating foreign key on partitioned table is too slow Tom Lane 18:35
Re: Yet another fast GiST build (typo) Heikki Linnakangas 18:40
Re: 回复:how to create index concurrently on partitioned table Anastasia Lubennikova 19:02
Re: Support for NSS as a libpq TLS backend Andrew Dunstan 19:26

Browse Archives

Prev | Next