PostgreSQL block

Abstract

The invention discloses a PostgreSQL block. The PostgreSQL block is the minimum unit allocated to a data table in a PostgreSQL database system, and the storage capacity of the PostgreSQL block is larger than 4 KB; the storage capacity of the PostgreSQL block is a positive integer multiple of 8 KB; the storage capacity of the PostgreSQL block is a product of 8KB and 2 to the Nth, wherein N is a natural number; the storage capacity of the PostgreSQL block is 1 MB, 2 MB, 4 MB, 8 MB, 16 MB, 32 MB, 64 MB, 128 MB, 256 MB, 512 MB or 1024 MB. The query speed and the read-write speed can be greatly increased and can be increased at the rate of 10%-20% under the same rear-end storage condition; data of the database can be safer: the data are stored in a block device according to established rules and are safer in terms of security; with the adoption of distributed storage, the data can be stored in a fragmentation manner and stored in multiple different data nodes and are a hundred times safer than data stored in a single magnetic disk in terms of security; database services and data separation are realized.

Description

technical field [0001] The invention relates to a PostgreSQL database storage device, in particular to a PostgreSQL block for storing a PostgreSQL data table 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, but the query time we need is getting smaller and smaller. Many application scenarios today require background storage with high concurrency, high capacity, and high response. The high-speed warehousing requirements force us to give up real-time indexing, and the data scanning of large data volumes is limited by the IO on the storage side. In the current PostgreSQL database system, high-concurrency multi-database scans are basically random reads. At the same time, the throughput of ordinary disks can no longer meet the demand. [0003] In order to adapt to the application scenarios with a 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