Schedule - PGCon 2020

Improve of Parallel Query when getting large scale records

Date: 2020-05-27
Time: 09:00–09:45
Room: Stream 3
Level: Intermediate

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.

Video

Slides

The following slides have been made available for this session:

Speaker

Shigeo Hirose