Hi everybody,

The python scripts to clean histories, datasets, users etc.. are fine...

However, the records are not really removed from the postgresql database and as a result, this one gets bigger and bigger with unused records. Ours is above 1 To after 2 years of production.

Is there a safe way to clean the database from unused records and their dependencies to reduce it size, without being a postgresql guru ?

Chris
--

Christophe Antoniewski

Drosophila Genetics and Epigenetics
Laboratoire de Biolologie du Développement
9, Quai St Bernard, Boîte courrier 24
75252 Paris Cedex 05

Tel +33 1 44 27 34 39
Fax +33 1 44 27 34 45
Mobile +33 6 68 60 51 50

http://drosophile.org