MySQL or Postgres size and growth?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL or Postgres size and growth?

McCully, Dwayne (NIH/NIAMS) [C]

When setting up a Galaxy site, what should I expect for MySQL or Postgres database initial size and growth?

 

Dwayne


___________________________________________________________
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:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/
Reply | Threaded
Open this post in threaded view
|

Re: MySQL or Postgres size and growth?

Dannon Baker-2
Hey Dwayne,

All of Galaxy's datasets are stored in flat files and are not in the database, so the size really doesn't grow that quickly.  Our test server's database is on the order of a couple gigabytes with several hundred thousand jobs having been run, if that helps.

-Dannon

On Mon Feb 23 2015 at 12:24:06 PM McCully, Dwayne (NIH/NIAMS) [C] <[hidden email]> wrote:

When setting up a Galaxy site, what should I expect for MySQL or Postgres database initial size and growth?

 

Dwayne

___________________________________________________________
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:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

___________________________________________________________
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:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/