Improve of Parallel Query when getting large scale records - Shigeo Hirose: PGCon 2020
Channel: PGCon
Date: 2020-12-12

From https://www.pgcon.org/events/pgcon_2020/schedule/session/91-improve-of-parallel-query-when-getting-large-scale-records/

IoT system has many of the edge computer and sensor devices. They are increasing to thousand and more, they have a lot of data. PostgreSQL provides a Parallel Query to collect such data efficiently.

But data Gather node is a bottleneck because it cannot process in parallel. we tried to improve the speed of Gather node.I will explain some solutions such as Gather node parallelization and bulk copy records in Gather node.