[Zonemaster-devel] Submitting bulk checks

Anand Buddhdev anandb at ripe.net
Fri Oct 7 10:38:04 UTC 2016


So if I create these indexes by hand now in the database, and then try
to submit a batch job, it should be inserted more quickly?

On 07/10/16 12:35, Michal Toma wrote:

> Hi Anand,
> 
> If was a simple index problem after all.
> Here is the content of the future fix.
> create index test_results__hash_id ON test_results (hash_id, creation_time);
> create index test_results__params_deterministic_hash ON test_results (params_deterministic_hash);
> 
> 100000 domains inserted in 2 minutes and 15 seconds


More information about the Zonemaster-devel mailing list