Re: [PERFORM] Sudden drastic change in performance

2017-06-15 Thread Andreas Kretschmer
Am 15. Juni 2017 16:53:44 MESZ schrieb "l...@laurent-hasson.com" : >Hello all, > >I have a query with many joins, something like: > >Select c1, c2, c3, sum(c5) > From V1 > Join V2 on ... > Left join V3 on ... > Left join T4 on ... > Join T5 on ... > Join T6 on ...

Re: [PERFORM] Sudden drastic change in performance

2017-06-15 Thread Tom Lane
"l...@laurent-hasson.com" writes: > I have a query with many joins, something like: > Select c1, c2, c3, sum(c5) > From V1 >Join V2 on ... >Left join V3 on ... >Left join T4 on ... >Join T5 on ... >Join T6 on ... >Left join T7 on ... >Join

[PERFORM] Sudden drastic change in performance

2017-06-15 Thread l...@laurent-hasson.com
Hello all, I have a query with many joins, something like: Select c1, c2, c3, sum(c5) From V1 Join V2 on ... Left join V3 on ... Left join T4 on ... Join T5 on ... Join T6 on ... Left join T7 on ... Join T8 on ... Left join T9 on ... Where