I have noticed recently that a table with many rows using a column of 'Bytea' type in PostgreSQL (version does not matter but for the case of record keeping that would be 10 and 11), takes a long time to load. Looking at the system monitor it appears that each time I click on such a table, it tried to download all blobs (bytea) before display any row content. I think that this is an issue. Is there a way to delay pre-loading of blob objects so it does not impact performance? When I double click on a cell in a table with a blob, I do not mind waiting because I know that this is the action I wanted to take. However, it seems to be excessive to be "penalized" for clicking only on a table to see its rows, doesn't it?
Do you have any comments/insights on this? I would greatly appreciate it.