influxdb: [bug] drop/delete terribly slow

Bug report

Influx version: v1.5.1 OS version: Ubuntu Linux 17.04

Steps to reproduce:

Have a big database with > 20000 series
Try to execute drop series from /{{regexp_pattern}}/.
or try to execute drop measurement /{{regexp_pattern}}/.
or try to execute delete from /{{regexp_pattern}}/.

It will take > 30 minutes.

Expected behavior:

Well deleting data should take miliseconds?
Or there should be some special command modifier that will do it fast (I think this is becaus esome influx DB cleaning stuff). And there should be another comment to execute this “long” part manually, so for example I can delete ton of series and run cleanup process manually (to reclaim space) from a cron job or something like this.

About this issue

Original URL
State: open
Created 6 years ago
Reactions: 6
Comments: 41 (14 by maintainers)

Most upvoted comments

We’ve replaced influx with PostgreSQL and delete is instant. Postgres (which is a surprise for me) is faster not only in delete operation, but in all operations basically.

lukaszgryglicki on May 24, 2018

master
$ time influx -database stress -execute 'delete from /m9.*/'

real    0m31.381s
user    0m0.021s
sys     0m0.021s

1.6
$ time influx -database stress -execute 'delete from /m9.*/'

real    0m29.174s
user    0m0.023s
sys     0m0.033s

1.5
$ time influx -database stress -execute 'delete from /m9.*/'

real    0m22.821s
user    0m0.022s
sys     0m0.029s

1.4 (inmem)
$ time influx -database stress -execute 'delete from /m9.*/'

real    0m0.385s
user    0m0.023s
sys     0m0.030s

1.3 (inmem)
$ time influx -database stress -execute 'delete from /m8.*/'

real    0m0.413s
user    0m0.020s
sys     0m0.023s

jacobmarble on Jul 17, 2018

Wow, over 3 years passed since I’ve reported this and it’s not fixed…

lukaszgryglicki on May 4, 2021