Database sync for Postgresql very slow when there are lots of databases
My Postgresql server has 150+ databases and each database has around 75 tables. Anytime I need to refresh the list of database the IDE freezes for 30 seconds while it tries to get the data about the database. You need to make it much faster. It seems like you're diving deep into each database to find out details that you don't need to display the tree of databases.
Also, dropping databases is really hard due to it trying to refresh the database list and then having to do a huge sync operation.
Version: 2018.2.4
Please sign in to leave a comment.
But you need all them on the list, right?
@Paul Mendoza Do you really need to work with all 150+ databases?
Yes, on refresh IDE goes to every selected db and checks for changes.