Background
The Performance Challenge Championship (PCC) is an event organized by ArchNotes. After learning about the rules of the competition, I found PostgreSQL is very suitable for this scenario. The scenario is reproduced as it is, implemented with PG, but how does it perform?
The competition is described as follows (page in Chinese, but Chrome can translate): https://github.com/archnotes/PCC
