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 postgresql database, we can make the following settings to log long DML and DDL operations.

In the postgresql.conf file, we’ll activate the following parameters and restart the database, then we’ll observe how long the update takes.

 

After changing these parameters, the database must be restarted using the following commands. (If you are using PostgreSQL 10 :))

 

After that;

We will connect to the database and run the update command.

 

After this process, we can reach the following log when we open the log file in /var/lib/pgsql/10/data/log

 

As a result, a database process that longer than 1000 ms was captured in the database log.

Engin Yilmaz
Author: Engin Yilmaz

Leave a Reply

Your email address will not be published. Required fields are marked *