These are chat archives for ManageIQ/manageiq/performance

29th
Sep 2016
Chris Arcand
@chrisarcand
Sep 29 2016 15:06
I wonder what parallel queries could do for us, and potentially the AR postgres adapter in general https://www.postgresql.org/about/news/1703/
Nick LaMuro
@NickLaMuro
Sep 29 2016 15:25
The PR I am working on would benefit from concurrency, since I am fixing it by using nested SELECT statements to provide aggregate column data. Not fully sure on the implementation of parallel queries, but the each of the nested select statements should be able to run in parallel.
That said, nested SELECTS are probably inferior to using a join and sharing the column data, but #reasons™ for using nested SELECTs
Jason Frey
@Fryguy
Sep 29 2016 16:53
parallel queries might help ems refresh a lot
assuming it means parallelizing queries that are completely unreleated
if it's talking about paralleizing subqueries or something then probably not as much
Daniel Berger
@djberg96
Sep 29 2016 16:58
did someone say parallel queries? https://www.postgresql.org/about/news/1703/
Chris Arcand
@chrisarcand
Sep 29 2016 17:01
:point_up: September 29, 2016 10:06 AM :smiley: