Programmer Group

2021SC@SDUSC PostgreSQL code I am responsible for: query compilation and execution Content of this blog: semantic analysis In my last blog, I analyzed the lexical analysis and syntax analysis of query analysis. We can know that after lexical analysis and syntax analysis, we can get an analysis tree stored in SelectStmt structure. From the f ...

The previous chapter tested the serial backup and recovery of KADB, pg_dump/pg_restore. This chapter tests the parallel backup and recovery gpbackup/gprestore of KADB. Because pg_dump and pg_restore is limited by the master node and cannot meet the backup and recovery of a large amount of data. Therefore, KADB provides gpbackup and gprestore ...

Requirements: use postgresql13 to test the Chinese full-text retrieval function Install postgresql13 database I use the docker container to install and test 1. Create a centos7 image container docker run -di --name postgres13 --privileged=true -p 5432:5432 centos:7 /usr/sbin/init docker exec -it postgres13 bash 2. Install yum source ...

The Python ConfigParser tutorial shows you how to use ConfigParser to use configuration files in Python. Article catalog 1 Introduction 1.1 Python ConfigParser reading files 1.2 sections in Python configparser 1.3 Python ConfigParser reading data from strings 1.4 Python ConfigParser reading data fro ...

Pure Linux PostgreSQL offline installation tutorial for girlfriend PostgreSQL database installation, based on version 10.5.1, Use *. gz binary compression package to install manually on Linux system. Installation package: postgresql-10.5.1-linux-x64-binaries.tar.gz 1. Create postgres user groupadd p ...

1. View the current data (or insert new data) as a marker. highgo=# create table t1(id int,name text); CREATE TABL id | name ----+---------------------------------- 1 | cf9920dd1f8a7be7e56a85f8a3e018f6 2 | cf9920dd1f8a7be7e56a85f8a3e018f6 3 | cf9920dd1f8a7be7e56a85f8a3e018f6 4 | cf9920dd1f8a7be ...

[toc] preface Every time we execute rm commands on the production environment server, we are always on the edge of our pants, because once we accidentally execute the error deletion, we will be ready to run. After all, people are not machines, let alone machines have bug s, hehe. So what if you really delete files that should not be deleted, su ...

Last article( https://www.cnblogs.com/meowv/p/12909558.html )Improved the code in the project and connected to Swagger. This article mainly uses the Entity Framework Core to access the database, and uses the code first method for data migration and automatic creation of table structure. data access Add our data access context object MeowvBl ...

Safety configuration instruction [TOC] Database security configuration is one of the important links of database management. Security configuration mainly includes password, network access control, audit, etc. Next, we will explain how to realize the password related security configuration in Hangao database. 1 password encrypted storage The pa ...

1,ANALYZE Actually execute the actual SQL, and see the time of each step of the execution plan 2,VERBOSE Additional information for explicit planning, additional information: columns output by each node in the planning tree. The trigger being fired also displays the name of the initiator. The default is FALSE. 3,COS ...