On 7 October 2017 at 2:49 PM, David Rowley wrote: > > Yeah, PostgreSQL does not make any effort to convert subqueries in the > target list into joins. SQL server does.
[...] > You'll probably find it'll run faster if you convert the subquery in > the target list into a join with a GROUP BY, like ... > Wow, David, that is perfect – 0.91 seconds. Problem well and truly solved. It took me a little while to modify my original query to use that concept, but now it flies. Many thanks Frank
