pgsql-hackers since 2020-08-08 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

Aug. 8, 2020

Thread Author Time
Re: Creating a function for exposing memory usage of backend process Michael Paquier 01:44
Re: Replace remaining StrNCpy() by strlcpy() 📎 Peter Eisentraut 05:57
Re: 回复:how to create index concurrently on partitioned table 📎 Justin Pryzby 06:37
get rid of distprep? Peter Eisentraut 07:45
Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary? Andrey M. Borodin 08:35
Re: [PATCH] Covering SPGiST index Andrey M. Borodin 08:44
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 09:52
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 10:32
Re: LSM tree for Postgres Konstantin Knizhnik 14:07
Re: get rid of distprep? Tom Lane 15:09
Re: Replace remaining StrNCpy() by strlcpy() Tom Lane 16:09
Re: walsender waiting_for_ping spuriously set Alvaro Herrera 16:42
Re: Amcheck: do rightlink verification with lock coupling Peter Geoghegan 18:14
Re: LSM tree for Postgres Alexander Korotkov 18:18
2020-08-13 Update + PostgreSQL 13 Beta 3 Release Announcement Draft 📎 Jonathan S. Katz 18:27
Re: LSM tree for Postgres Konstantin Knizhnik 20:49

Aug. 9, 2020

Thread Author Time
Re: LSM tree for Postgres Alexander Korotkov 01:53
Re: 回复:how to create index concurrently on partitioned table Michael Paquier 05:00
Re: Allow some recovery parameters to be changed with reload Michael Paquier 05:21
Re: Unnecessary delay in streaming replication due to replay lag 📎 Asim Praveen 05:54
Re: Amcheck: do rightlink verification with lock coupling Andrey M. Borodin 06:08
Re: LSM tree for Postgres Konstantin Knizhnik 07:26
Re: Unnecessary delay in streaming replication due to replay lag Michael Paquier 08:41
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Michael Paquier 11:02
Optimising latch signals 📎 Thomas Munro 11:48
tab completion of IMPORT FOREIGN SCHEMA 📎 Jeff Janes 15:46
Re: tab completion of IMPORT FOREIGN SCHEMA Tom Lane 16:33
Re: 回复:how to create index concurrently on partitioned table 📎 Justin Pryzby 23:44

Aug. 10, 2020

Thread Author Time
Re: POC and rebased patch for CSN based snapshots 📎 [email protected] 01:52
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Justin Pryzby 02:24
Re: Unnecessary delay in streaming replication due to replay lag Asim Praveen 04:31
Re: display offset along with block number in vacuum errors Masahiko Sawada 04:54
Re: Add information to rm_redo_error_callback() Masahiko Sawada 05:10
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Anna Akenteva 06:29
Re: Unnecessary delay in streaming replication due to replay lag Masahiko Sawada 06:57
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 07:34
Re: public schema default ACL Magnus Hagander 08:21
Re: Unnecessary delay in streaming replication due to replay lag 📎 Asim Praveen 08:53
Re: FETCH FIRST clause PERCENT option 📎 Surafel Temesgen 10:23
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks 📎 Bharath Rupireddy 10:52
Re: Parallel worker hangs while handling errors. Bharath Rupireddy 10:54
Re: problem with RETURNING and update row movement Amit Langote 11:43
Re: [PATCH] Add section headings to index types doc Jürgen Purtz 12:52
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 13:45
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 14:29
nested queries vs. pg_stat_activity Robert Haas 14:37
Re: Add Information during standby recovery conflicts 📎 Drouvot, Bertrand 14:43
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Tom Lane 14:44
Re: nested queries vs. pg_stat_activity Magnus Hagander 14:44
Re: Add information to rm_redo_error_callback() 📎 Drouvot, Bertrand 15:07
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 16:14
Re: pendingOps table is not cleared with fsync=off Shawn Debnath 16:35
nested queries vs. pg_stat_activity legrand legrand 16:51
Re: [BUG] Error in BRIN summarization 📎 Anastasia Lubennikova 17:30
Re: pendingOps table is not cleared with fsync=off Tom Lane 18:50
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 19:33
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Tom Lane 19:41
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 19:50
Re: nested queries vs. pg_stat_activity Robert Haas 19:51
Re: nested queries vs. pg_stat_activity Magnus Hagander 20:09
Re: Allow some recovery parameters to be changed with reload Robert Haas 20:20
Re: nested queries vs. pg_stat_activity Robert Haas 20:21
Re: autovac issue with large number of tables Jim Nasby 20:41
Re: pendingOps table is not cleared with fsync=off Shawn Debnath 21:02
Re: nested queries vs. pg_stat_activity Pavel Stehule 21:15
Re: Terminate the idle sessions Cary Huang 21:42
Re: Terminate the idle sessions David G. Johnston 21:49
Re: Add LWLock blocker(s) information Robert Haas 22:27
massive FPI_FOR_HINT load after promote 📎 Alvaro Herrera 22:56
Re: Replace remaining StrNCpy() by strlcpy() Peter Eisentraut 23:23
remove spurious CREATE INDEX CONCURRENTLY wait 📎 Alvaro Herrera 23:38
Re: remove spurious CREATE INDEX CONCURRENTLY wait Alvaro Herrera 23:41

