Re: parallel pg_restore blocks on heavy random read I/O on all children processes

2025-04-04 Thread Tom Lane
Dimitrios Apostolou writes: > On Thu, 20 Mar 2025, Tom Lane wrote: >> I am betting that the problem is that the dump's TOC (table of >> contents) lacks offsets to the actual data of the database objects, >> and thus the readers have to reconstruct that information by scanning >> the dump file. No

Fwd: Very slow query performance when using CTE

2025-04-04 Thread Chris Joysn
unfortunately that increased the query execution time by a factor of 8: https://explain.dalibo.com/plan/a6d2443d87fea1ee On Tue, 1 Apr 2025 at 16:28, Tom Lane wrote: > Chris Joysn writes: > > I have an issue when using CTEs. A query, which consists of multiple > CTEs, > > runs usually rather f