Open MPI logo

MTT Devel Mailing List Archives

  |   Home   |   Support   |   FAQ   |   all MTT Devel mailing list

Subject: Re: [MTT devel] Time to make the 2009 mtt database partitions?
From: Josh Hursey (jjhursey_at_[hidden])
Date: 2008-12-01 11:06:29


Good catch. I have a reminder email set to be sent out later this
month regarding this so we don't hit the same problem we had last
year. But we should probably do it now so we don't forget later.

There is a script here:
  server/sql/support/create-partitions.sh

This will generate SQL files for all of the tables and indexes that we
need. For 2009 it looks something like (XX is a short-cut for all
months):
./create-partitions-mpi-install.pl 2009 XX > 2009-mpi-install.sql
./create-partitions-test-build.pl 2009 XX > 2009-test-build.sql
./create-partitions-test-run.pl 2009 XX > 2009-test-run.sql
./create-partition-indexes.pl 2009 XX > 2009-indexes.sql

Then just run the generated SQL scripts into the database to create
the tables.

I can do this today, and send an email when it is done. I'll also add
some documentation about this to the Wiki.

Thanks,
Josh

On Dec 1, 2008, at 10:07 AM, Ethan Mallove wrote:

> Folks,
>
> \dt doesn't show any 2009 tables in the "mtt" Postgres database. Will
> the following commands (using 0-11) set us up for 2009?
>
> $ server/sql/support/create-partitions-mpi-install.pl 2009 00
> $ server/sql/support/create-partitions-mpi-install.pl 2009 01
> $ server/sql/support/create-partitions-mpi-install.pl 2009 02
> ...
> $ server/sql/support/create-partitions-test-build.pl 2009 00
> $ server/sql/support/create-partitions-test-build.pl 2009 01
> $ server/sql/support/create-partitions-test-build.pl 2009 02
> ...
> $ server/sql/support/create-partitions-test-run.pl 2009 00
> $ server/sql/support/create-partitions-test-run.pl 2009 01
> $ server/sql/support/create-partitions-test-run.pl 2009 02
> ...
>
> -Ethan
> _______________________________________________
> mtt-devel mailing list
> mtt-devel_at_[hidden]
> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-devel