Martin,
What Travis meant is that we have a bunch of tables in the default sys
schema and we would like to move them to a different schema, hopefully
without losing a day or two worth of ETL.
On that note what is the most efficient way to do ETL? We're using
COPY INTO right now and it works but we're only getting between
200-2000 rows/sec and mserver5 has crashed on us twice now for no
apparent reason.
-bob
On Jan 21, 2008 2:50 PM, Martin Kersten
Travis Brady wrote:
Hello, Hello Travis you can at any time add and drop columns without any reorganization cost. regards, Martin
Is it possible to change the schema for tables that have already been created and populated? I'd like to avoid having to fully recreate everything as the load process will likely take a few days at least.
thank you, Travis Brady ------------------------------------------------------------------------
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ ------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users