Managing traffic to the database can get harder and harder as it increases in amount and the database is actually distributed across multiple servers. PostgreSQL…
View More PostgreSQL Replication Setup using HAProxy
Month: August 2023
How to use pgBouncer with PostgreSQL
In the database world, there are many common concepts like High Availability, Failover, and Connection pooling. All of them are useful things to implement on any…
View More How to use pgBouncer with PostgreSQL
PostgreSQL Connection Pooling with PgBouncer
Connection pooling is a simple but effective way to improve the performance of your apps and decrease the load on your PostgreSQL servers. Read on…
View More PostgreSQL Connection Pooling with PgBouncer
Migrating partitioned Oracle database tables to PostgreSQL
Table partitioning is a useful functionality that most organizations use to store huge data, and it is quite common for users to come across partition…
View More Migrating partitioned Oracle database tables to PostgreSQL
PostgreSQL Architecture
PostgreSQL is probably the most advanced database in the open source relational database market. It was first released in 1989, and since then, there have been…
View More PostgreSQL Architecture
Amazon AWS upgrades to Postgres with Bucardo
Amazon Relational Database Service (RDS), allows for quick setup and use of a database system. Despite minimizing many database administration tasks, some issues still exist, one…
View More Amazon AWS upgrades to Postgres with Bucardo
Upgrade PostgreSQL RDS from version 9.x to 12.x using Bucardo
We are using Aurora PostgreSQL RDS clusters as our Database for our Applications. We were using a 9.x version of Aurora PostgreSQL RDS clusters for…
View More Upgrade PostgreSQL RDS from version 9.x to 12.x using Bucardo
Using the Oracle 11GR2 database flash cache
Oracle just released a patch which allows you to use the database flash cache on Oracle Enterprise Linux even if you don’t have exadata storage. …
View More Using the Oracle 11GR2 database flash cache
Find Top Running Processes by Memory and CPU Usage
1. top command The top command gives real-time information about the running processes as well as a summary of system information. It displays uptime, load averages, CPU…
View More Find Top Running Processes by Memory and CPU Usage
How to troubleshoot high memory usage in linux
There are situations where your server shows unintended behaviors like a slow response from websites, failures with services, inability to start applications, server crashes etc.…
View More How to troubleshoot high memory usage in linux