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...
A Guide to Automated Cloud Database Deployments
Complex, inflexible architectures, redundancy and out-of-date technology, are common problems for companies facing data to cloud migration. We look to the “clouds,” hoping that we will find there a magic solution to improve operational speed...
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...
Cloud Vendor Deep-Dive: PostgreSQL on AWS Aurora
How deep should we go with this? I’ll start by saying that as of this writing, I could locate only 3 books on Amazon about PostgreSQL in the cloud, and 117 discussions on PostgreSQL mailing...