[ckan-dev] How to maintain the database?

[Martin Szyszlican]

We sometimes re-upload datasets after a failed or incomplete datapusher run, and we would like to delete everything unused from the database. We have reached a point where the DB is too big, and it´s slowing down the server, which makes the datapusher crashes more frequent.

I know I can call resource.purge or datastore_delete on a single resource, but how do I detect everything that is deletable? Is there a maintenance command already created for this?

Martín Szyszlican
Programa Justicia Abierta | Secretaría de Planificación Estratégica
mszyszlican at jus.gob.ar<mailto:mszyszlican at jus.gob.ar>
(011) 5300-4000 int. 76067

[logo_minjus]


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20171201/09002876/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 12218 bytes
Desc: image001.png
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20171201/09002876/attachment-0002.png>