No Picture
PostgreSQL Performance

How PostgreSQL Vacuum works?

How does PostgreSQL Vacuum work? In PostgreSQL, the vacuum process is responsible for reclaiming space from deleted or updated rows in tables. The vacuum process works by scanning the table and removing any rows that […]
No Picture
PostgreSQL DBA

Step-by-step PostgreSQL 12 Streaming Replication on Ubuntu

Step-by-step Installation and Configuration of Streaming Replication in PostgreSQL 12 In this post we have explained how to implement step-by-step PostgreSQL 12 Streaming Replication on Ubuntu 20.04 (Codename: focal). PostgreSQL support several types of replication solutions […]