Hey @SimonWu,
Our tests are showing around 3x performance gains when running PostgreSQL 10 in some slow queries, thanks to the new parallel scans.
Do you know how close Azure is on the PostgreSQL 10 upgrade?
Some examples:
Query 1 PG 9.5: 1258.871 ms
Query 1 PG 10: 293.879 ms
Query 2 PG 9.5: 15532.489 ms
Query 2 PG 10: 4889.282 ms