Cloud Vendor Deep-Dive: PostgreSQL on Microsoft Azure
If you have followed Microsoft lately it will come as no surprise that the provider of a competing database product, namely SQL Server, also jumped on the PostgreSQL bandwagon. From releasing 60,000 patents to OIN...
An Overview of the JOIN Methods in PostgreSQL
In my previous blog, we discussed various ways to select, or scan, data from a single table. But in practical, fetching data from a single table is not enough. It requires selecting data from multiple...
Cloud Vendor Deep-Dive: PostgreSQL on Google Cloud Platform (GCP)
Where to Start? The best place I could find to start was none other than the official documentation. There is also a GCP Youtube channel for those who prefer multimedia. Once finding myself into the...
An Overview of the Various Scan Methods in PostgreSQL
In any of the relational databases engines, it is required to generate a best possible plan which corresponds to the execution of the query with least time and resources. Generally, all databases generate plans in...
Tips for Storing PostgreSQL Backups on Amazon AWS
Data is probably one of the most valuable assets in a company. Because of this we should always have a Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or...
Validating Your PostgreSQL Backups on Docker
Backups are the vital and important part of any disaster recovery plan, taking backups of the production database is also a basic and an important part of PostgreSQL administration. However, DBA’s don’t often validate that...
Running PostgreSQL Using Amazon RDS
Cloud computing is now commonplace in most companies. It allows for on demand availability of compute power, database, storage, applications, and other resources via the internet. The main advantages behind the cloud are that you...
PostgreSQL Replication Setup & Maintenance Using Ansible
Replication is a key feature for most setups and it is supported by most database technologies on the market. The PostgreSQL community introduced replication in version 9.0 (called Streaming Replication or SR), since then the...
Comparing Temporary Tables for PostgreSQL & Oracle GTT
The temporary tables are a useful concept present in most SGBDs, even though they often work differently. This blog describes the technical features for this kind of tables either in PostgreSQL (version 11) or Oracle...
Running a Data Warehouse on PostgreSQL
When you need to implement an analytics system for a company there is often the question of where the data should be stored. There is not always a perfect option for all the requirements and...
Big Data with PostgreSQL and Apache Spark
PostgreSQL is well known as the most advanced opensource database, and it helps you to manage your data no matter how big, small or different the dataset is, so you can use it to manage...
How to Monitor PostgreSQL Running Inside a Docker Container: Part Two
This is the second part of the multi-series How to Monitor PostgreSQL Running Inside a Docker Container. In Part 1, I presented an overview of docker containers, policies and networking. In this part we will...