pgsql-hackers since 2020-08-04 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. 4, 2020

Thread Author Time
Re: Document "59.2. Built-in Operator Classes" have a clerical error? Bruce Momjian 00:01
Re: EDB builds Postgres 13 with an obsolete ICU version Bruce Momjian 00:04
Re: public schema default ACL David G. Johnston 00:29
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Peter Geoghegan 00:37
Making JIT more granular 📎 David Rowley 02:01
Re: Cache relation sizes? Thomas Munro 02:21
SSL TAP test fails due to default client certs. 📎 Kyotaro Horiguchi 03:00
Clarifying the ImportForeignSchema API David Fetter 03:07
Rewrite view? Hao Wu 03:55
Re: Clarifying the ImportForeignSchema API Ian Lawrence Barwick 04:39
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 04:42
Re: SSL TAP test fails due to default client certs. Michael Paquier 05:43
Re: Handing off SLRU fsyncs to the checkpointer 📎 Thomas Munro 06:02
Re: [HACKERS][PATCH] Applying PMDK to WAL operations for persistent memory 📎 Takashi Menjo 06:11
Re: ModifyTable overheads in generic plans 📎 Amit Langote 06:15
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 07:11
Re: [PATCH v1] elog.c: Remove special case which avoided %*s format strings.. Michael Paquier 07:35
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 08:06
LSM tree for Postgres Konstantin Knizhnik 08:22
Re: Is it worth accepting multiple CRLs? 📎 Kyotaro Horiguchi 08:37
Re: SSL TAP test fails due to default client certs. Kyotaro Horiguchi 08:41
Re: [PATCH v1] elog.c: Remove special case which avoided %*s format strings.. David Rowley 09:06
Re: [PATCH] - Provide robust alternatives for replace_string Asim Praveen 09:22
Re: EDB builds Postgres 13 with an obsolete ICU version Thomas Kellerer 09:24
Re: EDB builds Postgres 13 with an obsolete ICU version Magnus Hagander 09:28
Re: EDB builds Postgres 13 with an obsolete ICU version Dave Page 09:41
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) 📎 Amit Langote 11:12
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? 📎 Bharath Rupireddy 11:27
Re: problem with RETURNING and update row movement Etsuro Fujita 12:25
Yet another issue with step generation in partition pruning 📎 Etsuro Fujita 12:45
Re: Reduce/eliminate the impact of FPW Stephen Frost 13:05
Re: Replace remaining StrNCpy() by strlcpy() 📎 Peter Eisentraut 13:31
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎 Peter Eisentraut 14:08
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Pavel Stehule 14:21
Re: Concurrency bug in amcheck 📎 Alexander Korotkov 14:27
Re: WIP: BRIN multi-range indexes Alexander Korotkov 14:36
Re: new heapcheck contrib module Robert Haas 14:59
Re: LSM tree for Postgres Alexander Korotkov 15:04
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 15:11
Re: LSM tree for Postgres Tomas Vondra 15:11
Re: WIP: BRIN multi-range indexes Tomas Vondra 15:17
Re: LSM tree for Postgres Stephen Frost 15:18
Re: LSM tree for Postgres Alexander Korotkov 15:24
Add information to rm_redo_error_callback() 📎 Drouvot, Bertrand 15:37
Re: new heapcheck contrib module Peter Geoghegan 16:00
Re: new heapcheck contrib module Robert Haas 16:07
Re: Error on failed COMMIT 📎 Dave Cramer 16:19
Re: Parallel copy Tomas Vondra 16:21
Re: Amcheck: do rightlink verification with lock coupling 📎 Andrey M. Borodin 16:32
Re: new heapcheck contrib module Robert Haas 16:44
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 16:50
Re: Confusing behavior of create table like Robert Haas 16:53
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Alvaro Herrera 16:56
Re: LSM tree for Postgres Konstantin Knizhnik 16:56
Re: LSM tree for Postgres Konstantin Knizhnik 17:18
Re: LSM tree for Postgres Konstantin Knizhnik 17:21
Re: Yet another fast GiST build (typo) 📎 Andrey M. Borodin 17:28
Re: Confusing behavior of create table like Konstantin Knizhnik 17:36
Re: LSM tree for Postgres Tomas Vondra 17:44
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Robert Haas 17:53
Re: LSM tree for Postgres Konstantin Knizhnik 18:55
For standby pg_ctl doesn't wait for PM_STATUS_READY in presence of promote_trigger_file Ashwin Agrawal 19:01
Re: display offset along with block number in vacuum errors 📎 Mahendra Singh Thalor 19:16
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Robert Haas 19:48
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Tom Lane 20:31
Re: Support for NSS as a libpq TLS backend Daniel Gustafsson 21:42
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Peter Geoghegan 21:49
Re: Confusing behavior of create table like Peter Eisentraut 21:50
Re: 13dev failed assert: comparetup_index_btree(): ItemPointer values should never be equal Tom Lane 22:00
Re: [patch] demote 📎 Jehan-Guillaume de Rorthais 22:04
Re: Confusing behavior of create table like Tom Lane 22:27
Re: Concurrency bug in amcheck Peter Geoghegan 22:58
Re: Concurrency bug in amcheck Alexander Korotkov 23:17
Re: Concurrency bug in amcheck Peter Geoghegan 23:19
Re: LSM tree for Postgres Alexander Korotkov 23:59

