PostgreSQL database mass data management method and system

Abstract

The invention provides a postgreSQL database mass data management method and system. The method is implemented based on a Linux platform and includes the steps that mass storage management configuration initialization is performed, and system timing scheduling is started; stale data partitions beyond a reserved time quantum are deleted, and then partition data, within a reserved time quantum and beyond an actual storage cycle, in non-stale data partitions is cleared away; storage space checking is performed, whether a storage space supports pre-expansion or not is judged, if yes, partition pre-expansion operation and index establishment are performed, and otherwise, an adaptive simplification mechanism is triggered. According to the postgreSQL database mass data management method and system, the validity, availability and expandability of data are guaranteed, a numerical basis is provided for data expansion, the maintenance efficiency of database administrators is effectively improved, the database management and maintenance cost is greatly reduced, and the postgreSQL database mass data management method and system have significant market value.

Description

technical field [0001] The invention relates to the technical field of database applications, in particular to a method and system for managing massive data of a PostgreSQL database based on a Linux platform. Background technique [0002] PostgreSQL database is an open source, practical, efficient, and widely used general-purpose database management system. Its traditional data management methods are mainly divided into two types: one is that the amount of data can be controlled within a predictable range, and it can be completed at one time. The deployment of data storage space does not need to be expanded in the future; the other is to rely on the database DBA to conduct daily inspections to maintain the normal operation of the database. With the continuous emergence of various business systems, the predictability of data storage is relatively reduced according to the needs of different types of data, and the difficulty of presetting data space is increasing. This requires...

AI Technical Summary

Problems solved by technology

With the continuous emergence of various business systems, the predictability of data storage is relatively reduced according to the needs of different types of data, and the difficulty of presetting data space is increasing. This requires different systems to be configured with different database administrators. , if a single database administrator DBA manages multiple systems at the same time, it will undoubtedly consume a lot of manpower and material resources, and the requirements and standards for database administrators are getting higher and higher

Images