0006763: Current gvm 11 is very slow with PostgreSQL 12

ID	Project	Category	View Status	Date Submitted	Last Update

0006763	Kali Linux	[All Projects] Tool Upgrade	public	2020-10-01 13:27	2020-10-01 18:44

Reporter	klbt001	Assigned To	sbrun
Priority	normal	Severity	tweak	Reproducibility	always
Status	assigned	Resolution	open
Product Version	2020.3
Target Version		Fixed in Version

Summary	0006763: Current gvm 11 is very slow with PostgreSQL 12
Description	Current 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 Reproduce	Create 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 Information	I 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?

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

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.