Disable introspecting schema from running for every change?
Hello,
I am using Datagrip 2016.3 build #DB-163.7744.4 on Windows 7 Enterprise. I develop against an in house Postgres v9.6 database with about 2k tables and 10k functions/views/triggers and the database is 790 MB in size.
Every time I create/alter a function the introspecting schema process is kicked off in the background tasks taking at least a minute to complete. During that time Datagrip often becomes un-usable as it either slows down or completely freezes. Another developer on my team is having the same issue and neither of us recall having this issue prior to upgrading to 2016.3.
Is there a way to disable the introspecting schema process from kicking off every time I create/alter a function? I would prefer to manually kick this off when needed instead of having to deal w/ the slow down. It appears to refresh the entire schema which seems unnecessary when only a single function was changed. Is there a way to limit that?
Please sign in to leave a comment.
I was looking around and I noticed there is an "Auto sync" checkbox on the data source properties page for this connection. I unchecked this box and the introspecting schema process appears to no longer automatically run when I create/alter a function.
Hi,
You're right. Don't forget to synchronise manually from time to time.
This is a symptom of another problem that remains in DG 2017.3: Introspection is not asynchronous and prevents work from being done. This should be a priority as it reduces the value of the software.
This is still a problem.
Yep, this is still a problem in 2021. Navicat doesn't do this at all and is MUCH faster. I really want to like DataGrip, but stuff like this keeps me away from it.
Charles Thompson,
Could you e-mail Vasily.Chernov@jetbrains.com me logs from `Prepare Introspector Diagnostics` action and SQL Logs?
Still actual. I don't want all tables of the scheme to be introspected at all. Only some and only on demand.
H6 Msangel,
Vote for feature request https://youtrack.jetbrains.com/issue/DBE-6687
Maybe you will already finish jerking off to trends and start fixing problems?
Nothing changed. As I lost time for introspection (> 1h) 4 years ago, I continue now. It was 2022... The question is why am I paying if you do not solve my problems?
D Strelets A,
Could you describe your issue in details? RDBMS? Number of schemas / objects?