In this blog we are going to upgrade the postgresql server from 9.5 to 11.3 . We are upgraded the postgres server by using pg_upgrade utility as well as logical backup method , you can follow anyone of the method …
# ./configure –prefix=/opt/postgresql/11.3/ checking build system type… x86_64-pc-linux-gnu checking host system type… x86_64-pc-linux-gnu checking which template to use… linux checking whether NLS is wanted… no checking for default port number… 5432 checking for block size… 8kB checking for segment size… …
Tips for MariaDB Server performance tuning & optimization Agenda MariaDB Performance Tuning: Common Principles and Best Practices Server Hardware and OS MariaDB Configuration Settings Database Monitoring Query Tuning Why Tune? The task of scalable server software is to maintain top …
What is AWS? – Amazon Web Services(AWS) is a cloud service from Amazon, which provides services in the form of building blocks, these building blocks can be used to create and deploy any type of application in the cloud. These services …
Check the status of the firewalld service: systemctl status firewalld.service The status displays as active (running) or inactive (dead). If the firewall is active / running, enter this command to stop it: systemctl stop firewalld.service To completely disable the firewalld …
Following steps will be helpful to improve the performance of Postgres database : First you have to issue the top command then see the process which one process is taking more CPU utilization then note that PID, if that is postgres process means …
In this post, I am sharing few important function for finding the size of database, table and index in PostgreSQL. Finding object size in postgresql database is very important and common. Is it very useful to know the exact size …
Here i expalined that””How to increase the performance postgresql server and i written script for vacuum database and changing PostgreSQL performance parameter cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.0 (Maipo) bash-4.2$ Checking the master and slave IP and …
Finding the Missing Records between two tables : I. creating table structure for excel sheet table data’s , table name as temp. II. Restore the Excel data on temp table then count the total records . Steps for Postgres COPY : …
This is the Basic Key notes of PostgreSQL PEM (EDB Postgres Enterprise Manager) 1. Hardware Pre-Requisites For optimum speed when monitoring servers and rendering dashboards, we recommend installing PEM on a system with at least: 4 CPU cores 8 GB …
Why Order Blog Writing Services from 2ndQuadrant.in? We offer fast, reliable blogging services for agencies who need help with their overload. Partnering with us allows your own staff to focus on higher-level tasks like strategy, brand messaging, and marketing research. …
Following steps will help you to improve the Postgresql database server performance: First you have to issue the top command then see the process which one process is taking more CPU utilization then note that PID, if that process is postgres process means …
This script is very useful after Issue top command you will get PID which one Process taken More CPU Utilization example for 32696 is the most CPU utilization process means take the PID then run the following script it will …
Answer: To check your top command version and variant use the -v option $ top -v procps-ng version 3.3.9 This post focuses on the top command coming from the procps-ng project. This is the version available on most modern distros …
BTree My issue here is that the BTree index will be huge since afaict it will store duplicate values (it has too, since it can’t assume the table is physically sorted). If the BTree is huge I end up having …
Login with Google