Programming VIP

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 ...

Windows Server 2008 deployment project environment summary Project environment: mongodbredispostgresqlmysqlnacos MonoDB 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, ...

Postgres Partition Table II 1, Background   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 ...

PostgreSQL PostGIS - getting started example introduce 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 ...

1,pg_basebackup 1.1,pg_basebackup principle 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 ...

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 ...

preface 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 ...

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 ...

  background 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 ...