Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tuning one Recurcive CTE

Tuning one Recurcive CTE

From
Henrik Ekenberg
Date:

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.

Re: Tuning one Recurcive CTE

From
Andreas Joseph Krogh
Date:
På onsdag 09. november 2016 kl. 14:05:55, skrev Henrik Ekenberg <henrik@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 provide the query in question when asking for help tuning it.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

Re: Tuning one Recurcive CTE

From
Henrik Ekenberg
Date:

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@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 provide the query in question when asking for help tuning it.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 



Attachment

Re: Tuning one Recurcive CTE

From
Andreas Joseph Krogh
Date:
På onsdag 09. november 2016 kl. 15:30:20, skrev Henrik Ekenberg <henrik@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:
http://blog.2ndquadrant.com/postgresql-ctes-are-optimization-fences/
https://robots.thoughtbot.com/advanced-postgres-performance-tips#common-table-expressions-and-subqueries
https://www.postgresql.org/message-id/CAPo4y_XUJR1sijvTySy9W%2BShpORwzbhSdEzE9pgtc1%3DcTkvpkw%40mail.gmail.com
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment