A postgresql block

Abstract

Provided is a PostgreSQL block. The PostgreSQL block is a minimum unit assigned to a data table in a PostgreSQL database system, and the storage capacity of the PostgreSQL block is larger than 4KB. According to the present invention, the query speed and the read-write speed of the database are improved, the data in the database are more secure, and the database service and the data are separated.

Description

Technical field [0001] The invention relates to a PostgreSQL database storage device, in particular to a PostgreSQL block for storing PostgreSQL data tables in a PostgreSQL database. Background technique [0002] With the development of the Internet, mobile Internet and the Internet of Things, we have ushered in an era of massive data, and more and more data are stored in the database, and the query time we need is getting smaller and smaller. Many application scenarios now require background storage with high concurrency, high capacity, and high response. The demand for high-speed storage forces us to abandon real-time indexing, and the large amount of data scanning is restricted by the IO on the storage side. In the current PostgreSQL database system, high-concurrency multi-database scanning needs to encounter basically random reads, and at the same time, the throughput of ordinary disks can no longer meet the demand. [0003] In order to adapt to the application scenarios of l...

AI Technical Summary

Problems solved by technology

[0027] Second, the expansion of the file system is also very troublesome

[0028] Third, the migration of databases between different systems is extremely complex, requiring high professional knowledge of operators

[0029] Fourth, the database data files are directly exposed to the operating system, and there are potential security risks in the data, so data security cannot be guaranteed. This is a huge security hole for some use environments that require a high level of security.

Images