Setting the validity period of user password in Postgresql

Test environment: Server 192.168.137.222 highgodb v4.1.1 corresponds to PostgreSQL V9.5 Client 192.168.137.220 1) Create a test user at the highgo user of host 192.168.137.222 and set the password Expiration: [highgo@hgdb01 ~]$ psql psql (4.1.1) PSQL: Release 4.1.1 Connected to: HighGo Database V4.1 Enterprise Ed ...

Posted on Fri, 03 Apr 2020 17:55:50 -0700 by harrymanjan

PostgreSQL uses functions to implement the merge function

PostgreSQL uses functions to implement the merge function Experimental environment Operating system: windows 10 home Chinese Database system: PostgreSQL 9.6.2 Explain The oracle database has the merge function, which can be judged before inserting data: if the specified column data does not exist, the data will ...

Posted on Thu, 02 Apr 2020 19:09:51 -0700 by rockroka

The effect of data table flags on query performance

The influence of flag bits on query performance. The example database uses PostgreSQL drop table if exists test; drop function if exists gen_random_zh(int,int); drop function if exists get_next_index(tweights[]); drop type if exists tweights; /************************************************************************ ...

Posted on Thu, 02 Apr 2020 14:22:01 -0700 by HaXoRL33T

postgresql recursive query

postgresql recursive query If there is a single inheritance relationship among the records in the database, that is, each record has only one parent record, to query all the child records of this record, recursive query can be used to simplify the query complexity. There are the following table relationships and recor ...

Posted on Thu, 02 Apr 2020 01:34:06 -0700 by TGWSE_GY

Performance test of AnalyticDB for PostgreSQL TPC-B

1 Preface Analytical dB for PostgreSQL 6.0 (ADBPG6.0 for short) has a qualitative leap in transaction processing performance compared with the previous version of ADBPG4.3. This paper will use TPC-B industry standard transaction performance test benchmark to show the transaction processing capacity of ADBPG6.0. 2 Introduction to tpc-b TPC-B is ...

Posted on Fri, 28 Feb 2020 01:04:56 -0800 by searchman

How to find the rows of all tables in Postgres

I'm looking for a way to find the number of rows for all tables in Postgres. I know that I can do the following on one table at a time: SELECT count(*) FROM table_name; But I want to look at the number of rows in all the tables and sort them in order to see the size of all my tables. #1 building I usually don't rely on statistics, e ...

Posted on Sun, 23 Feb 2020 02:23:15 -0800 by edawson003

Selected cases of Alibaba cloud PostgreSQL real time precision marketing and crowd selection

Label PostgreSQL, alicloud, real-time precision marketing, crowd selection, advertising background Industry: Almost all industries, such as Internet, new retail, education, games, etc Application scenario: According to the characteristics of the target group, the target group is extracted quickly For example, In the e-commerce industry, be ...

Posted on Thu, 20 Feb 2020 20:15:39 -0800 by Rustywolf

CentOS 7 installation of PostgreSQL (RPM mode) and common commands

Official course https://www.postgresql.org/download/linux/redhat/ Installation preparation System version: CentOS Linux release 7.3.1611 (Core) Software version: psql (PostgreSQL) 9.6.17 install 1, Check if PostgreSQL is installed rpm -qa | grep postgres #Check if PostgreSQL is installed rpm ...

Posted on Sun, 16 Feb 2020 22:52:18 -0800 by tripodkid

Personal understanding of postgresql replication slots

os: centos 7.4 postgresql: 9.6.9 replication slots was introduced from postgresql 9.4. It mainly provides an automatic method to ensure that the master computer will not remove all the backup computers before they receive the WAL segments, and the master computer will not remove the rows that may cause recovery conflicts, eve ...

Posted on Fri, 31 Jan 2020 12:34:44 -0800 by donkeychoker

MySQL stress test tool use

1, Mysqlslap: MySQL's own stress testing tool mysql slap is a benchmark tool of mysql. It can query data with simple syntax and is flexible and easy to use. It can simulate multiple clients sending query updates to the server at the same time. It provides performance test data and performance ratio of multiple engines. mysql slap provides intu ...

Posted on Mon, 06 Jan 2020 08:01:44 -0800 by mingo