We may need to keep passwords in databases for some reason, and we don’t want anyone to see them, including dba. In postgresql there …
Read More »PostgreSQL
POSTGRESQL DATABASE PERFORMANCE – 2
This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …
Read More »POSTGRESQL DATABASE PERFORMANCE – 1
If we examine some performance parameters in postgresql, I will mention a few parameters that will be quite useful for performance. You can configure …
Read More »Logical Replication
Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described below: Logical replication works at …
Read More »Configuration of PostgreSQL Database Replication
Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain …
Read More »PostgreSQL pg_rewind
Introduction : – pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. …
Read More »PG Log File Maintenance and DB Corruption
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 …
Read More »PostGre SQL Database Maintenance
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 …
Read More »PG DB Optimization
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 …
Read More »PG Tuning, Statistics and Indexes
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 …
Read More »