Re: increased max_parallel_workers_per_gather results in fewer workers?

Hi Philip, > On 4. Jun 2020, at 00:23, Philip Semanchuk > wrote: > >> I guess you should show an explain analyze, specifically "Workers >> Planned/Launched", maybe by linking to explain.depesz.com > > Out of an abundance of caution, our company has a policy of not pasting our > plans to publi

Re: increased max_parallel_workers_per_gather results in fewer workers?

Hi Philip, On 4. Jun 2020, at 18:41, Philip Semanchuk mailto:phi...@americanefficient.com>> wrote: [...] Also, there are more configuration settings related to parallel queries you might want to look into. Most notably: parallel_setup_cost parallel_tuple_cost min_parallel_table_scan_size Espe

Re: increased max_parallel_workers_per_gather results in fewer workers?

per table (ALTER TABLE SET STATISTICS). Cheers, Sebastian -- Sebastian Dressler, Solution Architect +49 30 994 0496 72 | sebast...@swarm64.com<mailto:sebast...@swarm64.com> Swarm64 AS Parkveien 41 B | 0258 Oslo | Norway Registered at Brønnøysundregistrene in Norway under Org.-Number 911 662 7

Re: Sudden insert performance degradation

HDD SATA-3 Seagate Exos Enterprise 7200RPM Disk3: 8TB HDD SATA-3 Seagate Exos Enterprise 7200RPM Disk1 and Disk2 are configured as a single logical volume. Just curious: does that mean you mix up SSD + HDD? Cheers, Sebastian -- Sebastian Dressler, Solution Architect +49 30 994 0496 72 | sebast...@

Re: Sudden insert performance degradation

Hi Henrique, On 13. Jul 2020, at 18:42, Henrique Montenegro mailto:typ...@gmail.com>> wrote: On Mon, Jul 13, 2020 at 11:20 AM Sebastian Dressler mailto:sebast...@swarm64.com>> wrote: Running the above loop worked fine for about 12 hours. Each file was taking about 30 seconds to

Re: Sudden insert performance degradation

enable partition pruning, partitionwise join and aggregate? Thanks, Sebastian -- Sebastian Dressler, Solution Architect +49 30 994 0496 72 | sebast...@swarm64.com<mailto:sebast...@swarm64.com> Swarm64 AS Parkveien 41 B | 0258 Oslo | Norway Registered at Brønnøysundregistrene in Norway under Or

Re: Query Performance / Planner estimate off

ing on your storage I hope this helps to get to a parallel plan without setting `nested_loop = off`. EXPLAIN should be enough already to see the difference. Best, Sebastian -- Sebastian Dressler, Solution Architect +49 30 994 0496 72 | sebast...@swarm64.com<mailto:sebast...@swarm64.co

Re: Query Performance / Planner estimate off

Hi Mats, Happy to help. On 21. Oct 2020, at 16:42, Mats Olsen mailto:m...@duneanalytics.com>> wrote: On 10/21/20 2:38 PM, Sebastian Dressler wrote: Hi Mats, On 20. Oct 2020, at 11:37, Mats Julian Olsen mailto:m...@duneanalytics.com>> wrote: [...] 1) Vanilla plan (16