Aug. 11, 2020

Thread Author Time
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Andres Freund 00:11
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andres Freund 00:21
Re: Switch to multi-inserts for pg_depend Andres Freund 00:32
Re: walsender waiting_for_ping spuriously set Andres Freund 00:33
Re: remove spurious CREATE INDEX CONCURRENTLY wait Tom Lane 00:37
Re: Add LWLock blocker(s) information Andres Freund 00:41
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Tom Lane 00:46
Re: remove spurious CREATE INDEX CONCURRENTLY wait James Coleman 01:26
RE: Libpq support to connect to standby server as priority Smith, Peter 01:38
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 02:10
Can I test Extended Query in core test framework Andy Fan 02:43
Re: Terminate the idle sessions 📎 Li Japin 03:14
Re: stress test for parallel workers Thomas Munro 04:38
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 05:23
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 05:39
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andres Freund 05:44
Re: Add information to rm_redo_error_callback() Masahiko Sawada 05:45
Re: Switch to multi-inserts for pg_depend Michael Paquier 05:59
Re: Creating a function for exposing memory usage of backend process torikoshia 06:24
Re: Add information to rm_redo_error_callback() Michael Paquier 06:29
Re: massive FPI_FOR_HINT load after promote Masahiko Sawada 06:55
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 07:09
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 07:38
RE: Libpq support to connect to standby server as priority Smith, Peter 07:46
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 08:11
Re: Add information to rm_redo_error_callback() Masahiko Sawada 10:03
Re: psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, matviews, triggers and tables Anna Akenteva 10:37
Re: Make contrib modules' installation scripts more secure. Christoph Berg 11:15
Re: Add session statistics to pg_stat_database Laurenz Albe 11:53
Re: Make contrib modules' installation scripts more secure. Christoph Berg 11:54
Re: SyncRepLock acquired exclusively in default configuration Asim Praveen 11:55
Re: EDB builds Postgres 13 with an obsolete ICU version Magnus Hagander 12:58
Re: Can I test Extended Query in core test framework Ashutosh Bapat 13:06
Inconsistent behavior of smart shutdown handling for queries with and without parallel workers Bharath Rupireddy 13:20
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 14:03
Re: Parallel worker hangs while handling errors. vignesh C 14:38
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 14:47
Re: Switch to multi-inserts for pg_depend Robert Haas 15:02
Re: remove spurious CREATE INDEX CONCURRENTLY wait Tom Lane 15:14
Re: posgres 12 bug (partitioned table) Robert Haas 15:21
Re: Can I test Extended Query in core test framework Tom Lane 15:22
Re: SyncRepLock acquired exclusively in default configuration Robert Haas 15:27
Re: posgres 12 bug (partitioned table) Tom Lane 15:33
Re: Make contrib modules' installation scripts more secure. Tom Lane 15:59
Re: Can I test Extended Query in core test framework Andres Freund 16:01
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 16:02
Re: massive FPI_FOR_HINT load after promote James Coleman 16:53
Re: posgres 12 bug (partitioned table) Robert Haas 17:13
Re: posgres 12 bug (partitioned table) Andres Freund 17:22
Re: massive FPI_FOR_HINT load after promote Alvaro Herrera 17:41
Re: autovac issue with large number of tables Tom Lane 17:46
Re: posgres 12 bug (partitioned table) Tom Lane 17:52
Re: posgres 12 bug (partitioned table) Andres Freund 18:02
Re: posgres 12 bug (partitioned table) 📎 Andres Freund 18:06
Re: posgres 12 bug (partitioned table) Andres Freund 18:06
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 18:31
Re: EDB builds Postgres 13 with an obsolete ICU version Jaime Casanova 18:39
Re: posgres 12 bug (partitioned table) Andres Freund 18:39
Re: remove spurious CREATE INDEX CONCURRENTLY wait James Coleman 18:42
Re: EDB builds Postgres 13 with an obsolete ICU version Thomas Kellerer 18:45
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 18:50
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 18:55
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 18:59
Re: posgres 12 bug (partitioned table) Andres Freund 19:01
Re: doc examples for pghandler 📎 Mark Wong 20:01
Re: Inconsistent behavior of smart shutdown handling for queries with and without parallel workers Tom Lane 21:28
Re: [BUG] Error in BRIN summarization 📎 Alvaro Herrera 23:43

