Re: [PERFORM] Tuning one Recurcive CTE

2016-11-09 Thread Andreas Joseph Krogh
På onsdag 09. november 2016 kl. 15:30:20, skrev Henrik Ekenberg < hen...@ekenberg.pw >: Hi, I will need to anonymized before sending it. Do you know if there is any tuning documents related to CTE scans You might want to read this:

Re: [PERFORM] Tuning one Recurcive CTE

2016-11-09 Thread Henrik Ekenberg
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 : Hi, I try to tune one Recursive CTE. Explain Plan can be found here

Re: [PERFORM] Tuning one Recurcive CTE

2016-11-09 Thread Andreas Joseph Krogh
På onsdag 09. november 2016 kl. 14:05:55, skrev Henrik Ekenberg < hen...@ekenberg.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

[PERFORM] Tuning one Recurcive CTE

2016-11-09 Thread Henrik Ekenberg
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.