On Aug 26, 2013, at 5:03 AM, Christophe Antoniewski wrote:
> 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 ?
The database maintains a permanent record of everything that was done, even
though the underlying data can be removed. There are a lot of dependencies
between objects in Galaxy and removing records, especially anything with a
foreign key, could easily result in a lot of problems with all kinds of things,
from the UI to running jobs. Because of this, records cannot be removed from
> 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
> Please keep all replies on the list by using "reply all"
> in your mail client. To manage your subscriptions to this
> and other Galaxy lists, please use the interface at:
> To search Galaxy mailing lists use the unified search at:
Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
To search Galaxy mailing lists use the unified search at: