View Issue Details

IDProjectCategoryView StatusLast Update
0006763Kali Linux[All Projects] Tool Upgradepublic2020-10-01 18:44
Reporterklbt001 Assigned Tosbrun  
PrioritynormalSeveritytweakReproducibilityalways
Status assignedResolutionopen 
Product Version2020.3 
Target VersionFixed in Version 
Summary0006763: Current gvm 11 is very slow with PostgreSQL 12
DescriptionCurrent gvm 11.0.5 is very slow with PostgreSQL 12.4.

This is because gvm 11 is optimized for PostgreSQL 9.6, but Kali ships 12.4.

See this forum message from Björn Ricks, the GVM development team lead:
https://community.greenbone.net/t/optimizing-postgresql-for-gvmd/6713/11

If PostgreSQL 12 will receive fixes in gvm 20 and gvm 21 isn't promised.
Please see this forum message of Björn Ricks:
https://community.greenbone.net/t/optimizing-postgresql-for-gvmd/6713/9
Steps To ReproduceCreate and execute a vulnerability scan that produces about 2000 results.

After the scan is finished go to the specific report and call the results tab.
In my case (8 core Intel i5, 3600 bogomips each core, 16 GB RAM) the results tab needs about 45 seconds to load.

With old gvm 9 there was no noteable delay in loading results.
Additional InformationI suggest that Kali ships also the reference implementation (combination) from Greenbone Networks.

Or should it be possible to do performance optimization on the combination gvm 11 and PostgreSQL 12?

Activities

klbt001

2020-10-01 18:44

reporter   ~0013518

While the query of the above example is running, these 45 seconds, there are one or partially two PostgreSQL procceses active, consuming 100 % CPU each.

Issue History

Date Modified Username Field Change
2020-10-01 13:27 klbt001 New Issue
2020-10-01 13:27 klbt001 Status new => assigned
2020-10-01 13:27 klbt001 Assigned To => sbrun
2020-10-01 18:44 klbt001 Note Added: 0013518