Linux System Diagnosis Tips (15): How to Fix File System Damage with Start-Stop Problems
Digression
Let's start with what file systems are and what tools are needed.
file system
Nowadays, there are many kinds of storage and complex stacks. But the user's direct interface is still file system . For Linux and the open source community, a lot of software is also dependent. file system . MySQL and PostgreSQL databases, for example, c ...
Added by mortona on Sun, 19 May 2019 08:56:28 +0300
PostgreSQL on Linux Best Deployment Manual
Installation of common packages
# yum -y install coreutils glib2 lrzsz mpstat dstat sysstat e4fsprogs xfsprogs ntp readline-devel zlib-devel openssl-devel pam-devel libxml2-devel libxslt-devel python-devel tcl-devel gcc make smartmontools flex bison perl-devel perl-ExtUtils* openldap-devel jadetex openjade bzip2
Configuring OS Kernel Parame ...
Added by hazel999 on Fri, 17 May 2019 02:29:34 +0300
Introduction to PostgreSQL Full-Text Retrieval
PostgreSQL comes with a simple full-text retrieval engine that enables full-text retrieval of small amounts of data.In this article, we will guide you through this feature, which is sufficient for small-volume searches without the need to build additional heavy-weight full-text retrieval servers such as ES.
For detailed full-text ...
Added by pumaf1 on Fri, 17 May 2019 00:39:42 +0300
PostgreSQL page inspect diagnoses and optimizes the query performance degradation caused by the delay of GIN (inverted) index merging
Label
PostgreSQL, brin index, gin index, merge delay, gin_pending_list_limit, query performance degradation
background
GIN index is an inverted index of PostgreSQL database with multi-value type. A record may involve KEY in multiple GIN indexes. So if index is merged in real time when writing, IO will increase sharply and RT will increase in ...
Added by hatching on Wed, 15 May 2019 09:30:25 +0300
PostgreSQL 11.1 trillion tpcb performance test on Aliyun ECS + ESSD + zfs/lvm2 strip + block_size=32K
Label
PostgreSQL, pgbench, tpcb, tpcc, tpch, lvm2, zfs, bands
background
Several recent PostgreSQL OLTP and OLAP tests:
PostgreSQL 11 tpcc Test (103,000 tpmC on ECS) - use sysbench-tpcc by Percona-Lab
(TPC-H test SF=10,SF=200) PostgreSQL 11 vs 10 vs Deepgreen
PostgreSQL 10 billion tpcb performance on ECS
PostgreSQL on Aliyun ECS + ESSD - 100 ...
Added by stanleycwb on Tue, 14 May 2019 14:43:51 +0300