downtime is more limited by your application. i.e. if there is a failure your connection / database pool just needs to reconnect. btw. we only have had psycopg2 pointing at it yet and that worked without a downtime. however i guess java hikaricp is as fast as that well. only "failures" will have a "small" downtime, however planned downtime is pretty/zero fast.