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

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Linux ctime,mtime,atime,cmin,amin,mmin

7 Steps to configure BDR replication in postgresql

How to Return a Result Set from a PostgreSQL Stored Procedure

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database