Hello Carlo,
You can challenge the fact that the report is stored and/or that the supported size is limited to 1Gb on Postgres.
However, in your position, I would first wonder whether it is any good to the performance of the analysis (during scanner run, network transfert, asynchronous processing, …) to have a 1Gb report produced in the first place.
Sources are compressed in the report and analysis data is stored in a size optimized binary format (that roughly the content of the report).
I’m wondering whether the report may be bundling files it shouldn’t.
You could directly impact the size of the report by excluding files from analysis which are actually non meaningful and double check the configuration of source directories (see this doc).
Cheers,