Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Postgresql interview Question and answer

Question:
We are planning to change deadlock_timeout from 1second to 180 seconds. Will it impact the system? If yes, what are they.

Answer:
Getting little bit slow ur server because this lock already taken resources so it will not release resources until 180 seconds

Comments

Popular posts from this blog

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

What's is the difference between streaming replication Vs hot standby vs warm standby ?

Script to kill ALL IDLE Connection In postgreSQL