1, Learn about KunlunDB1.1 basic concept & Architecture of kunlundb productsKunlunDB is an open source, high-performance distributed relational database, which supports mixed load (HTAP), PB level data volume management and provides a new generation of database solution with millisecond delay.1.1.1 cluster component architecture diagram1.2 ...
Added by chipev on Tue, 08 Mar 2022 09:22:57 +0200
Windows Server 2008 deployment project environment summary
In the project, MongoDB is used to store large files. In the test environment, the systems above Centos7 and windows server2012 are installed normally. When using windows server2008, the version needs to be reduced. Here, ...
Added by Mr P!nk on Tue, 08 Mar 2022 04:12:38 +0200
Postgres Partition Table II
in the previous article Postgres partition table I In, we mentioned that there are some differences in the way Postgres creates and uses partition tables after version 10.0. This article will mainly introduce the creation and use of partition tables after Postgres 10.0. after we cr ...
Added by lordphate on Sat, 05 Mar 2022 01:19:37 +0200
PostgreSQL PostGIS - getting started example
Spatial data is an important kind of data. The software used in our daily life, such as map navigation, taxi software, restaurant recommendation and takeout express, are closely related to spatial data. Spatial data usually has complex structure and large amount of data. For the analysis ...
1, Reference linkAlibaba open source mirror station OPSX mirror station Alibaba cloud developer communitypostgresql image - postgresql download address - postgresql installation tutorial - Alibaba open source image station 2, Introduction to PostgreSQLPostgreSQL is a free software object relational database management system (ORDBMS) with compl ...
Added by salhzmzm on Fri, 25 Feb 2022 14:43:33 +0200
Official document: pg_basebackup (postgres.cn)
1) Create a checkpoint, open FPW (full page writes), and create a backup label (store checkpoint location, time and other information)
2) Establish a connection with the database through the stream replication protocol, and the WAL Sender process ...
Added by bguzel on Mon, 14 Feb 2022 03:52:09 +0200
PostgreSQL best practices for automatically creating partitionsintroductionPartition table is a feature of PostgreSQL in version 10. In actual use, users often need to create partitions in advance or create partitions in real time according to the written data. This paper discusses several common automatic partition creation schemes.sceneIn pra ...
Added by dustinnoe on Sun, 13 Feb 2022 11:40:24 +0200
Recently, I began to bite the openGauss compatible package. I'll practice with a simpler one first.
UTL_ The url package has only two functions, "ESCAPE" and "unscape", which are actually two functions of URLENCODE and URLDECODE used in other development languages. They are mainly used to process some specific char ...
Added by Bryan Ando on Thu, 03 Feb 2022 10:04:16 +0200
tlinux 3.1 installing PostgreSQL 13 x
TencentOS Server is a customized server operating system independently developed by Tencent. The system integrates many services The advantages of the device series include the self-developed software, which is convenient for users to operate and use, and provides all-round (kernel and user state) Operatin ...
Added by buzzby on Mon, 31 Jan 2022 09:45:04 +0200
For hierarchical structures dealing with uncertain depth, such as organizations, a common design is to save ID and parent in a table_ ID, and construct a tree by self association. This method is very friendly to the process of writing data, but the query process becomes relatively complex. On the premise of not introducing MPTT ...