Re: Tuning one Recurcive CTE
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
Вложения
В списке pgsql-performance по дате отправления: