pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTuning one Recurcive CTE
4+ messages / 2 participants
[nested] [flat]
* Tuning one Recurcive CTE
@ 2016-11-09 13:05 Henrik Ekenberg <henrik@ekenberg.pw>
0 siblings, 1 reply; 4+ messages in thread
From: Henrik Ekenberg @ 2016-11-09 13:05 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Tuning one Recurcive CTE
@ 2016-11-09 13:29 Andreas Joseph Krogh <andreas@visena.com>
parent: Henrik Ekenberg <henrik@ekenberg.pw>
0 siblings, 1 reply; 4+ messages in thread
From: Andreas Joseph Krogh @ 2016-11-09 13:29 UTC (permalink / raw)
To: pgsql-performance
På onsdag 09. november 2016 kl. 14:05:55, skrev Henrik Ekenberg <
henrik@ekenberg.pw <mailto: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
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
<https://www.visena.com;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Tuning one Recurcive CTE
@ 2016-11-09 14:30 Henrik Ekenberg <henrik@ekenberg.pw>
parent: Andreas Joseph Krogh <andreas@visena.com>
0 siblings, 1 reply; 4+ messages in thread
From: Henrik Ekenberg @ 2016-11-09 14:30 UTC (permalink / raw)
To: ; +Cc: 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@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
> andreas@visena.com
> www.visena.com[1]
> [1]
>
>
Links:
------
[1] https://www.visena.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Tuning one Recurcive CTE
@ 2016-11-09 16:22 Andreas Joseph Krogh <andreas@visena.com>
parent: Henrik Ekenberg <henrik@ekenberg.pw>
0 siblings, 0 replies; 4+ messages in thread
From: Andreas Joseph Krogh @ 2016-11-09 16:22 UTC (permalink / raw)
To: pgsql-performance
På onsdag 09. november 2016 kl. 15:30:20, skrev Henrik Ekenberg <
henrik@ekenberg.pw <mailto: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-subque...
https://www.postgresql.org/message-id/CAPo4y_XUJR1sijvTySy9W%2BShpORwzbhSdEzE9pgtc1%3DcTkvpkw%40mail...
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
<https://www.visena.com;
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-11-09 16:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-11-09 13:05 Tuning one Recurcive CTE Henrik Ekenberg <henrik@ekenberg.pw>
2016-11-09 13:29 ` Andreas Joseph Krogh <andreas@visena.com>
2016-11-09 14:30 ` Henrik Ekenberg <henrik@ekenberg.pw>
2016-11-09 16:22 ` Andreas Joseph Krogh <andreas@visena.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox