Get ready for PostgreSQL 16's release and learn about the new Connection Load Balancing Support feature in libpq. Discover how it can help scale out read queries and improve PostgreSQL's performance.
Author: Aakash Muthuramalingam
Overview of Predefined Roles in PostgreSQL
The PostgreSQL community always adds new features in its release every year. One of the prominent features is the Predefined Role which was introduced in PostgreSQL 9.6 with a single role available. Now it is having more than 10 predefined roles. A predefined role is a built-in role that provided access to commonly needed information. … Continue reading Overview of Predefined Roles in PostgreSQL
Load Balancing/Query Routing using PGPOOL-II ( Part-II)
In our first part of the Pgpool-II series, the Installation and Configuration of Pgpool-II were discussed. This part will focus on one prominent feature of Pgpool-II, which is Load Balancing/Query Routing. What is Load Balancing?Why do we need Pgpool-II for load balancing?How is it actually work?Types of Load Balancing modesSession Level Load Balancing:Statement Level Load … Continue reading Load Balancing/Query Routing using PGPOOL-II ( Part-II)
Faster Logical Backup/Restore using pgcopydb – PostgreSQL
No doubt, pg_dump/pg_restore is an amazing tool to perform logical backup and restorations in PostgreSQL. We have already explained in detail about pg_dump/pg_restore here. The tool pgcopydb is an Open Source tool that automates executing pg_dump and pg_restore between two PostgreSQL servers. It is a wrapper over pg_dump and pg_restore to simplify the process with … Continue reading Faster Logical Backup/Restore using pgcopydb – PostgreSQL
PostgreSQL automatic failover with pg_auto_failover
PostgreSQL is a powerful, open-source relational database with a strong reputation for reliability, robustness, and performance. It supports replication to achieve high availability for a very long. But it lacks an important feature on its own, that is the concept of automated failover. Of course, there are a lot of open-source tools available to do … Continue reading PostgreSQL automatic failover with pg_auto_failover
PgPool – II Installation & Configuration – (Part-I)
PGPool-II is an open-source proxy software that can be used for the PostgreSQL servers(ProxySQL for MySQL) environment. It lies between the application server/PostgreSQL client and the PostgreSQL database servers and can provide much-needed features like Load Balancing, Query Cache, Connection Pooling, and Watchdog. Each feature requires a detailed explanation with supporting examples. So, in this … Continue reading PgPool – II Installation & Configuration – (Part-I)
Install Specific Version of MySQL 8 using YUM
We have many ways to install MySQL on linux machines such as source, binary and so on. But most of the Engineers always prefer default package managers (yum for RPM-Based distributions and apt for DPKG-Based distributions) for its ease of use and it can resolve all dependencies on its own. And of course, it is … Continue reading Install Specific Version of MySQL 8 using YUM
Deduplication of B Tree Indexes in PostgreSQL 13
PostgreSQL 13 is generally available from September 24, 2020. Last year, PostgreSQL 12 was released with a lot of features like Generated Columns, Partitioning Improvements and so on and started to be widely used in Production Environments. This year, PostgreSQL 13 comes up with more exciting features as well as performance and security improvements. Here … Continue reading Deduplication of B Tree Indexes in PostgreSQL 13
Exploring Logical Backup in PostgreSQL.
Backup and Recovery is one of the most essential jobs for every database administrator. We all know the importance of the backups for the databases. Here I am not going to write its importance, rather about the different types of backup tools available for … Continue reading Exploring Logical Backup in PostgreSQL.
Getting started with PGBouncer in PostgreSQL
Resource management is one of the key thing in all RDBMS. DB Connections is one of them. In PostgreSQL, Allocating more connections without proper analysis of resources causes an overhead in Memory usage and the creation of an OS process for each connection will lead to a scheduling overhead in the time-sharing operating system. These … Continue reading Getting started with PGBouncer in PostgreSQL