ElasticSearch and NEST: How do you purge all documents from an index? ElasticSearch and NEST: How do you purge all documents from an index? elasticsearch elasticsearch

ElasticSearch and NEST: How do you purge all documents from an index?


I was looking for something similar in Nest and I thought I'd put the syntax here for anyone looking:

var node = new Uri("http://localhost:9200");var settings = new ConnectionSettings(node);var client = new ElasticClient(settings);client.DeleteByQuery<ElasticsearchProject>(del => del    .Query(q => q.QueryString(qs=>qs.Query("*"))));


You can use a delete by query. This will delete all documents that match * i.e. everything.

curl -XDELETE localhost:9200/<indexname>/_query?q=*
  • Change localhost to the hostname that node is running on.

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/docs-delete-by-query.html

Don't forget to optimize afterwards.

curl localhost:9200/<indexname>/_optimize


$ curl -XPOST localhost:9200/myindex/_optimize ....

The optimization process will clean all your softdeletes done by you by delete by query.

We are also facing a simillar problem where we deletes a lot of documents.Actually we move lot of documents from one index to other as we have sharded data by date. But as ES doesn't support moving of data from one index to other.

But optimization, is a costly operation as it consumes a lot of IO seeks. If you just want to do purge just for deletes I guess then you can utilize "only_expunge_deletes" flag to merge segments with deletes only.

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/indices-optimize.html