Aug. 12, 2020

Thread Author Time
Re: Improving connection scalability: GetSnapshotData() Andres Freund 00:19
Re: [BUG] Error in BRIN summarization 📎 Alvaro Herrera 00:19
Re: Improving connection scalability: GetSnapshotData() Thomas Munro 00:24
Re: Can I test Extended Query in core test framework Andy Fan 01:30
Re: public schema default ACL Noah Misch 02:24
Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt. Andy Fan 02:33
Re: Can I test Extended Query in core test framework Andy Fan 02:38
RE: Can I test Extended Query in core test framework [email protected] 02:57
Re: Parallel copy Greg Nancarrow 03:39
Re: posgres 12 bug (partitioned table) Amit Langote 03:51
Re: posgres 12 bug (partitioned table) Tom Lane 04:08
Re: 回复:how to create index concurrently on partitioned table 📎 Michael Paquier 04:54
Re: SyncRepLock acquired exclusively in default configuration Asim Praveen 05:06
Re: posgres 12 bug (partitioned table) Amit Langote 05:19
Re: 回复:how to create index concurrently on partitioned table Justin Pryzby 05:28
Re: Handing off SLRU fsyncs to the checkpointer 📎 Thomas Munro 06:06
Re: SyncRepLock acquired exclusively in default configuration Masahiko Sawada 06:32
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Peter Eisentraut 07:04
remove some ancient port hacks 📎 Peter Eisentraut 07:12
Re: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 08:06
Re: remove some ancient port hacks Marco Atzeri 08:18
use pg_get_functiondef() in pg_dump 📎 Peter Eisentraut 08:25
AW: posgres 12 bug (partitioned table) Wilm Hoyer 09:35
Re: [Proposal] Global temporary tables 曾文旌 09:51
Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt. Dave Cramer 09:54
Re: Make contrib modules' installation scripts more secure. Christoph Berg 10:04
Re: AW: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 10:10
AW: AW: posgres 12 bug (partitioned table) Wilm Hoyer 10:57
Re: AW: AW: posgres 12 bug (partitioned table) 📎 Pavel Biryukov 11:08
Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt. Andy Fan 12:11
Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt. Andy Fan 12:14
Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt. Dave Cramer 12:21
Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt. Andy Fan 13:06
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎 Ashutosh Sharma 13:26
Re: 回复:how to create index concurrently on partitioned table 📎 Michael Paquier 13:37
Parallel query hangs after a smart shutdown is issued Bharath Rupireddy 15:32
Re: [BUG] Error in BRIN summarization Alvaro Herrera 16:00
Re: [BUG] Error in BRIN summarization Alvaro Herrera 16:01
pg_stat_statements and "IN" conditions 📎 Dmitry Dolgov 16:19
Re: posgres 12 bug (partitioned table) Andres Freund 16:27
Re: Parallel query hangs after a smart shutdown is issued Thomas Munro 16:56
Re: Improving connection scalability: GetSnapshotData() 📎 Andres Freund 17:38
Re: EDB builds Postgres 13 with an obsolete ICU version Jaime Casanova 17:54
Re: Parallel query hangs after a smart shutdown is issued 📎 Tom Lane 18:00
Re: [BUG] Error in BRIN summarization Alvaro Herrera 18:02
ltree_plpython failure test on Cygwin for 12.4 test 📎 Marco Atzeri 18:31
Re: Parallel query hangs after a smart shutdown is issued Thomas Munro 18:54
Re: Parallel query hangs after a smart shutdown is issued 📎 Tom Lane 19:28
Re: use pg_get_functiondef() in pg_dump Robert Haas 19:54
Re: [BUG] Error in BRIN summarization 📎 Alvaro Herrera 19:58
Re: Parallel query hangs after a smart shutdown is issued 📎 Tom Lane 20:59
Re: Parallel query hangs after a smart shutdown is issued Thomas Munro 21:41
Re: Dependencies for partitioned indexes are still a mess 📎 Alvaro Herrera 21:49
Re: Dependencies for partitioned indexes are still a mess 📎 Andres Freund 22:13
Re: Parallel query hangs after a smart shutdown is issued Tom Lane 22:21
Re: Dependencies for partitioned indexes are still a mess Tom Lane 22:29
run pgindent on a regular basis / scripted manner Andres Freund 22:34
Re: Dependencies for partitioned indexes are still a mess Andres Freund 22:38
Re: Dependencies for partitioned indexes are still a mess 📎 Alvaro Herrera 22:48
Re: run pgindent on a regular basis / scripted manner Alvaro Herrera 22:53
Re: run pgindent on a regular basis / scripted manner Jesse Zhang 23:08

Browse Archives

Prev | Next