Part I β Installing and patching the software Occasionally during our regular DBA tasks, we get a client request or simply notice the need and…
View More How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux
Author: Bulent Soylu
orapwd enforces password complexity rules in 12.2.0.1
Starting with Oracle Database 12.2.0.1 the orapwd utility β used to create Password Files for remote authentication β enforces complexity rules for the provided password.…
View More orapwd enforces password complexity rules in 12.2.0.1
PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
In this post, I will walk you through on how to perform load balancing and connection pooling with PgPool-II, what are the benefits and motivation…
View More PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
Upgrading the PostgreSQL DB engine for Amazon RDS from 11.9 to 12.4
In this article, I will share how upgraded the PostgreSQL from 11.9 to 12.4 in AWS RDS. Make sure that you thoroughly test after the…
View More Upgrading the PostgreSQL DB engine for Amazon RDS from 11.9 to 12.4
Materialized View Strategies Using PostgreSQL
Queries returning aggregate, summary, and computed data are frequently used in application development. Sometimes these queries are not fast enough. Caching query results using Memcached…
View More Materialized View Strategies Using PostgreSQL
Advanced SQL Techniques You Should Know
Window Functions Window functions allow you to perform calculations across a set of rows that are related to the current row. For example; we have…
View More Advanced SQL Techniques You Should Know
Understanding database Indexes in PostgreSQL
There are three types of developers: those who know that indexes speed up database queries, those who know that indexes speed up database queries and…
View More Understanding database Indexes in PostgreSQL
Understanding Postgres GIN Indexes: The Good and the Bad
Adding, tuning and removing indexes is an essential part of maintaining an application that uses a database. Oftentimes, our applications rely on sophisticated database features…
View More Understanding Postgres GIN Indexes: The Good and the Bad
Performance Tuning Queries in PostgreSQL
Database performance tuning: developers usually either love it or loathe it. I happen to be one that enjoys it and want to share some of…
View More Performance Tuning Queries in PostgreSQL
Correlated subquery
In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values from the outer query. Because…
View More Correlated subquery