About database indexes
Hello, Since our local Galaxy is a little sluggish, we were wondering if it could be related to broken or missing database indexes (we're using PostgreSQL), so we would like to know how they are managed in Galaxy, and if there is a way to restore them automatically. Thanks, L-A
On Dec 6, 2011, at 10:16 AM, Louise-Amélie Schmitt wrote:
Hello,
Since our local Galaxy is a little sluggish, we were wondering if it could be related to broken or missing database indexes (we're using PostgreSQL), so we would like to know how they are managed in Galaxy, and if there is a way to restore them automatically.
Hi L-A, You can see which columns are supposed to be indexed by looking through the database mapping in lib/galaxy/model/mapping.py. --nate
Thanks, L-A ___________________________________________________________ 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:
participants (2)
-
Louise-Amélie Schmitt
-
Nate Coraor