PostgreSQL

  Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described below:  Logical replication works at …

  Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain …

  Introduction : –  pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. …

  It is a good idea to save the database server’s log output somewhere, rather than just routing it to /dev/null. The log output is invaluable when …

PostgreSQL, like any database software, requires that certain tasks be performed regularly to achieve optimum performance. The tasks discussed here are required, but they are repetitive in nature …

Overview This article briefs us on how to tune a database or make it work faster Max connections: We can configure the maximum number of …

Database Tuning Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply …

Overview PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store …

  With using triggers in PostgreSQL, you can trigger another event before an event occurs (BEFORE TRIGGER). Or you can trigger another event after it …

I described creating an updateable view in the article “How To Create an Updatable View in PostgreSQL“. In this article I will describe how to …