关键词: 关系型数据库；PostgreSQL；并行查询；数据表索引；数据库分区

Abstract: With the increasing of electrical architecture, a large amount of driving data will be reported during vehicle operation. The amount of data processed in the database increases, and the difficulty of request is also upgrading. In order to save a large amount of vehicle data for a long time and stably, quickly query the required data to provide data analysis for R&D engineers, it is necessary to design a relational database suitable for storing vehicle data. As an advanced open source database, PostgreSQL supports complex queries, concurrency control and other functions. This paper proposes a design optimization method of multi thread parallel query, creating data table index, adding database partition and application connection pool for vehicle based relational database, and provides targeted optimization strategies for database operation efficiency. The test results show that the database performance improvement method proposed in this paper can improve the data request efficiency several times, and the database performance has been greatly improved.

Key words: Relational database; PostgreSQL; Parallel query; Data table index; Database partition