Postgres for Oracle DBAs – Datapump Vs Pg_dump
Table of Contents What is included in this blog post ? This is Part 4 of the “Postgres for Oracle DBAs” series where we compare logical backups – Data pump Vs pg_dump . We covered 1) Default tablespaces...
Read More ➜How TPS increased from 65k to 84k using multiple Pgbouncer instances
Table of Contents What is the multi-instance feature in Pgbouncer ? How is it beneficial ? PgBouncer supports SO_REUSEPORT socket option, which allows running multiple instances of PgBouncer on the same host(using same port).PgBouncer instances on the...
Read More ➜MySQL Innodb Cluster Operations – Part1
We are starting a new series from today “MySQL Innodb Cluster Operations” . Also check other Innodb cluster articles https://klouddb.io/innodb-cluster-5-7-vs-8-10-things-to-know/ and https://klouddb.io/innodb-cluster-open-book-github-wiki-launched/ 1) SELinux error when you try to add a new member to the group Sometimes when...
Read More ➜PostgreSQL Tips and Tricks – Part 2
This is part 2 of the series . Please read Part1 by clicking this URL https://klouddb.io/postgresql-tips-and-tricks-part-1/ 1. Log rotation Postgres log is automatically rotated depending on config like log_rotation_age, log_rotation_size, etc… What if you want to manually rotate...
Read More ➜PostgreSQL Tips and Tricks – Part 1
We are starting a new blog series from today where we plan to present interesting tips and tricks that can help you in managing postgres servers. We recommend you to go through our PgPool series and RDS series...
Read More ➜Pgpool Issues – Part 2
Please read Part 1 of this series by clicking here https://klouddb.io/pgpool-issues/ . NOTE : This is Part 2 of the PgPool series Why am I getting bad performance with PgPool? This is one of the common questions people...
Read More ➜Temporary files in PostgreSQL – Steps to identify and fix temp file issues
Work_mem is the memory area used by queries for operations such as JOINS, ORDER BY, DISTINCT etc . Default value is 4 MB which is not sufficient for large sort operations. When work_mem is not sufficient the sort...
Read More ➜Aurora PostgreSQL Gotchas – Part 1
There are some important gotchas that you have to take into consideration when you manage Aurora PostgreSQL.This is part -1 of the series where we showcase four important differences between standard PostgreSQL and Aurora PostgreSQL 1) Shared_buffers config...
Read More ➜Compare Postgres Config Using Simple DB Utility
As a postgres DBA one of the common maintenance tasks is to alter postgres config . Below are some of the scenarios that we would like to bring to your notice : Lets say we have a 3...
Read More ➜PgPool Issues – Part 1
Managing PgPool is not easy and you may see multiple issues during configuration and management of PgPool. This series will address some of the common errors/issues : 1) Different entries in pg_hba entries Lets say you have 3...
Read More ➜