Is it possible to disable blob fields' selection in queries?
Answered
Hello!
I have several tables (PostgreSQL) with embed bytea fields and queries to them via DataGrip Object Browser are extremely slow (about 30 seconds on 2,5k rows with LIMIT 500).
Is it possible to hide blob fields or not to load them at all like in pgAdmin III? Actually I need only NULL/NOT NULL values, I do not actually need byte array.
Please sign in to leave a comment.
You can go here File | Settings | Database | Data Views and set Max LOB length to 1, for example, to reduce amount of loaded data.
I tried to but it shrinks common text and integer columns too without any reasonable change in performance.
I am also having the same issue since two weeks. Also it changes the texts and number columns and performance is also same as it was earlier.
FaceTime PC