devops/postgres/tools/removeUnusedNgrams.sql · 91a2d6e2072f5e728bb86e18f49c615170c25898 · Christian Merten / haskell-gargantext · GitLab

Blame History Permalink

[TOOLING] sql queries to remove unused documents and ngrams from database.... · 1a951db1

Alexandre Delanoë authored 3 years ago

[TOOLING] sql queries to remove unused documents and ngrams from database. Usage: use a crontab to execute it every week for instance.

1a951db1

removeUnusedNgrams.sql



258 Bytes



WITH listed AS
  ( select nn.ngrams_id AS id, count(*) AS c
    FROM node_node_ngrams nn 
    GROUP BY nn.ngrams_id
  )

--SELECT count(*) from listed l
-- WHERE
--l.c <= 1


DELETE FROM ngrams n 
  USING listed l
  WHERE
  n.id = l.id
  AND l.c <= 1
; 