Learning PostgreSQL - Database Layouts (Logical and Physical)

As you might already know that I have started writing about my journey in learning of PostgreSQL as posts, which are sort of notes to me and professionals like me. If you are following along with the series, then there are 2 posts which I have already written about Architecture and Installation of PostgreSQL database.

In this post, I will share Logical and Physical structure of the PostgreSQL database. This will be an overview of the database layouts, we will go deep like discussing internal layout of a page in future posts.

Learning PostgreSQL - Installation

 If you have not viewed my last post, then I request you to please go and check it out. The last post is about the architecture of PostgreSQL database, and this post is in continuation of that series.

In this post, we will discuss, different ways of installing a PostgreSQL software. Most of the organizations use Linux to deploy their PostgreSQL database, so we will be discussing ways to install PostgreSQL software on a Linux.

This will be a long post, so I would suggest you to keep a cup of coffee or a tea handy 😉.

Before installation, we will first understand how PostgreSQL versioning works.

Learning PostgreSQL - Architecture

I have started learning a new database, i.e. PostgreSQL, which is a powerful and open source relational database system. 

This is something new that I am trying, so I will start this series where I will try to publish a post every week with what I learned. Basically, these posts are nothing but notes that I am taking during the learning journey of PostgreSQL database.

This can also help those who are also in the process of learning this database system, and to those who already learned PostgreSQL, it can be a refresher.

Without wasting more time in introduction, let's start with the Architecture of the PostgreSQL. For Oracle DBAs (someone like me 😉), I will try to compare it with Oracle terminology so that it may help or speedup the learning.