Re: Sudden drastic change in performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Am 15. Juni 2017 16:53:44 MESZ schrieb "ldh@xxxxxxxxxxxxxxxxxx" <ldh@xxxxxxxxxxxxxxxxxx>:
>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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux