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