POSTGRESQL

Access MySql database from PostgreSQL using MySQL Foreign Data Wrapper (MYSQL_FDW) 0 (0)

November 23, 2021

Access MySQL database from PostgreSQL using MySql Foreign Data Wrapper (MYSQL_FDW) The MySQL Foreign Data Wrapper (mysql_fdw) is a Postgres extension that allows you to access data that resides on…

Loading

📌
1💬 read more

Steps to enable HugePages in PostgreSQL 0 (0)

November 18, 2021

Steps to enable HugePages in PostgreSQL By default, the page size on Linux is 4kb. A typical PostgreSQL instance may allocate many GBs of memory, which will end up with…

Loading

📌
0💬 read more

Configure and monitor using pg_profile in PostgreSQL 0 (0)

November 9, 2021

Configure and monitor using pg_profile in PostgreSQL This extension for PostgreSQL helps you to find out the most resource-consuming activities in your PostgreSQL databases. Extension is based on statistic views…

Loading

📌
0💬 read more

Monitor PostgreSQL Cluster using pgCenter 0 (0)

October 27, 2021

Monitor PostgreSQL Cluster using pgCenter pgCenter is a command-line admin tool for observing and troubleshooting PostgreSQL i.e monitor PostgreSQL cluster. Postgres provides various activity statistics about its runtime, such as…

Loading

📌
0💬 read more

Install and Configure pg_repack in PostgreSQL 5 (2)

October 24, 2021

Install and Configure pg_repack in PostgreSQL pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike…

Loading

📌
1💬 read more

Install and Configure pgBadger in PostgreSQL Part-II 0 (0)

October 23, 2021

Install and Configure pgBadger in PostgreSQL Part-II This article is a continuation of the Installed pgBadger package in PostgreSQL click here to read more. In this blog, we will Configure…

Loading

📌
0💬 read more

Install and Configure pgBadger in PostgreSQL Part-I 5 (1)

October 22, 2021

Install and Configure pgBadger in PostgreSQL Part-I pgBadger is a PostgreSQL log analyzer built for speed providing fully detailed reports based on your PostgreSQL log files.        …

Loading

📌
0💬 read more

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade 0 (0)

October 16, 2021

PostgreSQL major version upgrade from 12.8 to 13.4 using pg_upgrade Current PostgreSQL version numbers consist of a major and a minor version number. For example, in version number 13.1, where 13 is the major version number and 1…

Loading

📌
0💬 read more

PostgreSQL minor version upgrade from 13.1 to 13.4 5 (2)

October 12, 2021

PostgreSQL minor version upgrade from 13.1 to 13.4 Current PostgreSQL version numbers consist of a major and a minor version number. For example, in version number 13.1, where 13 is…

Loading

📌
0💬 read more

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) 5 (1)

October 11, 2021

Access Oracle database from PostgreSQL using Oracle Foreign Data Wrapper (ORACLE_FDW) Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and…

Loading

📌
2💬 read more