pgsql-hackers since 2020-08-06 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 6, 2020

Thread Author Time
Re: Reg. Postgres 13 Bruce Momjian 00:35
Re: PROC_IN_ANALYZE stillborn 13 years ago Andres Freund 01:07
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 01:23
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Michael Paquier 02:50
Re: WIP: WAL prefetch (another approach) Thomas Munro 02:58
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 03:22
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Andy Fan 03:49
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Tom Lane 04:02
Re: Which SET TYPE don't actually require a rewrite Noah Misch 04:11
Re: Parallel copy vignesh C 04:49
Re: Amcheck: do rightlink verification with lock coupling Andrey M. Borodin 04:50
Re: pg_rewind is not crash safe Andrey M. Borodin 04:55
Re: public schema default ACL Noah Misch 05:00
Re: public schema default ACL Noah Misch 05:05
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 06:03
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 06:11
Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration 📎 Michael Paquier 06:27
RE: Creating foreign key on partitioned table is too slow [email protected] 07:25
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada 08:11
Re: PROC_IN_ANALYZE stillborn 13 years ago Simon Riggs 08:17
Re: recovering from "found xmin ... from before relfrozenxid ..." Rajkumar Raghuwanshi 08:55
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 09:05
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 09:13
Re: recovering from "found xmin ... from before relfrozenxid ..." Masahiko Sawada 09:19
Re: Display individual query in pg_stat_activity 📎 Drouvot, Bertrand 10:10
Re: Display individual query in pg_stat_activity Magnus Hagander 10:24
Re: WIP: WAL prefetch (another approach) Tomas Vondra 10:47
Re: public schema default ACL Magnus Hagander 10:48
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 12:41
Re: pg13dev: explain partial, parallel hashagg, and memory use David Rowley 12:44
Any objection to documenting pg_sequence_last_value()? James Coleman 13:14
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎 Ashutosh Sharma 13:23
Re: public schema default ACL Stephen Frost 13:34
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) 📎 Andy Fan 13:52
Re: display offset along with block number in vacuum errors Amit Kapila 14:09
Re: display offset along with block number in vacuum errors Amit Kapila 14:11
Re: display offset along with block number in vacuum errors Justin Pryzby 14:21
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Tom Lane 14:42
Re: pendingOps table is not cleared with fsync=off Tom Lane 15:42
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 15:48
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) 📎 Andy Fan 15:57
Re: Amcheck: do rightlink verification with lock coupling 📎 Peter Geoghegan 16:38
Re: new heapcheck contrib module Robert Haas 16:43
Re: pendingOps table is not cleared with fsync=off Heikki Linnakangas 17:35
Re: pendingOps table is not cleared with fsync=off Tom Lane 18:10
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 18:21
Re: PROC_IN_ANALYZE stillborn 13 years ago Robert Haas 18:25
Re: PROC_IN_ANALYZE stillborn 13 years ago Tom Lane 18:37
Re: PROC_IN_ANALYZE stillborn 13 years ago Robert Haas 18:48
Re: PROC_IN_ANALYZE stillborn 13 years ago Tom Lane 19:11
Release notes for next week's back-branch releases Tom Lane 19:53
Re: Parallel worker hangs while handling errors. Robert Haas 20:03
Re: pg_dump bug for extension owned tables Fabrízio de Royes Mello 20:11
Re: PROC_IN_ANALYZE stillborn 13 years ago Robert Haas 20:22
Re: PostgreSQL 13 Beta 3 Release Date (+ Update Release) Jonathan S. Katz 21:04
Re: PROC_IN_ANALYZE stillborn 13 years ago Andres Freund 21:26
Re: amcheck verification for GiST and GIN Peter Geoghegan 21:33
Re: [Patch] Optimize dropping of relation buffers using dlist 📎 Tomas Vondra 21:33
Re: PROC_IN_ANALYZE stillborn 13 years ago Tom Lane 21:35
Re: PROC_IN_ANALYZE stillborn 13 years ago Andres Freund 21:45
Re: PROC_IN_ANALYZE stillborn 13 years ago Tom Lane 22:02
Re: pg13dev: explain partial, parallel hashagg, and memory use David Rowley 22:24
walsender waiting_for_ping spuriously set 📎 Alvaro Herrera 22:55

Aug. 7, 2020

