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.

3 comments
Comment actions Permalink

You can go here File | Settings | Database | Data Views  and set Max LOB length to 1, for example, to reduce amount of loaded data.

0
Comment actions Permalink

I tried to but it shrinks common text and integer columns too without any reasonable change in performance.

 

0
Comment actions Permalink

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

0

Please sign in to leave a comment.