Re: [PERFORM] Sudden drastic change in performance - Mailing list pgsql-performance

Am 15. Juni 2017 16:53:44 MESZ schrieb "ldh@laurent-hasson.com" <ldh@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 ...
>Group by c1, c2, c3
>
>
>Thank you,
>Laurent.

Please show us the explain analyse for the queries.


Regards, Andreas

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.