Re: Tuning one Recurcive CTE

From: Henrik Ekenberg <henrik(at)ekenberg(dot)pw>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning one Recurcive CTE
Date: 2016-11-09 14:30:20
Message-ID: 20161109153020.Horde.n5RySbITOu8kiTavMDlfdS6@box1242.bluehost.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I will need to anonymized before sending it.
Do you know if there is any tuning documents related to CTE scans

//H

> På onsdag 09. november 2016 kl. 14:05:55, skrev Henrik Ekenberg
> <henrik(at)ekenberg(dot)pw>:
>
>> Hi,
>>
>> I try to tune one Recursive CTE.
>>
>> Explain Plan can be found here
>> https://explain.depesz.com/s/yLVd
>>
>> Anyone can give me direction to check?
>>
>> //H.
>
>  
> Rule number one; Always provide the query in question when asking for
> help tuning it.
>  
> -- ANDREAS JOSEPH KROGH
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas(at)visena(dot)com
> www.visena.com[1]
> [1]
>
>  

Links:
------
[1] https://www.visena.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Joseph Krogh 2016-11-09 16:22:34 Re: Tuning one Recurcive CTE
Previous Message Andreas Joseph Krogh 2016-11-09 13:29:47 Re: Tuning one Recurcive CTE