PostgreSQL format functions - (common functions such as memory context, planner content, memory context, etc.)

Label PostgreSQL , memory context , plan , pid signal , ... background https://github.com/MasaoFujii/pg_cheat_funcs Fujii Masao MasaoFujii PostgreSQL committer, DBA at NTT DATA, maybe good husband & father. This plug-in brings together common PG extension functions (which may be introduced into the PG community in the future), suc ...

Posted by ragrawal on Thu, 28 Nov 2019 21:29:04 +0100

Ovirt engine installation record of ovirt

In the process of studying the desktop cloud, it is found that there is not much difference between the server (private cloud or virtualization) and the application of thin client and the management of the desktop. The final landing may require customized development to meet the needs. In the open source virtualization products, limited to th ...

Posted by cent on Sun, 10 Nov 2019 15:13:59 +0100

Construction of thingsboard Kaiyuan Internet of Things Platform on Ubuntu in Aliyun

Install ThingsBoard CE on Ubuntu Server Precondition Step 1. Install Java 8 (OpenJDK) The ThingsBoard service runs on Java 8. Follow this instructions to install OpenJDK 8: sudo apt update sudo apt install openjdk-8-jdk Don't forget to configure ...

Posted by tycoon79 on Wed, 18 Sep 2019 11:26:18 +0200

PostgreSQL Multi-field Arbitrary Combination Search

In real life, we may encounter such a scenario: when you open Taobao to buy things, you often face as many as cattle hair goods, which may be screened according to the conditions you want, and then slowly choose, for example, to choose a certain bran ...

Posted by JNorman on Fri, 06 Sep 2019 11:37:56 +0200

PostgreSQL execution plan

Links to the original text: https://blog.csdn.net/JAVA528416037/article/details/91998019 Reproduced from: https://blog.csdn.net/JAVA528416037/article/details/91998019 brief introduction PostgreSQL is "the most advanced open source ...

Posted by cigardude on Tue, 20 Aug 2019 11:56:18 +0200

Jvm Monitoring of Skywalking_k8s Cluster

Here's a directory that doesn't need to exist Skywalking monitors intrusion-free-k8s cluster for jvm introduce server deployment busybox elasticsearch oap ui ingress agent deployment docker Mirror Making agent Embedding summary Skywalki ...

Posted by soulreaver on Mon, 19 Aug 2019 11:53:25 +0200

PostgreSQL Data Backup Strategy

Summary After any database is built and ready for use, the first thing to be determined is the database backup strategy. Rational and planned backup is the key to data security.Here is a set of backup strategies designed for PostgreSQL database WAL Archiving Strategy wal log The so-called wal is write ahead log. The history of all changes and o ...

Posted by nomanoma on Wed, 24 Jul 2019 12:43:39 +0200

Run, Big Screen-Time+Space Real-Time Four-Dimensional Data Perspective

Label PostgreSQL, recursive queries, big screen broadcasts, the most congested gateways, the busiest shops, the most congested toilets in an area, data perspective, streaming, time series data background With the development of the Internet of Things, the generation of data is faster and faster.For example, data of car passing through roads ...

Posted by vikramjeet.singla on Mon, 08 Jul 2019 19:17:10 +0200

Deploying OpenStreetMap Server with Docker

Last month, my teacher asked me to build Docker's OSM server. At that time, I stepped on the pit while recording. Finally, I got the deployment, so I blogged. I. Install and configure Docker This section describes the installation steps of docker in centOS 7 environment. The content is from http://www.runoob.com/docker/docker-tutorial.html Fo ...

Posted by Sassci on Wed, 19 Jun 2019 01:43:59 +0200

Parameters or factors affecting or controlling PostgreSQL garbage collection

Label PostgreSQL, garbage collection, parameters, freeze background What parameters or factors will affect or control the garbage collection of PostgreSQL? parameter Global parameters 1. Control the sleep time of VACUUM command. When the stage COST of vacuum is larger than vacuum_cost_limit, sleep will continue after a period of time. va ...

Posted by tomo11 on Fri, 14 Jun 2019 00:51:29 +0200