pgsql-hackers since 2020-08-05 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
Browse Archives
Prev
|
Next
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 |
|
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 |
Browse Archives
Prev
|
Next