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...
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...
PostgreSQL Index vs InnoDB Index – Understanding the Differences
Considering the current major use-case of a database as to retrieve data, it becomes very important that its performance is very high and It can only be achieved if data is fetched in the most...
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...
Scaling PostgreSQL for Large Amounts of Data
Nowadays, it’s common to see a large amount of data in a company’s database, but depending on the size, it could be hard to manage and the performance could be affected during high traffic if...
Running Multiple PostgreSQL Instances on a Single Host
We recently announced the release of ClusterControl 1.7.3 which includes a variety of improvements and newly added features. One of these new features is the addition of support in ClusterControl to allow a user to...
Announcing ClusterControl 1.7.3: Improved Support PostgreSQL & New Cloud Deployment Options
We’re excited to announce the 1.7.3 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. In this release we have added support for...
How to Monitor PostgreSQL Running Inside a Docker Container: Part One
Monitoring is the action of watching and checking over a period of time in order to see how what you are monitoring develops and performs. You do it so you can make any necessary changes...
An Overview of Database Diagram Tools Available for PostgreSQL
What’s in a Database Diagram? “Data are just summaries of thousands of stories – tell a few of those stories to help make the data meaningful” - Chip & Dan Heath Before you start playing...
PostgreSQL Deployment and Maintenance with Ansible
Ansible is one of the most well-known and widely-used IT automation tools, it helps us in automating IT operational tasks such as... Bootstrapping the host (VM or bare-metal machine) from scratch Configuring hosts and services...