The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.
Trickle Load - performance degradation
Hi , I am testing load process using Trickle Load to a table that include 180M records , the process is a java main that open 10 threads each one commit after 1000 records , I use auto mode since I see the direct is very slow . The process finish after 600Sec and die. Next time I re-execute the process I am facing performance degradation the process finish after 700Sec and so on and so on , each time it take extra time to finish . My general setup is : • Vetica 6.0 CE • Single node . • Hp server - 24Core and 32G memory (avg load during process execution is cpu ~13% disk ~5%). • No projections (only super) .