News for hackers. Stuff that matters.

A comment on Speeding up SQL queries by orders of magnitude using UNION. Parent comment

Re:Speeding up SQL queries by orders of magnitude using UNION by EdwardDiego on Saturday March 20, 2021 @05:45PM (#26526282)
I'm pretty sure later versions of PG can indeed execute both in parallel.
[ Parent | on HN ]
Re:Speeding up SQL queries by orders of magnitude using UNION by Izkata on Saturday March 20, 2021 @06:06PM (#26526396)
Not sure about each side of the UNION, but postgres can do parallel index scans for even simple criteria: https://www.postgresql.org/docs/10/parallel-plans.html#PARAL...

Also the article says these tests were done on postgres 12.6

[ Parent | on HN ]