No Comments

Countdown to Postgres v9.6: DBA’s life gets easier with better monitoring


by , , No Comments


Date: 17th August 2016 | 2.00 – 2.30 PM IST | 4:30 – 5:00 PM SGT

Register for the Hangout here and add to your  

In continuation to our Postgres Hangout series on the newest features and functionalities of Postgres v9.6, here we are again, to talk about how the new and better monitoring functionalities that will make a DBA’s life easier.

Have you ever wondered about the progress while working on a table maintenance during off-peak hours? I bet you have wished to have means of finding out how soon the VACUUM task will be over.

If you have worked in high concurrent system or simply with a badly designed application, you would have had a fair share of occasions when you wished you could see more more information on blocking events for each session. Currently, while “waiting” information is easily available in pg_stat_activity, it provides little information on what exactly is blocking the query. Or, have you ever been in a situation where master server has crashed and you have to promote one of the standby servers? You must have had a hard time figuring out which of the servers have received the lastest WAL file.

With v9.6, your life as a Postgres DBA is about to get easier. It comes with many great monitoring features like lock wait information in pg_stat_activity, vacuum progress reporting, pg_stat_wal_receiver etc.



Sameer Kumar – Database Solution Architect at Ashnik

Watch this Hangout live! 

Join us live on 17th Aug 2016 while we try to explore these features and discuss their applicability for DBAs and System Admins.