#284·dejavu

Trying to fingerprint about 200 000 files. After 15000 files INSERT operation is very slow.

Author: unbrokendubCreated Nov 23, 2022Updated Aug 16, 2025

Hi all. I stuck when trying to fingerpint big database of music. Becouse of the billions of indexes generated, INSERT operation take super big amount of time. In example first 3000 files on emtpy database (i use postgres) been ready in 3 hours. But after 15000 files added another 3000 files takes more than 10 hours, and looks like time will grow exponencialy. Is there any tweaks to hussle with indexes or maybe it is possible to run dejavu without indexes?

Cheers Denis