PostgreSQL data access across database instances

preface PostgresSQL is a single example multi database. Usually, a database instance contains multiple tablespaces and databases. One tablespace can store multiple databases. In this relationship, one tablespace can contain multiple databases, but a database can only belong to one tablespace and cannot be stored across tablespaces. Table space ...

Posted on Mon, 29 Nov 2021 14:10:26 -0500 by spivey

pg_terminate_backend() operation and maintenance transformation -- nonsuperuser supports kill autovacuum worker

1, Background introduction In view of security considerations, the superuser of the database is generally only in the hands of DBA students. Recently, many times such a scenario has happened. Students in the business make complaints about the structure of the table. The Tucao table is locked by the system process. After investigation, it is fo ...

Posted on Mon, 29 Nov 2021 13:44:50 -0500 by andrests

Linux file special permissions

SUID: When s appears on the x permission of the file owner, it is called setupid bits or setupid. Its characteristics are as follows: 1.SUID permission is only valid for binary executables2. If the performer has x permission on the binary executable, the performer will have the permission of the owner of the file3. This permission is onl ...

Posted on Sun, 28 Nov 2021 12:42:58 -0500 by Catfish

Tools | pg_recovery design principle and source code interpretation

Author: Zhang Lianzhuang, PostgreSQL R & D EngineerHe has been engaged in the development of PostgreSQL database kernel for many years and has a very in-depth research on citus.Last issue We introduced the PostgreSQL data retrieval tool: pg_reconveryThis article will take you to understand PG_ The implementation principle and design idea of ...

Posted on Fri, 26 Nov 2021 06:42:02 -0500 by mystrymaster

pg_bulkload fast loading data

pg_bulkload git download address: https://github.com/ossc-db/pg_bulkload introduce PostgreSQL provides a convenient data loading tool for the copy command. The copy command comes from the PostgreSQL database. The copy command supports data loading between files and tables and data unloading from tables to files. pg_bulkload is a high-speed dat ...

Posted on Mon, 22 Nov 2021 12:30:53 -0500 by Paul_Bunyan

PostgreSQL thinking - when can tuples be deleted?

PostgreSQL thinking - when can tuples be deleted? Preparatory knowledge <PostgreSQL transaction - MVCC> summary PostgreSQL supports MVCC, so when deleting, the related tuples will not and cannot be completely deleted. PostgreSQL only sets the T of the tuples involved in the Delete operation_ Xmax to indicate that the tuple has been t_ ...

Posted on Wed, 10 Nov 2021 13:38:13 -0500 by CSB

Slow SQL statement of PostgreSQL

Author: Song Shaohua 1, Reading guide Optimization is very important to improve the performance of the database itself in the case of hardware and non system failures. Each type of database has its own different ways to track and optimize the database. These methods include not only the optimization of the parameters of the database system it ...

Posted on Wed, 10 Nov 2021 01:43:12 -0500 by Arnold_26

Installation and deployment of GreenPlum database

This article introduces the installation and deployment steps of Greenplum. First, install Greenplum, then configure parameters, and then install the postgis extension. 1, Install and configure GreenPlum 1. Modify the corresponding machine name corresponding to / etc/hosts, which can be viewed through hostname (all nodes) 172.16.1.81 master ...

Posted on Tue, 09 Nov 2021 16:05:46 -0500 by rayzun

Learn about instant recovery of PG PITR

In the database system, data is the basis of everything, and the security of data is the top priority. However, data may be lost or damaged for various reasons, so data backup and recovery is particularly important.PostgreSQL is a powerful open source object relational database system. After more than 30 years of active development, PostgreSQL ...

Posted on Tue, 09 Nov 2021 15:32:07 -0500 by sysop

Introduction to Postgresql table connection method (comparison test with Oracle)

Author: Yang Yunlong, core member of Hangao PG laboratory, Senior Database Engineer, good at HGDB, post gresql, Oracle and other mainstream databases. Introduction to table connection methods (Nested Loop/Hash Join/Merge Join/Join) database version (oracle11.2.0.4 and PostgreSQL 13.1) Environmental structureNested Loop Oracle exec ...

Posted on Tue, 09 Nov 2021 06:34:37 -0500 by peranha