Aug. 5, 2020

Thread Author Time
RE: Creating foreign key on partitioned table is too slow [email protected] 00:43
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 00:53
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Bossart, Nathan 00:56
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Justin Pryzby 01:04
Re: new heapcheck contrib module Peter Geoghegan 01:06
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Amit Langote 01:12
pg13dev: explain partial, parallel hashagg, and memory use Justin Pryzby 01:21
Re: pg13dev: explain partial, parallel hashagg, and memory use David Rowley 01:44
Re: pg13dev: explain partial, parallel hashagg, and memory use James Coleman 02:01
Re: [DOC] Document concurrent index builds waiting on each other 📎 Alvaro Herrera 02:11
Re: pg13dev: explain partial, parallel hashagg, and memory use Justin Pryzby 02:13
Re: [DOC] Document concurrent index builds waiting on each other Alvaro Herrera 02:14
Re: pg13dev: explain partial, parallel hashagg, and memory use David Rowley 02:27
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path 📎 David Rowley 03:00
Re: LSM tree for Postgres Peter Geoghegan 03:12
Re: pg13dev: explain partial, parallel hashagg, and memory use 📎 David Rowley 05:25
Re: For standby pg_ctl doesn't wait for PM_STATUS_READY in presence of promote_trigger_file Kyotaro Horiguchi 05:46
Re: Handing off SLRU fsyncs to the checkpointer Thomas Munro 06:00
Reg. Postgres 13 Joel Mariadasan (jomariad) 06:08
Re: LSM tree for Postgres Konstantin Knizhnik 06:13
Re: [PATCH] - Provide robust alternatives for replace_string 📎 Asim Praveen 07:08
Re: LSM tree for Postgres Konstantin Knizhnik 07:08
Re: Reg. Postgres 13 Magnus Hagander 07:29
Re: Yet another issue with step generation in partition pruning Amit Langote 08:12
Re: [PATCH v1] elog.c: Remove special case which avoided %*s format strings.. Michael Paquier 08:22
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Masahiko Sawada 09:56
Re: LSM tree for Postgres Dmitry Dolgov 11:09
Re: display offset along with block number in vacuum errors Robert Haas 11:19
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Bharath Rupireddy 11:24
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 11:45
Re: Which SET TYPE don't actually require a rewrite Magnus Hagander 12:52
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Amit Kapila 12:55
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Bharath Rupireddy 13:02
Re: Can a background worker exist without shared memory access for EXEC_BACKEND cases? Robert Haas 13:14
Re: [PATCH] - Provide robust alternatives for replace_string Alvaro Herrera 13:31
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎 Ashutosh Sharma 13:42
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 14:04
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 14:07
Re: new heapcheck contrib module Robert Haas 14:08
Re: Yet another issue with step generation in partition pruning Etsuro Fujita 15:20
Re: Allow some recovery parameters to be changed with reload Robert Haas 15:41
Re: Replace remaining StrNCpy() by strlcpy() Tom Lane 15:49
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) 📎 Tom Lane 17:30
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andres Freund 17:44
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Robert Haas 17:53
pg_rewind is not crash safe Heikki Linnakangas 18:13
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Tom Lane 18:21
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 19:34
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 19:58
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Robert Haas 19:59
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Robert Haas 20:13
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Tom Lane 20:19
Re: FailedAssertion("pd_idx == pinfo->nparts", File: "execPartition.c", Line: 1689) Robert Haas 20:20
Re: new heapcheck contrib module Peter Geoghegan 20:36
Re: Support for NSS as a libpq TLS backend Andrew Dunstan 20:38
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Peter Geoghegan 20:40
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 22:00
Re: Replace remaining StrNCpy() by strlcpy() David Rowley 22:59
Re: Amcheck: do rightlink verification with lock coupling 📎 Peter Geoghegan 23:25
PROC_IN_ANALYZE stillborn 13 years ago 📎 Alvaro Herrera 23:55

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

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