Server 192.168.137.222 highgodb v4.1.1 corresponds to PostgreSQL V9.5
1) Create a test user at the highgo user of host 192.168.137.222 and set the password Expiration:
[highgo@hgdb01 ~]$ psql
PSQL: Release 4.1.1
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
Operating system: windows 10 home Chinese
Database system: PostgreSQL 9.6.2
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 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
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
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
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.
I usually don't rely on statistics, e ...
Posted on Sun, 23 Feb 2020 02:23:15 -0800 by edawson003
PostgreSQL, alicloud, real-time precision marketing, crowd selection, advertising
Almost all industries, such as Internet, new retail, education, games, etc
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
System version: CentOS Linux release 7.3.1611 (Core)
Software version: psql (PostgreSQL) 9.6.17
1, Check if PostgreSQL is installed
rpm -qa | grep postgres #Check if PostgreSQL is installed
Posted on Sun, 16 Feb 2020 22:52:18 -0800 by tripodkid
os: centos 7.4
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
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