Thread Author Time
Should the nbtree page split REDO routine's locking work more like the locking on the primary? Peter Geoghegan 00:02
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) 📎 Tom Lane 00:32
Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary? Tom Lane 01:08
RE: [bugfix]"make installcheck" could not work in PGXS 📎 [email protected] 01:43
Re: display offset along with block number in vacuum errors Amit Kapila 01:48
Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary? Peter Geoghegan 02:00
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Andy Fan 02:26
Re: display offset along with block number in vacuum errors Masahiko Sawada 02:40
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Tom Lane 02:44
Re: public schema default ACL Noah Misch 03:00
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 03:16
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Tom Lane 03:31
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 03:33
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 03:37
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks 📎 Bharath Rupireddy 03:46
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 03:49
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 03:52
Re: [Patch] Optimize dropping of relation buffers using dlist Tom Lane 04:03
Re: display offset along with block number in vacuum errors Amit Kapila 04:03
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 04:05
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 04:13
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 04:21
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 04:42
Re: PROC_IN_ANALYZE stillborn 13 years ago Simon Riggs 04:54
Re: walsender waiting_for_ping spuriously set Ashutosh Bapat 05:38
Re: Yet another issue with step generation in partition pruning Etsuro Fujita 05:55
Re: Amcheck: do rightlink verification with lock coupling Andrey M. Borodin 05:59
Re: [PATCH] - Provide robust alternatives for replace_string 📎 Asim Praveen 06:02
Switch to multi-inserts for pg_depend 📎 Michael Paquier 06:16
Re: Switch to multi-inserts for pg_depend Michael Paquier 06:21
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 06:31
Re: [Patch] Optimize dropping of relation buffers using dlist Konstantin Knizhnik 07:08
Re: recovering from "found xmin ... from before relfrozenxid ..." Ashutosh Sharma 07:15
Re: Creating a function for exposing memory usage of backend process Kasahara Tatsuhito 07:38
Re: [Proposal] Global temporary tables 曾文旌 08:17
Re: [Proposal] Global temporary tables 曾文旌 08:26
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 08:34
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 08:44
Re: Parallel worker hangs while handling errors. Bharath Rupireddy 09:04
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Amit Langote 09:14
Re: [Proposal] Global temporary tables [email protected] 09:30
[PATCH] Covering SPGiST index 📎 Pavel Borisov 11:59
Re: [Patch] Optimize dropping of relation buffers using dlist Tomas Vondra 12:20
Re: ModifyTable overheads in generic plans 📎 Amit Langote 12:26
[PG13] Planning (time + buffers) data structure in explain plan (format text) Pierre Giraud 12:30
Re: LSM tree for Postgres Alexander Korotkov 12:31
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) Julien Rouhaud 12:52
Re: problem with RETURNING and update row movement Etsuro Fujita 13:45
Re: Yet another issue with step generation in partition pruning Etsuro Fujita 13:46
Re: [PG13] Planning (time + buffers) data structure in explain plan (format text) Pierre Giraud 13:51
Re: Parallel worker hangs while handling errors. Robert Haas 13:52
Re: [Patch] Optimize dropping of relation buffers using dlist Robert Haas 14:39
Re: Handing off SLRU fsyncs to the checkpointer Robert Haas 14:44
Re: Parallel worker hangs while handling errors. 📎 Tom Lane 15:36
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 15:50
Re: [Patch] Optimize dropping of relation buffers using dlist Tom Lane 16:09
Re: Parallel worker hangs while handling errors. Robert Haas 16:13
Re: [Patch] Optimize dropping of relation buffers using dlist Robert Haas 16:26
Re: WIP: BRIN multi-range indexes 📎 Tomas Vondra 16:27
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 16:29
Re: [Patch] Optimize dropping of relation buffers using dlist Tom Lane 16:52
Re: Parallel worker hangs while handling errors. Tom Lane 16:56
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Tom Lane 17:12
Re: [Patch] Optimize dropping of relation buffers using dlist Robert Haas 17:33
Re: Parallel worker hangs while handling errors. Robert Haas 17:37
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Robert Haas 17:39
Re: Improve handling of pg_stat_statements handling of bind "IN" variables Pavel Trukhanov 17:42
Re: Parallel worker hangs while handling errors. Tom Lane 18:00
Re: PROC_IN_ANALYZE stillborn 13 years ago Robert Haas 18:03
Re: Parallel worker hangs while handling errors. Robert Haas 18:15
Re: PROC_IN_ANALYZE stillborn 13 years ago Tom Lane 18:41
Re: Add LWLock blocker(s) information David Zhang 19:53
Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks Andres Freund 21:20
Re: PROC_IN_ANALYZE stillborn 13 years ago Alvaro Herrera 21:35
Re: PROC_IN_ANALYZE stillborn 13 years ago Andres Freund 21:37
Re: Should the nbtree page split REDO routine's locking work more like the locking on the primary? Peter Geoghegan 22:28
Re: walsender waiting_for_ping spuriously set Alvaro Herrera 22:55
Re: walsender waiting_for_ping spuriously set Alvaro Herrera 23:18

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31